units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where DES_TP = 2, MNG_AG_TYP = 2 and YR_EST = 2019
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3241 | 3241 | 3240 | {"type": "Polygon", "coordinates": [[[-119.82045, 34.43733], [-119.81874, 34.43735], [-119.81907, 34.43679], [-119.81909, 34.43626], [-119.82044, 34.43625], [-119.82045, 34.43733]]]} | Open Access 1 | 48131 | Jonny D. Wallis Neighborhood Park | 32654 | 1121 | Goleta, City of 179 | City 2 | City Agency 2 | http://www.cityofgoleta.org/index.aspx?page=206 | City 2 | 1121 | Goleta, City of 175 | City 2 | City Agency 2 | https://www.cityofgoleta.org/projects-programs/parks-open-space/old-town-park | Santa Barbara 7 | 3.96 | Jonny D. Wallis Neighborhood Park | 2019 | Local Park 2 | 4 |
7642 | 7642 | 7641 | {"type": "Polygon", "coordinates": [[[-121.91965, 37.40115], [-121.91878, 37.40193], [-121.91857, 37.40145], [-121.91833, 37.40099], [-121.91804, 37.40054], [-121.91838, 37.40024], [-121.9184, 37.40032], [-121.91845, 37.40039], [-121.91922, 37.40091], [-121.91923, 37.40098], [-121.91927, 37.40103], [-121.91937, 37.40106], [-121.91947, 37.40102], [-121.91965, 37.40115]]]} | Open Access 1 | 48967 | Iris Chang Park | 33665 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | https://www.sanjoseca.gov/Home/Components/News/News/402/5103 | Santa Clara 19 | 2.664 | Iris Chang Park | 2019 | Local Park 2 | 4 |
8533 | 8533 | 8532 | {"type": "Polygon", "coordinates": [[[-117.2044, 33.66004], [-117.2044, 33.66054], [-117.20364, 33.66054], [-117.20359, 33.66062], [-117.20354, 33.6606], [-117.20346, 33.6606], [-117.20341, 33.66063], [-117.20336, 33.66068], [-117.20329, 33.66065], [-117.20297, 33.66079], [-117.20284, 33.66059], [-117.20195, 33.66065], [-117.20188, 33.66067], [-117.20183, 33.66063], [-117.20176, 33.6606], [-117.20171, 33.6606], [-117.20164, 33.66063], [-117.20158, 33.66056], [-117.20123, 33.66056], [-117.20122, 33.66075], [-117.20086, 33.66075], [-117.2008, 33.66083], [-117.20069, 33.6608], [-117.20062, 33.66083], [-117.20058, 33.66086], [-117.20053, 33.66083], [-117.19976, 33.66082], [-117.19975, 33.66119], [-117.19974, 33.66126], [-117.19976, 33.66132], [-117.19984, 33.66137], [-117.19983, 33.66196], [-117.19965, 33.66189], [-117.19954, 33.6619], [-117.1991, 33.66179], [-117.19873, 33.66179], [-117.19872, 33.66073], [-117.1987, 33.66058], [-117.19865, 33.66043], [-117.19893, 33.6603], [-117.19895, 33.66028], [-117.19946, 33.66011], [-117.19943, 33.66016], [-117.19942, 33.66021], [-117.19946, 33.66029], [-117.19955, 33.66033], [-117.19967, 33.66031], [-117.19976, 33.6604], [-117.2004, 33.66041], [-117.20046, 33.66038], [-117.20053, 33.66044], [-117.20062, 33.66045], [-117.20069, 33.66043], [-117.20073, 33.66038], [-117.20075, 33.66033], [-117.20074, 33.66025], [-117.20105, 33.66025], [-117.20106, 33.66021], [-117.201, 33.66008], [-117.20101, 33.65909], [-117.2012, 33.65907], [-117.20127, 33.65938], [-117.20143, 33.65965], [-117.20138, 33.65968], [-117.20135, 33.65973], [-117.20134, 33.65978], [-117.20136, 33.65984], [-117.20125, 33.6599], [-117.20126, 33.66018], [-117.2015, 33.66018], [-117.20169, 33.66026], [-117.20192, 33.66029], [-117.20226, 33.66029], [-117.20232, 33.66025], [-117.20237, 33.66029], [-117.20245, 33.66031], [-117.20256, 33.66027], [-117.20261, 33.66031], [-117.20297, 33.66035], [-117.20341, 33.66029], [-117.20345, 33.66024], [-117.20352, 33.66027], [-117.20358, 33.66027], [-117.20366, 33.66022], [-117.20372, 33.66026], [-117.20406, 33.66026], [-117.20406, 33.66004], [-117.2044, 33.66004]]]} | Open Access 1 | 48507 | Hidden Hills Park | 33218 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1707 | Menifee, City of 655 | City 2 | City Agency 2 | https://www.cityofmenifee.us/285/Parks | Riverside 10 | 9.645 | Hidden Hills Park | 2019 | Local Park 2 | 4 |
10074 | 10074 | 10073 | {"type": "Polygon", "coordinates": [[[-121.26493, 38.83074], [-121.26429, 38.83085], [-121.26318, 38.83041], [-121.26364, 38.82968], [-121.26371, 38.82953], [-121.26376, 38.8292], [-121.26378, 38.82917], [-121.26384, 38.82915], [-121.26484, 38.82927], [-121.2648, 38.82959], [-121.2648, 38.83], [-121.26485, 38.8304], [-121.26493, 38.83074]]]} | Open Access 1 | 49036 | Willard Park | 33743 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 4.813 | Willard Park | 2019 | Local Park 2 | 4 | |
11073 | 11073 | 11072 | {"type": "Polygon", "coordinates": [[[-121.49612, 38.47412], [-121.4957, 38.47412], [-121.49569, 38.47406], [-121.49534, 38.47406], [-121.49534, 38.47373], [-121.49529, 38.47367], [-121.49522, 38.47363], [-121.49445, 38.47365], [-121.4944, 38.47363], [-121.49437, 38.47359], [-121.49437, 38.47308], [-121.49435, 38.47289], [-121.49436, 38.47286], [-121.49441, 38.47283], [-121.49467, 38.47279], [-121.49482, 38.47279], [-121.49491, 38.47272], [-121.49494, 38.47263], [-121.49518, 38.47266], [-121.49612, 38.47412]]]} | Open Access 1 | 21274 | LaVar Burton Park | 33228 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/South-Sacramento/LeVar-Burton-Park | Sacramento 41 | 3.151 | LaVar Burton Park | 2019 | Local Park 2 | 4 |
11120 | 11120 | 11119 | {"type": "Polygon", "coordinates": [[[-117.86456, 33.73363], [-117.86494, 33.7337], [-117.865, 33.73375], [-117.86499, 33.73389], [-117.86456, 33.7339], [-117.86456, 33.73403], [-117.86354, 33.73405], [-117.86354, 33.73356], [-117.86456, 33.73363]]]} | Open Access 1 | 48687 | Pacific Electric Park | 33426 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | http://www.santa-ana.org/parks/ | City 2 | 1316 | Santa Ana, City of 19 | City 2 | City Agency 2 | https://www.santa-ana.org/parks/parks-location/pacific-electric | Orange 3 | 1.404 | Pacific Electric Park | 2019 | Local Park 2 | 4 |
11464 | 11464 | 11463 | {"type": "Polygon", "coordinates": [[[-119.22071, 35.67312], [-119.22071, 35.67438], [-119.21686, 35.67441], [-119.21687, 35.67315], [-119.22071, 35.67312]]]} | Open Access 1 | 48174 | Jim White "Blanco" Park | 32709 | 1691 | McFarland, City of 981 | City 2 | City Agency 2 | http://www.mcfarlandcity.org/194/Parks-Recreation | City 2 | 1691 | McFarland, City of 944 | City 2 | City Agency 2 | https://www.mcfarlandcity.org/194/Parks-Recreation | Kern 36 | 11.997 | Jim White "Blanco" Park | 2019 | 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]);