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

5
votes
3answers
1k views

Specification for US Census GEOID?

I'm writing a program that needs to generate GEOID values from 2000 and 2010 Census data, to link the census data to TIGER/Line records. I'm starting with the state, county, region block, etc, values ...
0
votes
1answer
16 views

How is distance measured in TIGER/Line data for roads?

So I'm working with some TIGER data for network analysis, and it comes with no speed or time attributes, so I was able to assign average speeds to the various road types, and I was going to use field ...
1
vote
2answers
552 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 ...
0
votes
1answer
61 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 ...
2
votes
1answer
91 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
1answer
37 views

Cannot generate nationscript.bat - Tiger Geocoder

I have been attempting to install tiger - geocoder in a postgres database. After muddling through examples and resources online for days I have been able to conjure up this much of the workflow. I ...
0
votes
0answers
29 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
59 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
92 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. ...
4
votes
1answer
86 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
36 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=# ...
4
votes
1answer
207 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 ...
13
votes
3answers
624 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 ...
3
votes
1answer
58 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
78 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
5answers
7k views

Where can I find base data shapefiles for whole US?

I am looking for the base layers for whole U.S. - roads, hydrological lines etc with flexibilities of changing symbology and labels. TIGER is a good source but it is at county level. I am running on ...
1
vote
1answer
71 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 ...
3
votes
3answers
281 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 ...
1
vote
2answers
1k views

How to improve poor performance times for PostGIS 2.1 Tiger Geocoder?

I've recently upgraded my PostGIS DB from 2.0 to 2.1. I initially followed the instructions from Waiting for PostGIS 2.1 - Install PostGIS Tiger Geocoder as an Extension and 2.7. Installing, ...
1
vote
0answers
39 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
46 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 ...
0
votes
1answer
463 views

ArcGIS constantly shut down by itself

I am trying to open Census tract data, downloaded from http://www.census.gov/geo/maps-data/data/tiger-data.html Every time, I open the file in ArcGIS, the software will return an "serious application ...
1
vote
2answers
115 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
76 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 ...
6
votes
2answers
2k views

US Tiger or Open Street Map Route Data: One Way Street & Intersection Data

We're building a U.S. street routing application (finding paths for cars between two or more locations using public roads) and would like to use open source data US Tiger Data or Open Street Map or ...
1
vote
1answer
60 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
57 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 ...
7
votes
1answer
24k views

How to change the unit of measure from degrees to meters in QGIS?

I am running QGIS 1.7.0 on windows, and I donwloaded a shapefile of census block group boundaries from TIGER. This file appears to be in the WGS 84 coordinate system, and when I open it in QGIS the ...
1
vote
1answer
758 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 ...
4
votes
1answer
157 views

Best place to download or purchase shapefiles for Louisiana Parish?

I am looking for shapefiles to either download or purchase for the BEAUREGARD Parish in Louisiana. I have been able to find files for the Townships and Sections but I am in desperate need of a ...
3
votes
1answer
171 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
votes
1answer
76 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
24 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
30 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 ...
6
votes
3answers
622 views

Is Tiger/Line 2010 Data Inaccurate? What's more reliable?

I followed the instructions at: http://www.letseehere.com/postgis-geocoder-using-tiger-2010-data To get postgres working with postgis, but some of the addresses are off 500 ft to as much as 1 mile in ...
0
votes
1answer
120 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 ...
1
vote
2answers
784 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
98 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 ...
5
votes
2answers
254 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, ...
0
votes
0answers
210 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
406 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
142 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
261 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
51 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 ...
8
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, ...
5
votes
3answers
2k views

What is the highest resolution of population density data that I can obtain for USA freely?

Ok so as far as my understanding goes the most high resolution dataset available that factors in many other things (other than Census data ) at a 1X1 km resolution is Landscan data created by Oak ...
1
vote
1answer
198 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
118 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
344 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 ...
1
vote
1answer
93 views

ArcMap Geoprocessing Operation to create a layer with incorporated places and, separately, surrounding unincorporated portion of a county?

I am working with TIGER FILES, attempting to use the update (analysis) operation in ArcMap 10.1. The files I'm using are counties, and the incorporated (non-CDP) segment of the places file. I'm ...