units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
11 rows where ACRES = "0.287"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
155 | 155 | 154 | {"type": "Polygon", "coordinates": [[[-121.7428, 36.9182], [-121.74279, 36.91824], [-121.7426, 36.9185], [-121.74256, 36.91853], [-121.7425, 36.91852], [-121.74237, 36.91846], [-121.74233, 36.91842], [-121.74234, 36.91838], [-121.74253, 36.91813], [-121.74258, 36.9181], [-121.74265, 36.9181], [-121.74277, 36.91816], [-121.7428, 36.9182]]]} | Open Access 1 | 417 | Bronte Park | 16417 | 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.287 | Bronte Park | 0 | Local Park 2 | 4 | |
1125 | 1125 | 1124 | {"type": "Polygon", "coordinates": [[[-118.19523, 33.85437], [-118.19505, 33.85468], [-118.19468, 33.85468], [-118.19486, 33.85437], [-118.19523, 33.85437]]]} | Open Access 1 | 6599 | Burton W. Chace Park | 28711 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Burton W. Chace Park | 0 | Local Park 2 | 4 | |
4234 | 4234 | 4233 | {"type": "Polygon", "coordinates": [[[-120.13118, 35.99946], [-120.13084, 35.99947], [-120.13084, 35.99912], [-120.13117, 35.99912], [-120.13118, 35.99946]]]} | Open Access 1 | 45105 | Avenal Neighborhood Park | 32506 | 1017 | Avenal, City of 735 | City 2 | City Agency 2 | City 2 | 1017 | Avenal, City of 719 | City 2 | City Agency 2 | https://www.cityofavenal.com/Facilities/Facility/Details/Avenal-Neighborhood-Park-3 | Kings 44 | 0.287 | Avenal Neighborhood Park | 0 | Local Park 2 | 4 | |
7127 | 7127 | 7126 | {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} | Restricted Access 2 | 6216 | Watts Historic Train Station | 29326 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1717 | Los Angeles - Community Redevelopment Agency, City of 829 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Watts Historic Train Station | 0 | Local Historic or Cultural Area 19 | 4 | |
9377 | 9377 | 9376 | {"type": "Polygon", "coordinates": [[[-122.40426, 37.71229], [-122.4041, 37.71254], [-122.40372, 37.71239], [-122.40387, 37.71214], [-122.40426, 37.71229]]]} | Open Access 1 | 15674 | Vis Valley Community Center | 27160 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.287 | Vis Valley Community Ctr. | 0 | Local Recreation Area 3 | 4 | |
9381 | 9381 | 9380 | {"type": "Polygon", "coordinates": [[[-122.40064, 37.73869], [-122.40024, 37.73914], [-122.40006, 37.73904], [-122.40047, 37.73859], [-122.40064, 37.73869]]]} | Open Access 1 | 15682 | Shlby & Palou Mini Park | 25417 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | http://sfrecpark.org/ | City 2 | 1300 | San Francisco, City and County of 21 | City 2 | City Agency 2 | San Francisco 13 | 0.287 | Shlby & Palou MP | 0 | Local Park 2 | 4 | |
13025 | 13025 | 13024 | {"type": "MultiPolygon", "coordinates": [[[[-122.44722, 37.47993], [-122.44714, 37.47996], [-122.44695, 37.47974], [-122.44702, 37.4797], [-122.44722, 37.47993]]], [[[-122.44891, 37.47986], [-122.44862, 37.48002], [-122.44843, 37.47979], [-122.44871, 37.47964], [-122.44891, 37.47986]]]]} | Open Access 1 | 34864 | Coastside Land Trust | 17467 | 3029 | Coastside Land Trust 678 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.coastsidelandtrust.org | Non Governmental Organization 10 | 3029 | Coastside Land Trust 668 | Non Profit 6 | Non Profit - Land Trust 10 | San Mateo 15 | 0.287 | Coastside Land Trust | 0 | Private Conservation 16 | 2 | |
14794 | 14794 | 14793 | {"type": "Polygon", "coordinates": [[[-116.95852, 32.65971], [-116.95848, 32.65998], [-116.95841, 32.66002], [-116.95813, 32.66], [-116.95816, 32.65968], [-116.95852, 32.65971]]]} | Restricted Access 2 | 45180 | Kensington Road Park | 33346 | 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.287 | Kensington Road Park | 0 | Private Recreation or Education 65 | 4 | ||
14820 | 14820 | 14819 | {"type": "Polygon", "coordinates": [[[-121.27616, 37.81964], [-121.27616, 37.81998], [-121.27581, 37.81998], [-121.27581, 37.81963], [-121.27616, 37.81964]]]} | Open Access 1 | 47254 | Lathrop Skate Park | 30965 | 1171 | Lathrop, City of 528 | City 2 | City Agency 2 | http://www.ci.lathrop.ca.us/lathrop/prd/Default.aspx | City 2 | 1171 | Lathrop, City of 520 | City 2 | City Agency 2 | San Joaquin 39 | 0.287 | Lathrop Skate Park | 0 | Local Recreation Area 3 | 4 | |
15047 | 15047 | 15046 | {"type": "Polygon", "coordinates": [[[-118.44182, 34.05762], [-118.44151, 34.05771], [-118.44138, 34.05738], [-118.44169, 34.0573], [-118.44182, 34.05762]]]} | Open Access 1 | 45838 | Westwood Gardens Park | 28858 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | http://lacity.org/ | City 2 | 1188 | Los Angeles, City of 24 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Westwood Gardens Park | 0 | Local Park 2 | 4 | |
15315 | 15315 | 15314 | {"type": "Polygon", "coordinates": [[[-118.39163, 33.86965], [-118.39122, 33.86971], [-118.39117, 33.86944], [-118.39157, 33.86938], [-118.39163, 33.86965]]]} | Open Access 1 | 46497 | Seaview Parkette | 29782 | 1134 | Hermosa Beach, City of 294 | City 2 | City Agency 2 | http://www.hermosabch.org/index.aspx?page=115 | City 2 | 1134 | Hermosa Beach, City of 290 | City 2 | City Agency 2 | Los Angeles 6 | 0.287 | Seaview Parkette | 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]);