Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think you need to install one GIS software. You can try open-source <a href="http://www.qgis.org/" rel="nofollow noreferrer">Qgis</a>.</p> <p>Because, firstly your data is not in long/lat (geographic) coordinates. Your .prj part of the shapefile (yes, all .dbf, .prj, .sbn, .sbx, .shp, and .shx files with the same name are one shapefile for GIS) says that the data are in the projected coordinate system NAD 1983 UTM Zone 15N. So, you need to <a href="http://kartoweb.itc.nl/geometrics/coordinate%20transformations/coordtrans.html" rel="nofollow noreferrer">transform</a> your data to geographic system. This you easy can do in GIS, or programmatically by <a href="https://trac.osgeo.org/proj/" rel="nofollow noreferrer">proj.4</a> library. (In Qgis add the shapefile to the project, then select it in the table of contents, right mouse button and choose "save as...". It will ask you for the target coordinate system.) Note, that you need to decide which geographic coordinates you wish, because your data are in the North American Datum (NAD 1983), but the most common worldwide now is WGS 1984.</p> <p>Secondly, in GIS you will see your data, are they really points, or maybe polygons. (In case your houses are polygons you will need to get centroids of them, in Qgis menu Vector - Geometry Tools - Polygon Centroids).</p> <p>Finally, when you really have your houses as points in geographic coordinates, you can get their coordinates, for example using advices from these questions <a href="https://gis.stackexchange.com/questions/8844/get-list-of-coordinates-for-points-in-a-layer">Get list of coordinates for points in a layer</a> and <a href="https://gis.stackexchange.com/questions/7199/how-do-i-calculate-the-latitude-and-longitude-of-points-using-qgis">How do I calculate the latitude and longitude of points using QGIS</a>.</p> <p>Besides, there is a good library to work with GIS vector data, <a href="http://www.gdal.org/ogr/" rel="nofollow noreferrer">OGR</a>, which can be used by many programming languages.</p>
    singulars
    1. This table or related slice is empty.
    1. POGIS data files converting each address to lat/lon in dbf shape data
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USnadya
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POGIS data files converting each address to lat/lon in dbf shape data
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks for your help, will investigate it tonight!
      singulars
      1. PO
      1. USmorty346
    2. COWell it appears I have the data switched to WGS1984, I was also successful in getting the polygon centroids... when I export as a csv file (per your links with GEOMETRY=AS_XY) I get X,Y points but they are not LAT/LON but in some other numeric range IF I go to vector->GeometryTools->Export/Add Geometry Layers it also has xy in non lat lon format I must be missing something.... when I export it shows CRS WGS 84
      singulars
      1. PO
      1. USmorty346
    3. COI also made sure onthefly reproject was set to on
      singulars
      1. PO
      1. USmorty346
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload