Hot answers tagged

13

There are some major differences in the two products, so it isn't exactly "apples to apples". Fusion Tables is extremely easy to use, just load in some data and you can have a Google Map displaying your data in no time. The back-end doesn't matter at all, you just need a place to store data and start working with it. So Fusion Tables is more of a product/...


10

Fusion Tables has storage limitations where AWS/EC2 is fully scalable to 5000TB. S3 users could only store objects up to 5GB. Amazon Web Services has decided to lift that limit and allow block storage up to 5TB http://aws.amazon.com/s3/#pricing Fusion storage limits - 250 MB per user account: 1 million characters per cell. And upload limits - 1 MB per ...


8

It sounds like you have a few different things you need to do: Geocode your user locations (e.g. from an address / postal code) Store the locations/attributes somewhere Render them on a map You can choose to do some or all of this using open source or other alternatives. If it were me, I would probably use some of Google's mapping stack (disclaimer, I ...


8

In ArcMap, If you look up Search in Polygon in ArcMap, you'll find this: "Select By Location to select those features from the points layer that intersect the polygon layer" That's found by "Selection>Select by Location" on the menu bar and it will ask for a Target layer then a Source layer and a selection method. So the Target layer is your point layer, ...


6

Fusion Table basic example Spatial Query set in the code: layer.setQuery("SELECT Country FROM 188044 WHERE ST_INTERSECTS(Country, RECTANGLE(LATLNG(35.77, -12.57), LATLNG(66.6, 37.3)))"); Source: http://homepage.ntlworld.com/keir.clarke/web/fusion2.htm from: http://googlemapsmania.blogspot.com/2010/11/spatial-queries-added-to-fusion-tables.html


4

In your crime incident table you are going to need some information that connects to your neighborhood. Your neighborhood polygon doesn't contain all the addresses within it so your best bet would be to either A) get some street, parcel or building data that contains addresses that match your list or B) open up your crime table and add a column for ...


4

There is the Route360 API that also works with Google Maps. https://developers.route360.net/index.html It offers quiet a few functionalities. Including different modes of transportation or the intersection of polygons As well you can add a few hundred points at once and see the result: It works for most countries in Europe and North America


4

check out this example here which uses arcgis service time geoprocessing service and google maps. if your points locate in US, u can use CreateDriveTimePolygons from ESRI here. you need to do is that write Input Location, Drive Times and format as json then execute your process. beside this you should check out similar ques.: Creating drive time ...


4

Yes. You are correct. Currently the functionality to zoom/fit bounds does not exist for polygon or line data from fusion tables. You will need to use the GVIZ (Google Visualization API) and the geoxml3 parser. I used some of the code from the following applications. One is a polygon example and the other is a line/arc example. There is a post in the Google ...


3

Unfortunately none of the google api's support this query beyond simple rectangles or circles. Your options are to pre-process using QGIS or the OGR API. Or you can implement the ray casting algorithm in JavaScript. Also - check out the source of this example: http://www.geocodezip.com/v3_collection-map2e_FT.html If you implement the algorithm yourself ...


3

You might want to re-think the overall approach. Displaying that many symbols is usually not a good idea, for performance and useability reasons (the labels would either over-print each other, or be so small as to be unreadable). Perhaps only show numbers when zoomed in to a certain scale (eg street level). You could also implement clustering to show "hot-...


3

You say that you have a spatial representation of the neigborhoods but the crime data is just addresses. there is to ways to connect the crimes to the neighborhoods. get a list of all addresses in the neighborhoods and join against that list. that is a non spatial solution. or you need to get some spatial representation of the crimeinformation. if you ...


3

Here is some code I'm successfully using to toggle a Fusion Tables layer in one of my maps: google.maps.event.addListener(map, 'zoom_changed', function() { zoomLevel = map.getZoom(); if (zoomLevel >= minFTZoomLevel) { FTlayer.setMap(map); } else { FTlayer.setMap(null); } }); it looks almost identical to your code, apart ...


3

While I can't test it, your VRT is different to that specified here: http://www.webrian.ch/2011/09/google-fusion-tables-in-qgis.html Try this: <OGRVRTDataSource> <OGRVRTLayer name="ps"> <SrcDataSource>GFT:refresh=<MY_VERY_LONG_TOKEN_IN_HERE></SrcDataSource> <SrcLayer>1kQSkw-...


3

It is trivial with ogr2ogr and SQLite SQL dialect. Next examples write 10 first lakes into one KML file and next 10 lakes into another KML file ogr2ogr -f kml batch_1.kml lakes.shp -dialect sqlite -sql "select * from lakes limit 10" ogr2ogr -f kml batch_2.kml lakes.shp -dialect sqlite -sql "select * from lakes limit 10 offset 10"


