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.

learn more… | top users | synonyms

0
votes
0answers
16 views

PostGIS tiger geocoder installation trouble

I am getting the TIGER geocoding feature set up on my windows 7 64 bit box (PostGIS 2.1; Postgres 9.4). I followed the steps outlined here to generate the batch scripts and ran them last night: ...
3
votes
1answer
46 views

in QGIS how to add (join?) another table to a layer

Very new so bear with me. I have QGIS loaded with a TIGER/Line Shapefile at the Block level for a County, and need to join other detailed CENSUS data various tables (which also have a Block ID to ...
4
votes
1answer
54 views

Remove sliver gaps between polygons with R

Is there a way to eliminate the small "slivers" between polygons using R? The desired solution would create a new SpatialPolygonsDataFrame where the shared boundaries between polygons are coincident. ...
1
vote
1answer
25 views

Understanding failures in the PostGIS TIGER geocoder

I have encountered an address that appears to be giving the PostGIS TIGER geocoder a hard time. I've loaded the geocoder with the 2015 data, which includes the following in the ma_edges table: gis=# ...
3
votes
1answer
50 views

Is Sandy Springs, GA actually Atlanta, GA (ambiguous cities while geocoding)?

I installed postGIS and the associated TIGER geocoder for work, and noticed a strange thing when geocoding some addresses in the Atlanta area. For example, when I geocode the address "8610 Roswell ...
0
votes
1answer
37 views

Converting historical (1992/2000/2006) TIGER/Line files to modern shapefile formats

I'm trying to get some historical geographic information from Wisconsin and have been pointed the way of the TIGER/Line Shapefiles. Unfortunately, they're in a strange format (see, e.g., the files for ...
1
vote
1answer
56 views

Can we limit the search range of geocode() function in PostGIS Tiger Geocoder?

I found the server with only 2 states data loaded is much faster than the server with all states loaded. My theory is bad formatted address that don't have a exact hit at first will cost much more ...
1
vote
0answers
32 views

Find census block for street intersection with tiger geocoder

I'm geocoding lots of addresses and map them to census block. Some of addresses are street intersections, like this select ST_X((geo).geomout)::numeric(8,6), ST_Y((geo).geomout)::numeric(8,6) ...
1
vote
1answer
34 views

Normalize address query not working in postGIS

Okay, so I'm new at SQL, so bear with me. I'm trying to use the tiger extensions on postGIS (2.1.7) to normalize my addresses and then geocode them. The normalize query runs, but never returns an ...
1
vote
2answers
76 views

Did the code example of geocode() in PostGIS tiger geocoder geocode all records then limit later intentionally?

The geocode function in PostGIS tiger geocoder extension have an example of batch geocoding, which seemed to be used by many people. However I'm not sure if the behavior of this example I observed is ...
0
votes
1answer
50 views

How to add tiger schema to the database search path? [closed]

The tiger schema must be added to the database search path for the functions to work properly. I just started recently to use tiger dataset and postgres database and I have basic understanding of ...
1
vote
1answer
41 views

QGIS - find sections of district boundaries that overlap with city/county boundaries from shapefiles

I am working on a project where I need to find, for each US congressional district, how much of the congressional district's perimeter overlaps with a city or county boundary. Since the boundaries are ...
0
votes
0answers
47 views

Postgis reverse geocoding for other countries

I have tried using postgis_tiger_geocoder extension for reverse geocoding and it just has the U.S related data(56 states or so) but I need to have few more countries like canada and few more. Is there ...
1
vote
1answer
389 views

How to resolve the postgis “type geometry does not exist” issue on installing tiger_geocode extension?

I have installed postgis extension in my db. I have few columns associated with its type in few tables and now I would like to use reverse geocode functionality in my app. Hence I tried to create ...
13
votes
3answers
458 views

How fast should I expect PostGIS to geocode well-formatted addresses?

How fast should I expect PostGIS to geocode well-formatted addresses? I've installed PostgreSQL 9.3.7 and PostGIS 2.1.7, loaded the nation data and all states data but have found geocoding to be much ...
-1
votes
1answer
48 views

sample xsd files from geographic sources

Where can I download sample xsd files for different features like road,rail,river,land etc.I need them urgently for checking the working of my project which works on the schema of geographic data.
1
vote
0answers
22 views

PostGIS TIGER reverse_geocode() returns state only

I have a clean install of PostGIS 2.1 in Postgres 9.3 on Ubuntu, using apt-get and postgres extensions. Ran the data loading scripts from here. normalize_address works well, but geocode returns no ...
1
vote
0answers
28 views

Can the correct TIGER Line Id be returned for an address from the PostGIS Tiger Geocoder?

After reviewing the PostGIS Tiger Geocoder documentation, I don't see a method of returning the TIGER Line Id for the address. I would assume this is information is available internally as part of ...
3
votes
1answer
137 views

Finding census block for given address using Tiger geocoder

I have a geocoder based on Tiger/Line data running on PostGIS. I need to find census block for a given address. How can I do it? Like I can do for census tract: SELECT get_tract(ST_Point(-71.101375, ...
1
vote
2answers
591 views

Geocoding accuracy of Google Maps vs Tiger

I recently compared result of US Census Geocoder(http://geocoding.geo.census.gov/geocoder/) with that of Google Maps. For any given address both of them are giving different set of lat, lon. Why there ...
0
votes
1answer
58 views

Loading a specific county dataset in PostGIS

I want to load a specific county dataset in PostGIS. I can load a state script using: SELECT loader_generate_script(ARRAY['CA'], 'linux'); However, I want to load dataset only for Los Angeles County ...
0
votes
1answer
94 views

How to load all states of TIGER into PostgreSQL?

I downloaded TIGER2014 from the Census FTP and I was wondering how I would be able to load all the geometries at once. I learned about loader_generate_script and loader_generate_nation_script but I ...
0
votes
0answers
184 views

All queries on wkb_geometry column return null regardless of input ( ST_Point, ST_Intersects )

I am new to Postgis and I don't know if I am doing something wrong with my query, or if there is a problem with the data. I have been running queries on tiger shape files from the US Census site, I ...
6
votes
2answers
365 views

Burning road network into DEM?

Does anyone have any suggestions for burning a road network into a DEM? I have a python script written up for this executing this in ArcMap, but I would love to hear if anyone knows of any freely ...
0
votes
1answer
93 views

Download US census data profiles?

US census summary file information is available on the census ftp server: ftp2.census.gov/acs2013_5yr but I can't seem to find the data profiles information anywhere. The only source appears to be ...
3
votes
3answers
239 views

Which tool/reference for address geocoding?

I have to geocode several corporate sites (a big excel file), close to Paris (France). I would like to geocode this file based on the addresses. Could you tell me the best tool for this task ...
0
votes
1answer
129 views

Can you use the US Census ACS Api with TIGER Shape File GEOID?

The US Census makes available the TIGER Shape files for geographic area like States, Counties, Tracts, etc. (https://www.census.gov/geo/maps-data/data/tiger-line.html). They also supply an api for ...
1
vote
0answers
238 views

Importing 2014 TIGER County Shape Files to 2012 SQL Server?

Last year, I figured out how to import TIGER Census Block shape files into 2012 SQL Server with no issues. I assumed I would use similar code to do the county shape files but I keep getting a few ...
1
vote
1answer
164 views

No results for PostGIS TIGER geocoder extension

Similar to this question, my TIGER geocoder extension in PostGIS isn't returning any results. It seemed to all install correctly, so I imported DC, and: psql -d geocoder -c "SELECT g.rating, ...
4
votes
1answer
108 views

Is there a public repository of common formating styles for QGIS? Specifically for Tiger data?

I have downloaded the Tiger data for a map I'm working on and wonder if there is somewhere I can download the common formatting styles for these shapes so I don't have to reinvent the wheel. For ...
-1
votes
1answer
290 views

US Census Geocoder returns different city that TIGER Shapefile data

When I geocode an address using PostGIS+TIGER 2013 I get a different city than what Census Bureau Geocoder reports. The Long/Lat are identical in both cases, but the PLACEFP is different although both ...
3
votes
1answer
127 views

Troubleshooting with Tiger for d3 — is this the wrong projection? Why's it look like this?

UPDATE: Solved, sort of … I downloaded the file afresh and tried feeding it through ogr2ogr and topojson again … and wouldn't you know … after a while it worked. I think I was possibly not setting an ...
2
votes
1answer
78 views

TIGER/LINE 2013 Feature, Edge and, Address Range Data Sets

I am looking at the Tiger 2013 data sets, in particular the Edge, Feature and, Range tables. It seems that the Edge tables have all the data elements that are in the Feature and Range sets. Is this ...
2
votes
2answers
158 views

Did I set up Tiger Geocoder incorrectly?

I set up Tiger Geocoder in PostGIS on my local box (PostGIS 2.1.3, PostgreSQL 9.3.5, Tiger 2013 data). The problem I'm running into is that on almost every street most of the points are clustered, ...
1
vote
1answer
47 views

How can I fix the issue in the TIGER loader that causes it to fetch all files when loading Kansas?

I've discovered a bug in the TIGER loading script provided by Postgis 2.1.2. When loading Kansas (state code 20) I get FTP statements like the following: wget ...
2
votes
0answers
64 views

Insanely large house numbers in TIGER data

I'm parsing the US TIGER data and I'm coming across huge house numbers. example: 10100005 Thousand oaks drive, st johns, florida Google maps, and open street maps - nominatim says this is valid! Im ...
0
votes
1answer
75 views

Function get_partition(geometry, unknown) does not exist - Nominatim tiger data import

Ive install Nominatim with postgres9.3 and postgis 2.1, imported osm data ok and now trying to import tiger data (tiger2013 edges) for the house numbers. The import looks to go ok, but there is no ...
0
votes
1answer
103 views

Loading Tiger & ACS Data Into CartoDB

Does anyone have experience loading the pre-joined TIGER shape files and ACS 5 year data files by block group into CartoDB? I have downloaded the data from ...
0
votes
2answers
72 views

Joining Tigerline Census Data 2010 and American FactFinder xls

I have a shapefile from TIGERLine data from the Census website, as well as a spreadsheet from the American FactFinder. I've edited the excel sheet to a 97-2003 workbook, and am now able to bring it ...
1
vote
0answers
105 views

Add polygons to PostGres to be queried by Nominatim

I'm trying to build out a geocoder that also returns the correct legislative district information from this data: http://www.census.gov/geo/maps-data/data/tiger.html I've got OSM data imported into a ...
4
votes
1answer
80 views

Determining accessibility of U.S. street address

I'd like to determine whether a given U.S. street address is publicly accessible to vehicle/foot traffic. This would include addresses on both publicly and privately maintained roads that are not ...
1
vote
1answer
114 views

TIGER Geocoder not matching intersections without ZIP

I'm using the TIGER geocoder (2013 data, PostGIS 2.1, Postgres 9.3) to geocode intersections in New York City, but I'm finding that if I omit the zip code, I almost never get a match. So, for ...
4
votes
2answers
222 views

Can't get Tiger Geocoder to work in PostGIS

I've installed the PostGIS Tiger Geocoder according to these instructions and loaded in data for the state of New York. Unfortunately, when I try to geocode something... ny_tiger=# SELECT g.rating, ...
3
votes
1answer
875 views

Anyone who has the ESRI Census 2000 Tiger/Line data?

The ESRI Census 2000 TIGER/Line Data were free. http://www.esri.com/data/download/census2000-tigerline http://arcdata.esri.com/data/tiger2000/tiger_download.cfm But they vanished. The download link ...
1
vote
2answers
504 views

can't geocode with PostGIS 2.1.1

I don't know where's the mistake... I am using the process from the PostGIS documentation (http://postgis.net/docs/manual-2.1/postgis_installation.html#loading_extras_tiger_geocoder) . I created a ...
1
vote
0answers
36 views

Comparing TIGER 2013 with TIGER 2006

I'm doing a project when I want to compare TIGER 2013 data with the TIGER 2006 data. Essentially, the Census updated the data between 2002-2008, and a number of the counties were updated in the 2006 ...
0
votes
0answers
122 views

Extract city boundary from TIGER data

I'm trying to find the bounding box of US cities but I just can't seem to figure out what to do with the TIGER data I download (not to mention, which data to download!). Could someone experienced with ...
4
votes
1answer
186 views

Interpretation of PostGIS geocode function ratings

Edit: I am using Postgres 9.2 and recently installed PostGIS along with the Tiger Geocoder from the extras folder and downloaded all the latest Tiger data. I have been testing the Tiger Geocoder ...
6
votes
3answers
699 views

How can I obtain the same area values provided by the Census for TIGER boundaries using PostGIS functions?

In PostGIS, how can I compute the area of Census Boundaries and obtain the same results as are provided by the Census? For example, most Census Boundaries include attributes for Land Area and Water ...
7
votes
2answers
2k views

Install PostGIS and TIGER Data in Ubuntu 12.04

Could someone write a brief albeit dumbed down idiot's guide to installing postgis and loading national Tiger data on ubuntu? I've tried a few guides, namely, ...