Hi Mike - It's been years since I worked on that code, but I recall WKT being the export format for csv. Are you getting JSON or no geometries at all with csv export?
Regarding how to preserve the value order, I can't think of an easy way to do it. I'd have to really dive into the code and do some debugging to figure it out. - Cyrus On Fri, Mar 15, 2019 at 3:44 AM Michael Fisher <[email protected]> wrote: > Hi Cyrus, thanks for getting back to me on this. > > Yeah, I should have specified that I'm asking for Arches 3 (for now, > anyway). We're re-attempting an EAMENA v1-v2 migration and in some cases > this requires us to change the Resource type (because the v2 database has > tiered Resource classification) and rearrange those Resources' data > accordingly. Thus, .csv is the preferable export method. > > The workaround we used was exporting to JSON and extracting the geometries > to .csv, but if it's possible to rig the .csv export to produce WKT, that > would be killer, as I've got to do another migration in the coming week. > > Also of note is that a .csv export generates multivalent field data > alphabetically, meaning that the relationships between data of grouped > fields is lost. I don't see any sorted function in csvfile.py; any ideas as > to how to preserve value order? > > Best, > -Mike > > Dr Michael T. Fisher > Database Manager in Endangered Archaeology > EAMENA Project, School of Archaeology > University of Oxford > 1-2 South Parks Road, Oxford OX1 3TG > http://eamena.arch.ox.ac.uk > > > On Mar 14, 2019, at 7:51 PM, Cyrus Hiatt <[email protected]> wrote: > > Hi Mike - > > Sorry for the late response. Are you asking in regards to exporting > geometries from Arches 3 or 4? > > Thanks, > > Cyrus > > On Mon, Mar 11, 2019 at 8:45 AM Mike Fisher <[email protected]> > wrote: > >> I'd like to export geometries to a .csv file. Can anyone clarify the >> correct code for using GEOMETRY=AS_WKT and where to deploy it? >> Thanks! >> >> -- >> -- To post, send email to [email protected]. To >> unsubscribe, send email to [email protected]. >> For more information, visit >> https://groups.google.com/d/forum/archesproject?hl=en >> --- >> You received this message because you are subscribed to the Google Groups >> "Arches Project" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/d/optout. >> > > -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
