superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 2, LAYER = 14, MNG_AGENCY = 1110 and MNG_AG_TYP = 15
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Home Owners Association · 1 ✖
MNG_AGENCY 1
- CZ Master Association · 1 ✖
ACCESS_TYP 1
- Restricted Access · 1 ✖
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15432 | 15432 | 15431 | {"type": "Polygon", "coordinates": [[[-117.59014, 33.62644], [-117.58955, 33.6267], [-117.58932, 33.62718], [-117.58911, 33.62751], [-117.58878, 33.62766], [-117.5885, 33.62759], [-117.58811, 33.62759], [-117.58789, 33.62764], [-117.58737, 33.62751], [-117.58704, 33.62726], [-117.58642, 33.62719], [-117.58659, 33.62671], [-117.58671, 33.62632], [-117.58679, 33.62628], [-117.58696, 33.62629], [-117.58718, 33.62627], [-117.58752, 33.62631], [-117.58764, 33.6263], [-117.58776, 33.62627], [-117.58791, 33.62618], [-117.58819, 33.62594], [-117.58822, 33.62593], [-117.58832, 33.62578], [-117.58836, 33.62565], [-117.58835, 33.62548], [-117.58828, 33.62533], [-117.58847, 33.62532], [-117.58856, 33.62488], [-117.58954, 33.6252], [-117.5897, 33.62528], [-117.5898, 33.62571], [-117.59003, 33.62582], [-117.59015, 33.62615], [-117.59014, 33.62644]]]} | Restricted Access 2 | Coto Sports And Recreation Park | 32378 | 6037 | CZ Master Association 1110 | Private 7 | Home Owners Association 15 | http://www.czmaster.org/ | Private 14 | 14.255 | Coto Sports And Rec. Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);