Timeline for How to generate a column with a count of number of points in a polygon AND have 0 for the rows where there are no points in the polygon?
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 11, 2020 at 17:03 | comment | added | Vince | Doh, yes. But that was the issue, indirectly. | |
| Aug 11, 2020 at 16:58 | comment | added | geozelot |
@Vince COUNT cannot return NULL?
|
|
| Aug 11, 2020 at 15:52 | comment | added | Kyle Pennell |
This was it. Now I know that count(table.*) works differently than count(table.column_a)
|
|
| Aug 11, 2020 at 15:52 | vote | accept | Kyle Pennell | ||
| Aug 11, 2020 at 12:42 | comment | added | Vince |
If it were count(geom), then coalesce(count(geom),0) would be necessary.
|
|
| Aug 11, 2020 at 8:00 | history | answered | geozelot | CC BY-SA 4.0 |