units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1 and ACRES = "0.929"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
DES_TP 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
335 | 335 | 334 | {"type": "Polygon", "coordinates": [[[-117.26243, 32.81163], [-117.26192, 32.81174], [-117.26174, 32.81106], [-117.26223, 32.81095], [-117.26243, 32.81163]]]} | Open Access 1 | 914 | Bird Rock Neighborhood Park | 30091 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.929 | Bird Rock Neighborhood Park | 0 | Local Park 2 | 4 | |
3688 | 3688 | 3687 | {"type": "Polygon", "coordinates": [[[-122.35421, 40.59997], [-122.35391, 40.60034], [-122.35384, 40.60035], [-122.3538, 40.5989], [-122.35408, 40.59916], [-122.35416, 40.59929], [-122.35418, 40.5994], [-122.35419, 40.59974], [-122.35415, 40.59985], [-122.35416, 40.5999], [-122.35421, 40.59997]]]} | Open Access 1 | 44423 | Vista Ridge Park | 27189 | 1268 | Redding, City of 403 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | Shasta 27 | 0.929 | Vista Ridge Park | 0 | Local Park 2 | 4 | |
5269 | 5269 | 5268 | {"type": "Polygon", "coordinates": [[[-117.9999, 33.66174], [-117.9991, 33.66252], [-117.99902, 33.66247], [-117.99902, 33.66178], [-117.99905, 33.66172], [-117.99913, 33.66169], [-117.9993, 33.66173], [-117.99953, 33.66176], [-117.99971, 33.66176], [-117.9999, 33.66174]]]} | Open Access 1 | 47379 | Triangle Park | 31102 | 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 | http://www.huntingtonbeachca.gov/residents/parks_facilities/parks/triangle-park.cfm | Orange 3 | 0.929 | Triangle Park | 0 | Local Park 2 | 4 |
13245 | 13245 | 13244 | {"type": "Polygon", "coordinates": [[[-119.16516, 34.26881], [-119.16499, 34.26864], [-119.16492, 34.26863], [-119.16465, 34.26879], [-119.16388, 34.26916], [-119.16322, 34.26952], [-119.16279, 34.26941], [-119.16126, 34.26959], [-119.16098, 34.26984], [-119.16101, 34.27013], [-119.16059, 34.26969], [-119.16097, 34.2696], [-119.16121, 34.26957], [-119.16253, 34.26941], [-119.16297, 34.26935], [-119.1634, 34.26925], [-119.16382, 34.26912], [-119.16422, 34.26896], [-119.16461, 34.26877], [-119.16494, 34.26859], [-119.16498, 34.2686], [-119.16515, 34.26878], [-119.16516, 34.26881]]]} | Open Access 1 | 35304 | Ventura holding 101 | 26854 | 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.929 | Ventura holding 101 | 0 | Local Other or Unknown 14 | 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]);