60 reputation
4
bio website
location
age
visits member for 3 years, 5 months
seen Dec 9 at 12:53

Aug
31
revised memory issue when trying to buffer/union large dataset using postgis
added 285 characters in body
Aug
31
comment memory issue when trying to buffer/union large dataset using postgis
Thanks Paul. Your solution worked (almost) perfectly. It is a bit slow to run on my server (I think I still have work to do to optimise memory usage, it now never ramps up!) but it does the job! I had to remove the last step (groupedfinal) because for some reason it crashes (Error message: GEOSUnaryUnion: St9bad_alloc - even though I call ST_Union not ST_UnaryUnion, and even if I ST_Dump() the multipolygons before the final union to simplify the geometries). However I managed to run that step separately in arcgis so that is not a big issue.
Aug
31
accepted memory issue when trying to buffer/union large dataset using postgis
Aug
24
comment memory issue when trying to buffer/union large dataset using postgis
Thanks. This looks pretty simple indeed. I will fall back to this if my attempts are doing it through a sql loop fail (quite likely given my level!)
Aug
24
comment memory issue when trying to buffer/union large dataset using postgis
Thanks for your help. I do have 1 attribute I could use in a group by clause, but I suspect it won't help much (only 2 values in the field, and the split is 90% / 10%). If spliting the multipolygon in individual polygons using ST_Dump or similar would help I can definitely do it, but from what I can tell this would happen after the massive multigeometry is created anyway so not sure it would help? also, my geometries are not in lat-long, so if I want to use geohash I believe I need to convert the coordinates first... is there an alternative?
Aug
21
asked memory issue when trying to buffer/union large dataset using postgis
Oct
11
comment Is it possible to reference data using mapped network drives instead of UNC path in arcgis server services?
Thanks for your answer Unicoletti, however I don't think I made myself clear. I don't see how what you describe can help me with my problem: I already know that the services can access network shares using the unc path, and I have sucessfully created gis services using that method. what I wanted to know was if there was a way to make the service understand things like Z:\ == \\myserver\myshare, just like a normal user could.
Oct
11
awarded  Editor
Oct
11
revised Is it possible to reference data using mapped network drives instead of UNC path in arcgis server services?
deleted 1 characters in body
Oct
11
comment Is it possible to reference data using mapped network drives instead of UNC path in arcgis server services?
Thanks Thomas, I think that is the clear and definitive answer I was looking for!
Oct
11
awarded  Supporter
Oct
11
awarded  Scholar
Oct
11
accepted Is it possible to reference data using mapped network drives instead of UNC path in arcgis server services?
Oct
11
comment Is it possible to reference data using mapped network drives instead of UNC path in arcgis server services?
Well I think ideally I would be happy not to use to them but historically we (my company) have been using mapped drives as a abstraction layer to allow mxds to be copied across various offices/servers (without breaking the links, as long as long as the relevant datasets were copied as well and using the same folder structure). If I could make this work it would work well with our existing file structure.
Oct
11
awarded  Student
Oct
11
asked Is it possible to reference data using mapped network drives instead of UNC path in arcgis server services?