If I have a list of address that is for instance "Keilaranta 17 FI-02150 ESPOO FINLAND" in my sql server database and I want to add a new column to add the data of WGS 84. You retrieve the WGS 84 data from google map or similiar. Is it possible to do it?
Retrieve WGS 84 from Google map
1.3k Views Asked by HelloWorld1 At
2
There are 2 best solutions below
0
Andrew - OpenGeoCode
On
Generally, you can't permanently store coordinates obtained from Google map API, though you can cache for up to 30 days for performance purposes. Here's a link to a similar stackoverflow question I and others had answered:
Terms and Conditions Google Maps: Can I store lat/lng and address components?
Related Questions in GOOGLE-MAPS
- Uncaught TypeError: google.maps.LatLng is not a constructor at init (script.js:7:13)
- MarkerInfoWindow doesn't hold the clicked marker position after list refresh in Compose Map
- The Polyline is not showing in flutter but the directions api is enabled and the current position is not updating
- Unsure what imports to use for Advanced Marker Element
- The problem is that it takes a long time to index web pages in emdadrodbar.ir?
- distance matrix api gives incorrect data
- How to display google maps in dark mode in a .NET MAUI (Android) app
- Couldn't import Google Map API
- google maps api - how to get location information /place_id from shareable links maps.goo.gl
- 'map-advanced-marker' component not found after upgrading @angular/google-maps
- How to Filter bus stops between Start and Stop BUS STOP?
- How to make pressing on marker fill in the textViews
- Google api nearbysearch how to filter data business_status
- Embedded google map throws net::ERR_BLOCKED_BY_CLIENT in chromium(Brave) browser
- Why the code shows only the header and footer of xml file?
Related Questions in GEO
- Convert lat,lon,data points to matrix (2D grid) at 0.5 degree resolution in Python
- how to use maps in an offline power bi dashboard, it can be created online then transferred to the offline machine?
- Edit Map in px.scatter_geo Plot (add GA county lines)
- Is the map service support multi language?
- Join two datasets based on latitude and distance
- Creating openlayers feature in the backend
- How to convert string representation of coordinates to geopandas LineString?
- Read pixel values from GeoTIFF in C#
- If I include Geo Targeted content in a website, how could I also change that content when a visitor selects a location page?
- How to set the colors for a numeric variable and color points above a threshold in one color?
- BigQuery: Cluster non-convex geo points into MECE shapes/polygons
- What does the r parameter stand for in the _geoToHex2d function in Uber's H3 geospatial indexing system?
- Function using Haversine formula to calculate distance
- Add data from another dataframe based on nearest spatial location (lon, lat) and datetime
- switch WP url based on visitor country
Related Questions in WGS84
- Is there a way to convert points in a U-V Coordinate system to WGS84 points?
- why yandex can not get satellite map by tiles api and use different pro4j
- How can I calculate the rows where a 10 meter (0.01km) increase has occurred?
- Relationship between azimuthal equidistant projection and WGS84 curvilinear to NED transformation
- Javascript Formula to convert WGS84 lat, long values to RD_New co-ordinates
- How Do I Convert from Map Coordinates from SWEREF99 TM to WGS84 Using R?
- How can I get equal lan lat grids using WGS84 with ggplot in R
- Is there a convenient way to generate points a given distance and direction away from another point on the globe in R?
- WGS 84 geojson to lat lng coordinate system
- Intersection of a ray and a sphere
- QGIS: 2 layers using different CRS
- How to convert ECI coordinates to a specific ITRS (such as ITRF2014) coordinate frame using astropy?
- Convert coordinates from Dealul Piscului 1970 coordinate reference system to wgs84
- How to project a point to wgs84 crs with geographicLib
- Using sp, terra, raster packages in R to convert Albers Equal Area to Lat/Long
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You need to look into the Geocoding API. Effectively you need to provide Google with an address (so in your case Keilaranta 17 FI-02150 ESPOO FINLAND) and the API will return the long and lat in WGS84 (Spherical Mercator).
You will also want to read the TOS associated with this as storing results for any use other than caching is against the rules laid out without a commercial licence.