7
votes
How fast should I expect PostGIS to geocode well-formatted addresses?
I've spent a lot of time experimenting with this, I think it's better to post separately since they are from different angle.
This is really a complex topic, see more details in my blog post about ...
- 370
7
votes
Accepted
Remove sliver gaps between polygons with R
It seems that the solution lies in setting the smoothFactor argument in AddPolygons to 0, as suggested in this related post: Leaflet geojson styling leaves gaps between polygon
I also found it ...
- 396
6
votes
Accepted
in QGIS how to add (join?) another table to a layer
You've got a few options here. QGIS can natively open and process from CSV files so if your data is already in that format, you should be fine. Otherwise, you can export it to that format or install a ...
- 1,388
5
votes
Accepted
Resolving postgis "type geometry does not exist" issue on installing tiger_geocode extension?
It should be able to find it if postgis is in your database search path.
Trying doing this:
ALTER DATABASE your_db SET search_path=public,postgis;
Then connect to your database again and do:
...
- 10.2k
5
votes
Free Open Source Geocoders using Local Address Data
You should definitely look closer at the Mapzen Pelias geocoder.
We have been having this same issue for several years, and recently discovered that one of the back-end sources for Pelias is ...
5
votes
Accepted
Returning US Census geographies within range of coordinate using PostGIS and Tiger Decoder?
Query structure:
In general, querying a table for true radius lookups is best executed using ST_DWithin, i.e.:
SELECT *
FROM <your_table>
WHERE ST_DWithin(<geom_colum>, <ref_geom>, ...
- 28k
5
votes
Accepted
Extracting roads shapefiles from old TIGER/Line RT format?
QGIS
has a built-in driver for the TIGER data, as you've noted, through GDAL. This is exposed through the GUI in the Data Source Manager/Add Vector layer dialogs.
Similarly to how one would load ...
- 2,669
4
votes
Accepted
Analyzing map data in QGIS
The best way to find out what the attributes of any dataset represent and classify is to lookup the MetaData, In your case you should consult the metadata files the the US Census Bureau maintains of ...
- 3,306
4
votes
Accepted
Wrong results from TIGER geocoder for WA
You are probably missing the District of Columbia data. Using what you have for the state of Washington, you get the "best" result, which is fairly bad (wrong town and postal code)
- 38.3k
4
votes
Accepted
Working around US Census site blocking of IP addresses?
To simplify the download on multiple machines, you can use more advanced downloading tool (such as aria2c) that supports resume etc., and have a script continuously download the dataset from a file of ...
- 958
3
votes
Accepted
How to obtain Census block data in SQL format?
You can install PostgreSQL (opensource) and the PostGIS and TIGER extensions to load the TIGER data. This post has a lot of good info that I used to load the census data.
Then you can run SQL ...
- 3,580
3
votes
Accepted
Understanding failures in the PostGIS TIGER geocoder
I checked this. The problem seems to be that in the data GARDENS is part of the street name, but the normalizer breaks out GARDENS as a street_type
Curiously leaving out the GARDENS actually works
...
- 10.2k
3
votes
Changing unit of measure from degrees to meters in QGIS?
You need to save the shapefile as (right click the shapefile name and "save as") and when you save it - choose the new CRS, make sure to tick the "add to project" box at the bottom before you confirm.
...
- 31
3
votes
Did the code example of geocode() in PostGIS tiger geocoder geocode all records then limit later intentionally?
Hopefully this answers your questions
1) You don't want to geocode a whole table at once because of the way Postgres works. All work in an update gets committed as a single transaction, which means ...
- 10.2k
3
votes
Accepted
Finding census block for given address using Tiger geocoder
@Akhil answered his/her own question but I wanted to post this clearly for posterity in case others find themselves combing through comments to figure this out like I did.
TL/DR answer:
SELECT ...
- 826
3
votes
Interpretation of PostGIS geocode function ratings
As you already discovered, address input can be vague.
Geocoding function usually first try to standardize the input, which including use standardized format of road prefix, road post fix, ...
- 370
3
votes
Local geolocation to FIPS county using Latitude and Longitude
See this FFC site, it has moved: https://geo.fcc.gov/api/census/#!/area/get_area
And some python 3 code to get the data:
import urllib, json, requests
with urllib.request.urlopen("https://geo.fcc....
3
votes
Specification for US Census GEOID
After several years, I finally created my own code to build a schema. However, it is currently embedded in a python library, so it isn't generally usable as a spec. Here is the geoid module, which ...
- 181
3
votes
Accepted
Which the columns available on the TIGER geocoder
Tiger data doesn't include parcels. It just has street centerlines and census tract.
For census tract that may be be turned off loading by default since I recall it taking some space. If it's not, ...
- 10.2k
3
votes
Loading Tiger Data, and populating missing table data (such as tabblock)
The 304 error that you're getting is expected since you're re-running the script and the data has already been downloaded locally for most of the data sets and isn't deleted between runs.
There seems ...
- 550
3
votes
Return GeoJSON from a Census Tract
You could use GeoServer to handle the conversion of PostGIS results to GeoJSON for you. A simple WFS request like this would return the geometry (and optionally the attributes associated with it).
...
- 79k
3
votes
Working around US Census site blocking of IP addresses?
I only see you mentioning http sites. Try using the Census' FTP site, ftp://ftp2.census.gov/geo/tiger/
- 2,255
3
votes
Accepted
Assistance Speeding up a Query with ST_Distance_Sphere
Your query seems slightly odd to me since you are going from a point to point with ST_Point(ST_X(ST_Centroid. That is going to slow things down for sure. Another thing is that you don't get the ...
- 3,267
3
votes
Extracting roads shapefiles from old TIGER/Line RT format?
The following code uses R to open the appropriate layer from TGR files for roads and saves it as a shapefile format.
I added additional steps within R to filter for just the roads in the code I used ...
- 3,666
2
votes
Specification for US Census GEOID
Here you cand find a simple explanation for the columns that you must concantenate to generate the GeoIDs for different geographic areas
https://www.census.gov/geo/reference/geoidentifiers.html
- 123
2
votes
Download US census data profiles?
The demographic profile tables (DP02, DP03, DP04, DP05) are extracts from the more detailed ones, so I'm not sure they would be available on the ftp server (since all the data is there in the full ...
- 473
2
votes
sample xsd files from geographic sources
If you're interested in INSPIRE data (as per your tag) then you should look at the INSPIRE site, for example INSPIRE xml schemas would seem a good place to look. These though aren't samples, they are ...
- 13k
2
votes
Can the correct TIGER Line Id be returned for an address from the PostGIS Tiger Geocoder?
A geometry is returned as part of the geocode() result, by which you can use to locate the nearest ID from any table that has a geometry column.
select gid from tiger.edges order by st_setsrid(...
- 3,580
2
votes
How fast should I expect PostGIS to geocode well-formatted addresses?
According to this discussion thread, you are supposed to use same normalization procedure to process the Tiger data and your input address. Since the Tiger data have been processed with the built-in ...
- 370
2
votes
How to add tiger schema to the database search path?
Hmm well if you installed with
CREATE EXTENSION postgis_tiger_geocoder;
It should do that automatically for you unless your user has an overriding search_path.
Anyrate standard way is to do:
...
- 10.2k
Only top scored, non community-wiki answers of a minimum length are eligible