[Qgis-user] Data import and export
Nicolas Cadieux
nicolas.cadieux at archeotec.ca
Fri Jul 8 11:29:59 PDT 2016
Hi,"My first issue is the CVS file has both the lat/long in one column separated by a comma. I see that the import process requires them to be in separate columns."
Import the file in Excel or Libre Office calc. Use the text to column to split the data. I qgis, I think the data will need to be decimal degrees. If you don't have other commas, you may be able to import it in Qgis by using both comma and space (or tab or whatever field separator you have) in the csv import window.
"Second when collecting the pole numbers, it cannot be a dropdown box, as there are thousands of poles to scroll through on the app."
If your pole are georeferenced, you can use that to link both files. If not, you could join one file to another using the "layer property/ join" option. Expand more if this is not the answer you are looking for. "My goal is to create a process that imports the data from the Canvas app and creates a visual status of the lines – different colors for each status type. I would have to “link” my data to the current data received from the client."
You can create visual style based on a column or a function. layer property/style/rule based. The style will be updated when the file is saved.
Hope this helps.Nicolas Cadieux
From: ml-node+s1560n5275470h31 at n6.nabble.com
To: nicolas.cadieux at archeotec.ca
Date: Fri, 8 Jul 2016 11:51:36 -0600
Subject: Data import and export
I have a process that I would like to create using QGIS. I
am just a beginner in this program/process, but know just enough to get into
trouble. I work for a vegetation control company and want a way to manage my
data. I have data from my client (power company) – points of the poles and
lines for the power lines. I need to collect data in the filed using Canvas app
– customizable and can export into a CVS file. What I want to do is collect location
(pole number), status (applied not needed, application completed, customer
refusal, federal land), time, date, employee, photo and some details if the
application was applied.
My first issue is the CVS file has both the lat/long in one
column separated by a comma. I see that the import process requires them to be
in separate columns.
Second when collecting the pole numbers, it cannot be a
dropdown box, as there are thousands of poles to scroll through on the app.
My goal is to create a process that imports the data from
the Canvas app and creates a visual status of the lines – different colors for
each status type. I would have to “link” my data to the current data received from
the client.
Any thoughts, applications/ programs or resources would be
greatly appreciated.
--
Jonathon Roberts
503-798-1917
_______________________________________________
Qgis-user mailing list
[hidden email]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
If you reply to this email, your message will be added to the discussion below:
http://osgeo-org.1560.x6.nabble.com/Data-import-and-export-tp5275470.html
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38 at n6.nabble.com
To unsubscribe from Quantum GIS - User, click here.
NAML
--
View this message in context: http://osgeo-org.1560.x6.nabble.com/Data-import-and-export-tp5275470p5275475.html
Sent from the Quantum GIS - User mailing list archive at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20160708/9a1c20d0/attachment.html>
More information about the Qgis-user
mailing list