Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [tiger]

Topographically Integrated Geographic Encoding and Referencing (TIGER) is a series of spatial data releases managed by the US Census Bureau. Many of its smaller area geographic divisions known as Census tracts and blocks are used as a standard in spatial analyses.

1
vote
0answers
35 views

PostGIS geocoding with local street centerline data

I have the PostGIS TIGER geocoder setup and working to geocode addresses in a single city. I am trying to use local street centerline data for geocoding instead of the TIGER data because it is more ...
0
votes
2answers
23 views

PostGIS Tiger Geocoder Not returning, stno, street, styp for geocoding

I recently loaded TIGER 2018 data for California. After fixing all the errors I have loaded all the data into the database. I checked each of the tables and all of them contain data. From this ...
-1
votes
0answers
5 views

Trying to run functions with adjusted TIGER and Census data but there are now datum conflicts?

I am trying to create maps that display the intersection between elevation and population, and elevation and housing costs using TIGER and Census data. However, when trying to get the census and TIGER ...
0
votes
1answer
21 views

Can't find my zip codes in TIGER/tigris

(This is my first attempt to use R, so I apologize for any stupidity. Also, please let me know if this is better posted in Stack Overflow.) I'm trying to use the Microsoft building footprint dataset ...
4
votes
1answer
134 views

Returning US Census geographies within range of coordinate using PostGIS and Tiger Decoder?

TL;DR: How do I write a query in SQL (postgres, postGIS, tiger extension) that will return census geographies (blocks, tracts, zcta) within an X mile radius of a lat/lng coordinate? Background: I ...
0
votes
0answers
21 views

Query all cities in the US

I have a PostGIS 2.3.3 Database with TIGER Geocoder. I would like to query for all the cities there are registered in the database, is there any way to do this?
0
votes
0answers
12 views

Joining Block Groups with Municipalities layer

I am trying to preform a join between block groups and municipalities to give the Block Groups a "District". Ideally what I wanted to do was preform a join between the Place File and Block Group file. ...
0
votes
1answer
21 views

GeoServer: copying style (Tiger Road)

I am learning GeoServer by extracting OpenStreetMap shapefile from https://extract.bbbike.org/ and add to Stores n Layers within GeoServer following this tutorial http://docs.geoserver.org/latest/en/...
1
vote
1answer
479 views

Free Open Source Geocoders using Local Address Data [closed]

We publish a geocoding service using ArcGIS server but are interested in moving to a free and open source alternative but can't seem to find anything that allows us to use local address data. Are ...
1
vote
0answers
82 views

Geometry/Geography type issue for US Census TIGER ShapeFiles

I'm loading the ShapeFiles from TIGER into SQL Server (via Python Geopandas/Fiona). It seems the boundaries are all of the Geometry data type (flat-earth). Do these file exist in the Geography ...
1
vote
2answers
75 views

postgis moving tiger data

Is there a way to move tiger, tiger_data to another database on another host? Without having to use the loader scripts? If I use pg_dump I get no data.
3
votes
1answer
180 views

How to extract zip code from reverse geocoding in PostGIS

I have a bunch of lat/lng coordinates that I can reverse geocode, after having installed PostGIS and the relevant Tiger files. I throw in a query like this: select reverse_geocode(ST_Point(lng, lat))...
0
votes
0answers
19 views

Trouble with Tigerfiles, fields come in as string and not as integer?

I am trying to do something simple like make a choropleth map of poverty ranges, but when I bring the csv file into qgis, all the fields come in as string and I can't do any analysis on those ...
0
votes
2answers
250 views

How to download TIGER data (for Postgis_tiger_geocoder) for one state through FileZila [closed]

I'm having issues to download Tiger data from the census site using the PostGIS packaged postgis_tiger_geocoder loader scripts. I want to try it using FileZila. FTP site: ftp2.census.gov USER: ...
1
vote
0answers
28 views

Change attribute table name in Tiger file

I'm fairly new at QGIS, though pretty experienced with ArcMap. So I thought I would learn it with a fun data set, a Census bureau tiger file. Specifically the Public Use Microdata Area (PUMA) which ...
2
votes
1answer
219 views

Assistance Speeding up a Query with ST_Distance_Sphere

I'm using PostGIS/Tiger for geocoding I am trying to find the first/nearest tract for a given long/lat, and while this query works great every time, it takes anywhere from 2-5 seconds to complete. ...
1
vote
0answers
54 views

