units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
663 rows where DES_TP = 14 and MNG_AG_TYP = 2 sorted by rowid descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Ventura, City of 106
- Roseville, City of 45
- Poway, City of 34
- Irvine, City of 29
- California City, City of 25
- Los Angeles, City of 22
- Encinitas, City of 21
- Napa, City of 19
- Seaside, City of 16
- Rocklin, City of 16
- San Diego, City of 15
- Lompoc, City of 14
- Santa Cruz, City of 12
- Oroville, City of 12
- Santa Barbara, City of 11
- Mammoth Lakes, Town of 11
- Auburn, City of 11
- Guadalupe, City of 10
- Escondido, City of 9
- Santa Maria, City of 8
- Scotts Valley, City of 7
- Torrance, City of 7
- San Luis Obispo, City of 6
- Los Angeles - Department of Water and Power, City of 6
- Salinas, City of 5
- Stockton, City of 5
- Watsonville, City of 4
- Anaheim, City of 4
- San Marcos, City of 4
- Marina, City of 4
- …
ACCESS_TYP 4
- Open Access 564
- No Public Access 57
- Unknown Access 16
- Restricted Access 6
MNG_AG_TYP 1
- City Agency · 643 ✖
DES_TP 1
- Local Other or Unknown · 643 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13988 | 13988 | 13987 | {"type": "Polygon", "coordinates": [[[-119.17705, 34.27796], [-119.17699, 34.27793], [-119.17693, 34.27794], [-119.17623, 34.27829], [-119.17578, 34.27854], [-119.17577, 34.27853], [-119.17622, 34.27828], [-119.17693, 34.27792], [-119.177, 34.27792], [-119.17705, 34.27796]]]} | Open Access 1 | 36671 | Ventura holding 115 | 26869 | 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.051 | Ventura holding 115 | 0 | Local Other or Unknown 14 | 4 | |
13987 | 13987 | 13986 | {"type": "Polygon", "coordinates": [[[-117.77229, 35.1638], [-117.77201, 35.16434], [-117.77031, 35.16558], [-117.76994, 35.16597], [-117.76939, 35.167], [-117.76933, 35.16753], [-117.76956, 35.16838], [-117.76975, 35.16886], [-117.76969, 35.16945], [-117.76955, 35.16976], [-117.76951, 35.16914], [-117.76942, 35.16875], [-117.76841, 35.16875], [-117.7684, 35.16826], [-117.76877, 35.1674], [-117.76886, 35.16681], [-117.76891, 35.16627], [-117.76909, 35.16595], [-117.76953, 35.1653], [-117.76956, 35.16465], [-117.76953, 35.16448], [-117.77127, 35.16445], [-117.77162, 35.1644], [-117.77164, 35.16403], [-117.77151, 35.1636], [-117.76951, 35.16363], [-117.76956, 35.16306], [-117.77214, 35.16304], [-117.77216, 35.16319], [-117.77225, 35.16349], [-117.77229, 35.1638]]]} | Open Access 1 | 36670 | California City holding 10 | 16690 | 1041 | California City, City of 482 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1041 | California City, City of 474 | City 2 | City Agency 2 | Kern 36 | 16.43 | California City holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13984 | 13984 | 13983 | {"type": "Polygon", "coordinates": [[[-121.99423, 37.05383], [-121.99408, 37.05456], [-121.99386, 37.05528], [-121.99284, 37.05628], [-121.99279, 37.05727], [-121.99213, 37.05728], [-121.99209, 37.05371], [-121.99423, 37.05383]]]} | Open Access 1 | 36665 | Scotts Valley holding 6 | 25212 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 11.96 | Scotts Valley holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13982 | 13982 | 13981 | {"type": "Polygon", "coordinates": [[[-121.82236, 38.44685], [-121.82236, 38.44746], [-121.82165, 38.44744], [-121.82164, 38.44684], [-121.82236, 38.44685]]]} | Open Access 1 | 36652 | Dixon holding 1 | 18172 | 1087 | Dixon, City of 426 | City 2 | City Agency 2 | http://www.ci.dixon.ca.us/ | City 2 | 1087 | Dixon, City of 420 | City 2 | City Agency 2 | Solano 26 | 1.036 | Dixon holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13981 | 13981 | 13980 | {"type": "Polygon", "coordinates": [[[-118.37443, 33.82141], [-118.37442, 33.82234], [-118.37432, 33.82233], [-118.37398, 33.82192], [-118.37365, 33.822], [-118.37358, 33.82193], [-118.37359, 33.82188], [-118.37374, 33.82172], [-118.374, 33.82188], [-118.37443, 33.82141]]]} | No Public Access 3 | 36651 | Torrance holding 11 | 26417 | 1349 | Torrance, City of 292 | City 2 | City Agency 2 | http://www.torranceca.gov/ | City 2 | 1349 | Torrance, City of 288 | City 2 | City Agency 2 | Los Angeles 6 | 0.738 | Torrance holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13978 | 13978 | 13977 | {"type": "Polygon", "coordinates": [[[-119.16687, 34.2964], [-119.16665, 34.29659], [-119.1664, 34.29639], [-119.16607, 34.29624], [-119.16634, 34.29607], [-119.16687, 34.2964]]]} | Open Access 1 | 36645 | Ventura holding 4 | 26918 | 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.422 | Ventura holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13977 | 13977 | 13976 | {"type": "Polygon", "coordinates": [[[-121.38992, 38.04625], [-121.3899, 38.04627], [-121.38944, 38.04634], [-121.38941, 38.04632], [-121.38933, 38.04599], [-121.38933, 38.04586], [-121.38935, 38.04585], [-121.38971, 38.04588], [-121.38992, 38.04625]]]} | Open Access 1 | 36644 | Stockton holding 4 | 25861 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 0.498 | Stockton holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13976 | 13976 | 13975 | {"type": "Polygon", "coordinates": [[[-121.38323, 38.04933], [-121.38318, 38.0494], [-121.3823, 38.04957], [-121.38221, 38.04953], [-121.382, 38.04884], [-121.38205, 38.04877], [-121.38293, 38.0486], [-121.38301, 38.04864], [-121.38323, 38.04933]]]} | Open Access 1 | 36643 | Stockton holding 5 | 25862 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.047 | Stockton holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13975 | 13975 | 13974 | {"type": "Polygon", "coordinates": [[[-121.3818, 38.05196], [-121.38173, 38.05202], [-121.38083, 38.05202], [-121.38076, 38.05197], [-121.38075, 38.05126], [-121.38082, 38.0512], [-121.38173, 38.0512], [-121.3818, 38.05125], [-121.3818, 38.05196]]]} | Open Access 1 | 36642 | Stockton holding 3 | 25860 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 2.046 | Stockton holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13974 | 13974 | 13973 | {"type": "Polygon", "coordinates": [[[-121.39101, 38.04978], [-121.39099, 38.0498], [-121.3903, 38.04991], [-121.39027, 38.04989], [-121.39015, 38.04943], [-121.39083, 38.04932], [-121.39101, 38.04978]]]} | Open Access 1 | 36641 | Stockton holding 2 | 25859 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 0.86 | Stockton holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13973 | 13973 | 13972 | {"type": "Polygon", "coordinates": [[[-121.38181, 38.05445], [-121.38174, 38.05451], [-121.38084, 38.05451], [-121.38077, 38.05445], [-121.38077, 38.05333], [-121.38083, 38.05327], [-121.38174, 38.05327], [-121.38181, 38.05333], [-121.38181, 38.05445]]]} | Open Access 1 | 36640 | Stockton holding 1 | 25858 | 1343 | Stockton, City of 402 | City 2 | City Agency 2 | http://www.stocktongov.com/services/parkRec/default.html | City 2 | 1343 | Stockton, City of 396 | City 2 | City Agency 2 | San Joaquin 39 | 3.08 | Stockton holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13972 | 13972 | 13971 | {"type": "Polygon", "coordinates": [[[-121.67307, 37.12075], [-121.67269, 37.1219], [-121.6661, 37.12198], [-121.6661, 37.12148], [-121.6667, 37.12121], [-121.66665, 37.121], [-121.66732, 37.12079], [-121.66731, 37.12073], [-121.66735, 37.12071], [-121.66764, 37.12123], [-121.668, 37.12105], [-121.66799, 37.12067], [-121.66792, 37.12032], [-121.66765, 37.12036], [-121.66754, 37.12016], [-121.66758, 37.11983], [-121.66702, 37.11999], [-121.66738, 37.11973], [-121.6674, 37.11966], [-121.66739, 37.1196], [-121.66736, 37.11954], [-121.66718, 37.11941], [-121.66712, 37.11933], [-121.66708, 37.11924], [-121.66701, 37.11929], [-121.66667, 37.11941], [-121.66669, 37.11947], [-121.66618, 37.11962], [-121.6658, 37.11892], [-121.66479, 37.1192], [-121.66477, 37.11877], [-121.66592, 37.11804], [-121.66555, 37.11732], [-121.67204, 37.11703], [-121.67277, 37.11831], [-121.67106, 37.11883], [-121.67307, 37.12075]], [[-121.66687, 37.11787], [-121.66668, 37.11788], [-121.66652, 37.1179], [-121.66627, 37.11813], [-121.66658, 37.1186], [-121.66791, 37.1186], [-121.66768, 37.11842], [-121.6675, 37.11814], [-121.66734, 37.11795], [-121.66723, 37.11788], [-121.66687, 37.11787]]]} | Open Access 1 | 36639 | Morgan Hill holding 4 | 22483 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 67.307 | Morgan Hill holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13971 | 13971 | 13970 | {"type": "Polygon", "coordinates": [[[-121.64923, 37.11735], [-121.64827, 37.11568], [-121.64669, 37.11625], [-121.64579, 37.11463], [-121.64632, 37.11444], [-121.64626, 37.11431], [-121.64731, 37.11393], [-121.64642, 37.11231], [-121.64774, 37.11159], [-121.65067, 37.11677], [-121.65066, 37.11682], [-121.65062, 37.11685], [-121.64923, 37.11735]]]} | Open Access 1 | 36638 | Morgan Hill holding 3 | 22482 | 1217 | Morgan Hill, City of 416 | City 2 | City Agency 2 | http://www.morgan-hill.ca.gov/index.aspx?nid=187 | City 2 | 1217 | Morgan Hill, City of 410 | City 2 | City Agency 2 | Santa Clara 19 | 29.883 | Morgan Hill holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13970 | 13970 | 13969 | {"type": "Polygon", "coordinates": [[[-122.04145, 37.38351], [-122.0413, 37.38395], [-122.04108, 37.38384], [-122.0407, 37.38374], [-122.04064, 37.38368], [-122.04074, 37.38335], [-122.04145, 37.38351]]]} | Open Access 1 | 36637 | Sunnyvale holding 1 | 26015 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 0.711 | Sunnyvale holding 1 | 1987 | Local Other or Unknown 14 | 4 | |
13969 | 13969 | 13968 | {"type": "Polygon", "coordinates": [[[-121.97688, 38.51984], [-121.97524, 38.52043], [-121.97486, 38.51977], [-121.97649, 38.51918], [-121.97669, 38.51951], [-121.97633, 38.51964], [-121.97632, 38.51966], [-121.97635, 38.51968], [-121.97671, 38.51955], [-121.97688, 38.51984]]]} | Open Access 1 | 36635 | Winters holding 1 | 27655 | 1675 | Winters, City of 581 | City 2 | City Agency 2 | http://www.cityofwinters.org/recreation/recreation_gen.htm | City 2 | 1675 | Winters, City of 573 | City 2 | City Agency 2 | Yolo 33 | 3.09 | Winters holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13968 | 13968 | 13967 | {"type": "Polygon", "coordinates": [[[-124.15321, 41.05423], [-124.15271, 41.05488], [-124.15229, 41.05661], [-124.15206, 41.05669], [-124.15203, 41.05709], [-124.14985, 41.05669], [-124.14873, 41.05627], [-124.14866, 41.05582], [-124.14772, 41.05465], [-124.14731, 41.05383], [-124.14725, 41.05301], [-124.14791, 41.0522], [-124.14977, 41.0522], [-124.15099, 41.05294], [-124.15272, 41.05295], [-124.15297, 41.05333], [-124.1532, 41.05337], [-124.15321, 41.05423]], [[-124.15021, 41.05434], [-124.15022, 41.05435], [-124.15082, 41.05449], [-124.15108, 41.05383], [-124.15048, 41.05369], [-124.15021, 41.05434]]]} | Open Access 1 | 36634 | Trinidad holding 1 | 26538 | 1664 | Trinidad, City of 718 | City 2 | City Agency 2 | http://www.trinidad.ca.gov/ | City 2 | 1664 | Trinidad, City of 701 | City 2 | City Agency 2 | Humboldt 45 | 45.982 | Trinidad holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13967 | 13967 | 13966 | {"type": "Polygon", "coordinates": [[[-118.43001, 35.11787], [-118.43, 35.11814], [-118.42927, 35.11814], [-118.42927, 35.11787], [-118.42934, 35.11781], [-118.42994, 35.11782], [-118.43001, 35.11787]]]} | Open Access 1 | 36633 | Tehachapi holding 1 | 26217 | 1467 | Tehachapi, City of 310 | City 2 | City Agency 2 | http://www.tehachapicityhall.com/ | City 2 | 1467 | Tehachapi, City of 307 | City 2 | City Agency 2 | Kern 36 | 0.591 | Tehachapi holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13965 | 13965 | 13964 | {"type": "Polygon", "coordinates": [[[-121.77936, 38.67377], [-121.77932, 38.67379], [-121.77838, 38.67379], [-121.77836, 38.67377], [-121.77838, 38.67215], [-121.77934, 38.67215], [-121.77937, 38.67216], [-121.77936, 38.67377]]]} | Open Access 1 | 36630 | Woodland holding 1 | 27720 | 1665 | Woodland, City of 547 | City 2 | City Agency 2 | http://www.cityofwoodland.org/gov/depts/communityserv/parks/default.asp | City 2 | 1665 | Woodland, City of 540 | City 2 | City Agency 2 | Yolo 33 | 3.889 | Woodland holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13955 | 13955 | 13954 | {"type": "Polygon", "coordinates": [[[-118.31888, 33.7978], [-118.31888, 33.79814], [-118.31867, 33.79814], [-118.31868, 33.79781], [-118.31888, 33.7978]]]} | Open Access 1 | 36592 | Lomita holding 1 | 21413 | 1182 | Lomita, City of 461 | City 2 | City Agency 2 | http://www.lomita.com/cityhall/government/parksrec/index.cfm | City 2 | 1182 | Lomita, City of 454 | City 2 | City Agency 2 | Los Angeles 6 | 0.174 | Lomita holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13953 | 13953 | 13952 | {"type": "Polygon", "coordinates": [[[-117.01467, 32.96351], [-117.01068, 32.96361], [-117.01063, 32.96125], [-117.01119, 32.96125], [-117.01145, 32.96129], [-117.01165, 32.96145], [-117.012, 32.96202], [-117.01304, 32.96183], [-117.01339, 32.96141], [-117.01338, 32.96072], [-117.01418, 32.96145], [-117.01434, 32.96161], [-117.01464, 32.96196], [-117.01467, 32.96351]]]} | Open Access 1 | 36589 | Poway holding 36 | 23961 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | San Diego 4 | 20.871 | Poway holding 36 | 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]);