Vjylku

What's the meaning of 間時肆拾貳 at a car parking sign

Denied boarding although I have proper visa and documentation. To whom should I make a complaint?

Why didn't this character "real die" when they blew their stack out in Altered Carbon?

ListPlot join points by nearest neighbor rather than order

Using et al. for a last / senior author rather than for a first author

Why did the IBM 650 use bi-quinary?

In predicate logic, does existential quantification (∃) include universal quantification (∀), i.e. can 'some' imply 'all'?

Coloring maths inside a tcolorbox

Output the ŋarâþ crîþ alphabet song without using (m)any letters

If a contract sometimes uses the wrong name, is it still valid?

2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?

How to find out what spells would be useless to a blind NPC spellcaster?

Why am I getting the error "non-boolean type specified in a context where a condition is expected" for this request?

When do you get frequent flier miles - when you buy, or when you fly?

How to align text above triangle figure

What to do with chalk when deepwater soloing?

How do I stop a creek from eroding my steep embankment?

What is the logic behind the Maharil's explanation of why we don't say שעשה ניסים on Pesach?

Why light coming from distant stars is not discreet?

Do I really need recursive chmod to restrict access to a folder?

Why is my conclusion inconsistent with the van't Hoff equation?

Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?

Identifying polygons that intersect with another layer using QGIS?

Why aren't air breathing engines used as small first stages

Intersections in linestrings using Postgis

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ margin-bottom:0;
}

0

I need to get the intersections of streets and create a graph, so to get the intersections I use this select:

SELECT ST_geometrytype(geom), geom from (SELECT

a.gid, st_intersection(a.geom, b.geom) as geom

    FROM

        streets a

    JOIN

        streets b ON st_intersects(a.geom, b.geom)

    and

        a.gid!=b.gid

    and

        a.gid>b.gid) as foo

But this query returns different types of geometries, and some rows returns ST_GeometryColletion.

I tried to use this select:

SELECT ST_geometrytype(geom), geom from (SELECT

    (ST_Dump(st_intersection(a.geom, b.geom))).geom as geom

        FROM

            streets a

        JOIN

            streets b ON st_intersects(a.geom, b.geom)

        and

            a.gid!=b.gid

        and

            a.gid>b.gid) as foo

When I used this query many linestrings were "broken" in short linestrings.

And now, I do not know how to join the short lines that are part of the same intersection. I need this to then create a graph, the linestrings will be my vertex.

Please, can anyone help me?

Thanks,

postgis

share

asked 5 mins ago

JessikdominfuesJessikdominfues

1

New contributor

Jessikdominfues 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 need to get the intersections of streets and create a graph, so to get the intersections I use this select:

SELECT ST_geometrytype(geom), geom from (SELECT

a.gid, st_intersection(a.geom, b.geom) as geom

    FROM

        streets a

    JOIN

        streets b ON st_intersects(a.geom, b.geom)

    and

        a.gid!=b.gid

    and

        a.gid>b.gid) as foo

But this query returns different types of geometries, and some rows returns ST_GeometryColletion.

I tried to use this select:

SELECT ST_geometrytype(geom), geom from (SELECT

    (ST_Dump(st_intersection(a.geom, b.geom))).geom as geom

        FROM

            streets a

        JOIN

            streets b ON st_intersects(a.geom, b.geom)

        and

            a.gid!=b.gid

        and

            a.gid>b.gid) as foo

When I used this query many linestrings were "broken" in short linestrings.

And now, I do not know how to join the short lines that are part of the same intersection. I need this to then create a graph, the linestrings will be my vertex.

Please, can anyone help me?

Thanks,

postgis

share

asked 5 mins ago

JessikdominfuesJessikdominfues

1

New contributor

Jessikdominfues 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 need to get the intersections of streets and create a graph, so to get the intersections I use this select:

SELECT ST_geometrytype(geom), geom from (SELECT

a.gid, st_intersection(a.geom, b.geom) as geom

    FROM

        streets a

    JOIN

        streets b ON st_intersects(a.geom, b.geom)

    and

        a.gid!=b.gid

    and

        a.gid>b.gid) as foo

But this query returns different types of geometries, and some rows returns ST_GeometryColletion.

I tried to use this select:

SELECT ST_geometrytype(geom), geom from (SELECT

    (ST_Dump(st_intersection(a.geom, b.geom))).geom as geom

        FROM

            streets a

        JOIN

            streets b ON st_intersects(a.geom, b.geom)

        and

            a.gid!=b.gid

        and

            a.gid>b.gid) as foo

When I used this query many linestrings were "broken" in short linestrings.

And now, I do not know how to join the short lines that are part of the same intersection. I need this to then create a graph, the linestrings will be my vertex.

Please, can anyone help me?

Thanks,

postgis

share

asked 5 mins ago

JessikdominfuesJessikdominfues

1

New contributor

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

SELECT ST_geometrytype(geom), geom from (SELECT

a.gid, st_intersection(a.geom, b.geom) as geom

    FROM

        streets a

    JOIN

        streets b ON st_intersects(a.geom, b.geom)

    and

        a.gid!=b.gid

    and

        a.gid>b.gid) as foo

SELECT ST_geometrytype(geom), geom from (SELECT

    (ST_Dump(st_intersection(a.geom, b.geom))).geom as geom

        FROM

            streets a

        JOIN

            streets b ON st_intersects(a.geom, b.geom)

        and

            a.gid!=b.gid

        and

            a.gid>b.gid) as foo

share

asked 5 mins ago

JessikdominfuesJessikdominfues

1

New contributor

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

share

asked 5 mins ago

JessikdominfuesJessikdominfues

1

New contributor

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

asked 5 mins ago

JessikdominfuesJessikdominfues

1

New contributor

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

asked 5 mins ago

JessikdominfuesJessikdominfues

1