Error importing TIGER census block gdb in GDAL

I have downloaded the 2015 Census Block GDB for the entire country from the census website here: https://www.census.gov/geo/maps-data/data/tiger-geodatabases.html. I am facing a problem in that when ...
0
votes
1answer
341 views

PostGIS Geocode function taking a lot of time some address, but not others

I setup a PostGIS/Tiger database and have been going through trying to optimize my queries. At this point I have am having issues with geocoding certain addresses, and I just can't seem figure it out. ...
0
votes
1answer
30 views

TIGER shapefiles and ZCTA

I am completely new to this and have never worked with shapefiles. What I'm trying to find out is whether it is possible, using the TIGER data in conjunction with the ZCTA files, to determine the ...
3
votes
3answers
236 views

Working around US Census site blocking of IP addresses?

I'm downloading TIGER data from the census site for the TIGER geocoder, but the computers IP has been blocked. I'm trying the following now: Generate the loader script on the target machine. Copy ...
2
votes
1answer
34 views

Speeding up a Query

I am using PostGIS/Tiger and I would like to find all locations within ~2 miles (~3218 meters) of a given location. The location in question is obtained by just doing select geography(the_geom) FROM ...
1
vote
0answers
96 views

Speeding up closest point query?

I'm using PostGIS/Tiger for a mapping solution. For a given longitude, latitude (derived when someone clicks on a point in my Google Map), I want to retrieve the closest point from my table. My table ...
2
votes
0answers
94 views

Configure Postgres for geocoding on amazon EC2 [closed]

I have an Amazon r3.large instance I'll use for geocoding. I'm using the TIGER geocoder with and have downloaded two states already. Texas and California, but I'm getting poor results on this. For CA, ...
1
vote
0answers
17 views

Copy TIGER geocoder data to another machine

I have downloaded census data and I want to copy to a different machine, which files should I move and how can I create the tables from this? since I will not be using the regular loader scripts.
0
votes
1answer
74 views

PostGIS Not Geocoding Counties

I have been able to use PostGIS and Tiger successfully to geocode addresses that are more formally typed out, however when I try with something like "Queens, NY" or "Brooklyn" it doesn't work. ...
0
votes
1answer
36 views

Error while downloading census tiger data: 304 Not Modified

I'm running nation_script_load.sh but I'm getting several errors and the data isn't been downloaded: First one is: HTTP request sent, awaiting response... 304 Not Modified Second one: rm: cannot ...
1
vote
1answer
62 views

Wrong results from TIGER geocoder for WA

For WA I'm getting wrong results from my local setup. For the this address: "1150 Varnum St NE, Washington, DC 20017" SELECT g.rating, ST_X(geomout) As lon, ST_Y(geomout) As lat, (addy).* FROM ...
3
votes
3answers
166 views

Return GeoJSON from a Census Tract

I am working on a new project where I need to highlight census tracts by boundaries. Google Maps can do this as long as I give it GeoJSON (data layers). I did some research and it seemed like Tiger ...
1
vote
1answer
197 views

Loading Tiger Data, and populating missing table data (such as tabblock)

I'm working with postgis and followed many tutorials out there to try to use tiger data. this one seems to be the best: https://bluehatrecord.wordpress.com/2015/07/06/installing-the-tiger-geocoder-...
2
votes
1answer
75 views

Populating postgis tiger tables

I've been following along with this Ansible Playbook to get PostGIS Tiger data setup: https://github.com/enigma-io/ansible-tiger-geocoder-playbook Everything worked great, and it said everything was ...
0
votes
1answer
34 views

Is possible to create a set up of the tiger geocoder in different hardrives?

I have a local setup of the geocoder, after some test, I realized that the time for the states is different. Some states have more data and the geocoding takes much more for these. E.G. for MA the ...
0
votes
0answers
346 views

Drawing Census Tracts in Google Maps

If I have census data with TigerGIS/PostGIS is it possible to get back all of the long/lat coordinates for the certain census tract? I want someone to be able to type in an address or census tract, ...
2
votes
1answer
171 views

Low accuracy for TIGER geocoder

I have the setup of the tiger geocoder for 15 states, the geocoding time for each address for each record takes between 30-100ms for most of the cases. The problem I'm having is that for a group of ...
0
votes
1answer
50 views

How to delete the data of one state from the TIGER geocoder

