meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 5 months |
| seen | Jan 14 at 14:05 | |
| stats | profile views | 6 |
|
Nov 4 |
comment |
Crashing ArcGIS 10.1 Add-ins Using Multiprocessing @blah238 Cool stuff, didn't know about that |
|
Nov 2 |
comment |
Crashing ArcGIS 10.1 Add-ins Using Multiprocessing 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 |
