units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACRES = "0.846"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1770 | 1770 | 1769 | {"type": "Polygon", "coordinates": [[[-122.46873, 38.50001], [-122.46855, 38.50036], [-122.46833, 38.50029], [-122.46828, 38.50017], [-122.4681, 38.50004], [-122.4679, 38.50005], [-122.46752, 38.49995], [-122.46769, 38.49965], [-122.46873, 38.50001]]]} | Open Access 1 | 13240 | Mary Fryer Park | 21930 | 1290 | Saint Helena, City of 422 | City 2 | City Agency 2 | http://cityofsthelena.org/parks-recreation | City 2 | 1290 | Saint Helena, City of 416 | City 2 | City Agency 2 | Napa 11 | 0.846 | Mary Fryer Park | 0 | Local Park 2 | 4 | |
10849 | 10849 | 10848 | {"type": "Polygon", "coordinates": [[[-118.15398, 34.08516], [-118.15331, 34.08515], [-118.15331, 34.08529], [-118.15286, 34.0853], [-118.15299, 34.08511], [-118.15317, 34.08496], [-118.15341, 34.08484], [-118.15365, 34.08478], [-118.15384, 34.08477], [-118.15397, 34.08496], [-118.15398, 34.08503], [-118.15398, 34.08516]]]} | Open Access 1 | 20637 | Emery Park | 18624 | 1003 | Alhambra, City of 158 | City 2 | City Agency 2 | http://www.cityofalhambra.org/page/20/parks_rec_department/ | City 2 | 1003 | Alhambra, City of 154 | City 2 | City Agency 2 | Los Angeles 6 | 0.846 | Emery Park | 0 | Local Park 2 | 4 | |
11880 | 11880 | 11879 | {"type": "Polygon", "coordinates": [[[-118.14718, 33.96609], [-118.14712, 33.96647], [-118.14626, 33.96637], [-118.14632, 33.96599], [-118.14718, 33.96609]]]} | Open Access 1 | 24484 | Bell Gardens Skate Park | 15973 | 1023 | Bell Gardens, City of 226 | City 2 | City Agency 2 | http://www.bellgardens.org/GOVERNMENT/CityDepartments/RecreationCommunityServices/ParksandFacilities.aspx | City 2 | 1023 | Bell Gardens, City of 222 | City 2 | City Agency 2 | Los Angeles 6 | 0.846 | Bell Gardens Skate Park | 0 | Local Recreation Area 3 | 4 | |
13333 | 13333 | 13332 | {"type": "Polygon", "coordinates": [[[-119.29926, 34.30404], [-119.29875, 34.30564], [-119.29869, 34.30563], [-119.29879, 34.30522], [-119.29883, 34.30475], [-119.2988, 34.3046], [-119.29871, 34.30448], [-119.29885, 34.30437], [-119.29897, 34.30398], [-119.29926, 34.30404]]]} | Open Access 1 | 35409 | Ventura holding 44 | 26923 | 1366 | Ventura, City of 113 | City 2 | City Agency 2 | http://www.cityofventura.net/prcp | City 2 | 1366 | Ventura, City of 110 | City 2 | City Agency 2 | Ventura 8 | 0.846 | Ventura holding 44 | 0 | Local Other or Unknown 14 | 4 | |
14787 | 14787 | 14786 | {"type": "Polygon", "coordinates": [[[-117.0031, 32.62517], [-117.00301, 32.62553], [-117.00297, 32.62555], [-117.00229, 32.62541], [-117.00226, 32.62538], [-117.00235, 32.62501], [-117.00239, 32.62499], [-117.00308, 32.62513], [-117.0031, 32.62517]]]} | Restricted Access 2 | 45174 | Orchard Park | 33354 | 6074 | Home Owners Association - Unknown Name 640 | Private 7 | Home Owners Association 16 | Private 14 | 6074 | Home Owners Association - Unknown Name 629 | Private 7 | Home Owners Association 15 | San Diego 4 | 0.846 | Orchard Park | 0 | Private Recreation or Education 65 | 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]);