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
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Ventura, City of 101
- Roseville, City of 43
- Poway, City of 34
- Irvine, City of 29
- California City, City of 23
- Encinitas, City of 21
- Napa, City of 21
- Los Angeles, City of 18
- Rocklin, City of 17
- Seaside, City of 16
- San Diego, City of 13
- Lompoc, City of 13
- Santa Cruz, City of 12
- Auburn, City of 11
- Guadalupe, City of 10
- Mammoth Lakes, Town of 10
- Santa Barbara, City of 9
- Santa Maria, City of 9
- Oroville, City of 9
- Scotts Valley, City of 7
- Watsonville, City of 6
- San Luis Obispo, City of 6
- Salinas, City of 5
- Los Angeles - Department of Water and Power, City of 5
- Torrance, City of 5
- Stockton, City of 5
- Anaheim, City of 4
- Escondido, City of 4
- San Marcos, City of 4
- Marina, City of 4
- …
ACCESS_TYP 4
- Open Access 551
- No Public Access 47
- Unknown Access 12
- Restricted Access 5
MNG_AG_TYP 1
- City Agency · 615 ✖
DES_TP 1
- Local Other or Unknown · 615 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4499 | 4499 | 4498 | {"type": "MultiPolygon", "coordinates": [[[[-118.03255, 33.97371], [-118.03203, 33.9737], [-118.03203, 33.97351], [-118.03246, 33.97351], [-118.03249, 33.97355], [-118.03255, 33.97359], [-118.03255, 33.97371]]], [[[-118.03556, 33.97383], [-118.03511, 33.97384], [-118.0351, 33.9737], [-118.03556, 33.9737], [-118.03556, 33.97383]]], [[[-118.03609, 33.9737], [-118.03608, 33.97384], [-118.03563, 33.97384], [-118.03562, 33.97371], [-118.03609, 33.9737]]], [[[-118.03723, 33.98024], [-118.03676, 33.98024], [-118.03676, 33.98001], [-118.03723, 33.98002], [-118.03723, 33.98024]]], [[[-118.03912, 33.97384], [-118.03866, 33.97384], [-118.03865, 33.97371], [-118.03912, 33.97371], [-118.03912, 33.97384]]], [[[-118.03965, 33.97385], [-118.03919, 33.97384], [-118.03919, 33.97371], [-118.03965, 33.97371], [-118.03965, 33.97385]]], [[[-118.04028, 33.97371], [-118.04027, 33.97385], [-118.03981, 33.97384], [-118.03981, 33.97371], [-118.04028, 33.97371]]], [[[-118.0408, 33.97384], [-118.04035, 33.97385], [-118.04034, 33.97371], [-118.0408, 33.97371], [-118.0408, 33.97384]]], [[[-118.04143, 33.97385], [-118.04096, 33.97384], [-118.04097, 33.97371], [-118.04142, 33.97371], [-118.04143, 33.97385]]], [[[-118.04196, 33.97385], [-118.04149, 33.97385], [-118.04149, 33.97371], [-118.04196, 33.97371], [-118.04196, 33.97385]]], [[[-118.04312, 33.97387], [-118.04306, 33.97383], [-118.04264, 33.97382], [-118.04225, 33.97382], [-118.04219, 33.97387], [-118.04218, 33.97373], [-118.04223, 33.97369], [-118.04311, 33.97369], [-118.04312, 33.97387]]]]} | Open Access 1 | 6534 | Unnamed site - Whittier, City of | 29858 | 1380 | Whittier, City of 291 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | Los Angeles 6 | 2.108 | 0 | Local Other or Unknown 14 | 4 | ||
4500 | 4500 | 4499 | {"type": "Polygon", "coordinates": [[[-118.14894, 33.76065], [-118.14889, 33.76086], [-118.14849, 33.76069], [-118.14818, 33.7606], [-118.14798, 33.76055], [-118.14796, 33.76053], [-118.14796, 33.76047], [-118.14799, 33.76044], [-118.14804, 33.76043], [-118.14818, 33.76043], [-118.14894, 33.76065]]]} | Open Access 1 | 6605 | Unknown park - Long Beach, City of | 29921 | 1184 | Long Beach, City of 298 | City 2 | City Agency 2 | http://www.longbeach.gov/park/default.asp | City 2 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 0.432 | 0 | Local Other or Unknown 14 | 4 | ||
4530 | 4530 | 4529 | {"type": "MultiPolygon", "coordinates": [[[[-119.6514, 36.81889], [-119.65097, 36.81932], [-119.65097, 36.81957], [-119.65051, 36.81957], [-119.65033, 36.81959], [-119.65012, 36.8196], [-119.65006, 36.81956], [-119.65001, 36.8194], [-119.65, 36.81924], [-119.65003, 36.81904], [-119.65009, 36.81899], [-119.65035, 36.81897], [-119.65105, 36.81896], [-119.65116, 36.81894], [-119.6513, 36.81887], [-119.65135, 36.81887], [-119.6514, 36.81889]]], [[[-119.65415, 36.81664], [-119.65396, 36.81664], [-119.65381, 36.81677], [-119.65373, 36.81681], [-119.65341, 36.81684], [-119.65327, 36.81692], [-119.65319, 36.81703], [-119.65309, 36.81731], [-119.65302, 36.81735], [-119.65298, 36.81741], [-119.65298, 36.81748], [-119.653, 36.81752], [-119.65311, 36.8176], [-119.65281, 36.8176], [-119.65264, 36.81764], [-119.65225, 36.81764], [-119.65224, 36.81796], [-119.65232, 36.81798], [-119.65226, 36.81805], [-119.65206, 36.81812], [-119.6515, 36.81876], [-119.65136, 36.81869], [-119.65167, 36.81831], [-119.65202, 36.81792], [-119.65203, 36.81784], [-119.65211, 36.81778], [-119.65213, 36.81768], [-119.65206, 36.81758], [-119.65204, 36.81751], [-119.65263, 36.8175], [-119.65273, 36.81748], [-119.65281, 36.81744], [-119.6529, 36.81734], [-119.65303, 36.81699], [-119.65311, 36.81686], [-119.65322, 36.81677], [-119.65334, 36.81672], [-119.65346, 36.8167], [-119.65362, 36.81669], [-119.6537, 36.81666], [-119.6539, 36.81649], [-119.6539, 36.81631], [-119.65402, 36.81633], [-119.6541, 36.81639], [-119.65415, 36.81648], [-119.65415, 36.81664]]], [[[-119.65351, 36.79302], [-119.65342, 36.79309], [-119.65342, 36.79339], [-119.65311, 36.79339], [-119.65307, 36.79337], [-119.65306, 36.79334], [-119.65306, 36.79298], [-119.65348, 36.79298], [-119.65351, 36.79302]]], [[[-119.65478, 36.81582], [-119.65478, 36.81604], [-119.65463, 36.81604], [-119.65428, 36.81634], [-119.65418, 36.81624], [-119.6545, 36.81596], [-119.6545, 36.81582], [-119.65478, 36.81582]]], [[[-119.67228, 36.80779], [-119.67221, 36.80782], [-119.67211, 36.80781], [-119.67204, 36.80754], [-119.67204, 36.80747], [-119.67207, 36.80731], [-119.67213, 36.80716], [-119.6722, 36.80714], [-119.67227, 36.80717], [-119.67228, 36.80779]]], [[[-119.67672, 36.86383], [-119.67672, 36.86416], [-119.67562, 36.86415], [-119.67554, 36.86417], [-119.67549, 36.86419], [-119.67541, 36.86412], [-119.67597, 36.86398], [-119.67672, 36.86383]]]]} | Open Access 1 | 18266 | Unknown park - Clovis, City of | 28715 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 4.819 | 0 | Local Other or Unknown 14 | 4 | ||
4532 | 4532 | 4531 | {"type": "MultiPolygon", "coordinates": [[[[-117.21241, 32.80723], [-117.21239, 32.80731], [-117.21232, 32.80734], [-117.2111, 32.80742], [-117.21111, 32.80697], [-117.21157, 32.80696], [-117.21172, 32.80698], [-117.21219, 32.80709], [-117.21237, 32.80716], [-117.21241, 32.80723]]], [[[-117.21219, 32.80689], [-117.21219, 32.80695], [-117.21195, 32.80689], [-117.21219, 32.80689], [-117.21219, 32.80689]]]]} | No Public Access 3 | 18410 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 1.217 | 0 | Local Other or Unknown 14 | 4 | ||
4533 | 4533 | 4532 | {"type": "Polygon", "coordinates": [[[-117.20364, 32.79871], [-117.20168, 32.7987], [-117.2017, 32.79679], [-117.20364, 32.79871], [-117.20364, 32.79871]]]} | Open Access 1 | 18603 | Unnamed site - San Diego, City of | 28704 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 4.797 | 0 | Local Other or Unknown 14 | 4 | ||
4535 | 4535 | 4534 | {"type": "Polygon", "coordinates": [[[-117.23982, 32.87111], [-117.23981, 32.87152], [-117.23927, 32.87152], [-117.23951, 32.87136], [-117.23982, 32.87111]]]} | No Public Access 3 | 19896 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.273 | 0 | Local Other or Unknown 14 | 4 | ||
4536 | 4536 | 4535 | {"type": "Polygon", "coordinates": [[[-117.1276, 32.76738], [-117.12717, 32.76784], [-117.12705, 32.76778], [-117.12742, 32.76738], [-117.1276, 32.76738]]]} | No Public Access 3 | 19905 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.196 | 0 | Local Other or Unknown 14 | 4 | ||
4537 | 4537 | 4536 | {"type": "Polygon", "coordinates": [[[-117.10461, 32.76969], [-117.10445, 32.76969], [-117.10461, 32.76951], [-117.10461, 32.76969], [-117.10461, 32.76969]]]} | No Public Access 3 | 19907 | Unnamed site - San Diego, City of | 31719 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.035 | 0 | Local Other or Unknown 14 | 4 | ||
4538 | 4538 | 4537 | {"type": "Polygon", "coordinates": [[[-117.05883, 32.72129], [-117.05851, 32.72137], [-117.05826, 32.72054], [-117.05856, 32.72042], [-117.05883, 32.72129]]]} | Open Access 1 | 19925 | Unnamed site - San Diego, City of | 28704 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.747 | 0 | Local Other or Unknown 14 | 4 | ||
4539 | 4539 | 4538 | {"type": "Polygon", "coordinates": [[[-117.06411, 32.71928], [-117.06404, 32.71934], [-117.06249, 32.71803], [-117.0625, 32.71793], [-117.06411, 32.71928]]]} | Open Access 1 | 19932 | Unnamed site - San Diego, City of | 28704 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 0.466 | 0 | Local Other or Unknown 14 | 4 | ||
4540 | 4540 | 4539 | {"type": "Polygon", "coordinates": [[[-118.09143, 33.87602], [-118.09139, 33.87609], [-118.09128, 33.87602], [-118.09124, 33.87543], [-118.09143, 33.87602]]]} | Open Access 1 | 19997 | Unnamed site - Artesia, City of | 29525 | 1051 | Cerritos, City of 225 | City 2 | City Agency 2 | http://www.ci.cerritos.ca.us/ | City 2 | 1051 | Cerritos, City of 221 | City 2 | City Agency 2 | Los Angeles 6 | 0.128 | 0 | Local Other or Unknown 14 | 4 | ||
4551 | 4551 | 4550 | {"type": "Polygon", "coordinates": [[[-118.25818, 33.88567], [-118.25791, 33.88568], [-118.25784, 33.88564], [-118.25764, 33.88483], [-118.25765, 33.88479], [-118.25768, 33.88477], [-118.25796, 33.88475], [-118.25818, 33.88567]]]} | Open Access 1 | 25083 | Unnamed site - Carson, City of | 29714 | 1400 | Los Angeles - Department of Water and Power, City of 282 | City 2 | City Agency 2 | http://www.ladwp.com/ | City 2 | 1400 | Los Angeles - Department of Water and Power, City of 278 | City 2 | City Agency 2 | Los Angeles 6 | 0.769 | 0 | Local Other or Unknown 14 | 4 | ||
4579 | 4579 | 4578 | {"type": "Polygon", "coordinates": [[[-120.14651, 34.6035], [-120.14643, 34.60387], [-120.14512, 34.60449], [-120.14492, 34.60438], [-120.14466, 34.6043], [-120.14438, 34.6043], [-120.14381, 34.60437], [-120.14377, 34.60436], [-120.14373, 34.60432], [-120.14374, 34.6041], [-120.14379, 34.60395], [-120.14434, 34.60404], [-120.14512, 34.60379], [-120.14578, 34.60373], [-120.14651, 34.6035]]]} | Open Access 1 | 35310 | Unnamed site - Solvang, City of | 28670 | 1337 | Solvang, City of 81 | City 2 | City Agency 2 | http://www.cityofsolvang.com/index.php/departments/parks-a-recreation | City 2 | 1337 | Solvang, City of 79 | City 2 | City Agency 2 | Santa Barbara 7 | 3.005 | 0 | Local Other or Unknown 14 | 4 | ||
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 | ||
4584 | 4584 | 4583 | {"type": "MultiPolygon", "coordinates": [[[[-119.29299, 34.28177], [-119.29297, 34.28184], [-119.29281, 34.28191], [-119.29269, 34.28203], [-119.29249, 34.28203], [-119.29249, 34.28177], [-119.29299, 34.28177]]], [[[-119.29359, 34.28203], [-119.29355, 34.28202], [-119.2935, 34.28196], [-119.29342, 34.2819], [-119.29328, 34.28185], [-119.29326, 34.28181], [-119.29325, 34.28176], [-119.29359, 34.28175], [-119.29359, 34.28203]]]]} | Open Access 1 | 35403 | Unknown park - Ventura, City of | 30393 | 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.37 | 0 | Local Other or Unknown 14 | 4 | ||
4596 | 4596 | 4595 | {"type": "Polygon", "coordinates": [[[-117.28319, 33.04494], [-117.28317, 33.045], [-117.28306, 33.045], [-117.28307, 33.04496], [-117.28304, 33.04495], [-117.28303, 33.04494], [-117.28298, 33.04494], [-117.28297, 33.04495], [-117.28295, 33.04495], [-117.28294, 33.045], [-117.2829, 33.04497], [-117.28291, 33.04454], [-117.28293, 33.04452], [-117.28296, 33.04453], [-117.28319, 33.04492], [-117.28319, 33.04494]]]} | Open Access 1 | 35531 | Unknown park - Encinitas, City of | 28635 | 1100 | Encinitas, City of 43 | City 2 | City Agency 2 | http://www.cityofencinitas.org/index.aspx?page=49 | City 2 | 1100 | Encinitas, City of 42 | City 2 | City Agency 2 | San Diego 4 | 0.21 | 0 | Local Other or Unknown 14 | 4 | ||
4597 | 4597 | 4596 | {"type": "Polygon", "coordinates": [[[-117.18544, 33.1626], [-117.18544, 33.16267], [-117.18537, 33.16299], [-117.18467, 33.1629], [-117.18466, 33.16288], [-117.18471, 33.16253], [-117.18544, 33.1626]]]} | Open Access 1 | 35551 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.736 | 0 | Local Other or Unknown 14 | 4 | ||
4614 | 4614 | 4613 | {"type": "Polygon", "coordinates": [[[-117.14137, 33.15374], [-117.14114, 33.15399], [-117.1411, 33.154], [-117.14106, 33.154], [-117.14103, 33.15398], [-117.14101, 33.15395], [-117.14087, 33.15347], [-117.14094, 33.15346], [-117.14137, 33.15374]]]} | Open Access 1 | 35852 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.339 | 0 | Local Other or Unknown 14 | 4 | ||
4616 | 4616 | 4615 | {"type": "Polygon", "coordinates": [[[-122.25499, 38.35941], [-122.25411, 38.35979], [-122.25361, 38.35995], [-122.25326, 38.35997], [-122.25289, 38.3599], [-122.25265, 38.35979], [-122.25242, 38.35946], [-122.25248, 38.35927], [-122.25284, 38.35909], [-122.2538, 38.35892], [-122.2543, 38.35893], [-122.25499, 38.35941]]]} | No Public Access 3 | 35922 | Unnamed site - Napa, City of | 28645 | 1397 | Napa, City of 447 | City 2 | City Agency 2 | http://www.cityofnapa.org/index.php?option=com_content&view=article&id=42&Itemid=63 | City 2 | 1397 | Napa, City of 441 | City 2 | City Agency 2 | Napa 11 | 4.386 | 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]);