Difference between multipolygon and polygon in PostGIS

gis polygon postgis esri
Ahlam picture Ahlam · Dec 31, 2012 · Viewed 8.2k times · Source

What is the difference between point and multipoint ? linestring and multilinestring ? polygon and multipolygon ? In PostGIS

What is the secret behind defining "Multi" shapes?

Answer

user1702401 picture user1702401 · Dec 31, 2012

"Multi" means, that several objects of that kind are "grouped" together to single object. For example, imagine Philippines. That country consists of lot of islands - you can't draw it with single polygon; and it would be inconvenient to store it as several different database rows, each containing single polygon.

Related questions

sp::over() for point in polygon analysis

I have a shapefile named "ind_adm" and a SpatialPointsDataFrame called "pnts". The "pnts" contains points generated at random, and some of the points overlap with the polygon. See picture below. Now, I want do do a point in polygon …

Read More
How to get list of points inside a polygon in python?

I searched a lot and cant find any practical answer to my question. I have a polygon. For example: [(86, 52), (85, 52), (81, 53), (80, 52), (79, 48), (81, 49), (86, 53), (85, 51), (82, 54), (84, 54), (83, 49), (81, 52), (80, 50), (81, 48), (85, 50), (86, 54), (85, 54), (80, 48), (79, 50), (85, 49), (80, 51), (85, 53), (82, 49), (83, 54), (82, 53), (84, 49), (79, 49)] I want to get a list of all the points inside this border polygon. I heard alot about polygon triangulation techniques …

Read More
See if lat / long falls within a polygon using mysql

I have the created the table below CREATE TABLE geom (g GEOMETRY); and have inserted many rows, example below: INSERT INTO geom (g) VALUES(PolygonFromText('POLYGON(( 9.190586853 45.464518970, 9.190602686 45.463993916, 9.191572471 45.464001929, 9.191613325 45.463884676, 9.192136130 45.463880767, 9.192111509 45.464095594, 9.192427961 45.464117804, 9.192417811 45.464112862, 9.192509035 45.464225851, 9.192493139 45.464371079, 9.192448471 45.464439002, 9.192387444 45.464477861, 9.192051402 45.464483037, 9.192012814 45.464643592, 9.191640825 45.464647090, 9.191622331 45.464506215, 9.190586853 45.464518970))') ); Now I want to search all the data and return the entries where …

Read More