- 2 replies
- 1,126 views
- Add Reply
- 6 replies
- 2,670 views
- Add Reply
- 4 replies
- 2,492 views
- Add Reply
- 1 reply
- 952 views
- Add Reply
- 1 reply
- 1,309 views
- Add Reply
Help PostgreSQL: Case Statement (ST_Intersects)
By Reyalino,
I am trying to write case statement to intersect point in areas using Postgres as below:
SELECT Point.id, Point.geom, Box.Postcode,
CASE
WHEN ST_Intersects(Box.geom, Point.geom) AND Box.postcode = 'A' THEN 'A'
WHEN ST_Intersects(Box.geom, Point.geom) AND Box.postcode = 'B' THEN 'B'
WHEN ST_Intersects(Box.geom, Point.geom) AND Box.postcode = 'C' THEN 'C'
ELSE 'No postcode'
END AS PointPostcode
INTO PointCode
FROM Point, Box
The idea is that every Point which is located inside the
How to convert dgn files to esri shape file format
By deepgis,
Respected All,
I have three sets of .dgn files. These are the files of topomaps of my studyd area. I want to convert these files into esri shape file format. Main issue is with how to convert annotaions into the labels of respecitve shape file i.e. point, polyline, polygon etc. Need help.
Where to download historical SPOT imagery?
By colleendupont,
Hello,
I am looking to buy SPOT imagery from the 90s through to the present. I have been able to find imagery from 2011-2016 through AIRBUS, but I cannot find where to download older imagery.
Any ideas?
I'm not sure if it matters, but I am in Canada.
Thank you,
Colleen
Eurocontrol Specification for Data Quality Requirements
By Mapper310,
Hi all,
I have started big project for one startup company and I need to find out what does it mean term "resolution". Yes, it seems simple but I´m little bit confused. Yes I know what does it mean in real world (example resolution 50 --> pixel with size 50 cm x 50 cm), but in "air" terminology.....something wrong
Example: I have for example Runway threshold (point) and he should be scan in "resolution" 1/100 sec and accuracy 1 m. Could someone explain me what does it mean in remote
Georeferencing multiple topo maps
By ahyakbaba,
Hi everyone, i have the massive which i should complete in 1 month about the subjected topic. I have 1000 topo maps and i need your contribution how i can automate this process as much as i can. Thanks in advance. Tapatalk kullanarak iPhone aracılığıyla gönderildi
-
Forum Statistics
8.7k
Total Topics43.4k
Total Posts