units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where DES_TP = 14 and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
MNG_AGENCY 5
ACCESS_TYP 3
MNG_AG_TYP 1
- Recreation/Parks District · 8 ✖
DES_TP 1
- Local Other or Unknown · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8220 | 8220 | 8219 | {"type": "MultiPolygon", "coordinates": [[[[-121.67375, 37.19466], [-121.67332, 37.19501], [-121.6721, 37.19402], [-121.66931, 37.19621], [-121.66716, 37.19428], [-121.66577, 37.19395], [-121.66325, 37.19234], [-121.66291, 37.19106], [-121.65873, 37.18793], [-121.65677, 37.18978], [-121.65701, 37.18997], [-121.6572, 37.1902], [-121.65728, 37.19036], [-121.65744, 37.1908], [-121.65752, 37.19093], [-121.65768, 37.19109], [-121.65782, 37.19118], [-121.65797, 37.19124], [-121.65814, 37.19129], [-121.65831, 37.1913], [-121.65903, 37.1915], [-121.65932, 37.19154], [-121.65951, 37.19153], [-121.6597, 37.19149], [-121.65996, 37.1914], [-121.66012, 37.1913], [-121.66116, 37.19129], [-121.6613, 37.19151], [-121.66078, 37.1925], [-121.66037, 37.19312], [-121.65995, 37.19326], [-121.65974, 37.19354], [-121.65972, 37.19382], [-121.65989, 37.19421], [-121.6605, 37.19431], [-121.6609, 37.19442], [-121.66129, 37.19454], [-121.6617, 37.19489], [-121.662, 37.19498], [-121.66253, 37.19545], [-121.66294, 37.19584], [-121.66305, 37.19586], [-121.66327, 37.19587], [-121.66349, 37.19586], [-121.6638, 37.19579], [-121.66439, 37.19537], [-121.66444, 37.19523], [-121.66481, 37.19494], [-121.66497, 37.19493], [-121.66523, 37.19506], [-121.66593, 37.1955], [-121.66643, 37.19552], [-121.66731, 37.19526], [-121.66776, 37.19538], [-121.66841, 37.19586], [-121.66844, 37.19627], [-121.66918, 37.19753], [-121.6694, 37.19754], [-121.66957, 37.19745], [-121.66991, 37.19746], [-121.67042, 37.19752], [-121.67092, 37.19764], [-121.67147, 37.19794], [-121.67173, 37.19829], [-121.67164, 37.19869], [-121.67182, 37.19903], [-121.67264, 37.1994], [-121.67294, 37.19944], [-121.6729, 37.19964], [-121.67274, 37.2], [-121.67273, 37.20041], [-121.67311, 37.2009], [-121.67291, 37.20106], [-121.6719, 37.20147], [-121.67156, 37.2015], [-121.67086, 37.20186], [-121.67039, 37.20185], [-121.67037, 37.20194], [-121.67046, 37.20195], [-121.67045, 37.20208], [-121.67064, 37.20215], [-121.6721, 37.20242], [-121.67219, 37.20247], [-121.67226, 37.20254], [-121.67229, 37.20263], [-121.6723, 37.20271], [-121.67076, 37.20315], [-121.67054, 37.20325], [-121.67028, 37.20347], [-121.67051, 37.20373], [-121.67054, 37.20382], [-121.6702, 37.20496], [-121.66781, 37.20618], [-121.66476, 37.20618], [-121.6638, 37.20497], [-121.66105, 37.20567], [-121.66095, 37.20549], [-121.65936, 37.20486], [-121.65888, 37.20465], [-121.65833, 37.20381], [-121.65789, 37.20355], [-121.65783, 37.20317], [-121.65723, 37.20271], [-121.65558, 37.20205], [-121.65509, 37.20198], [-121.65315, 37.20186], [-121.65243, 37.20147], [-121.65162, 37.20136], [-121.65087, 37.20155], [-121.6508, 37.20184], [-121.65101, 37.2022], [-121.65087, 37.20231], [-121.65047, 37.20198], [-121.65004, 37.20155], [-121.64942, 37.2015], [-121.64935, 37.20239], [-121.65039, 37.20416], [-121.65064, 37.20448], [-121.64971, 37.20385], [-121.64956, 37.20394], [-121.64947, 37.20448], [-121.64968, 37.20529], [-121.64911, 37.20421], [-121.64921, 37.2034], [-121.64911, 37.20312], [-121.64884, 37.20299], [-121.64858, 37.20242], [-121.64845, 37.20157], [-121.64816, 37.20148], [-121.64781, 37.20164], [-121.64757, 37.20189], [-121.64736, 37.20206], [-121.64705, 37.20252], [-121.64665, 37.20358], [-121.64617, 37.20431], [-121.64539, 37.20467], [-121.64594, 37.20319], [-121.64673, 37.20119], [-121.64707, 37.20093], [-121.64721, 37.20057], [-121.64569, 37.20077], [-121.64536, 37.20098], [-121.64461, 37.20026], [-121.64537, 37.20036], [-121.64596, 37.2003], [-121.64698, 37.20009], [-121.64725, 37.19995], [-121.64693, 37.19888], [-121.64662, 37.19767], [-121.64676, 37.19726], [-121.64666, 37.19657], [-121.64633, 37.19607], [-121.64615, 37.19585], [-121.64556, 37.19615], [-121.64435, 37.19653], [-121.6442, 37.19712], [-121.64375, 37.19745], [-121.6435, 37.19724], [-121.64379, 37.19688], [-121.64391, 37.19609], [-121.64415, 37.19598], [-121.64442, 37.19578], [-121.64476, 37.19564], [-121.64514, 37.19536], [-121.64532, 37.19502], [-121.64544, 37.19438], [-121.64532, 37.19405], [-121.64513, 37.19384], [-121.64466, 37.19347], [-121.64426, 37.19335], [-121.64369, 37.19288], [-121.64316, 37.19251], [-121.6469, 37.19007], [-121.64731, 37.18986], [-121.64827, 37.19022], [-121.64888, 37.19041], [-121.64927, 37.19081], [-121.64959, 37.19108], [-121.64978, 37.19134], [-121.65018, 37.19125], [-121.6506, 37.19122], [-121.65101, 37.19125], [-121.65141, 37.19134], [-121.65167, 37.19144], [-121.6519, 37.19155], [-121.65338, 37.1925], [-121.65464, 37.18997], [-121.65256, 37.18777], [-121.6494, 37.18505], [-121.65302, 37.17121], [-121.65615, 37.17223], [-121.65621, 37.17216], [-121.65783, 37.17259], [-121.65882, 37.17264], [-121.65952, 37.17264], [-121.66124, 37.17269], [-121.65752, 37.17852], [-121.65647, 37.18174], [-121.65872, 37.18298], [-121.66133, 37.18434], [-121.66205, 37.18443], [-121.66306, 37.18517], [-121.6641, 37.1855], [-121.66506, 37.18668], [-121.66659, 37.1872], [-121.66687, 37.18756], [-121.66654, 37.18865], [-121.66646, 37.18927], [-121.66776, 37.1906], [-121.66918, 37.19163], [-121.67142, 37.19208], [-121.67375, 37.19466]]], [[[-121.68743, 37.19048], [-121.68638, 37.19073], [-121.68551, 37.19118], [-121.6846, 37.19161], [-121.68377, 37.19207], [-121.68286, 37.19246], [-121.68243, 37.19194], [-121.68333, 37.19155], [-121.68419, 37.19107], [-121.68506, 37.19067], [-121.68593, 37.1902], [-121.68702, 37.18995], [-121.68743, 37.19048]]]]} | No Public Access 3 | 47778 | Coyote Ridge Property | 31578 | 2143 | Santa Clara Valley Water District 483 | Special District 4 | Water District 13 | http://www.valleywater.org/ | Special District 4 | 2142 | Santa Clara Valley Open Space Authority 468 | Special District 4 | Recreation/Parks District 4 | Santa Clara 19 | 1178.052 | Coyote Ridge Property | 0 | Local Other or Unknown 14 | 4 | |
9081 | 9081 | 9080 | {"type": "Polygon", "coordinates": [[[-123.07275, 38.37014], [-123.07057, 38.37134], [-123.06942, 38.37164], [-123.0685, 38.37149], [-123.06748, 38.37154], [-123.06637, 38.37194], [-123.06309, 38.3645], [-123.06149, 38.36456], [-123.05809, 38.35921], [-123.05832, 38.35919], [-123.05836, 38.35916], [-123.0584, 38.35911], [-123.05846, 38.35892], [-123.05851, 38.35864], [-123.05854, 38.35835], [-123.05851, 38.35812], [-123.05851, 38.35799], [-123.05848, 38.35785], [-123.0583, 38.35731], [-123.05826, 38.35714], [-123.05826, 38.35705], [-123.05823, 38.35697], [-123.05822, 38.35682], [-123.05822, 38.35627], [-123.0582, 38.356], [-123.05824, 38.35569], [-123.05831, 38.35553], [-123.05838, 38.35543], [-123.05872, 38.35516], [-123.05927, 38.3549], [-123.05941, 38.35485], [-123.05994, 38.35473], [-123.06015, 38.35469], [-123.06041, 38.35468], [-123.06101, 38.35462], [-123.06128, 38.35457], [-123.06153, 38.35449], [-123.06171, 38.35435], [-123.06179, 38.35419], [-123.06177, 38.3541], [-123.06176, 38.35385], [-123.06179, 38.35378], [-123.06188, 38.35331], [-123.06184, 38.35315], [-123.06172, 38.35292], [-123.06172, 38.35287], [-123.06166, 38.35281], [-123.06163, 38.35274], [-123.06158, 38.35256], [-123.06249, 38.35334], [-123.06313, 38.35379], [-123.06445, 38.35463], [-123.06499, 38.35501], [-123.06561, 38.35547], [-123.0666, 38.35624], [-123.06683, 38.3565], [-123.06689, 38.35665], [-123.06694, 38.35688], [-123.06696, 38.35708], [-123.06696, 38.35747], [-123.06692, 38.3578], [-123.06695, 38.358], [-123.06706, 38.35821], [-123.0675, 38.35885], [-123.06775, 38.35926], [-123.06781, 38.35942], [-123.06797, 38.3601], [-123.06807, 38.36033], [-123.06817, 38.36051], [-123.06855, 38.361], [-123.06867, 38.36122], [-123.06873, 38.36144], [-123.06873, 38.36205], [-123.06878, 38.36226], [-123.06891, 38.36246], [-123.06962, 38.36317], [-123.06968, 38.36328], [-123.0698, 38.36358], [-123.06997, 38.36427], [-123.07005, 38.36441], [-123.07075, 38.36541], [-123.0715, 38.36668], [-123.07159, 38.36688], [-123.0717, 38.36731], [-123.07179, 38.36752], [-123.07194, 38.3677], [-123.07229, 38.36799], [-123.07245, 38.36823], [-123.07281, 38.3691], [-123.07287, 38.36927], [-123.07288, 38.36939], [-123.07287, 38.36952], [-123.07283, 38.3697], [-123.07275, 38.36998], [-123.07275, 38.37014]]]} | Restricted Access 2 | 15036 | Carrington Coast Ranch | 31268 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 329.459 | Carrington Coast Ranch | 2003 | Local Other or Unknown 14 | 4 | |
9628 | 9628 | 9627 | {"type": "Polygon", "coordinates": [[[-122.69582, 38.54625], [-122.69567, 38.54622], [-122.6949, 38.54581], [-122.69432, 38.54576], [-122.69338, 38.54514], [-122.69307, 38.54474], [-122.69284, 38.54396], [-122.69244, 38.5437], [-122.69183, 38.54277], [-122.69113, 38.54204], [-122.69108, 38.54018], [-122.69581, 38.54015], [-122.69582, 38.54625]]]} | No Public Access 3 | 47850 | Wendle Property | 31796 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 50.237 | Wendle Property | 2018 | Local Other or Unknown 14 | 4 | |
10163 | 10163 | 10162 | {"type": "MultiPolygon", "coordinates": [[[[-118.85683, 34.23954], [-118.8568, 34.23959], [-118.8567, 34.23938], [-118.8567, 34.23937], [-118.85683, 34.23954]]], [[[-118.85689, 34.23975], [-118.85688, 34.23975], [-118.85685, 34.23971], [-118.85689, 34.23975], [-118.85689, 34.23975]]], [[[-118.85275, 34.24064], [-118.85264, 34.24059], [-118.85237, 34.24061], [-118.85243, 34.24058], [-118.85242, 34.2406], [-118.85264, 34.24058], [-118.85275, 34.24064]]], [[[-118.85339, 34.24098], [-118.85317, 34.24081], [-118.85289, 34.2407], [-118.85298, 34.24071], [-118.85321, 34.24082], [-118.85339, 34.24098]]], [[[-118.8536, 34.2412], [-118.85343, 34.24101], [-118.85343, 34.24101], [-118.85345, 34.24102], [-118.8536, 34.2412]]], [[[-118.84856, 34.24296], [-118.84855, 34.24427], [-118.84855, 34.24422], [-118.84856, 34.24296]]], [[[-118.86424, 34.24569], [-118.86392, 34.24579], [-118.86363, 34.24573], [-118.86183, 34.24504], [-118.85908, 34.24514], [-118.85907, 34.24557], [-118.85582, 34.24601], [-118.85521, 34.24539], [-118.85472, 34.24505], [-118.85435, 34.2448], [-118.85356, 34.24447], [-118.85308, 34.24441], [-118.85229, 34.24447], [-118.85197, 34.24434], [-118.85209, 34.24376], [-118.85209, 34.2433], [-118.85238, 34.24315], [-118.85305, 34.24322], [-118.85335, 34.24361], [-118.85382, 34.24395], [-118.85445, 34.24414], [-118.85491, 34.24409], [-118.85552, 34.24377], [-118.85678, 34.24345], [-118.85787, 34.24342], [-118.85893, 34.24344], [-118.86001, 34.24322], [-118.86029, 34.24304], [-118.86109, 34.2424], [-118.86142, 34.24204], [-118.86166, 34.24164], [-118.86184, 34.24115], [-118.86212, 34.24004], [-118.86244, 34.23969], [-118.86267, 34.23997], [-118.86275, 34.24039], [-118.86274, 34.24099], [-118.86322, 34.24375], [-118.86361, 34.24494], [-118.86381, 34.24529], [-118.86424, 34.24569]]], [[[-118.85901, 34.24664], [-118.8583, 34.24676], [-118.8579, 34.24681], [-118.85901, 34.24664]]], [[[-118.85211, 34.24762], [-118.8504, 34.24762], [-118.85039, 34.24535], [-118.84855, 34.24563], [-118.85039, 34.24535], [-118.85042, 34.2476], [-118.85211, 34.24762]]]]} | Restricted Access 2 | 17736 | McCrea Ranch | 22015 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | http://www.crpd.org/ | Special District 4 | 2025 | Conejo Recreation and Park District 12 | Special District 4 | Recreation/Parks District 4 | Ventura 8 | 63.673 | McCrea Ranch | 0 | Local Other or Unknown 14 | 4 | |
15479 | 15479 | 15478 | {"type": "Polygon", "coordinates": [[[-121.72963, 36.78547], [-121.72962, 36.78553], [-121.72872, 36.78627], [-121.72865, 36.78628], [-121.72807, 36.78601], [-121.72823, 36.78577], [-121.72779, 36.78557], [-121.728, 36.78528], [-121.72812, 36.78532], [-121.72824, 36.78532], [-121.72835, 36.78529], [-121.72844, 36.78523], [-121.7285, 36.78514], [-121.72863, 36.7848], [-121.72871, 36.78483], [-121.72869, 36.78491], [-121.72871, 36.78496], [-121.72875, 36.785], [-121.72886, 36.78503], [-121.72899, 36.78498], [-121.72903, 36.78499], [-121.72935, 36.78519], [-121.72948, 36.7853], [-121.72963, 36.78547]]]} | Open Access 1 | 43075 | Unknown park - North County Recreation and Park District | 28650 | 2094 | North County Recreation and Park District 733 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.408 | 0 | Local Other or Unknown 14 | 4 | ||
15482 | 15482 | 15481 | {"type": "Polygon", "coordinates": [[[-121.85976, 36.9403], [-121.85956, 36.94034], [-121.85939, 36.94045], [-121.85932, 36.94046], [-121.85927, 36.94041], [-121.85927, 36.94028], [-121.85951, 36.94009], [-121.85976, 36.9403]]]} | Open Access 1 | 43081 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.222 | 0 | Local Other or Unknown 14 | 4 | ||
15483 | 15483 | 15482 | {"type": "Polygon", "coordinates": [[[-121.7569, 36.77289], [-121.75622, 36.77347], [-121.75458, 36.77228], [-121.75464, 36.77222], [-121.75547, 36.77222], [-121.75581, 36.77227], [-121.75598, 36.77233], [-121.75612, 36.77239], [-121.7569, 36.77289]]]} | Open Access 1 | 43083 | Unnamed site - North County Recreation and Park District | 28720 | 2094 | North County Recreation and Park District 733 | Special District 4 | Recreation/Parks District 4 | http://www.ncrpd.org | Special District 4 | 2094 | North County Recreation and Park District 717 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 3.303 | 0 | Local Other or Unknown 14 | 4 | ||
15485 | 15485 | 15484 | {"type": "Polygon", "coordinates": [[[-121.8621, 36.93337], [-121.86183, 36.93378], [-121.86183, 36.93423], [-121.86175, 36.93427], [-121.86176, 36.93376], [-121.86206, 36.93332], [-121.8621, 36.93337]]]} | Open Access 1 | 43087 | Unnamed site - La Selva Beach Recreation District | 28638 | 2056 | La Selva Beach Recreation District 772 | Special District 4 | Recreation/Parks District 4 | http://php.santacruzpl.org/cid/public/full.php?id=383 | Special District 4 | 2056 | La Selva Beach Recreation District 753 | Special District 4 | Recreation/Parks District 4 | Santa Cruz 5 | 0.166 | 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]);