Storing GPS data

joselv

Hello,

How are folks storing GPS data? I am coming from Alpha Software and they have a dedicated attribute for lat and long.

Does AIM automatically handle this data or will I need to do out of the box work to get that functionality?

I searched the forums but nothing relevant came up.

Thanks,

Jose

pbrad

Hi,
What are you doing with the stored Lat/Long? If you are just storing it and using for something like displaying in a Google map you just need to add Lat and Long attributes. If you want to do something more complex then you may need to extend the AwareIM functionality using a java plugin or something like php.

Cheers,
Pete

joselv

Hi Pete,

Yes, I want to store simple lat/long values in decimal degree format for viewing them in google maps.

My question is two fold:

To store lat/long data in decimal degree format, do I use type number?
Once I store the lat/long data, will AIM automatically show the data in google maps?

Thanks!

pbrad

Hi,
This is all out-of-the-box functionality. Please refer to the manual or to the help files. Just search for Google and it will all be laid out for you.
Cheers,
Pete

joselv

Pete,

The only reference I found with Google search was this: https://www.awareim.com/forum/d/5778> and it mentions that it requires a custom component - that is not out of the box functionality.

I searched through the manual and found nothing. Am I missing something?

Thanks,

Jose

pbrad

First of 14 items found when searching for Google in help file:

How to show Google Maps
You can display Google Maps both on object forms and on object presentations. A Google map shown on a form can only show one address and this address must be stored in some attribute of the object. A Google map shown on a presentation can show multiple addresses if the presentation is used to display query results. Again an object that the query queries on must have the attribute that stores the address to be shown on a Google map.

To define a Google map on a form define a form layout cell of the “Google Map” type – see the “Editing Form Sections” section of the User Guide. To define a Google Map on a presentation select the Google Map element in the Report Designer when defining a presentation for an object. Then define a query that would display this presentation. If a query finds multiple instances of an object, multiple addresses will be shown on the Google Map.

You can also show colored areas on Google Maps using the so-called “polygon” feature. Each area must be represented as a collection of map points in the KML format. An example of the polygon specified in the KML format is provided here:
https://developers.google.com/kml/documentation/kml_tut#polygons

To display polygon areas on a Google Map you need to do the following:
·        Define a business object representing the area. This object can have any attributes you like, but it must have an attribute that will store the KML representation of the polygon as described in the example above.
·        Define a query that will retrieve instances of this object. Note that:
o       You can define item rules on this query to specify the background color of the area
o       You can define “Mouse Over” options to specify what happens when the user moves the mouse over the area
o       You can define operations to specify what happens when the user clicks on the area
·        When specifying Google Map options provide the query above and identify the attribute of the “Polygon” object that stores the KML data of the polygon.

joselv

Pete,

I saw these as well but they reference addresses. I don't have addresses.

I am tracking Lat/Long coordinates for equipment in remote places with no addresses.

What I need to know is if I can store Lat/Long data in AIM and exactly how? Should it be stored as a number since I saw no location or geographic related type in the selections for data types?

If it is stored as a number, then how will AIM know that it is geographic information and will make it possible to view a set of Lat/Long coordinates on Google Earth?

Thanks for providing the links and reference information but I don't think this is what I am looking for.

Could support chime in here? I am using the 30 day trial to see if AIM will work as an alternative to Alpha Anywhere but the ability to store GPS data and display the coordinates on Google Maps OUT OF THE BOX with no custom work is a must have. If AIM does not have this then I can end the trial now.

Thanks!

aware_support

We have never tried this but if you REALLY need to store Lat/Long then try storing them as a text value with comma separator:

55.7889,34.4545

Then specify an attribute that stores these as an "Address" attribute for your GoogleMap and then use Aware IM Google Map feature as usual.

In theory this should work.

mfauzi

I think this should be included in the future enhancement.
I also has the need to store the lat/long since most of our customer remote location do not has proper address

yuri.rj

One thing no one mentioned.... you're talking about DISPLAYING coordenates or adresses, but is there a way to GET this?

For example: A button like "SET CURRENT LOCATION AS HOME ADDRESS"

Did i made myself clear?!

Cheers

lineamovil

Ok,

I needed something similar before and found this solution.

1.- Had my GPS tracking provider, who has a webservice.
2.- I made a table in MySQL database and linked it to AwareIm
3.- Have an outside solution made with PHP
4.- In awareIm I call the php script and send the variable. (Unit number) this runs the Webservice and download the info into the mysql table. in this case lat and long.
5.-Use a html + php to display the position in a google map.

