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 COUNTY
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_TYP, PARK_URL, YR_EST
MNG_AGENCY >30
- Ventura, City of 106
- Roseville, City of 46
- Poway, City of 35
- Irvine, City of 29
- Los Angeles, City of 26
- California City, City of 25
- Encinitas, City of 21
- Napa, City of 21
- Rocklin, City of 17
- Seaside, 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
- Santa Maria, City of 9
- Escondido, City of 9
- Watsonville, City of 7
- 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
- Anaheim, City of 5
- Stockton, City of 5
- San Marcos, City of 4
- Marina, City of 4
- …
ACCESS_TYP 4
- Open Access 581
- No Public Access 60
- Unknown Access 16
- Restricted Access 6
AGNCY_LEV 3 ✖
- City 661
- Special District 1
- Private 1
MNG_AG_TYP 1
- City Agency · 663 ✖
DES_TP 1
- Local Other or Unknown · 663 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4580 | 4580 | 4579 | {"type": "Polygon", "coordinates": [[[-120.65368, 35.25981], [-120.65355, 35.25973], [-120.65336, 35.25938], [-120.65327, 35.25852], [-120.65304, 35.25837], [-120.65297, 35.25826], [-120.65294, 35.25809], [-120.653, 35.2577], [-120.65339, 35.25769], [-120.65368, 35.25981]]]} | Open Access 1 | 35313 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 1.637 | 0 | Local Other or Unknown 14 | 4 | ||
4581 | 4581 | 4580 | {"type": "Polygon", "coordinates": [[[-120.68305, 35.25007], [-120.68298, 35.25011], [-120.68277, 35.25009], [-120.68274, 35.25012], [-120.68269, 35.25007], [-120.68285, 35.24982], [-120.68305, 35.25007]]]} | Open Access 1 | 35336 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.137 | 0 | Local Other or Unknown 14 | 4 | ||
4656 | 4656 | 4655 | {"type": "Polygon", "coordinates": [[[-120.65374, 35.27663], [-120.65364, 35.27676], [-120.65352, 35.27662], [-120.65365, 35.27654], [-120.65374, 35.27663]]]} | Open Access 1 | 36580 | Unnamed site - San Luis Obispo, City of | 28661 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 0.06 | 0 | Local Other or Unknown 14 | 4 | ||
4802 | 4802 | 4801 | {"type": "Polygon", "coordinates": [[[-120.66013, 35.63128], [-120.65942, 35.63268], [-120.65926, 35.63296], [-120.65904, 35.63322], [-120.65859, 35.63364], [-120.65798, 35.63378], [-120.6577, 35.63328], [-120.65709, 35.63251], [-120.65635, 35.63171], [-120.65613, 35.63141], [-120.656, 35.63112], [-120.65584, 35.6307], [-120.65575, 35.63011], [-120.65576, 35.62995], [-120.65587, 35.62993], [-120.65595, 35.62995], [-120.65595, 35.63027], [-120.65598, 35.63049], [-120.65603, 35.63073], [-120.6561, 35.63095], [-120.6562, 35.63117], [-120.65643, 35.63159], [-120.65674, 35.63195], [-120.65711, 35.63228], [-120.65757, 35.63281], [-120.65772, 35.63301], [-120.65818, 35.63275], [-120.65829, 35.63277], [-120.65841, 35.63275], [-120.65885, 35.63303], [-120.659, 35.63286], [-120.65945, 35.6323], [-120.66004, 35.63116], [-120.66012, 35.63122], [-120.66013, 35.63128]]]} | Open Access 1 | 48594 | Unknown park - Paso Robles, City of | 33303 | 1247 | Paso Robles, City of 118 | City 2 | City Agency 2 | http://www.prcity.com/government/departments/recreation/facilities/index.asp | City 2 | 1247 | Paso Robles, City of 115 | City 2 | City Agency 2 | San Luis Obispo 1 | 4.795 | 0 | Local Other or Unknown 14 | 4 | ||
5516 | 5516 | 5515 | {"type": "MultiPolygon", "coordinates": [[[[-120.69549, 35.26127], [-120.69548, 35.26128], [-120.69541, 35.26128], [-120.69525, 35.26141], [-120.69521, 35.26138], [-120.69516, 35.26142], [-120.69512, 35.26139], [-120.69469, 35.26174], [-120.69444, 35.2619], [-120.69428, 35.26211], [-120.69453, 35.26232], [-120.69428, 35.26244], [-120.69411, 35.2625], [-120.69402, 35.26226], [-120.69374, 35.26222], [-120.69335, 35.26231], [-120.69301, 35.26246], [-120.6928, 35.26259], [-120.69256, 35.2624], [-120.6928, 35.26223], [-120.6933, 35.26193], [-120.69392, 35.26169], [-120.69501, 35.26115], [-120.69505, 35.2609], [-120.69549, 35.26127]]], [[[-120.70148, 35.25778], [-120.70136, 35.25781], [-120.70118, 35.25801], [-120.7008, 35.25828], [-120.70044, 35.25829], [-120.69958, 35.25844], [-120.69948, 35.2583], [-120.69956, 35.2583], [-120.69968, 35.25822], [-120.69974, 35.25827], [-120.70009, 35.25821], [-120.70024, 35.25809], [-120.70039, 35.25812], [-120.70056, 35.25786], [-120.7006, 35.25786], [-120.70047, 35.25809], [-120.70048, 35.25812], [-120.7008, 35.25812], [-120.70097, 35.25799], [-120.70118, 35.25774], [-120.70127, 35.25768], [-120.70133, 35.25754], [-120.70146, 35.25757], [-120.70144, 35.25765], [-120.70148, 35.25778]]]]} | Open Access 1 | 18808 | Prefumo Creek | 23980 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 4.164 | Prefumo Creek | 0 | Local Other or Unknown 14 | 4 | |
13335 | 13335 | 13334 | {"type": "Polygon", "coordinates": [[[-120.67302, 35.2668], [-120.67283, 35.26847], [-120.6727, 35.26922], [-120.67258, 35.26972], [-120.67213, 35.26967], [-120.67165, 35.26873], [-120.6726, 35.26791], [-120.67217, 35.26714], [-120.67277, 35.26669], [-120.67286, 35.26668], [-120.67294, 35.2667], [-120.67299, 35.26674], [-120.67302, 35.2668]]]} | Open Access 1 | 35412 | San Luis Obispo holding 1 | 24934 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 5.051 | San Luis Obispo holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13894 | 13894 | 13893 | {"type": "Polygon", "coordinates": [[[-120.63621, 35.2961], [-120.63574, 35.29718], [-120.63513, 35.29735], [-120.63415, 35.29709], [-120.63289, 35.29573], [-120.63328, 35.29565], [-120.6337, 35.2956], [-120.63476, 35.29554], [-120.63607, 35.29587], [-120.63621, 35.2961]]]} | Open Access 1 | 36499 | San Luis Obispo holding 6 | 24935 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | http://www.slocity.org/parksandrecreation/index.asp | City 2 | 1307 | San Luis Obispo, City of 22 | City 2 | City Agency 2 | San Luis Obispo 1 | 9.747 | San Luis Obispo holding 6 | 0 | Local Other or Unknown 14 | 4 | |
4376 | 4376 | 4375 | {"type": "Polygon", "coordinates": [[[-121.1454, 37.46398], [-121.14539, 37.46422], [-121.14474, 37.46421], [-121.14469, 37.46417], [-121.14469, 37.46347], [-121.1453, 37.46348], [-121.14529, 37.46374], [-121.14524, 37.46379], [-121.14522, 37.46387], [-121.14527, 37.46394], [-121.14534, 37.46398], [-121.1454, 37.46398]]]} | Open Access 1 | 48546 | Unknown Park - Patterson, City of | 33386 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 1.121 | 0 | Local Other or Unknown 14 | 4 | ||
13763 | 13763 | 13762 | {"type": "Polygon", "coordinates": [[[-120.97866, 37.6451], [-120.97872, 37.64511], [-120.97873, 37.64514], [-120.97872, 37.64516], [-120.97864, 37.64523], [-120.97846, 37.64535], [-120.97815, 37.64548], [-120.97793, 37.64552], [-120.97788, 37.6455], [-120.97788, 37.64545], [-120.97793, 37.64541], [-120.97866, 37.6451]]]} | Open Access 1 | 36284 | Modesto holding 2 | 22338 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.29 | Modesto holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13764 | 13764 | 13763 | {"type": "Polygon", "coordinates": [[[-120.9913, 37.64285], [-120.99095, 37.64312], [-120.99036, 37.64263], [-120.99071, 37.64236], [-120.9913, 37.64285]]]} | Open Access 1 | 36285 | Modesto holding 1 | 22337 | 1208 | Modesto, City of 517 | City 2 | City Agency 2 | http://www.modestogov.com/prnd/ | City 2 | 1208 | Modesto, City of 510 | City 2 | City Agency 2 | Stanislaus 2 | 0.794 | Modesto holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13776 | 13776 | 13775 | {"type": "Polygon", "coordinates": [[[-121.15526, 37.46194], [-121.15507, 37.46228], [-121.15456, 37.46207], [-121.15465, 37.46189], [-121.15464, 37.46185], [-121.15461, 37.46182], [-121.15454, 37.46182], [-121.15434, 37.46192], [-121.15427, 37.46191], [-121.15422, 37.46189], [-121.15457, 37.46164], [-121.1549, 37.4618], [-121.15526, 37.46194]]]} | Open Access 1 | 36322 | Patterson holding 1 | 23519 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | http://www.ci.patterson.ca.us/ | City 2 | 1248 | Patterson, City of 10 | City 2 | City Agency 2 | Stanislaus 2 | 0.674 | Patterson holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13780 | 13780 | 13779 | {"type": "Polygon", "coordinates": [[[-121.02895, 37.31704], [-121.02791, 37.31731], [-121.02765, 37.31665], [-121.02793, 37.31658], [-121.02778, 37.31619], [-121.02855, 37.316], [-121.02895, 37.31704]]]} | Open Access 1 | 36327 | Newman holding 1 | 22729 | 1223 | Newman, City of 527 | City 2 | City Agency 2 | http://www.cityofnewman.com/ | City 2 | 1223 | Newman, City of 519 | City 2 | City Agency 2 | Stanislaus 2 | 2.641 | Newman holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13783 | 13783 | 13782 | {"type": "Polygon", "coordinates": [[[-120.86505, 37.75339], [-120.86502, 37.75345], [-120.86242, 37.75402], [-120.86235, 37.75399], [-120.8622, 37.75369], [-120.86223, 37.75363], [-120.86306, 37.75346], [-120.86339, 37.75335], [-120.86362, 37.75324], [-120.86446, 37.7527], [-120.86456, 37.75272], [-120.86505, 37.75339]]]} | Open Access 1 | 36339 | Oakdale holding 1 | 23024 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | http://www.oakdalegov.com/#!recreation/c222d | City 2 | 1227 | Oakdale, City of 2 | City 2 | City Agency 2 | Stanislaus 2 | 3.574 | Oakdale holding 1 | 0 | Local Other or Unknown 14 | 4 | |
2953 | 2953 | 2952 | {"type": "Polygon", "coordinates": [[[-117.88143, 33.70905], [-117.8815, 33.70906], [-117.88153, 33.70911], [-117.88152, 33.70962], [-117.88149, 33.70965], [-117.87994, 33.70965], [-117.88027, 33.70954], [-117.88143, 33.70905]]]} | Open Access 1 | 20418 | Segerstrom Triangle | 25286 | 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 | Orange 3 | 1.234 | Segerstrom Triangle | 0 | Local Other or Unknown 14 | 4 | |
3560 | 3560 | 3559 | {"type": "Polygon", "coordinates": [[[-117.97816, 33.85487], [-117.97665, 33.85405], [-117.97656, 33.85345], [-117.97814, 33.85344], [-117.97816, 33.85487]]]} | Open Access 1 | 36526 | Anaheim holding 3 | 15468 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 3.956 | Anaheim holding 3 | 0 | Local Other or Unknown 14 | 4 | |
4783 | 4783 | 4782 | {"type": "Polygon", "coordinates": [[[-117.79446, 33.8233], [-117.7936, 33.82387], [-117.79307, 33.82417], [-117.79173, 33.82406], [-117.79024, 33.82475], [-117.78846, 33.82477], [-117.78746, 33.82377], [-117.78764, 33.82361], [-117.7879, 33.82307], [-117.78779, 33.82268], [-117.78789, 33.82253], [-117.78847, 33.82231], [-117.7888, 33.82226], [-117.79011, 33.82225], [-117.79095, 33.82214], [-117.79122, 33.82312], [-117.79446, 33.8233]]]} | Open Access 1 | 47428 | Unnamed site - City of Orange | 31145 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | Orange 3 | 26.593 | 0 | Local Other or Unknown 14 | 4 | ||
4813 | 4813 | 4812 | {"type": "MultiPolygon", "coordinates": [[[[-117.91074, 33.8344], [-117.9097, 33.83464], [-117.90958, 33.83429], [-117.91063, 33.83404], [-117.91074, 33.8344]]], [[[-117.91175, 33.83527], [-117.91127, 33.83537], [-117.9112, 33.83526], [-117.91055, 33.83541], [-117.91028, 33.8346], [-117.9103, 33.83456], [-117.91076, 33.83445], [-117.9108, 33.83457], [-117.91083, 33.83459], [-117.91099, 33.8346], [-117.91111, 33.83496], [-117.91163, 33.83486], [-117.91175, 33.83527]]]]} | Open Access 1 | 48752 | Unknown Park - Anaheim, City of | 33479 | 1006 | Anaheim, City of 59 | City 2 | City Agency 2 | http://www.anaheim.net/comm_svc/parks/ | City 2 | 1006 | Anaheim, City of 57 | City 2 | City Agency 2 | Orange 3 | 3.033 | 0 | Local Other or Unknown 14 | 4 | ||
11976 | 11976 | 11975 | {"type": "Polygon", "coordinates": [[[-117.82251, 33.79145], [-117.82246, 33.79155], [-117.82231, 33.79174], [-117.8211, 33.79298], [-117.82087, 33.79328], [-117.82042, 33.7937], [-117.82014, 33.79351], [-117.81984, 33.79349], [-117.81974, 33.79342], [-117.8196, 33.79321], [-117.8195, 33.79314], [-117.81936, 33.79315], [-117.8192, 33.79332], [-117.8191, 33.79354], [-117.81888, 33.79357], [-117.8187, 33.7934], [-117.81849, 33.7934], [-117.8185, 33.7915], [-117.82251, 33.79145]]]} | Open Access 1 | 24606 | Grijalva Park at Santiago Creek | 19519 | 1233 | Orange, City of 306 | City 2 | City Agency 2 | http://www.cityoforange.org/ | City 2 | 1233 | Orange, City of 302 | City 2 | City Agency 2 | http://www.cityoforange.org/civicax/filebank/blobdload.aspx?BlobID=2445 | Orange 3 | 15.556 | Grijalva Park at Santiago Creek | 0 | Local Other or Unknown 14 | 4 |
12498 | 12498 | 12497 | {"type": "Polygon", "coordinates": [[[-117.7145, 33.62239], [-117.71426, 33.62257], [-117.71372, 33.62196], [-117.71285, 33.62261], [-117.71277, 33.62251], [-117.71271, 33.62237], [-117.71269, 33.62221], [-117.71271, 33.62208], [-117.71276, 33.62196], [-117.71287, 33.62183], [-117.71322, 33.62159], [-117.71326, 33.6215], [-117.71326, 33.6214], [-117.71319, 33.62132], [-117.71167, 33.6197], [-117.70952, 33.61734], [-117.70949, 33.61728], [-117.70951, 33.6172], [-117.70966, 33.61712], [-117.71251, 33.62021], [-117.71284, 33.62061], [-117.71319, 33.62099], [-117.71328, 33.62106], [-117.71339, 33.62129], [-117.71362, 33.62142], [-117.71374, 33.62152], [-117.71413, 33.62196], [-117.71412, 33.62198], [-117.7145, 33.62239]]]} | Open Access 1 | 36514 | Lake Forest holding 1 | 20889 | 1167 | Lake Forest, City of 235 | City 2 | City Agency 2 | http://www.lakeforestca.gov/depts/cs/city_parks/default.asp | City 2 | 1167 | Lake Forest, City of 231 | City 2 | City Agency 2 | Orange 3 | 6.308 | Lake Forest holding 1 | 0 | Local Other or Unknown 14 | 4 | |
12622 | 12622 | 12621 | {"type": "Polygon", "coordinates": [[[-117.77841, 33.67962], [-117.77312, 33.68506], [-117.77251, 33.68462], [-117.77792, 33.67926], [-117.77841, 33.67962]]]} | Open Access 1 | 35835 | Irvine holding 3 | 20260 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 12.992 | Irvine holding 3 | 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]);