Vjylku

My story is written in English, but is set in my home country. What language should I use for the dialogue?

Can "semicircle" be used to refer to a part-circle that is not a exact half-circle?

Who is our nearest neighbor

Co-worker team leader wants to inject the crap software product of his friends into our development. What should I say to our common boss?

Format picture and text with TikZ and minipage

What exactly is the purpose of connection links straped between the rocket and the launch pad

Why does Deadpool say "You're welcome, Canada," after shooting Ryan Reynolds in the end credits?

Life insurance that covers only simultaneous/dual deaths

A curious inequality concerning binomial coefficients

Can't remove a file with file mode bits a+rw

This equation is outside the page, how to modify it

Is King K. Rool's down throw to up-special a true combo?

Block storage rewrites

How could a female member of a species produce eggs unto death?

Unreachable code, but reachable with exception

If the Captain's screens are out, does he switch seats with the co-pilot?

Do I need to leave some extra space available on the disk which my database log files reside, for log backup operations to successfully occur?

Should we release the security issues we found in our product as CVE or we can just update those on weekly release notes?

What is the definition of "Natural Selection"?

Single word request: Harming the benefactor

Why do Australian milk farmers need to protest supermarkets' milk price?

Am I not good enough for you?

Best approach to update all entries in a list that is paginated?

validation vs test vs training accuracy, which one to compare for claiming overfit?

Using ST_Intersection with three or more tables

How to update attribute values of points outside an area?Merging polygons for rendering with GeoserverCutting linestrings with points?ST_Intersection between MultiPolygon tables leads to gaps, missing intersectionsST_Difference on linestrings and polygons slow and failsUsing ST_Intersection with two rasters?Listing results of many ST_Intersects in one table?Difference between PostGIS ST_Intersects vs '=', QGIS and ArcGIS 'select by location'Intersection between an angle and a polygon (postgreSQL + postGIS or Python2.7 + shapely + psycopg2)Aggregate version of ST_Intersection

0

I'm trying to achieve a multiple-table intersect with PostGIS while retaining the geom for each shape.

For any given property shape, I want individual cuts of that shape split apart by different characteristics of the below layers.

So for example:

480128 | 3Sh3W | Otamatea | MOZ | S | 2 | B' | 5 | P 5 | geom

480128 | 3Sh3W | Turangai| MOZ | L/S | 2 | B' | 5 | P 5 | geom

480128 | 3Sh3W | Makahu | ZOT | L/S | 2 | B' | 5 | P 5 | geom

The SQL I've used so far is:

CREATE TABLE sd_processed AS 

SELECT 

    A.title_no, 

    B.erosion, 

    C.series, 

    C.domnzsc nzsc,

    C.ps, 

    D.prd_class as prd, 

    E.slope as slope, 

    F.drain_clas as drain,

    G.veg,

    ST_DUMP(ST_INTERSECTION(

        A.geom, 

        ST_INTERSECTION(A.geom,

            ST_INTERSECTION(B.geom, 

                ST_INTERSECTION(C.geom,

                    ST_INTERSECTION(D.geom, 

                        ST_INTERSECTION(E.geom, 

                            ST_INTERSECTION(F.geom, G.geom)

                        )

                    )

                )

            )

        )

    )) geom

FROM

    sd_title A,

    sd_erosion B,

    sd_particle_size C,

    sd_potential_rooting_depth D,

    sd_slope E,

    sd_soil_drainage F,

    sd_vegetation G

WHERE

    ST_INTERSECTS(A.geom, B.geom) = true

    AND ST_INTERSECTS(A.geom, C.geom) = true

    AND ST_INTERSECTS(A.geom, D.geom) = true

    AND ST_INTERSECTS(A.geom, E.geom) = true

    AND ST_INTERSECTS(A.geom, F.geom) = true

    AND ST_INTERSECTS(A.geom, G.geom) = true

    AND ST_INTERSECTS(B.geom, C.geom) = true

    AND ST_INTERSECTS(B.geom, D.geom) = true

    AND ST_INTERSECTS(B.geom, E.geom) = true

    AND ST_INTERSECTS(B.geom, F.geom) = true

    AND ST_INTERSECTS(B.geom, G.geom) = true

    AND ST_INTERSECTS(C.geom, D.geom) = true

    AND ST_INTERSECTS(C.geom, E.geom) = true

    AND ST_INTERSECTS(C.geom, F.geom) = true

    AND ST_INTERSECTS(C.geom, G.geom) = true

    AND ST_INTERSECTS(D.geom, E.geom) = true

    AND ST_INTERSECTS(D.geom, F.geom) = true

    AND ST_INTERSECTS(D.geom, G.geom) = true

    AND ST_INTERSECTS(E.geom, F.geom) = true

    AND ST_INTERSECTS(E.geom, G.geom) = true

    AND ST_INTERSECTS(F.geom, G.geom) = true

