Tag Info

Hot answers tagged

10

As of PostGIS version 2.0, "geom" is the common column name. (At least I see it documentation, etc.) Prior to that it was "the_geom", and I can only speculate as to why. You may safely use either, but I am happily using "geom" in PostGIS and SpatiaLite. Edit: Because I completely missed the second part of the question. In general, a common name is ...


9

You're looking (Searching) for P R and K as strings. You need to do FeatureCODE searches on Parks: http://api.geonames.org/search?featureCode=PRK&maxRows=10&username=demo More Geonames API search information: http://www.geonames.org/export/geonames-search.html


7

From the search documentation: 'name' and 'toponymName' The response returns two name attributes. The 'name' attribute is a localized name, the preferred name in the language passed in the optional 'lang' parameter or the name that triggered the response in a 'startWith' search. The attribute 'toponymName' is the main name of the ...


6

I think your best bet is going to be downloading GIS data for populated places and coastlines (Natural Earth is an oft-recommended source) and performing a proximity analysis using GIS software to exclude all places except those matching some criteria, e.g. within 10 miles of a coastline. Bear in mind the world is a big place, and the coastlines are very ...


6

One potential reason that "geom" or "the_geom" was chosen as the generic name for the "shape" field was because you can actually store multiple geometry types (point, line, poly, etc) in the one "geom" field in the same table. You can even look back to 2005 when this was discussed on the PostGIS email list. For example, you could store all of your houses, ...


6

The parks come from a points of interest layer - and points are just that, points. They don't have an area so there's no way to determine which one is bigger. You would have to do another query from the points to a polygon layer, or have some similar means of obtaining the area of the park, to filter by size. The "score" is "how appropriate these results ...


4

It depends what do you define as a "code". An abbreviation? The ISO breaks down the geopolitical world into only country codes. Beyond that, there are no international standards for a country's regions (e.g., State, Province, Territory, Region, District, etc.). Update: The ISO also defines principle subdivisions of countries with ISO 3166-2. The US Federal ...


4

I have identified some variable quoting problems in the code (causing troubles with white space in the path and such) and fixed it. A few hours ago a new winGRASS binary snapshot was built, you can download it here: http://josef.fsv.cvut.cz/wingrass/grass64/ -> WinGRASS-6.4.SVN-r45245-1-Setup.exe (or more recent) I hope it works now. Alternatively, you ...


3

Puerto Rico isn't included under the 'US' label (likely due to its unincorporated status), it can instead by found by changing the country to 'PR': http://api.geonames.org/search?featureCode=PRK&username=genadinik&country=PR&style=full&maxRows=10


3

To display labels on QGIS you can click on the menu on "Layer"->"Labelling". Then you can choose the field name to display on your label. On recent versions of QGIS you can add modifiers and functions to the field content. Then you set the options for the way it will be rendered : color, size, buffer... You can see the data fields content with the ...


3

Working with the GeoNames.org database can be a bit difficult because of this inconsistency in the categories you described. I don't know where it comes from, but I guess it has to do with the different sources the names are from. In regions like Europe it is even harder to work with the GeoNames.org data, because of the different administration levels in ...


2

The country code for American Samoa is AS. Try something like this: http://api.geonames.org/search?featureCode=PRK&username=genadinik&country=AS&maxRows=1000


2

Download the data dump and put it into PostGIS. See http://ian01.geog.psu.edu/geoserver_docs/data/geonames/index.html for more details.


1

The SimpleSvg plugin (as described in this answer) passes through some of the shapefile's attributes. It only works with Old Symbology layers, and may produce SVG that's specific to the Inkscape drawing program.


1

You have to select encoding for SHP-files. If it works UTF-8 is the best solution. If it doesn't you can experiment with other latin2..9 encodings. This should work, but it will show encoding correctly for one of the language/diacritics groups. So it will work fine within a single country. But you may need more than one shape if there are multiple ...


1

When using Geoserver REST api in publishing existing PostGis tables, the REST command will fail if the geometry column is not named "geom".


1

http://www.geonames.org/statistics/mexico.html Area Features (parks,area, ...) Parks 71 71 L.PRK park an area, often of forested land, maintained as a place of beauty, or for recreation 65 L.AREA area a tract of land without homogeneous character or boundaries 51 L.LCTY locality a minor area or place of unspecified or mixed character and ...


1

For Canada and all details including Provinces ( & FIPS Code): http://api.geonames.org/search?q=Canada&maxRows=10&lang=en&username=demo&style=full prettified: http://www.geonames.org/CA/administrative-division-canada.html



Only top voted, non community-wiki answers of a minimum length are eligible