New answers tagged

1

The ellipse and double-quote should not be there and should read as: PSQL=${PGBIN}/psql The ellipse (...) you are seeing is not part of the actual text and is just telling you that there is more data not being shown. Your 'tiger.loader_platform.geocoder' field should end like this for os= 'sh': PSQL=${PGBIN}/psql SHP2PGSQL=${PGBIN}/shp2pgsql cd ${...


1

If you want to interact with this data using SQL expressions without loading into a database server (PostgreSQL/PostGIS or SQL Server), try loading the shapefiles into QGIS and use the DB manager plugin. There is a node called "Virtual Layers" > "QGIS Layers" then you will see the shapefiles in your map. You can hit the "SQL Window" button and start writing ...


2

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 queries to get at the data. I loaded all US Data into PostgreSQL on a Win 7 (64 bit) with 8 GB ram and a 230 GB hard-drive (with other apps installed).... I am just ...


0

This statement will generate a script to load all states: SELECT loader_generate_script(array(select stusps from tiger.state), 'windows'); I do it a batch at a time (states that begin with A) with this statement so I can make sure it's working properly: SELECT loader_generate_script(array(select stusps from tiger.state where stusps like 'A%' order by ...


0

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(the_geom,4326) <-> ST_GeomFromText('POINT(-71.06941 42.34225)',4326) limit 1;


0

The link you provided (and other guides) don't go into any detail about setting up your environment paths in the tiger.loader_platform table. Check out this post which has more detail.


0

Regarding the warnings, I received the same warnings. Regarding the geocode time of 136 seconds, I have 37 states loaded and your request takes 2.8 seconds on my windows 64 bit box. If you have more states loaded, it will take longer. If you have fewer states loaded than I, then you may need to double check your indexes and modify your PostgreSQL server ...


0

Load both the TIGER data and the OSM data into the same PostGIS enabled database (I would suggest different schemas). Use the TIGER data to locate the road/address and then use its geometry to find the nearest road (by geometry) in the OSM data and display its 'access'. SELECT access from public.osm_roads order by geom <-> (select st_setsrid(geom,...



Top 50 recent answers are included