LIMIT 1000;

postgis intersection

share

asked 1 min ago

andryoandryo

1

New contributor

andryo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I'm trying to achieve a multiple-table intersect with PostGIS while retaining the geom for each shape.

For any given property shape, I want individual cuts of that shape split apart by different characteristics of the below layers.

So for example:

480128 | 3Sh3W | Otamatea | MOZ | S | 2 | B' | 5 | P 5 | geom

480128 | 3Sh3W | Turangai| MOZ | L/S | 2 | B' | 5 | P 5 | geom

480128 | 3Sh3W | Makahu | ZOT | L/S | 2 | B' | 5 | P 5 | geom

The SQL I've used so far is:

CREATE TABLE sd_processed AS 

SELECT 

    A.title_no, 

    B.erosion, 

    C.series, 

    C.domnzsc nzsc,

    C.ps, 

    D.prd_class as prd, 

    E.slope as slope, 

    F.drain_clas as drain,

    G.veg,

    ST_DUMP(ST_INTERSECTION(

        A.geom, 

        ST_INTERSECTION(A.geom,

            ST_INTERSECTION(B.geom, 

                ST_INTERSECTION(C.geom,

                    ST_INTERSECTION(D.geom, 

                        ST_INTERSECTION(E.geom, 

                            ST_INTERSECTION(F.geom, G.geom)

                        )

                    )

                )

            )

        )

    )) geom

FROM

    sd_title A,

    sd_erosion B,

    sd_particle_size C,

    sd_potential_rooting_depth D,

    sd_slope E,

    sd_soil_drainage F,

    sd_vegetation G

WHERE

    ST_INTERSECTS(A.geom, B.geom) = true

    AND ST_INTERSECTS(A.geom, C.geom) = true

    AND ST_INTERSECTS(A.geom, D.geom) = true

    AND ST_INTERSECTS(A.geom, E.geom) = true

    AND ST_INTERSECTS(A.geom, F.geom) = true

    AND ST_INTERSECTS(A.geom, G.geom) = true

    AND ST_INTERSECTS(B.geom, C.geom) = true

    AND ST_INTERSECTS(B.geom, D.geom) = true

    AND ST_INTERSECTS(B.geom, E.geom) = true

    AND ST_INTERSECTS(B.geom, F.geom) = true

    AND ST_INTERSECTS(B.geom, G.geom) = true

    AND ST_INTERSECTS(C.geom, D.geom) = true

    AND ST_INTERSECTS(C.geom, E.geom) = true

    AND ST_INTERSECTS(C.geom, F.geom) = true

    AND ST_INTERSECTS(C.geom, G.geom) = true

    AND ST_INTERSECTS(D.geom, E.geom) = true

    AND ST_INTERSECTS(D.geom, F.geom) = true

    AND ST_INTERSECTS(D.geom, G.geom) = true

    AND ST_INTERSECTS(E.geom, F.geom) = true

    AND ST_INTERSECTS(E.geom, G.geom) = true

    AND ST_INTERSECTS(F.geom, G.geom) = true

LIMIT 1000;

postgis intersection

share

asked 1 min ago

andryoandryo

1

New contributor

andryo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I'm trying to achieve a multiple-table intersect with PostGIS while retaining the geom for each shape.

For any given property shape, I want individual cuts of that shape split apart by different characteristics of the below layers.

So for example:

480128 | 3Sh3W | Otamatea | MOZ | S | 2 | B' | 5 | P 5 | geom

480128 | 3Sh3W | Turangai| MOZ | L/S | 2 | B' | 5 | P 5 | geom

480128 | 3Sh3W | Makahu | ZOT | L/S | 2 | B' | 5 | P 5 | geom

The SQL I've used so far is:

CREATE TABLE sd_processed AS 

SELECT 

    A.title_no, 

    B.erosion, 

    C.series, 

    C.domnzsc nzsc,

    C.ps, 

    D.prd_class as prd, 

    E.slope as slope, 

    F.drain_clas as drain,

    G.veg,

    ST_DUMP(ST_INTERSECTION(

        A.geom, 

        ST_INTERSECTION(A.geom,

            ST_INTERSECTION(B.geom, 

                ST_INTERSECTION(C.geom,

                    ST_INTERSECTION(D.geom, 

                        ST_INTERSECTION(E.geom, 

                            ST_INTERSECTION(F.geom, G.geom)

                        )

                    )

                )

            )

        )

    )) geom

