Timeline for Perform a group by query on geodatabase in ArcMap
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 29, 2018 at 1:01 | history | edited | PolyGeo♦ | CC BY-SA 3.0 |
deleted 63 characters in body
|
| Sep 18, 2014 at 22:04 | vote | accept | Timnit Gebru | ||
| Sep 18, 2014 at 21:14 | comment | added | nmpeterson | The .gdb indicates it's a file geodatabase, rather than a personal geodatabase (.mdb) -- personal GDBs have more thorough SQL support | |
| Sep 18, 2014 at 21:11 | history | edited | nmpeterson |
Tags: mysql -> sql, file-geodatabase instead of feature-class
|
|
| Sep 18, 2014 at 20:20 | answer | added | Inactivated Account | timeline score: 5 | |
| Sep 18, 2014 at 20:11 | comment | added | Timnit Gebru | how would I find out what type of .gdb I'm using? It just says file geodatabase. Also I tried only one column in where like where avg_price in (SELECT SUM(avg_price) from output_gis_120_Project GROUP BY lat,lng). Is there a different way to achieve what I am trying to do here? | |
| Sep 18, 2014 at 20:07 | comment | added | Vince |
Why do you have this tagged with mysql? File geodatabse doesn't have a RDBMS, so even valid ANSI SQL isn't fully supported.
|
|
| Sep 18, 2014 at 20:02 | comment | added | janechii | I'm not sure what ArcGIS's limitations are in regards to GROUP BY, but you cannot have a WHERE ... IN specified like that. Must have one column only. See syntax here: w3schools.com/sql/sql_in.asp | |
| Sep 18, 2014 at 20:01 | comment | added | radouxju | what type of geodatabase do you use ? note that .gdb do not support all queries. | |
| Sep 18, 2014 at 19:56 | history | asked | Timnit Gebru | CC BY-SA 3.0 |