On 09/06/2012 00:36, Chuck Young wrote:
I have Two Tiger files that I need to associate. 

One is the roads layer:  tl_2010_04007_roads.shp, with  tl_2010_04007_roads.dbf

The other is the address data table: tl_2010_04007_addr.dbf

I need to understand how to get the data in the address table to work with the shape file and display data on the map.


I don't know too much about the TIGER data, but have you had a look at the "edges" shapefiles. That layer seems to have everything already joined, and ready to use. So all roads appear in the edges shapefile, with their LFROMADD, LTOADD, RTOADD, RFROMADD, FULLNAME,  etc, etc.
You can filter out roads (or any other line features with the MTFCC column. All roads or trails start with an 'S'. Primary roads are, i.e S1100. So you could make a view in spatialite ( or a query in QGIS) showing only paved streets with:
WHERE MTFCC='S1100' OR MTFCC='S1200' OR MTFCC='S1400'
and so forth.



I can make a query or a view in the Spatialite GUI but I don't understand how to integrate that into QGIS.

QGIS can, of course, display spatialite based layers and views...
Can you be more specific as to what you're trying to do?

HTH,
Micha

If someone can give me a simple explanation, possibly with some examples that would be much appreciated,

Thanks

Chuck

This mail was received via Mail-SeCure System.


_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

This mail was received via Mail-SeCure System.



_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to