<html style="direction: ltr;">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<style>body p { margin-bottom: 0cm; margin-top: 0pt; } </style>
</head>
<body style="direction: ltr;"
bidimailui-detected-decoding-type="UTF-8" bgcolor="#FFFFFF"
text="#000000">
On 09/06/2012 00:36, Chuck Young wrote:
<blockquote
cite="mid:CAKckdBRK6oYCMUMCrgZC=Qo2R-2U0hHJRRj9w3+9xg1fGNZufQ@mail.gmail.com"
type="cite">I have Two Tiger files that I need to associate. <br>
<br>
One is the roads layer: tl_2010_04007_roads.shp, with
tl_2010_04007_roads.dbf<br>
<br>
The other is the address data table: tl_2010_04007_addr.dbf<br>
<br>
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.<br>
<br>
</blockquote>
<br>
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. <br>
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:<br>
WHERE MTFCC='S1100' OR MTFCC='S1200' OR MTFCC='S1400'<br>
and so forth.<br>
<br>
<br>
<br>
<blockquote
cite="mid:CAKckdBRK6oYCMUMCrgZC=Qo2R-2U0hHJRRj9w3+9xg1fGNZufQ@mail.gmail.com"
type="cite">I can make a query or a view in the Spatialite GUI but
I don't understand how to integrate that into QGIS.<br>
</blockquote>
<br>
QGIS can, of course, display spatialite based layers and views...<br>
Can you be more specific as to what you're trying to do?<br>
<br>
HTH,<br>
Micha<br>
<blockquote
cite="mid:CAKckdBRK6oYCMUMCrgZC=Qo2R-2U0hHJRRj9w3+9xg1fGNZufQ@mail.gmail.com"
type="cite"><br>
If someone can give me a simple explanation, possibly with some
examples that would be much appreciated,<br>
<br>
Thanks<br>
<br>
Chuck<br>
<br>
This mail was received via Mail-SeCure System.<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
This mail was received via Mail-SeCure System.
</pre>
</blockquote>
<p><br>
</p>
</body>
</html>