Good evening, I use opencitiemaps and I should import cadastral data in csv format, these data will have to be linked to the map on opencitie with a symbol or a number, my question is if there is this possibility to do it via geospacial or other ways to connect things. Would you give me a guide. thanks
This is accomplished with the Import CSV command in OpenCities Map. Are you familiar with that? If not, have a look at the online resources that describe the functionality. The option to define a symbol (cell) can be done at the time of import. Labeling the parcels can be achieved after they are on the map.
- VRT file parameters to import Points, Lines, and Polygons
- VRT files to import ODBC and CSV data sources
- Map Help file; Importing CXV and ODBC data sources
- Map Help file: Labeling & Annotation
Answer Verified By: christian capozi
Good evening Dan, I tried the string you indicated, and it works, but my basic problem is that I have two distinct CSVs, one with the cadastral data, but without coordinates, and another with only the coordinates, I wanted to know if in the VRT there is the possibility to mix the two CSVs to have a point with the coordinates. Thanks for your patience
The image is the result of my work as a designer of expropriations on autoca that I would like to import into Opencitiemaps. Once the points have been entered I would like to create a feutors that automatically creates the circled numbers for me.
Hi Christian,
thanks for the files. It's not clear how they can be joined (linked) together, because I do not see any unique ID. What columns should be used as "link"? Or is it organized in such way that a row is equal to row in 1:1 relation?
I quickly check VRT format description and I still think that it's not possible to define relationships between different data sources. And even when it would be possible (maybe some "VRT expert" will find a solution), I am not sure whether it will be the right way.
I recommend to process CSV files upfront, which allow to check data quality and to filter and reorganize data to obtain required data format. To link and join CSV files can be done in many ways, you can find plenty of discussions on internet, from simple command line approach over Excel to specialized tools. I think e.g. csvkit is simple but powerful tool.
With regards,
Jan
Bentley Accredited Developer: iTwin Platform - AssociateLabyrinth Technology | dev.notes() | cad.point
Thanks Jan, for your time, I wanted to know if it was possible to create a features, with line and circle and number to be inserted at my choice like the example I have attached. Thanks again
In the Map Manager you can create a join between a layer and a CSV file. In the Define Joins dialog, create a Session Feature from the CSV file using the option New File Source ... As Jan already mentioned, there should be a join column between the imported CSV file and the CSV file with the attributes.
thanks, I'll try your method and update you on the evolution