spatialite find if point is in polygon

How to find if a point is in a polygon. The shape file I used is tigerline data from the census site. I created a new database and imported the shapefile. $ spatialite us.sqlite SpatiaLite version ..: 4.1.1 Supported Extensions: - 'VirtualShape' [direct Shapefile access] - 'VirtualDbf' [direct DBF access] - 'VirtualXL' [direct XLS access] - 'VirtualText' [direct CSV/TXT access] - 'VirtualNetwork' [Dijkstra shortest path] - 'RTree' [Spatial Index - R*Tree] - 'MbrCache' [Spatial Index - MBR cache] - 'VirtualSpatialIndex' [R*Tree metahandler] - 'VirtualXPath' [XML Path Language - XPath] - 'VirtualFDO' [FDO-OGR interoperability] - 'SpatiaLite' [Spatial SQL - OGC] PROJ. [Read More]

Exploring openstreetmap

I want to make a map of the continental united states (CONUS) that contains the US border, state borders and major highways using data from OpenStreetMap. It can’t be that difficult, right? Getting OpenStreetMap Data The first order of business is getting the data. A quick google search led me to the Downloading data page on the OpenStreetMap wiki. A quick look through extracts that others provide did not seem to have what I wanted so I opted to download the entire planet. [Read More]