units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACRES = "0.218"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
MNG_AGENCY 6
DES_TP 1
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3276 | 3276 | 3275 | {"type": "Polygon", "coordinates": [[[-116.30936, 33.6529], [-116.30904, 33.6529], [-116.30905, 33.65265], [-116.3091, 33.65262], [-116.30936, 33.65263], [-116.30936, 33.6529]]]} | Open Access 1 | 39079 | Velasco Park | 26843 | 1161 | La Quinta, City of 612 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | Riverside 10 | 0.218 | Velasco Park | 0 | Local Park 2 | 4 | |
7107 | 7107 | 7106 | {"type": "Polygon", "coordinates": [[[-122.02773, 36.9637], [-122.0276, 36.96381], [-122.02751, 36.96396], [-122.02747, 36.9641], [-122.02747, 36.96425], [-122.02745, 36.96402], [-122.0275, 36.96347], [-122.02767, 36.96347], [-122.02773, 36.9637]]]} | Open Access 1 | 47746 | Chestnut Park | 31555 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 0.218 | Chestnut Park | 0 | Local Park 2 | 4 | |
7412 | 7412 | 7411 | {"type": "Polygon", "coordinates": [[[-118.22982, 34.08555], [-118.22966, 34.08568], [-118.22908, 34.08522], [-118.22911, 34.08519], [-118.22943, 34.08538], [-118.22981, 34.08552], [-118.22982, 34.08555]]]} | Open Access 1 | 6926 | Oso Park | 23235 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.218 | Oso Park | 0 | Local Park 2 | 4 | |
12901 | 12901 | 12900 | {"type": "Polygon", "coordinates": [[[-118.07112, 33.7252], [-118.07073, 33.72527], [-118.07071, 33.72521], [-118.07066, 33.72516], [-118.07086, 33.72496], [-118.07101, 33.72503], [-118.07104, 33.72506], [-118.07109, 33.72512], [-118.07112, 33.7252]]]} | Open Access 1 | 30354 | Prince Park | 24007 | 1141 | Huntington Beach, City of 125 | City 2 | City Agency 2 | http://www.surfcity-hb.org/residents/parks_facilities/parks/index.cfm | City 2 | 1141 | Huntington Beach, City of 122 | City 2 | City Agency 2 | Orange 3 | 0.218 | Prince Park | 0 | Local Park 2 | 4 | |
14804 | 14804 | 14803 | {"type": "Polygon", "coordinates": [[[-122.30253, 37.80789], [-122.30246, 37.8081], [-122.3024, 37.80817], [-122.30212, 37.80803], [-122.30219, 37.80782], [-122.30253, 37.80789]]]} | Open Access 1 | 47998 | Bertha Port Park | 32420 | 1228 | Oakland, City of 58 | City 2 | City Agency 2 | http://www2.oaklandnet.com/Government/o/opr/index.htm | City 2 | 1228 | Oakland, City of 56 | City 2 | City Agency 2 | Alameda 17 | 0.218 | Bertha Port Park | 0 | Local Park 2 | 4 | |
15085 | 15085 | 15084 | {"type": "MultiPolygon", "coordinates": [[[[-118.15916, 34.01883], [-118.15918, 34.01884], [-118.15919, 34.01886], [-118.15904, 34.01936], [-118.15896, 34.01951], [-118.15899, 34.0193], [-118.15913, 34.01885], [-118.15916, 34.01883]]], [[[-118.15947, 34.01784], [-118.15947, 34.01795], [-118.15928, 34.01858], [-118.15923, 34.0186], [-118.15921, 34.01856], [-118.1594, 34.01795], [-118.15947, 34.01784]]]]} | Open Access 1 | 45867 | Woods Avenue Park | 28914 | 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 | http://parks.lacounty.gov/wps/portal/dpr/Parks/Woods_Avenue_Park | Los Angeles 6 | 0.218 | Woods Avenue 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]);