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
17 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
18k 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 ...
0
votes
1answer
29 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 ...
2
votes
3answers
158 views

Which tool/referecence for adress geocoding?

I have to geocode several corporate sites (a big excel file), near 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
395 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 ...
9
votes
1answer
196 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
133 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 ...
2
votes
1answer
80 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
20 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
16 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
19 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
572 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
51 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 ...
0
votes
2answers
245 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
53 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
76 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 ...
4
votes
2answers
162 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
120 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
282 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
87 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
175 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
35 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 ...
5
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
1k 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
112 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
98 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
210 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
92 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 ...
3
votes
1answer
95 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
2answers
133 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, ...
2
votes
1answer
66 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 ...
0
votes
1answer
69 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 ...
2
votes
0answers
61 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
81 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
66 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
89 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 ...
3
votes
0answers
71 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
95 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 ...
2
votes
1answer
689 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 ...
0
votes
4answers
5k 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
0answers
35 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 ...
4
votes
3answers
711 views

Downloading multiple files from TIGER FTP site

Hello everyone! I've been downloading TIGER data per county from the FTP site one at a time, with some states having hundreds of files. I was curious if there was a faster way to download maybe all ...
0
votes
0answers
112 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 ...
1
vote
3answers
486 views

How long does it take to load the complete Tiger 2013 dataset into Postgis?

I'm loading the complete TIGER 2013 dataset into a Postgis database and finding that the process is taking an extraordinarily long time. I was surprised by how long it took to load the TIGER 2012 ...
3
votes
1answer
393 views

Where are TIGER's “Consolidated Cities”?

The TIGER reference docs make numerous references to Consolidated Cities. It's also one of the checkboxes on TIGERWeb. But there are only 5 files in the Consolidate cities directory and available for ...
2
votes
0answers
149 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
593 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 ...
1
vote
1answer
66 views

How to write unique ID(s) of polygons in layer A intersecting polygons in layer B to field in layer B?

I'm working in ArcGIS 10.1. Suppose that I have two polygon layers, A and B. Polygons in layer B can have one of a few relationships to those in layer A: They may be completely contained by ...
2
votes
1answer
128 views

How to geocode addresses that are outside Address Ranges of source layer?

Im using TIGER lines to geocode a table of addresses. Say for instance the address range for a street is 1100-1200. What would be the best way to match an address such as 1094?
12
votes
7answers
15k views

Where can I find a shapefile of city boundaries in the US?

Where can I find a shapefile that contains boundaries for the major cities in the United States? I have tried the census website but could not find anything.