Tag Info

New answers tagged

1

Grant the following privileges on the appropriate database/schema to your user, you should then, be able to read the data into Cadcorp SIS 7.1 / 8.0. GRANT select ON ALL TABLES IN SCHEMA public TO username;


1

You should add a PostGIS extension, and use the geometry type instead. It will handle 30000 features easily, and work with many GIS systems (e.g. QGIS). You can always extract the WKT equivalent from a geometry column using ST_AsText. Here's an example workflow, assuming it's a table in postgres --Say you have a table described in your question CREATE TEMP ...


1

I followed this guide by a Duncan Golicher: https://duncanjg.wordpress.com/2012/11/20/the-basics-of-postgis-raster/ I was using tiles with an automatic setting originally, but I reset the tiling to 100x100 cells per row and then included the pyramids as shown in the guide like so: raster2pgsql -s 3161 -d -C -I -M -l 4 D:\PostGIS_data\dem.img -t 100x100 ...


2

Changing text fields length needs an exclusive schema lock on the dataset. Exclusive schema locks—In contrast to shared schema locks, exclusive schema locks are controlled by the developer or ArcGIS application, such as ArcMap or ArcCatalog. An exclusive lock is used to lock a geodatabase dataset or object from use by others to make the necessary ...


0

I am not sure if your concern in 1) is justified. If I am not mistaken, GeoDjango stores coordinates as a float and in Python has 16 digits precision, which is probably more precision than most observed spatial data has. For instance, to store a longitude coordinate in WGS84, you have values between -180 and 180. This takes three digits before the comma and ...


0

Clicking through on the links from the Rural definition pdf eventually gets you to here: http://www.ons.gov.uk/ons/guide-method/geography/products/index.html Where you can download the 2001 and 2011 definitions at a variety of resolutions... In response to Mapparz suggestion - I'd be tempted to use the OA level Rural-Urban geography in conjunction with the ...


2

I made a test with SQLite / SpatiaLite and for me QGIS does show UPPERCASE or whatever I want to.


4

Any SQL-compliant spatial database should work, including PostGIS (if you happen to be running a PostGIS server) or SpatiaLite (but note quirks about behavior mentioned below). Either one will satisfy your criteria: Identifiers (including column names) can be up to 63 characters in a default PostGIS installation (and this can be increased by changing the ...


0

I'm doing something like this with OSM data - looking for changes in specified tags (milestones, hydrants) and if there is some change I'm sending mail. Resolution is for linux. Workflow is very simple Selecting interesting data (e.g. somefield older than 48 hours) and writing response into file checking what is size of file If greater then just empty ...


0

We already using a similar solution for our existing service. Postgres/postgis(with triggers for calculated fields) connected to gmail + google calendar via zapier ( http://zapier.com ) Unfortunately to connect to postgresql via zapier is not free.



Top 50 recent answers are included