Geopackage - select on geometry column returns null The Next CEO of Stack OverflowHow to select from geometry column in postgresql?Writing GeoPackage with FME - no geometryAdd layer to existing geopackage not working in QGIS?QGIS and geopackage spatial viewsGeopackage: update query generates an error “no such function: ST_IsEmpty”SQLite / Geopackage and saving Geometry in ArcGISSpatialite 4.3 err: no such function: gpkgAddGeomtryColumnQGIS 3 - load point layer from Geopackage doesn't render pointsGEOMETRY error when trying Tegola with a geopackageCreate geometry column in Geopackage with SQL
Inexact numbers as keys in Association?
Can I calculate next year's exemptions based on this year's refund/amount owed?
TikZ: How to fill area with a special pattern?
Help! I cannot understand this game’s notations!
Is wanting to ask what to write an indication that you need to change your story?
What is the difference between Statistical Mechanics and Quantum Mechanics
What steps are necessary to read a Modern SSD in Medieval Europe?
Decide between Polyglossia and Babel for LuaLaTeX in 2019
Sulfuric acid symmetry point group
Aggressive Under-Indexing and no data for missing index
How to properly draw diagonal line while using multicolumn inside tabular environment?
What flight has the highest ratio of timezone difference to flight time?
Can I use the word “Senior” as part of a job title directly in German?
Is a distribution that is normal, but highly skewed, considered Gaussian?
Defamation due to breach of confidentiality
Is French Guiana a (hard) EU border?
Example of a Mathematician/Physicist whose Other Publications during their PhD eclipsed their PhD Thesis
Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?
Deriving the equation for variance
Is there a way to save my career from absolute disaster?
"Eavesdropping" vs "Listen in on"
Is it convenient to ask the journal's editor for two additional days to complete a review?
Is "three point ish" an acceptable use of ish?
Won the lottery - how do I keep the money?
Geopackage - select on geometry column returns null
The Next CEO of Stack OverflowHow to select from geometry column in postgresql?Writing GeoPackage with FME - no geometryAdd layer to existing geopackage not working in QGIS?QGIS and geopackage spatial viewsGeopackage: update query generates an error “no such function: ST_IsEmpty”SQLite / Geopackage and saving Geometry in ArcGISSpatialite 4.3 err: no such function: gpkgAddGeomtryColumnQGIS 3 - load point layer from Geopackage doesn't render pointsGEOMETRY error when trying Tegola with a geopackageCreate geometry column in Geopackage with SQL
In DB Manager in QGIS 2.18.26
I want to select geometries in geopackage table.
The returned geometry column is null but the source layer can be loaded as a geometry table in Qgis and i can read the geometry text.
Source Layer:
Select on geometry column
How can i get the geometries?
EDIT: Here is the file
sql qgis-2 geopackage
asked Feb 27 at 14:03
jlStajlSta
483218
bumped to the homepage by Community♦ 2 days ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
In DB Manager in QGIS 2.18.26
I want to select geometries in geopackage table.
The returned geometry column is null but the source layer can be loaded as a geometry table in Qgis and i can read the geometry text.
Source Layer:
Select on geometry column
How can i get the geometries?
EDIT: Here is the file
sql qgis-2 geopackage
asked Feb 27 at 14:03
jlStajlSta
483218
bumped to the homepage by Community♦ 2 days ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
Use justselect geom from deljin*_lines. Orselect ST_AsText(geom)…if you want to see the WKT presentation of geometries.
– user30184
Feb 27 at 14:33
nothing returned with the simple select or withselect ST_AsText(geom)
– jlSta
Feb 27 at 15:52
I added the gpkg file
– jlSta
Feb 27 at 16:00
add a comment |
In DB Manager in QGIS 2.18.26
I want to select geometries in geopackage table.
The returned geometry column is null but the source layer can be loaded as a geometry table in Qgis and i can read the geometry text.
Source Layer:
Select on geometry column
How can i get the geometries?
EDIT: Here is the file
sql qgis-2 geopackage
asked Feb 27 at 14:03
jlStajlSta
483218
In DB Manager in QGIS 2.18.26
I want to select geometries in geopackage table.
The returned geometry column is null but the source layer can be loaded as a geometry table in Qgis and i can read the geometry text.
Source Layer:
Select on geometry column
How can i get the geometries?
EDIT: Here is the file
sql qgis-2 geopackage
sql qgis-2 geopackage
asked Feb 27 at 14:03
jlStajlSta
483218
asked Feb 27 at 14:03
jlStajlSta
483218
edited Feb 27 at 15:57
jlSta
asked Feb 27 at 14:03
jlStajlSta
483218
asked Feb 27 at 14:03
jlStajlSta
483218
asked Feb 27 at 14:03
jlStajlSta
483218
483218
bumped to the homepage by Community♦ 2 days ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 2 days ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
1
Use justselect geom from deljin*_lines. Orselect ST_AsText(geom)…if you want to see the WKT presentation of geometries.
– user30184
Feb 27 at 14:33
nothing returned with the simple select or withselect ST_AsText(geom)
– jlSta
Feb 27 at 15:52
I added the gpkg file
– jlSta
Feb 27 at 16:00
add a comment |
1
Use justselect geom from deljin*_lines. Orselect ST_AsText(geom)…if you want to see the WKT presentation of geometries.
– user30184
Feb 27 at 14:33
nothing returned with the simple select or withselect ST_AsText(geom)
– jlSta
Feb 27 at 15:52
I added the gpkg file
– jlSta
Feb 27 at 16:00
1
1
Use just
select geom from deljin*_lines. Or select ST_AsText(geom)…if you want to see the WKT presentation of geometries.– user30184
Feb 27 at 14:33
Use just
select geom from deljin*_lines. Or select ST_AsText(geom)…if you want to see the WKT presentation of geometries.– user30184
Feb 27 at 14:33
nothing returned with the simple select or with
select ST_AsText(geom)– jlSta
Feb 27 at 15:52
nothing returned with the simple select or with
select ST_AsText(geom)– jlSta
Feb 27 at 15:52
I added the gpkg file
– jlSta
Feb 27 at 16:00
I added the gpkg file
– jlSta
Feb 27 at 16:00
add a comment |
1 Answer
1
active
oldest
votes
I can't comment so I post this as an answer.
I downloaded your file and opened it in QGIS's DB Manager but I can see only the stops.
Could you please share it again making sure the lines are included? I'm trying to reproduce the error.
answered Feb 27 at 16:57
user99006user99006
316
I dowloaded my file, dragged and dropepd in qgis. It gives me the possibility to choose 3 layers :/
– jlSta
Feb 28 at 7:19
Ok, never mind. What exactly are you trying to select? By which attribute?
– user99006
Feb 28 at 14:54
i want to select the table. it returns all the attributes and the geometry column. But this geometry column is empty as showed on the last snapshot.
– jlSta
Feb 28 at 15:14
All the elements of the table?
– user99006
Feb 28 at 19:14
or only the geom as you want but the geom column is always empty
– jlSta
Mar 4 at 20:43
add a comment |
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%2f313769%2fgeopackage-select-on-geometry-column-returns-null%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
I can't comment so I post this as an answer.
I downloaded your file and opened it in QGIS's DB Manager but I can see only the stops.
Could you please share it again making sure the lines are included? I'm trying to reproduce the error.
answered Feb 27 at 16:57
user99006user99006
316
I dowloaded my file, dragged and dropepd in qgis. It gives me the possibility to choose 3 layers :/
– jlSta
Feb 28 at 7:19
Ok, never mind. What exactly are you trying to select? By which attribute?
– user99006
Feb 28 at 14:54
i want to select the table. it returns all the attributes and the geometry column. But this geometry column is empty as showed on the last snapshot.
– jlSta
Feb 28 at 15:14
All the elements of the table?
– user99006
Feb 28 at 19:14
or only the geom as you want but the geom column is always empty
– jlSta
Mar 4 at 20:43
add a comment |
I can't comment so I post this as an answer.
I downloaded your file and opened it in QGIS's DB Manager but I can see only the stops.
Could you please share it again making sure the lines are included? I'm trying to reproduce the error.
answered Feb 27 at 16:57
user99006user99006
316
I dowloaded my file, dragged and dropepd in qgis. It gives me the possibility to choose 3 layers :/
– jlSta
Feb 28 at 7:19
Ok, never mind. What exactly are you trying to select? By which attribute?
– user99006
Feb 28 at 14:54
i want to select the table. it returns all the attributes and the geometry column. But this geometry column is empty as showed on the last snapshot.
– jlSta
Feb 28 at 15:14
All the elements of the table?
– user99006
Feb 28 at 19:14
or only the geom as you want but the geom column is always empty
– jlSta
Mar 4 at 20:43
add a comment |
I can't comment so I post this as an answer.
I downloaded your file and opened it in QGIS's DB Manager but I can see only the stops.
Could you please share it again making sure the lines are included? I'm trying to reproduce the error.
answered Feb 27 at 16:57
user99006user99006
316
I can't comment so I post this as an answer.
I downloaded your file and opened it in QGIS's DB Manager but I can see only the stops.
Could you please share it again making sure the lines are included? I'm trying to reproduce the error.
answered Feb 27 at 16:57
user99006user99006
316
answered Feb 27 at 16:57
user99006user99006
316
answered Feb 27 at 16:57
user99006user99006
316
answered Feb 27 at 16:57
user99006user99006
316
316
I dowloaded my file, dragged and dropepd in qgis. It gives me the possibility to choose 3 layers :/
– jlSta
Feb 28 at 7:19
Ok, never mind. What exactly are you trying to select? By which attribute?
– user99006
Feb 28 at 14:54
i want to select the table. it returns all the attributes and the geometry column. But this geometry column is empty as showed on the last snapshot.
– jlSta
Feb 28 at 15:14
All the elements of the table?
– user99006
Feb 28 at 19:14
or only the geom as you want but the geom column is always empty
– jlSta
Mar 4 at 20:43
add a comment |
I dowloaded my file, dragged and dropepd in qgis. It gives me the possibility to choose 3 layers :/
– jlSta
Feb 28 at 7:19
Ok, never mind. What exactly are you trying to select? By which attribute?
– user99006
Feb 28 at 14:54
i want to select the table. it returns all the attributes and the geometry column. But this geometry column is empty as showed on the last snapshot.
– jlSta
Feb 28 at 15:14
All the elements of the table?
– user99006
Feb 28 at 19:14
or only the geom as you want but the geom column is always empty
– jlSta
Mar 4 at 20:43
I dowloaded my file, dragged and dropepd in qgis. It gives me the possibility to choose 3 layers :/
– jlSta
Feb 28 at 7:19
I dowloaded my file, dragged and dropepd in qgis. It gives me the possibility to choose 3 layers :/
– jlSta
Feb 28 at 7:19
Ok, never mind. What exactly are you trying to select? By which attribute?
– user99006
Feb 28 at 14:54
Ok, never mind. What exactly are you trying to select? By which attribute?
– user99006
Feb 28 at 14:54
i want to select the table. it returns all the attributes and the geometry column. But this geometry column is empty as showed on the last snapshot.
– jlSta
Feb 28 at 15:14
i want to select the table. it returns all the attributes and the geometry column. But this geometry column is empty as showed on the last snapshot.
– jlSta
Feb 28 at 15:14
All the elements of the table?
– user99006
Feb 28 at 19:14
All the elements of the table?
– user99006
Feb 28 at 19:14
or only the geom as you want but the geom column is always empty
– jlSta
Mar 4 at 20:43
or only the geom as you want but the geom column is always empty
– jlSta
Mar 4 at 20:43
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%2f313769%2fgeopackage-select-on-geometry-column-returns-null%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
1
Use just
select geom from deljin*_lines. Orselect ST_AsText(geom)…if you want to see the WKT presentation of geometries.– user30184
Feb 27 at 14:33
nothing returned with the simple select or with
select ST_AsText(geom)– jlSta
Feb 27 at 15:52
I added the gpkg file
– jlSta
Feb 27 at 16:00