3

You can use the Proj4 converter: http://trac.osgeo.org/proj/ Yes, it is a converter but you can convert bulk coordinates. Create a simple text file (let's say sweref99.txt) with the coordinates, e.g. 606905.22 6970515.93 635765.54 7223101.41 In order to convert all coordinates from this file the command is like this: cs2cs +init=epsg:3006 +no_defs +to +...


2

I like jilivni answer the most (so far). I have yet to mess about with Fusion, and seems like a good choice for your needs. However, you mention a LAMP, stack, so storing the data in MySQL could be a good option. Check this tutorial on how to use PHP to show MySQL data (your table of users/locations) on top of Google Maps. In terms of gathering the ...


2

You have to export your table to csv Maybe use google refine to improve the data of your articles csv Import csv in a Fusion Table Geocode the table, its a feature in the user interface, you Geocode by the column "Article text" where the addresses are Click on the map view, and you could view the points, some of them will be missing because of an ...


2

The official answer from Google's Fusion Tables team is that this is not currently possible. I've added an enhancement request for this.


2

This seems to work - it doesn't seem to be a problem to call setMap if it's already set: google.maps.event.addListener(map, 'zoom_changed', function() { zoomLevel = map.getZoom(); if (zoomLevel >= minZoomLevel) { FTlayer.setMap(map); } else { FTlayer.setMap(null); } }); Thanks to Chris Broadfoot from the GM team for ...


2

You can get your all your table data and find the bounds from the response: var bounds = new google.maps.LatLngBounds(); for(i = 0; i < numRows; i++) { var point = new google.maps.LatLng( parseFloat(response.getDataTable().getValue(i, 0)), parseFloat(response.getDataTable().getValue(i, 1))); bounds.extend(point); ...


2

Recent updates to Google Maps v3 allow you to change the symbol using the API (from fusion tables) For example 'gold star' var goldStar = { path: 'M 125,5 155,90 245,90 175,145 200,230 125,180 50,230 75,145 5,90 95,90 z', fillColor: "yellow", fillOpacity: 0.8, scale: 1, strokeColor: "gold", strokeWeight: 14 }; var marker = new google.maps....


2

For this many features, you will want to render them into raster tiles. My recommendation would be to evaluate products that serve up Web maps like MapServer, GeoServer, Mapnick, etc. MapServer has C# bindings, but you could likely just use the standard WMS or CGI interface. Depending on your specific use case, you could look at caching with something ...


2

As GeoSpatialpython.com mentioned, javascript based ray-casting is a good choice. Here is a script from tparkin : https://github.com/tparkin/Google-Maps-Point-in-Polygon/blob/master/maps.google.polygon.containsLatLng.js It extends the google maps api v3 polygon class with a new method called containsLatLng which accepts a single LatLng object, which ...


2

If you don't mind a 3rd party app, you could try Arc2Earth Sync It will connect to Fusion Tables on your account's behalf and make it look like an ArcGIS Feature service. It can also use your ArcGIS.com credentials to create/update web maps so your FT tables show up automatically in the ArcGIS iOS/Android apps (or any of the ArcGIS Online apps/apis). Check ...


2

Disclaimer: I work for iGeolise You can use the TravelTime API to draw maps based on drive times here, it works for location-based searches (for consumer-facing sites for example) or one off maps. This example is for drive times from Norwich, UK. There are multiple polygons for 15 minute intervals from 15 mins - 1 hour, starting at midday. It uses lat/ ...


2

You can make a custom tiled layer that makes direct requests for FusionTables tiles, though you'll need to play with the URL to figure out what X/Y/Z parameters are in the URL, and you'll need to check the T&C to make sure you're not breaking them. I had it figured out a couple months back, but I honestly cannot remember what X/Y represent. Z is the ...


2

Google Fusion tables is pretty limited beyond basic use cases. May I suggest bringing your data to CartoDB, this is exactly made to resolve level of problems.


2

What you describe is finding the best route along a network which has each segment assigned an impedance representing risk of accident. For this you could use a license for the Network Analyst extension to ArcGIS for Desktop. A good place to start reading about this topic is here. Having the route based on your assigned impedances solved using Google ...


2

The ogr2ogr example is probably the most efficient, but if you prefer to do it without commandline you can just open the attribute table of the layer you're saving as KML, order the table on ID and starting from the top you select a number of records which you think will be within the limit (if the file is 150 megabytes, maybe select half of the records?) ...



Only top voted, non community-wiki answers of a minimum length are eligible