I am using -e flag to copy the attribute table as well. I have data in json format. I am importing json data in separate maps and then patching them into one map to have all the points in one place. I did not find any smarter way to import them. Is there any way that I can directly insert the records in the db instead of saving them in json file first and then importing it?
I am using GRASS 7.0. v.db.connect -p patch_map1 layer <1/patch_map1> table <patch_map1> in database </home/shared/research/GRASSDATA/RedRiverValley/aroy/sqlite/sqlite.db> through driver <sqlite> with key <cat> v.info -c patch_map1 INTEGER|cat CHARACTER|air_temp CHARACTER|cloud_cover CHARACTER|descriptors CHARACTER|dew_point CHARACTER|ice_acc_last_hour CHARACTER|liquid_acc_last_hour CHARACTER|msl_pressure CHARACTER|precip_acc_last_hour CHARACTER|relative_humidity CHARACTER|snow_acc_last_hour CHARACTER|station_pressure CHARACTER|u_wind_speed CHARACTER|v_wind_speed DOUBLE PRECISION|valid_time_end DOUBLE PRECISION|valid_time_start CHARACTER|visibility CHARACTER|wind_direction CHARACTER|wind_speed Displaying column types/names for database connection of layer <1>: (Tue Dec 2 10:47:58 2014) Command finished (0 sec) Thanks Roy -----Original Message----- From: Moritz Lennert [mailto:[email protected]] Sent: Tuesday, December 02, 2014 3:54 AM To: Arighna; 'Vaclav Petras'; [email protected] Subject: Re: [GRASS-user] Loading JSON data in GRASS On 02/12/14 10:12, Arighna wrote: > Hi Moritz, > > Thanks a lot for your reply. > > It is connected with the 'cat' column as I didn't provide any key > column while importing the data. Both the input and the output maps > have the key column as 'cat'. Still I am getting the error. Could this > be a problem that for both the maps the 'cat 'values are 1? > > Also I was trying to import the data with a specific key column. But > there is no provision for doing that. > I tried these commands. > > v.in.ogr input=/home/aroy/geojson_sample/patch/patch1.1.geojson > output=patch_test1 key=category > ERROR: Sorry, <input> is not a valid parameter > ERROR: Sorry, <key> is not a valid parameter > ERROR: Required parameter <dsn> not set: > (OGR datasource name) > > > v.in.ogr dsn=/home/aroy/geojson_sample/patch/patch1.1.geojson > output=patch_test1 key=category > ERROR: Sorry, <key> is not a valid parameter You are using grass6.4, I suppose ? In that version v.in.ogr does not have a key parameter. Could you send us the output of v.db.connect -p patch_test1 and v.info -c patch_test1 ? Also, I don't really understand the sens of your v.patch: v.patch -e input=patch_map1 output=patch_map6 Why only one input map ? Doing that is somewhat like copying patch_map1 to patch_map6... If patch_map6 already exists and you want to append patch_map1 to it, then you have to use the '-a' flag. Moritz _______________________________________________ grass-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/grass-user