FROM

    sd_title A,

    sd_erosion B,

    sd_particle_size C,

    sd_potential_rooting_depth D,

    sd_slope E,

    sd_soil_drainage F,

    sd_vegetation G

WHERE

    ST_INTERSECTS(A.geom, B.geom) = true

    AND ST_INTERSECTS(A.geom, C.geom) = true

    AND ST_INTERSECTS(A.geom, D.geom) = true

    AND ST_INTERSECTS(A.geom, E.geom) = true

    AND ST_INTERSECTS(A.geom, F.geom) = true

    AND ST_INTERSECTS(A.geom, G.geom) = true

    AND ST_INTERSECTS(B.geom, C.geom) = true

    AND ST_INTERSECTS(B.geom, D.geom) = true

    AND ST_INTERSECTS(B.geom, E.geom) = true

    AND ST_INTERSECTS(B.geom, F.geom) = true

    AND ST_INTERSECTS(B.geom, G.geom) = true

    AND ST_INTERSECTS(C.geom, D.geom) = true

    AND ST_INTERSECTS(C.geom, E.geom) = true

    AND ST_INTERSECTS(C.geom, F.geom) = true

    AND ST_INTERSECTS(C.geom, G.geom) = true

    AND ST_INTERSECTS(D.geom, E.geom) = true

    AND ST_INTERSECTS(D.geom, F.geom) = true

    AND ST_INTERSECTS(D.geom, G.geom) = true

    AND ST_INTERSECTS(E.geom, F.geom) = true

    AND ST_INTERSECTS(E.geom, G.geom) = true

    AND ST_INTERSECTS(F.geom, G.geom) = true

LIMIT 1000;

postgis intersection

share

asked 1 min ago

andryoandryo

1

New contributor

andryo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

480128 | 3Sh3W | Otamatea | MOZ | S | 2 | B' | 5 | P 5 | geom

480128 | 3Sh3W | Turangai| MOZ | L/S | 2 | B' | 5 | P 5 | geom

480128 | 3Sh3W | Makahu | ZOT | L/S | 2 | B' | 5 | P 5 | geom

CREATE TABLE sd_processed AS 

SELECT 

    A.title_no, 

    B.erosion, 

    C.series, 

    C.domnzsc nzsc,

    C.ps, 

    D.prd_class as prd, 

    E.slope as slope, 

    F.drain_clas as drain,

    G.veg,

    ST_DUMP(ST_INTERSECTION(

        A.geom, 

        ST_INTERSECTION(A.geom,

            ST_INTERSECTION(B.geom, 

                ST_INTERSECTION(C.geom,

                    ST_INTERSECTION(D.geom, 

                        ST_INTERSECTION(E.geom, 

                            ST_INTERSECTION(F.geom, G.geom)

                        )

                    )

                )

            )

        )

    )) geom

FROM

    sd_title A,

    sd_erosion B,

    sd_particle_size C,

    sd_potential_rooting_depth D,

    sd_slope E,

    sd_soil_drainage F,

    sd_vegetation G

WHERE

    ST_INTERSECTS(A.geom, B.geom) = true

    AND ST_INTERSECTS(A.geom, C.geom) = true

    AND ST_INTERSECTS(A.geom, D.geom) = true

    AND ST_INTERSECTS(A.geom, E.geom) = true

    AND ST_INTERSECTS(A.geom, F.geom) = true

    AND ST_INTERSECTS(A.geom, G.geom) = true

    AND ST_INTERSECTS(B.geom, C.geom) = true

    AND ST_INTERSECTS(B.geom, D.geom) = true

    AND ST_INTERSECTS(B.geom, E.geom) = true

    AND ST_INTERSECTS(B.geom, F.geom) = true

    AND ST_INTERSECTS(B.geom, G.geom) = true

    AND ST_INTERSECTS(C.geom, D.geom) = true

    AND ST_INTERSECTS(C.geom, E.geom) = true

    AND ST_INTERSECTS(C.geom, F.geom) = true

    AND ST_INTERSECTS(C.geom, G.geom) = true

    AND ST_INTERSECTS(D.geom, E.geom) = true

    AND ST_INTERSECTS(D.geom, F.geom) = true

    AND ST_INTERSECTS(D.geom, G.geom) = true

    AND ST_INTERSECTS(E.geom, F.geom) = true

    AND ST_INTERSECTS(E.geom, G.geom) = true

    AND ST_INTERSECTS(F.geom, G.geom) = true

LIMIT 1000;

share

asked 1 min ago

andryoandryo

1

New contributor

andryo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 1 min ago

andryoandryo

1

New contributor

andryo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

andryoandryo

1

New contributor

andryo is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 1 min ago

andryoandryo

1