How do I use pre-existing Lat/Long data in a SQLite table with QGIS?Derive WGS84 Longitude & Latitude from British Northings & EastingsHow to insert geometries from shapefile into existing table?Why is Spatialite showing dates in MM-DD-YYYY format?Add x y data from existing attribute tableHow do make a CSV file visible in QGIS?SQLite db with FDO geometries: how to assign ID of point in layer A to closest point in Layer B with SpatiaLite?QGIS : Creating point feature from Lat, Lon SQL Server 2008R2 data importHow can I combine two vector layers with identical columns in virtual layer
Idiom for a situation or event that makes one poor or even poorer?
During Adventurers League character creation, are the listed variant options always available even if the associated book is not chosen as my PHB+1?
Incorrect mmap behavior when assembly files included in the project
Why does Sonny say they call Michael "Giogali"?
Help Me unlock her phone
Why does a single pole tandem breaker allow connecting the switch handles?
"inuendo" in a piano score
What are the branches of statistics?
Code Golf Measurer © 2019
How to create a vimrc macro using :sort?
How to treat unhandled exceptions? (Terminate the application vs. Keep it alive)
'Pound' meaning in this context
Adjusting Table in Latex tabularx environment
What could possibly power an Alcubierre drive?
Draw an helix and a circle under it
In "Avatar: The Last Airbender" can a metalbender bloodbend if there is metal in our blood?
Is there a historical explanation as to why the USA people are so litigious compared to France?
My Guitar came with both metal and nylon strings, what replacement strings should I buy?
Who can change WIP limit in DoW when urgent work emerges?
Why isn't Hagrid removed from Hogwarts sooner in Harry's would-be 7th year?
How can a "proper" function have a vertical slope?
Easy way of generating a 50-150W load @12V
Why exactly does maximum power transfer happen at 50 ohms (matched impedance)?
Is it possible to have 2 ports open on SSH with 2 different authentication schemes?
How do I use pre-existing Lat/Long data in a SQLite table with QGIS?
Derive WGS84 Longitude & Latitude from British Northings & EastingsHow to insert geometries from shapefile into existing table?Why is Spatialite showing dates in MM-DD-YYYY format?Add x y data from existing attribute tableHow do make a CSV file visible in QGIS?SQLite db with FDO geometries: how to assign ID of point in layer A to closest point in Layer B with SpatiaLite?QGIS : Creating point feature from Lat, Lon SQL Server 2008R2 data importHow can I combine two vector layers with identical columns in virtual layer
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;
I have an application that stores its data in a SQLite database. I can't modify the application or database to add geometry extensions, but it does already have latitude and longitude columns for each row of data it stores (stored in decimal format).
How do I tell QGIS to look at these columns to generate x,y points? If I dump the database to a CSV file, I just have to choose the X field and Y field for lat and long under "Point Coordinates" when adding the layer. I'm essentially looking for a way to do the same, but with a SQLite data source.
Here's how the SQLite data source looks when loaded in QGIS as a vector layer:
I'm trying to turn each of those rows into a point.
qgis sql geometry sqlite
asked 8 hours ago
Matthew ManjosMatthew Manjos
83 bronze badges
New contributor
Matthew Manjos 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 have an application that stores its data in a SQLite database. I can't modify the application or database to add geometry extensions, but it does already have latitude and longitude columns for each row of data it stores (stored in decimal format).
How do I tell QGIS to look at these columns to generate x,y points? If I dump the database to a CSV file, I just have to choose the X field and Y field for lat and long under "Point Coordinates" when adding the layer. I'm essentially looking for a way to do the same, but with a SQLite data source.
Here's how the SQLite data source looks when loaded in QGIS as a vector layer:
I'm trying to turn each of those rows into a point.
qgis sql geometry sqlite
asked 8 hours ago
Matthew ManjosMatthew Manjos
83 bronze badges
New contributor
Matthew Manjos 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 have an application that stores its data in a SQLite database. I can't modify the application or database to add geometry extensions, but it does already have latitude and longitude columns for each row of data it stores (stored in decimal format).
How do I tell QGIS to look at these columns to generate x,y points? If I dump the database to a CSV file, I just have to choose the X field and Y field for lat and long under "Point Coordinates" when adding the layer. I'm essentially looking for a way to do the same, but with a SQLite data source.
Here's how the SQLite data source looks when loaded in QGIS as a vector layer:
I'm trying to turn each of those rows into a point.
qgis sql geometry sqlite
asked 8 hours ago
Matthew ManjosMatthew Manjos
83 bronze badges
New contributor
Matthew Manjos is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I have an application that stores its data in a SQLite database. I can't modify the application or database to add geometry extensions, but it does already have latitude and longitude columns for each row of data it stores (stored in decimal format).
How do I tell QGIS to look at these columns to generate x,y points? If I dump the database to a CSV file, I just have to choose the X field and Y field for lat and long under "Point Coordinates" when adding the layer. I'm essentially looking for a way to do the same, but with a SQLite data source.
Here's how the SQLite data source looks when loaded in QGIS as a vector layer:
I'm trying to turn each of those rows into a point.
qgis sql geometry sqlite
qgis sql geometry sqlite
asked 8 hours ago
Matthew ManjosMatthew Manjos
83 bronze badges
New contributor
Matthew Manjos is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 hours ago
Matthew ManjosMatthew Manjos
83 bronze badges
New contributor
Matthew Manjos is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 hours ago
Matthew ManjosMatthew Manjos
83 bronze badges
New contributor
Matthew Manjos is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 8 hours ago
Matthew ManjosMatthew Manjos
83 bronze badges
asked 8 hours ago
Matthew ManjosMatthew Manjos
83 bronze badges
83 bronze badges
New contributor
Matthew Manjos is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Matthew Manjos 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
|
add a comment
|
1 Answer
1
active
oldest
votes
In QGIS, make sure your processing toolbox is visible, then use the "Vector creation" > "Create Points Layer From Table" tool.
answered 7 hours ago
user2856user2856
34.2k2 gold badges65 silver badges114 bronze badges
That did it! That's exactly the dialog I was looking for. I have also never come across this Processing Toolbox before - I think a lot of these tools would have saved me hours in the past. Cheers!
– Matthew Manjos
7 hours ago
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/4.0/"u003ecc by-sa 4.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
);
);
Matthew Manjos is a new contributor. Be nice, and check out our Code of Conduct.
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%2f338042%2fhow-do-i-use-pre-existing-lat-long-data-in-a-sqlite-table-with-qgis%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
In QGIS, make sure your processing toolbox is visible, then use the "Vector creation" > "Create Points Layer From Table" tool.
answered 7 hours ago
user2856user2856
34.2k2 gold badges65 silver badges114 bronze badges
That did it! That's exactly the dialog I was looking for. I have also never come across this Processing Toolbox before - I think a lot of these tools would have saved me hours in the past. Cheers!
– Matthew Manjos
7 hours ago
add a comment
|
In QGIS, make sure your processing toolbox is visible, then use the "Vector creation" > "Create Points Layer From Table" tool.
answered 7 hours ago
user2856user2856
34.2k2 gold badges65 silver badges114 bronze badges
That did it! That's exactly the dialog I was looking for. I have also never come across this Processing Toolbox before - I think a lot of these tools would have saved me hours in the past. Cheers!
– Matthew Manjos
7 hours ago
add a comment
|
In QGIS, make sure your processing toolbox is visible, then use the "Vector creation" > "Create Points Layer From Table" tool.
answered 7 hours ago
user2856user2856
34.2k2 gold badges65 silver badges114 bronze badges
In QGIS, make sure your processing toolbox is visible, then use the "Vector creation" > "Create Points Layer From Table" tool.
answered 7 hours ago
user2856user2856
34.2k2 gold badges65 silver badges114 bronze badges
answered 7 hours ago
user2856user2856
34.2k2 gold badges65 silver badges114 bronze badges
answered 7 hours ago
user2856user2856
34.2k2 gold badges65 silver badges114 bronze badges
answered 7 hours ago
user2856user2856
34.2k2 gold badges65 silver badges114 bronze badges
34.2k2 gold badges65 silver badges114 bronze badges
That did it! That's exactly the dialog I was looking for. I have also never come across this Processing Toolbox before - I think a lot of these tools would have saved me hours in the past. Cheers!
– Matthew Manjos
7 hours ago
add a comment
|
That did it! That's exactly the dialog I was looking for. I have also never come across this Processing Toolbox before - I think a lot of these tools would have saved me hours in the past. Cheers!
– Matthew Manjos
7 hours ago
That did it! That's exactly the dialog I was looking for. I have also never come across this Processing Toolbox before - I think a lot of these tools would have saved me hours in the past. Cheers!
– Matthew Manjos
7 hours ago
That did it! That's exactly the dialog I was looking for. I have also never come across this Processing Toolbox before - I think a lot of these tools would have saved me hours in the past. Cheers!
– Matthew Manjos
7 hours ago
add a comment
|
Matthew Manjos is a new contributor. Be nice, and check out our Code of Conduct.
Matthew Manjos is a new contributor. Be nice, and check out our Code of Conduct.
Matthew Manjos is a new contributor. Be nice, and check out our Code of Conduct.
Matthew Manjos is a new contributor. Be nice, and check out our Code of Conduct.
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%2f338042%2fhow-do-i-use-pre-existing-lat-long-data-in-a-sqlite-table-with-qgis%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