I'm getting wrong values for the coordinates using the tiger geocoder. I have some issues with this states because some missing values and I want to upload all the data again, but now it says 'xxxxxx' ...
0
votes
0answers
22 views

Missing files in Loader_Generate_Nation_Script for TIGER geocoder

I'm while running CREATE SCHEMA Archive: tl_2015_us_state.zip extracting: /tmp/gis/gisdata/temp/tl_2015_us_state.cpg inflating: /tmp/gis/gisdata/temp/tl_2015_us_state.dbf inflating: /tmp/...
1
vote
0answers
7 views

Tiger geocoder ask for password for each step while downloading the data

I'm downloading the data for geocoder with the respective scripts: nation_script_load.sh ma_load.sh The problem I'm having here is that for each of the files I asked to type the password, ...
3
votes
1answer
102 views

Inconsistent performance using the tiger geocoder.

I'm testing the geocoder results for one state, and I'm getting different results for directions that seem to be well formatted. E.G. Geocoding these addresses is taking around 100ms each: 280 ...
1
vote
1answer
39 views

Does the TIGER geocoder intersect the polygons to match an address?

This post has a very good overwiew of how open source geocoders works. 1) Address normalization 2) String matching. 3) Interpolation. It shows a simple case of how interpolation in made, taking as ...
1
vote
0answers
228 views

Normalizing addresses using PostgreSQL and PostGIS?

I am trying to geocode addresses in Hawaii using the PostGres/PostGIS with the 13.1. Tiger Geocoder. In Hawaii, many street addresses take the following format: ##-####. This is problematic with the ...
0
votes
1answer
53 views

Which the columns available on the TIGER geocoder

I have a local setup of the tiger geocoder and I want to extract as much information as possible from it. Currently, from a query SELECT g.rating, ST_X(geomout) As lon, ST_Y(geomout) As lat, (addy).*...
3
votes
2answers
74 views

Nation_script_load.sh asks for the DB password for each step

I'm loading TIGER geocoder data with the nation_script_load, during the process, I have to type the password several times. The same password that I set earlier along with the paths. export ...
1
vote
1answer
78 views

Select the correct paths for The TIGER geocoder (linux)

I'm following this tutorial to setup the geocoder. I'm stuck on the step 2.8.1.4 "edit the paths in the declare_sect column to those that fit Debbie's pg, unzip,shp2pgsql, psql, etc path locations."...
3
votes
1answer
128 views

Tiger geocoder is not finding results from manually loaded tables

I'm trying to test the TIGER geocoder with the address provided in the documentation. This is the sample address I'm testing:75 State Street, Boston MA 02109 SELECT g.rating, ST_X(g.geomout) As lon, ...
1
vote
1answer
184 views

Loader_Generate_Nation_Script is not creating the scripts

I'm working on setting up the TIGER geocoder on a Linux machine. I have installed PostgreSQL and PostGIS, now I'm working on the extension, point 2.8.1 of this guide: I'm having problems with the ...
3
votes
1answer
67 views

Where are contained the coordinates in the TIGER data

I have downloaded a shapefile from: https://www.census.gov/geo/maps-data/data/tiger-line.html Specifically tl_2016_11001_edges for the District of Carolina, which has the following columns: [u'...
4
votes
0answers
232 views

Customizing rules for Address Standardizer using PostGIS?

Following PostGIS documentation, I created a custom table for having different pagc_rules (also pagc_lex and pagc_gaz) so I can standardize/normalize addresses with different formats than the US where ...
1
vote
1answer
67 views

Spec for TIGER all lines files?

I have read the "technical" documentation for the TIGER geographic datasets and they fail to describe the way the geometry is encoded. The document claims that the shape files encode the geometry of ...
1
vote
0answers
61 views

Number of lanes in road data

I have been learning about the TIGER and the National Map datasets for mapping roads in the United States. One limitation is that as far as I can see there is no data on the number of lanes. The main ...
1
vote
0answers
30 views

Bad PostGIS TIGER Geocoding Performance In Specific States But Not Others

Short version: What should I do when I get great geocoding performance for all but one installed state? Long version: I (not a DB expert) am running the PostGIS tiger geocoder on my machine, not a ...
2
votes
1answer
79 views

TIGER schema information

I've recently pulled some of the TIGER data onto my local machine but, I'm at a loss about what it all means. I'm hoping to find some technical documentation on what all the tables and columns mean. ...