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: [email protected]
To: [email protected]
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
[email protected]
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._______________________________________________
Qgis-user mailing list
[email protected]
List info: http://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
