4
The line $sql='UPDATE signaletique SET infos="'.$_POST['maj_infos'].'"WHERE id="'.$_GET['feature-id'].'"'; is extremely bad. Seriously.
Let's start with the gentle item: in Postgres, double quotes are used to specify an object name, in this case a field. The content of maj_infos is therefore interpreted as a field name, which likely does not exist.
Then ...
2
Several modifications are required to make it work.
Before that, let's note that geom is a confusing name for a geography field... call it geog and so it will be obvious when a cast to geography is needed or not.
A spatial index is used only if the same expression as the one used to create the index is used. In your case, it is a index on a geography field ...
2
So you are checking a coordinate from the UK, and the polygon CRS is either WGS84 with a typo, or a CRS for Taiwan with a way out of bounds coordinate.
Since the typo is more likely, you need to fix the query
where ST_WITHIN(ST_SetSRID(ST_MakePoint(long,lat),4326),l.wkb_geometry)
Else if you are really using 4236 (Taiwan), you would need to fix the data ...
2
The image index typically has attributes that you collected via property collectors (if you configured them). This allows you to select a single image, using the CQL_FILTER parameter: set a filter that acts against the attributes of the mosaic index, and it select the one image you want.
If you don't have any other attribute, you can try using the "location"...
1
The general idea of an image mosaic is to display all of the images in it. The only control that you have is over the "order" they are displayed using the SORTING parameter to control which image is on top.
You can filter the mosaic by TIME or ELEVATION parameters or a custom DIMENSION as described in the manual. But there is no specific way to limit that ...
1
Each row in firstblock has its own ID.
When you do the lead(..)(PARTITION BY ID ..), it "breaks" the data for each ID, so there is a single row and therefore no previous (lead) row.
In this example, you can simply order the window function to find the previous row:
...
SELECT
CASE
WHEN ST_Area(the_geom) <= ST_Area(lead(the_geom) OVER(...
1
Thought I would provide an update as the earlier user guides are a bit out of date.
I used a combination of the website from @Hani Dradi which really helped with the PostgreSQL installation and a second website as I was not sure what applications I should install with PostgreSQL using Stack Builder - the answer was only PostGIS.
https://www.geo-gate....
Only top voted, non community-wiki answers of a minimum length are eligible
