Defining geometry type in QgsDataSourceUri Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) Announcing the arrival of Valued Associate #679: Cesar Manara Unicorn Meta Zoo #1: Why another podcast?Postgis - Converting 'geometry_dump' data type to a 'geometry' typePostgis geometry type = GeometryPostGIS change column type varchar => geometryCan QGIS import Multipatch geometry type?PostgreSQL geometry type invalidDefining features geometry in new created layer using PyQGIS?Debug QgsDataSourceUri as a QgsVectorLayerQGIS change geometry type in shapefileHow to backup QGIS (3.2.1) layer to independent PostGIS table?Invalid geometry vs. no geometry
What is the meaning of the simile “quick as silk”?
2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?
How to answer "Have you ever been terminated?"
For a new assistant professor in CS, how to build/manage a publication pipeline
Need Bar Animation Gradient Fixed
Matrices and TikZ : arrows inside the matrix
Why are both D and D# fitting into my E minor key?
On SQL Server, is it possible to restrict certain users from using certain functions, operators or statements?
How to tell that you are a giant?
Wu formula for manifolds with boundary
Why aren't air breathing engines used as small first stages
Can you shove before Attacking with Shield Master using a Readied action?
Significance of Cersei's obsession with elephants?
What is this building called? (It was built in 2002)
How do I stop a creek from eroding my steep embankment?
T-test, ANOVA or Regression, what's the difference?
Can melee weapons be used to deliver Contact Poisons?
Tht Aain’t Right... #2
Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?
Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?
Do square wave exist?
Novel: non-telepath helps overthrow rule by telepaths
Can anything be seen from the center of the Boötes void? How dark would it be?
What would be the ideal power source for a cybernetic eye?
Defining geometry type in QgsDataSourceUri
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
Announcing the arrival of Valued Associate #679: Cesar Manara
Unicorn Meta Zoo #1: Why another podcast?Postgis - Converting 'geometry_dump' data type to a 'geometry' typePostgis geometry type = GeometryPostGIS change column type varchar => geometryCan QGIS import Multipatch geometry type?PostgreSQL geometry type invalidDefining features geometry in new created layer using PyQGIS?Debug QgsDataSourceUri as a QgsVectorLayerQGIS change geometry type in shapefileHow to backup QGIS (3.2.1) layer to independent PostGIS table?Invalid geometry vs. no geometry
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
There is a PostgreSQL database containing some layers that have few types of geometry (multipolygons and linestrings). I need to distinguish these geometries in two separate layers.
My basic strings that make layer for QGIS are:
uri.setConnection('srs', '5432', 'db_name', 'postgres' , 'password')
for i, name in enumerate(sorted(list_of_layers)): # list containing elements like ['schema_name', 'layer_name']
if name[1] in ['layer_with_geometry_collection']:
uri.setDataSource(name[0], name[1], 'SP_GEOMETRY')
vlayer=QgsVectorLayer (uri.uri(), name[1], "postgres")
Where do I need to set the geometry type?
If I check vlayer.wkbType(), it throws me 0.
Manual set uri.setWkbType() hadn't helped yet.
qgis pyqgis geometry
edited Apr 10 at 10:56
Vince
14.8k32850
asked Apr 10 at 9:32
Pavel PereverzevPavel Pereverzev
543211
add a comment |
There is a PostgreSQL database containing some layers that have few types of geometry (multipolygons and linestrings). I need to distinguish these geometries in two separate layers.
My basic strings that make layer for QGIS are:
uri.setConnection('srs', '5432', 'db_name', 'postgres' , 'password')
for i, name in enumerate(sorted(list_of_layers)): # list containing elements like ['schema_name', 'layer_name']
if name[1] in ['layer_with_geometry_collection']:
uri.setDataSource(name[0], name[1], 'SP_GEOMETRY')
vlayer=QgsVectorLayer (uri.uri(), name[1], "postgres")
Where do I need to set the geometry type?
If I check vlayer.wkbType(), it throws me 0.
Manual set uri.setWkbType() hadn't helped yet.
qgis pyqgis geometry
edited Apr 10 at 10:56
Vince
14.8k32850
asked Apr 10 at 9:32
Pavel PereverzevPavel Pereverzev
543211
It is very dangerous to casually connect to an RDBMS as the administrative user. Doing so can often result in casual destruction of the database. Instead, create a login user to own your data, and another to manage read-only or read-mostly connections. Thepostgresuser should never own spatial data.
– Vince
Apr 10 at 12:22
@Vince you mean not to usepostgresas a username?
– Pavel Pereverzev
Apr 10 at 12:24
Yes. Only connect as postgres to create new login and group roles.
– Vince
Apr 10 at 12:49
add a comment |
There is a PostgreSQL database containing some layers that have few types of geometry (multipolygons and linestrings). I need to distinguish these geometries in two separate layers.
My basic strings that make layer for QGIS are:
uri.setConnection('srs', '5432', 'db_name', 'postgres' , 'password')
for i, name in enumerate(sorted(list_of_layers)): # list containing elements like ['schema_name', 'layer_name']
if name[1] in ['layer_with_geometry_collection']:
uri.setDataSource(name[0], name[1], 'SP_GEOMETRY')
vlayer=QgsVectorLayer (uri.uri(), name[1], "postgres")
Where do I need to set the geometry type?
If I check vlayer.wkbType(), it throws me 0.
Manual set uri.setWkbType() hadn't helped yet.
qgis pyqgis geometry
edited Apr 10 at 10:56
Vince
14.8k32850
asked Apr 10 at 9:32
Pavel PereverzevPavel Pereverzev
543211
There is a PostgreSQL database containing some layers that have few types of geometry (multipolygons and linestrings). I need to distinguish these geometries in two separate layers.
My basic strings that make layer for QGIS are:
uri.setConnection('srs', '5432', 'db_name', 'postgres' , 'password')
for i, name in enumerate(sorted(list_of_layers)): # list containing elements like ['schema_name', 'layer_name']
if name[1] in ['layer_with_geometry_collection']:
uri.setDataSource(name[0], name[1], 'SP_GEOMETRY')
vlayer=QgsVectorLayer (uri.uri(), name[1], "postgres")
Where do I need to set the geometry type?
If I check vlayer.wkbType(), it throws me 0.
Manual set uri.setWkbType() hadn't helped yet.
qgis pyqgis geometry
qgis pyqgis geometry
edited Apr 10 at 10:56
Vince
14.8k32850
asked Apr 10 at 9:32
Pavel PereverzevPavel Pereverzev
543211
edited Apr 10 at 10:56
Vince
14.8k32850
asked Apr 10 at 9:32
Pavel PereverzevPavel Pereverzev
543211
edited Apr 10 at 10:56
Vince
14.8k32850
edited Apr 10 at 10:56
Vince
14.8k32850
edited Apr 10 at 10:56
Vince
14.8k32850
14.8k32850
asked Apr 10 at 9:32
Pavel PereverzevPavel Pereverzev
543211
asked Apr 10 at 9:32
Pavel PereverzevPavel Pereverzev
543211
asked Apr 10 at 9:32
Pavel PereverzevPavel Pereverzev
543211
543211
It is very dangerous to casually connect to an RDBMS as the administrative user. Doing so can often result in casual destruction of the database. Instead, create a login user to own your data, and another to manage read-only or read-mostly connections. Thepostgresuser should never own spatial data.
– Vince
Apr 10 at 12:22
@Vince you mean not to usepostgresas a username?
– Pavel Pereverzev
Apr 10 at 12:24
Yes. Only connect as postgres to create new login and group roles.
– Vince
Apr 10 at 12:49
add a comment |
It is very dangerous to casually connect to an RDBMS as the administrative user. Doing so can often result in casual destruction of the database. Instead, create a login user to own your data, and another to manage read-only or read-mostly connections. Thepostgresuser should never own spatial data.
– Vince
Apr 10 at 12:22
@Vince you mean not to usepostgresas a username?
– Pavel Pereverzev
Apr 10 at 12:24
Yes. Only connect as postgres to create new login and group roles.
– Vince
Apr 10 at 12:49
It is very dangerous to casually connect to an RDBMS as the administrative user. Doing so can often result in casual destruction of the database. Instead, create a login user to own your data, and another to manage read-only or read-mostly connections. The
postgres user should never own spatial data.– Vince
Apr 10 at 12:22
It is very dangerous to casually connect to an RDBMS as the administrative user. Doing so can often result in casual destruction of the database. Instead, create a login user to own your data, and another to manage read-only or read-mostly connections. The
postgres user should never own spatial data.– Vince
Apr 10 at 12:22
@Vince you mean not to use
postgres as a username?– Pavel Pereverzev
Apr 10 at 12:24
@Vince you mean not to use
postgres as a username?– Pavel Pereverzev
Apr 10 at 12:24
Yes. Only connect as postgres to create new login and group roles.
– Vince
Apr 10 at 12:49
Yes. Only connect as postgres to create new login and group roles.
– Vince
Apr 10 at 12:49
add a comment |
1 Answer
1
active
oldest
votes
Found an answer in PosGIS reference guide.
According to types of geometry that can be stored in PostGIS database, a filter should be written to get the specific geometry.
For example, I need to get only polygon features. The full code will be:
filter = """ST_GeometryType("") LIKE ''""".format('SP_GEOMETRY', 'ST_Polygon')
uri.setConnection('srs', '5432', 'db_name', 'postgres' , 'password')
for i, name in enumerate(sorted(list_of_layers)): # list containing elements like ['schema_name', 'layer_name']
if name[1] in ['layer_with_geometry_collection']:
uri.setDataSource(name[0], name[1], 'SP_GEOMETRY', filter) # filter added
vlayer=QgsVectorLayer (uri.uri(), name[1], "postgres")
answered Apr 10 at 11:11
Pavel PereverzevPavel Pereverzev
543211
You'd have to build a covering index to make this query performant, and doing do would conflict with use of a spatial index in the application.
– Vince
Apr 10 at 12:51
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318343%2fdefining-geometry-type-in-qgsdatasourceuri%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Found an answer in PosGIS reference guide.
According to types of geometry that can be stored in PostGIS database, a filter should be written to get the specific geometry.
For example, I need to get only polygon features. The full code will be:
filter = """ST_GeometryType("") LIKE ''""".format('SP_GEOMETRY', 'ST_Polygon')
uri.setConnection('srs', '5432', 'db_name', 'postgres' , 'password')
for i, name in enumerate(sorted(list_of_layers)): # list containing elements like ['schema_name', 'layer_name']
if name[1] in ['layer_with_geometry_collection']:
uri.setDataSource(name[0], name[1], 'SP_GEOMETRY', filter) # filter added
vlayer=QgsVectorLayer (uri.uri(), name[1], "postgres")
answered Apr 10 at 11:11
Pavel PereverzevPavel Pereverzev
543211
You'd have to build a covering index to make this query performant, and doing do would conflict with use of a spatial index in the application.
– Vince
Apr 10 at 12:51
add a comment |
Found an answer in PosGIS reference guide.
According to types of geometry that can be stored in PostGIS database, a filter should be written to get the specific geometry.
For example, I need to get only polygon features. The full code will be:
filter = """ST_GeometryType("") LIKE ''""".format('SP_GEOMETRY', 'ST_Polygon')
uri.setConnection('srs', '5432', 'db_name', 'postgres' , 'password')
for i, name in enumerate(sorted(list_of_layers)): # list containing elements like ['schema_name', 'layer_name']
if name[1] in ['layer_with_geometry_collection']:
uri.setDataSource(name[0], name[1], 'SP_GEOMETRY', filter) # filter added
vlayer=QgsVectorLayer (uri.uri(), name[1], "postgres")
answered Apr 10 at 11:11
Pavel PereverzevPavel Pereverzev
543211
You'd have to build a covering index to make this query performant, and doing do would conflict with use of a spatial index in the application.
– Vince
Apr 10 at 12:51
add a comment |
Found an answer in PosGIS reference guide.
According to types of geometry that can be stored in PostGIS database, a filter should be written to get the specific geometry.
For example, I need to get only polygon features. The full code will be:
filter = """ST_GeometryType("") LIKE ''""".format('SP_GEOMETRY', 'ST_Polygon')
uri.setConnection('srs', '5432', 'db_name', 'postgres' , 'password')
for i, name in enumerate(sorted(list_of_layers)): # list containing elements like ['schema_name', 'layer_name']
if name[1] in ['layer_with_geometry_collection']:
uri.setDataSource(name[0], name[1], 'SP_GEOMETRY', filter) # filter added
vlayer=QgsVectorLayer (uri.uri(), name[1], "postgres")
answered Apr 10 at 11:11
Pavel PereverzevPavel Pereverzev
543211
Found an answer in PosGIS reference guide.
According to types of geometry that can be stored in PostGIS database, a filter should be written to get the specific geometry.
For example, I need to get only polygon features. The full code will be:
filter = """ST_GeometryType("") LIKE ''""".format('SP_GEOMETRY', 'ST_Polygon')
uri.setConnection('srs', '5432', 'db_name', 'postgres' , 'password')
for i, name in enumerate(sorted(list_of_layers)): # list containing elements like ['schema_name', 'layer_name']
if name[1] in ['layer_with_geometry_collection']:
uri.setDataSource(name[0], name[1], 'SP_GEOMETRY', filter) # filter added
vlayer=QgsVectorLayer (uri.uri(), name[1], "postgres")
answered Apr 10 at 11:11
Pavel PereverzevPavel Pereverzev
543211
answered Apr 10 at 11:11
Pavel PereverzevPavel Pereverzev
543211
answered Apr 10 at 11:11
Pavel PereverzevPavel Pereverzev
543211
answered Apr 10 at 11:11
Pavel PereverzevPavel Pereverzev
543211
543211
You'd have to build a covering index to make this query performant, and doing do would conflict with use of a spatial index in the application.
– Vince
Apr 10 at 12:51
add a comment |
You'd have to build a covering index to make this query performant, and doing do would conflict with use of a spatial index in the application.
– Vince
Apr 10 at 12:51
You'd have to build a covering index to make this query performant, and doing do would conflict with use of a spatial index in the application.
– Vince
Apr 10 at 12:51
You'd have to build a covering index to make this query performant, and doing do would conflict with use of a spatial index in the application.
– Vince
Apr 10 at 12:51
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f318343%2fdefining-geometry-type-in-qgsdatasourceuri%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It is very dangerous to casually connect to an RDBMS as the administrative user. Doing so can often result in casual destruction of the database. Instead, create a login user to own your data, and another to manage read-only or read-mostly connections. The
postgresuser should never own spatial data.– Vince
Apr 10 at 12:22
@Vince you mean not to use
postgresas a username?– Pavel Pereverzev
Apr 10 at 12:24
Yes. Only connect as postgres to create new login and group roles.
– Vince
Apr 10 at 12:49