Questions tagged [geocoding]
5 questions
3
votes
1 answer
Is it possible to build PostGIS extensions without building the entire project?
PostGIS has an extension called postgis_tiger_geocoder, I have a few questions about it (all pretty tied together),
Is it possible to build that without building the rest of PostGIS?
If so, can I use the copy I build with my distro-installed…
Evan Carroll
- 65,432
- 50
- 254
- 507
2
votes
0 answers
MySQL 8 - Optimize query using ST_Contains or ST_Within
I have a table called locations with ~70000 records which includes a geometry column of points and a spatial index as follows:
UPDATE locations SET geom = ST_GeomFromText(CONCAT( 'POINT(', latitude, ' ', longitude, ')' ), 4326);
ALTER TABLE…
adam78
- 155
- 1
- 8
0
votes
2 answers
How do I generate a Loader_Generate_Script for all states and regions?
I'm using PostGIS and I'm wondering how do I generate a loader script for all states that will load all of the census dataset.
Evan Carroll
- 65,432
- 50
- 254
- 507
0
votes
1 answer
PostGIS geocoding from stdaddr?
PostGIS provides many different methods of address standardization
Some newer methods return stdaddr,
standardize_address (which requires explicit lex, gaz, and rules)
Others return norm_addy
pagc_normalize_address (which provides default…
Evan Carroll
- 65,432
- 50
- 254
- 507
0
votes
1 answer
What is the easiest way to install the latest postgis_tiger_geocoder?
Ubuntu distributes PostGIS with a core extension called PostGIS TIGER Geocoder, packaged as postgis_tiger_geocoder. Currently, as of PostGIS 2.2.2, it pulls data from TIGER2015. I would like to upgrade this to pull from TIGER2016. I want to use the…
Evan Carroll
- 65,432
- 50
- 254
- 507