Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm really new in this GIS world. I downloaded a shp file from Geofabrik (http://download.geofabrik.de/osm/south-america/chile.shp.zip) and imported it to Postgresql using Postgis. If I see the road table, this is the info that I get:

http://grab.by/fHa4

Looking in internet, I understood that geom can give me some geographic info that I need (lat, long per example). But, I need to know more specific information about this polyline: City, State, numeration, etc. Is this info in geom column? Or in other part in this .shp? How could I get this information?

share|improve this question
2  
a shape-file (extension shp) has only geometry-information. the companion dbase-file has infos like name of items, values of items etc. a shape-file is in reality at least three (or more) files: name.shp (geometry info), name.dbf (values), name.shx (index).esri has posted a detailed technical doku esri.com/library/whitepapers/pdfs/shapefile.pdf –  Kurt Aug 28 '12 at 18:15
add comment

1 Answer 1

up vote 3 down vote accepted

The shapefiles from Geofabrik contain all information on roads as far as they are stored in the Openstreetmap geodatabase. City and state are not part of the road data. You have to look for adminstrative borders and make database queries to look inside which city or state a road is.

The road number is stored in the ref field, if it is entered by a user. For example you will find G-300 or 78. But most of city streets don't have a ref, hence the table column is empty there.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.