here is the sample:

<?PHP
$dispositivo = $_GET['varDispositivo'];

require_once('connections/cnx_cfdi.php');
mysql_select_db($database_cfdi, $cnx_cfdi);

$resSQL = "SELECT dispositivo, evento, fechahoragps, latitud, longitud, velocidad, curso, orientacion, referencia FROM cargonet_unidades_historial WHERE dispositivo = '".$dispositivo."' ORDER BY fechahoragps DESC";

$runSQL = mysql_query($resSQL, $cnx_cfdi);
$rowSQL = mysql_fetch_assoc($runSQL);

$lat = $rowSQL['latitud'];
$log = $rowSQL['longitud'];
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Ubicacion de Unidad</title>
</head>

<body>
<iframe width="640" height="480" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.com.mx/maps?f=q&source=s_q&hl=es-419&geocode=&q=<?php echo $lat ?>+<?php echo $log?>%09&aq=&sll=<?php echo $lat ?>,<?php echo $log?>&sspn=0.180316,0.338173&t=h&ie=UTF8&ll=<?php echo $lat ?>,<?php echo $log?>&spn=0.038499,0.054932&z=14&output=embed"></iframe>
<br />
<small><a href="https://maps.google.com.mx/maps?f=q&source=embed&hl=es-419&geocode=&q=<?php echo $lat ?>+<?php echo $log?>%09&aq=&sll=<?php echo $lat ?>,<?php echo $log?>&sspn=0.180316,0.338173&t=h&ie=UTF8&ll=<?php echo $lat ?>,<?php echo $log?>&spn=0.038499,0.054932&z=14" style="color:#0000FF;text-align:left">VER MAPA MAS GRANDE</a></small>
</body>
</html>

<?php

This is pretty much what we did. Hope it gives you a hint.

bye!

hpl123

Nice lineamovil

lineamovil

Thank you!

I always willing to share what ever I can.. I just hope more people would show their solutions and make AIM even bigger.

Back in MS Access Forums you could find anything that help you to make more helpful and attractive apps.

Hope we can do that here too.

hpl123

lineamovil wrote
I always willing to share what ever I can.. I just hope more people would show their solutions and make AIM even bigger.

kenlyle

Is there any more info on using KML files? I have an ESRI SHP file with a couple thousand parcels, converted to KML. I'd like to know how to go about loading these into the database.

aware_support

Aware iM supports polygons on Google Maps represented as KML. You just need to load KML into some attribute and specify this attribute when defining the map.

ACDC

I can confirm (as support has suggested) if you store the Coordinates in a Text attribute as follows 55.305012, -1.730040 and then set this attribute as the Address Attribute in the google map setup it will work .

Longitude, Latitude eg: 55.305012, -1.730040

kenlyle

I have been putting various forms of KML into a Plain Text field, which I have formatted as HTML because that seems more logical for a markup format like KML....the full KML file with the namespace, etc., just the <Placemark> element, and just the polygon, like:
<Polygon><outerBoundaryIs><LinearRing><coordinates>-75.136567630275337,40.306989485096189 -75.136567255909043,40.306989240434184 -75.13656566369113,40.306988207460044 -75.136566146483048,40.306987781747026 -75.136640102951105,40.306922284404443 -75.136706363200176,40.306863601825626 -75.136970595047245,40.307034279502616 -75.136832611318781,40.307160644178893 -75.136831862370244,40.307160160344317 -75.136567630275337,40.306989485096189</coordinates></LinearRing></outerBoundaryIs></Polygon>

and a bare list of coordinates...

I selected the field (Coords) in the Google Map control, which is on a tab by itself. No polygons.

Any more clues, please?

kenlyle

When I add an attribute of type Document, it's not available in the KML source dropdown in the Google Map settings. Anyone corroborate?

kenlyle

So here's what works:

Use a Plain Text field, but DON'T set it to HTML even though HTML and XML are related, I think as descendants of SGML....anyway...

And, if you happen to switch the field from HTML to Standard with data in it, the markup will get replaced with < etc., which won't work.

<?xml version="1.0" encoding="utf-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2">
<Placemark>
<Polygon>
<outerBoundaryIs>
<LinearRing>
<coordinates>
Long,Lat
Long,Lat
Long,Lat
</coordinates>
</LinearRing>
</outerBoundaryIs>
</Polygon>
</Placemark>
</kml>

If you received a SHP file like I did, run it through one of the free KML converters on the web, and strip out any unneeded attributes.

Enjoy!