meta user
network profile
| bio | website | |
|---|---|---|
| location | Berlin | |
| age | ||
| visits | member for | 6 months |
| seen | 2 days ago | |
| stats | profile views | 5 |
|
Mar 17 |
accepted | Count Points in Polygon with Postgis |
|
Mar 17 |
comment |
Count Points in Polygon with Postgis Hi Nicklas, got this answer from the mailing list, right? Thanks everyone |
|
Mar 16 |
comment |
Count Points in Polygon with Postgis thanks, but they all have a WHERE-clause. I don't know if I need one. How would you re-write it? |
|
Mar 16 |
asked | Count Points in Polygon with Postgis |
|
Feb 13 |
comment |
Merging OSM files with OSMOSIS and import to Postgres with OSM2PGSQL I do not have FME but GeoKettle. Do you know how it works? |
|
Feb 13 |
asked | Merging OSM files with OSMOSIS and import to Postgres with OSM2PGSQL |
|
Feb 5 |
asked | How to handle mmqgis geocoding IOError: [Errno socket error] [Errno 101]? |
|
Feb 3 |
comment |
How can I enable Shapefile GUI Loader in pgadmin3? Shouldn't it be wget -qO- apt.opengeo.org/gpg.key | sudo apt-key add - |
|
Dec 19 |
awarded | Talkative |
|
Dec 18 |
awarded | Teacher |
|
Dec 18 |
accepted | How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? |
|
Dec 18 |
answered | How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? |
|
Dec 11 |
comment |
How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? Sorry, but cannot see it. You could send me an eMail an I'll send you the files. |
|
Dec 11 |
comment |
How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? Thanks a lot. What would be the best way to send it to you? |
|
Dec 11 |
awarded | Commentator |
|
Dec 11 |
comment |
How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? select distinct on (t2.h_key) t2.h_key, t2.l_iso_a2, t2.country2, t2.distance from (select h.h_key, h.l_iso_a2, i.ctry as country2, st_distance (h.geom, i.geom) as distance from hotels h, iata_codes i where h.l_iso_a2 = i.ctry order by h.geom, i.geom) as t2 limit 2; This one is running for 30 minutes now (and it is limited to two rows); the one without limiting factor is runnig for five hours now. I have now time reference for calculations like this. is it okay that it's not finished yet? |
|
Dec 11 |
comment |
How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? It really takes a lot of time. It's still running. Are there some "tuning" possiblities for the next time? |
|
Dec 11 |
comment |
How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? It's calculating something. At least since 35 min now. But t1 has about 140.000 rows and t2 12.000. Guess that takes some time, right? |
|
Dec 11 |
comment |
How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? Thank you. It says "relation "point_hotels" does not exist" :( |
|
Dec 11 |
comment |
How to perform a join on simultaneous spatial and attribute criteria in ArcGIS? Maybe you can help me again? |
