units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACRES = "0.54"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP, DES_TP
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1946 | 1946 | 1945 | {"type": "Polygon", "coordinates": [[[-121.76093, 36.91723], [-121.76076, 36.91733], [-121.76072, 36.91757], [-121.7608, 36.91771], [-121.76083, 36.91787], [-121.76082, 36.91797], [-121.76078, 36.91807], [-121.76066, 36.91822], [-121.76067, 36.91867], [-121.76061, 36.91868], [-121.76059, 36.91821], [-121.76052, 36.91809], [-121.7605, 36.91802], [-121.76049, 36.91789], [-121.7605, 36.91782], [-121.76055, 36.9177], [-121.76065, 36.91757], [-121.7607, 36.91729], [-121.76089, 36.91719], [-121.76093, 36.91723]]]} | Open Access 1 | 16647 | Gonzalez Pocket Park | 19401 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.54 | Gonzalez PP | 0 | Local Park 2 | 4 | |
13481 | 13481 | 13480 | {"type": "Polygon", "coordinates": [[[-118.16406, 34.20859], [-118.16399, 34.20877], [-118.16379, 34.20908], [-118.16333, 34.20952], [-118.16322, 34.20967], [-118.16298, 34.20963], [-118.16307, 34.20948], [-118.16318, 34.20935], [-118.16368, 34.20899], [-118.16383, 34.20886], [-118.16406, 34.20859]]]} | Open Access 1 | 35765 | Los Angeles holding 11 | 21486 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 0.54 | Los Angeles holding 11 | 0 | Local Other or Unknown 14 | 4 | |
14112 | 14112 | 14111 | {"type": "Polygon", "coordinates": [[[-117.22611, 33.89861], [-117.22604, 33.89868], [-117.22536, 33.89868], [-117.22533, 33.89865], [-117.22533, 33.8984], [-117.22611, 33.8984], [-117.22611, 33.89861]]]} | Open Access 1 | 39195 | Patriot Park | 23514 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | http://www.moreno-valley.ca.us/city_hall/departments/pcs/index-parks.shtml | City 2 | 1216 | Moreno Valley, City of 15 | City 2 | City Agency 2 | Riverside 10 | 0.54 | Patriot Park | 0 | Local Park 2 | 4 | |
14497 | 14497 | 14496 | {"type": "Polygon", "coordinates": [[[-122.05109, 37.3278], [-122.05067, 37.32805], [-122.05066, 37.32751], [-122.05061, 37.32715], [-122.05071, 37.32712], [-122.05109, 37.3278]]]} | Open Access 1 | 47157 | Mary Avenue Dog Park | 30837 | 1076 | Cupertino, City of 195 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | http://www.cupertino.org/ | Santa Clara 19 | 0.54 | Mary Avenue Dog Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);