23 reputation
4
bio website
location
age
visits member for 2 years, 7 months
seen Jan 14 '13 at 14:05

Nov
4
comment ArcGIS 10.1 Python AddIn Using Multiprocessing crashes ArcMap?
@blah238 Cool stuff, didn't know about that
Nov
2
comment ArcGIS 10.1 Python AddIn Using Multiprocessing crashes ArcMap?
Have you installed all 5 Service Packs for ArcGIS 10.x that are already out? Maybe that'll help
May
25
awarded  Scholar
May
25
accepted Spatial Join in PostGIS according to Line Attribute
May
23
comment Spatial Join in PostGIS according to Line Attribute
@NicklasAvén Thank you for all the help. I will probably do as you suggest, that is map projected coordinate systems per country in a table of the database and do the projection upon import, I think this will be computationally profitable. The number of columns for my example is fixed, so your reply is actually the reply to my question, but I will leave the question for a few days in case somebody gives a reply that includes pivot-tables. Thanks again
May
23
comment Spatial Join in PostGIS according to Line Attribute
@NicklasAvén The SRID is 4326 (WGS_1984) imported from GCS_1984 shapefile
May
23
comment Spatial Join in PostGIS according to Line Attribute
I think I have done what you have suggested and came up with pretty accurate results. You can find above the query used. The only issue now is speed, since I will have to work with extremely large datasets and on the fly projection seems to take a big toll on the performance.
May
23
revised Spatial Join in PostGIS according to Line Attribute
Potential Solution to the question
May
23
revised Spatial Join in PostGIS according to Line Attribute
added 95 characters in body
May
23
comment Spatial Join in PostGIS according to Line Attribute
I have realised that I get "too many roads" when comparing the sum of stats for all AA's with the total stats of the Country, significant deviations occur in relation to the expected numbers. I will attempt to implement it according to your suggestions and post back the results. Thank you for the effort Sergios
May
23
comment Spatial Join in PostGIS according to Line Attribute
Hi Nicklas Thank you very much for the answer, indeed I am looking for pivot-table functionality.
May
23
awarded  Supporter
May
22
awarded  Editor
May
22
revised Spatial Join in PostGIS according to Line Attribute
deleted 2 characters in body
May
22
awarded  Student
May
22
asked Spatial Join in PostGIS according to Line Attribute