Tag Info

Hot answers tagged

2

Create a table or a view from it: CREATE TABLE my_selection AS SELECT name, neighname FROM neighborhoods WHERE ST_Intersects(geom, ST_GeomFromText('LINESTRING(586781.701577724 4504202.15314339,586863.51964484 4504215.9881701)', 26918));` Although if you want it in QGIS you will also want to select the geometry so: CREATE TABLE ...


2

Use UNION or UNION ALL to build one result from your two selects: insert into table_1 (name, id) select name, id from table_2 limit 1 UNION select name, id from table_3 limit 1; UNION will remove the duplicated rows from the union, UNION ALL will include all.


1

You're thinking in cartesian and operating in geodetics. If you really want to do delta_x/delta_y, do the work in in geometry in some projected space, not geography. If you want to use geography, don't use delta_x/delta_y, use distance/direction, generated using ST_Distance(geog,geog) and ST_Azimuth(geog,geog). (It's sometimes hard to visualize, but if you ...


1

The omission in the dbtune parameters have been acknowledged, by Esri development and are intended to be addressed in the next release. The changes will address the ability to control the placement of the spatial index on the business table, the a table (created by registering the feature class as versioned) and the location of the sde log files.


1

One possible improvement would be to create the line buffer once, and re-use that for each raster. As currently you're recreating the buffer for each raster. WITH linebuffer AS ( SELECT ST_Buffer(ST_Makeline(CAST(startloc AS GEOMETRY), CAST(endloc AS GEOMETRY)), 75) AS linebuffer_geom ) SELECT ST_UNION(rast) INTO elevationdata FROM uk_rasters, linebuffer ...


1

Normally, the shp2pgsql binary is in /usr/bin/shp2pgsql when you install with packages like in the method you mentioned. Did you type shp2pgsql in command line? Normally, it works out of the box. If not, did you do an updatedb (command line to index files) followed with a locate shp2pgsql to find the real binary path? did you echoed the output from the ...


1

This question is more than a little confusing ("point data is sample not really very" what?). Your SQL query syntax is highly irregular, and fails to use the correct function to take advantage of a spatial index on the point layer. What you probably want is: SELECT b.shape FROM table_b b, table_a a WHERE ...



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