search

ariesteam / aries

http://www.ariesonline.org
GNU General Public License v3.0
6 stars 1 forks source link

miscellaneous shp2db/geoserver-update problems #64

Open kbagstad opened 12 years ago

kbagstad commented 12 years ago

@fvilla @lambdatronic

I'm trying to add the vector layer "transmission_lines" in the usa workspace of the latest REST spreadsheet and when I use shp2db (shp2db 4326 /raid/geodata/data/united_states/transmission/US_Transmission_Final transmission_lines2 usa postgres) I get a long string of "INSERT 01"'s just like it's supposed to, but at the end I get the error "column "the_geom" does not exist ROLLBACK

So for some reason I can't add this layer.

Also when running geoserver-update if I try to remove a vector layer by just putting a minus in column a, pushing and running geoserver-update, I get the message "java.lang.IllegalArgumentException: No value supplied for key: DROP TABLE reservoirs_co" Any idea how to remove vector data using geoserver-update, or do I need to just manually remove?

lambdatronic commented 12 years ago

I think this one is for me. For the moment, I'd recommend just removing the layer manually, but I'll make sure to look at this asap on Monday.

kbagstad commented 12 years ago

Manual layer removal seems to be the way to go for vector data - have run into a few instances where I get the "No value supplied for key: DROP TABLE" message when trying to remove vector data from GeoServer via geoserver-update.

However the first part of the issue - the error with getting the transmission line data into GeoServer - does deserve a second look when you have time to do it.

lambdatronic commented 12 years ago

Got it. I'll take a look later this week.