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 sorted by MNG_AG_ID
This data as json, copyable, CSV (advanced)
MNG_AGENCY 6
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 | |
4687 | 4687 | 4686 | {"type": "Polygon", "coordinates": [[[-121.32025, 36.42989], [-121.32025, 36.43031], [-121.31912, 36.4303], [-121.31914, 36.42962], [-121.31995, 36.42962], [-121.31996, 36.42988], [-121.32025, 36.42989]]]} | Open Access 1 | 43092 | Unknown park - Soledad-Mission Recreation District | 28668 | 2154 | Soledad-Mission Recreation District 775 | Special District 4 | Recreation/Parks District 4 | http://www.soledad-mission-recreation-district.org/ | Special District 4 | 2154 | Soledad-Mission Recreation District 756 | Special District 4 | Recreation/Parks District 4 | Monterey 14 | 1.687 | 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 | |
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-118.35128, 33.78024], [-118.35122, 33.78036], [-118.35108, 33.78051], [-118.35086, 33.78065], [-118.35069, 33.7807], [-118.35057, 33.78035], [-118.35093, 33.78032], [-118.35092, 33.78], [-118.35108, 33.78], [-118.35119, 33.78003], [-118.35127, 33.78011], [-118.35128, 33.78024]]]} | Open Access 1 | 5914 | Unnamed site - Westfield Recreation and Park District | 28676 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.653 | 0 | Local Other or Unknown 14 | 4 | |||
4493 | 4493 | 4492 | {"type": "Polygon", "coordinates": [[[-118.36086, 33.76832], [-118.3608, 33.76862], [-118.36056, 33.76861], [-118.36041, 33.76865], [-118.36031, 33.76842], [-118.36043, 33.76817], [-118.36086, 33.76832]]]} | Open Access 1 | 5915 | Unknown park - Westfield Recreation and Park District | 28677 | 2180 | Westfield Recreation and Park District 769 | Special District 4 | Recreation/Parks District 4 | Special District 4 | 2180 | Westfield Recreation and Park District 750 | Special District 4 | Recreation/Parks District 4 | Los Angeles 6 | 0.462 | 0 | Local Other or Unknown 14 | 4 | |||
4800 | 4800 | 4799 | {"type": "Polygon", "coordinates": [[[-120.91362, 38.89783], [-120.91305, 38.89803], [-120.91312, 38.89817], [-120.91226, 38.89828], [-120.91215, 38.89848], [-120.91174, 38.89845], [-120.91132, 38.89844], [-120.91116, 38.89838], [-120.91124, 38.89813], [-120.91198, 38.89771], [-120.91213, 38.89791], [-120.91217, 38.89791], [-120.91219, 38.89797], [-120.91239, 38.89791], [-120.91242, 38.89803], [-120.91284, 38.89788], [-120.91293, 38.898], [-120.91358, 38.89777], [-120.91362, 38.89783]]]} | Open Access 1 | 48517 | Unnamed site - Georgetown Divide Recreation District | 33230 | 2223 | Georgetown Divide Recreation District 784 | Special District 4 | Recreation/Parks District 4 | http://www.gdrd.org/ | Special District 4 | 2223 | Georgetown Divide Recreation District 764 | Special District 4 | Recreation/Parks District 4 | El Dorado 34 | 1.949 | 0 | Local Other or Unknown 14 | 4 | ||
7798 | 7798 | 7797 | {"type": "Polygon", "coordinates": [[[-122.26488, 38.57654], [-122.26001, 38.57628], [-122.25998, 38.57271], [-122.2502, 38.57224], [-122.24999, 38.5757], [-122.24669, 38.57566], [-122.24449, 38.57208], [-122.24579, 38.57211], [-122.24589, 38.56866], [-122.24142, 38.56847], [-122.24147, 38.56167], [-122.2507, 38.56202], [-122.25035, 38.56881], [-122.25518, 38.569], [-122.25526, 38.5656], [-122.25995, 38.56577], [-122.25998, 38.56918], [-122.26488, 38.56972], [-122.26488, 38.57654]]]} | No Public Access 3 | 47669 | Swittle Creek | 31410 | 2268 | Napa County Regional Park and Open Space District 362 | Special District 4 | Recreation/Parks District 4 | http://napaoutdoors.org/ | Special District 4 | 2268 | Napa County Regional Park and Open Space District 108 | Special District 4 | Recreation/Parks District 4 | Napa 11 | 422.914 | Swittle Creek | 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]);