units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
100 rows where ACCESS_TYP = 1 and MNG_AGENCY = 266 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
DES_TP 6
- Local Park 43
- Local Other or Unknown 29
- Local Recreation Area 5
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 80
MNG_AGENCY 1
- Irvine, City of · 80 ✖
ACCESS_TYP 1
- Open Access · 80 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8150 | 8150 | 8149 | {"type": "Polygon", "coordinates": [[[-117.77725, 33.68548], [-117.77669, 33.68604], [-117.77658, 33.68597], [-117.77641, 33.68596], [-117.77634, 33.68598], [-117.77629, 33.68606], [-117.77634, 33.68613], [-117.77641, 33.68616], [-117.77655, 33.68618], [-117.77583, 33.6869], [-117.77339, 33.68522], [-117.77379, 33.68482], [-117.77524, 33.68582], [-117.77619, 33.68487], [-117.77644, 33.68504], [-117.77653, 33.68497], [-117.77725, 33.68548]]]} | Open Access 1 | 12331 | Hoeptner Park | 20020 | 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 | 8.29 | Hoeptner Park | 0 | Local Park 2 | 4 | |
1615 | 1615 | 1614 | {"type": "Polygon", "coordinates": [[[-117.77406, 33.6503], [-117.77364, 33.64968], [-117.77292, 33.64894], [-117.7726, 33.64871], [-117.77183, 33.64826], [-117.77182, 33.64821], [-117.77206, 33.64793], [-117.77233, 33.64766], [-117.77285, 33.64718], [-117.773, 33.64708], [-117.77304, 33.64713], [-117.7733, 33.64819], [-117.77335, 33.6483], [-117.77342, 33.64837], [-117.77354, 33.64844], [-117.77391, 33.64855], [-117.77403, 33.64857], [-117.77396, 33.64895], [-117.77385, 33.64918], [-117.77383, 33.64927], [-117.77388, 33.64943], [-117.77407, 33.64989], [-117.7741, 33.65009], [-117.7741, 33.65019], [-117.77406, 33.6503]]]} | Open Access 1 | 12345 | Knollcrest Park | 20699 | 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 | 6.395 | Knollcrest Park | 0 | Local Park 2 | 4 | |
1639 | 1639 | 1638 | {"type": "Polygon", "coordinates": [[[-117.75592, 33.72636], [-117.75321, 33.72576], [-117.75327, 33.72558], [-117.75337, 33.72544], [-117.75337, 33.72535], [-117.75331, 33.72529], [-117.75322, 33.72526], [-117.75313, 33.72528], [-117.75307, 33.72533], [-117.75303, 33.7253], [-117.75335, 33.72435], [-117.75588, 33.72459], [-117.75592, 33.72463], [-117.75587, 33.72478], [-117.75591, 33.72487], [-117.75592, 33.72497], [-117.75592, 33.72636]]]} | Open Access 1 | 12489 | Meadowood Park | 22092 | 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 | 10.895 | Meadowood Park | 0 | Local Park 2 | 4 | |
8224 | 8224 | 8223 | {"type": "Polygon", "coordinates": [[[-117.77483, 33.7005], [-117.77383, 33.70109], [-117.77349, 33.70135], [-117.77324, 33.70159], [-117.77313, 33.70161], [-117.77247, 33.70114], [-117.77246, 33.70105], [-117.77341, 33.70011], [-117.77363, 33.70005], [-117.77372, 33.7], [-117.77381, 33.69988], [-117.77382, 33.6998], [-117.7738, 33.69968], [-117.7741, 33.69938], [-117.77483, 33.7005]]]} | Open Access 1 | 12533 | Orchard Park | 23190 | 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 | 5.831 | Orchard Park | 0 | Local Park 2 | 4 | |
1448 | 1448 | 1447 | {"type": "MultiPolygon", "coordinates": [[[[-117.7968, 33.71263], [-117.79486, 33.71471], [-117.79121, 33.71637], [-117.79065, 33.71596], [-117.79421, 33.71435], [-117.79447, 33.71419], [-117.79612, 33.71251], [-117.79652, 33.71222], [-117.7968, 33.71263]]], [[[-117.79842, 33.71109], [-117.79768, 33.71171], [-117.79698, 33.71243], [-117.79676, 33.71211], [-117.79741, 33.71138], [-117.79803, 33.71098], [-117.79842, 33.71109]]], [[[-117.80311, 33.70634], [-117.80161, 33.70847], [-117.801, 33.70878], [-117.80042, 33.70925], [-117.79889, 33.71078], [-117.79822, 33.71065], [-117.79916, 33.70961], [-117.79986, 33.70899], [-117.80047, 33.7086], [-117.80098, 33.70813], [-117.80129, 33.70794], [-117.80153, 33.70775], [-117.80192, 33.70722], [-117.8026, 33.70608], [-117.80311, 33.70634]]]]} | Open Access 1 | 12559 | Peters Canyon Wash & Bike Path | 23631 | 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 | 21.252 | Peters Canyon Wash & Bike Path | 0 | Local Recreation Area 3 | 4 | |
1660 | 1660 | 1659 | {"type": "Polygon", "coordinates": [[[-117.75764, 33.70435], [-117.75725, 33.70459], [-117.75723, 33.70464], [-117.75713, 33.70465], [-117.75709, 33.70469], [-117.75707, 33.70475], [-117.75701, 33.70473], [-117.75652, 33.70501], [-117.75652, 33.70506], [-117.75644, 33.70506], [-117.7564, 33.70509], [-117.75635, 33.70514], [-117.75629, 33.70514], [-117.75579, 33.7054], [-117.75576, 33.70546], [-117.75567, 33.70547], [-117.75561, 33.70553], [-117.75553, 33.70552], [-117.75708, 33.70396], [-117.75764, 33.70435]]]} | Open Access 1 | 12560 | Pinewood Park | 23693 | 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 | 2.052 | Pinewood Park | 0 | Local Park 2 | 4 | |
1654 | 1654 | 1653 | {"type": "Polygon", "coordinates": [[[-117.81031, 33.69008], [-117.81012, 33.69032], [-117.80993, 33.69052], [-117.80959, 33.69081], [-117.80948, 33.69084], [-117.80944, 33.69081], [-117.80937, 33.69085], [-117.8087, 33.69041], [-117.80827, 33.69084], [-117.80889, 33.69125], [-117.80878, 33.69129], [-117.80616, 33.68949], [-117.8066, 33.68956], [-117.80696, 33.68958], [-117.80853, 33.68961], [-117.80899, 33.68965], [-117.80982, 33.68985], [-117.81029, 33.69002], [-117.81031, 33.69008]]]} | Open Access 1 | 12568 | Plaza Park | 23785 | 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 | 7.975 | Plaza Park | 0 | Local Park 2 | 4 | |
8236 | 8236 | 8235 | {"type": "Polygon", "coordinates": [[[-117.7843, 33.65032], [-117.78379, 33.65149], [-117.78363, 33.65181], [-117.78346, 33.65208], [-117.78325, 33.65238], [-117.78303, 33.65265], [-117.78274, 33.65296], [-117.78199, 33.65368], [-117.78128, 33.6542], [-117.78121, 33.65417], [-117.78102, 33.65413], [-117.78085, 33.65415], [-117.78072, 33.6542], [-117.78052, 33.65405], [-117.78291, 33.64981], [-117.7829, 33.64979], [-117.78279, 33.64975], [-117.78291, 33.64957], [-117.78311, 33.64962], [-117.78352, 33.64967], [-117.78368, 33.64973], [-117.78384, 33.64986], [-117.78388, 33.64992], [-117.78393, 33.65005], [-117.78412, 33.65005], [-117.78425, 33.6503], [-117.7843, 33.65032]]]} | Open Access 1 | 12570 | Quail Hill Community Park | 24041 | 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 | 17.783 | Quail Hill Community Park | 0 | Local Park 2 | 4 | |
1663 | 1663 | 1662 | {"type": "Polygon", "coordinates": [[[-117.77914, 33.71297], [-117.77844, 33.71369], [-117.77818, 33.71352], [-117.77813, 33.71344], [-117.77797, 33.71338], [-117.77783, 33.71329], [-117.77882, 33.71229], [-117.77893, 33.71237], [-117.77888, 33.71245], [-117.77888, 33.7125], [-117.77894, 33.71257], [-117.77888, 33.71279], [-117.77914, 33.71297]]]} | Open Access 1 | 12571 | Racquet Club Park | 24067 | 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 | 2.081 | Racquet Club Park | 0 | Local Park 2 | 4 | |
8238 | 8238 | 8237 | {"type": "Polygon", "coordinates": [[[-117.78357, 33.68538], [-117.78346, 33.68549], [-117.78247, 33.68481], [-117.78228, 33.68483], [-117.78161, 33.68437], [-117.78136, 33.68462], [-117.78153, 33.68475], [-117.78151, 33.68477], [-117.78133, 33.68466], [-117.78082, 33.68517], [-117.78099, 33.6853], [-117.78097, 33.68533], [-117.78079, 33.68521], [-117.78054, 33.68546], [-117.78197, 33.68646], [-117.782, 33.68653], [-117.78226, 33.68672], [-117.78217, 33.68682], [-117.78149, 33.68635], [-117.78146, 33.68636], [-117.78143, 33.68634], [-117.78145, 33.68632], [-117.78079, 33.68586], [-117.78076, 33.68588], [-117.78073, 33.68586], [-117.78075, 33.68583], [-117.78014, 33.6854], [-117.78011, 33.68542], [-117.78008, 33.6854], [-117.78009, 33.68538], [-117.77949, 33.68495], [-117.77946, 33.68497], [-117.77943, 33.68495], [-117.77944, 33.68492], [-117.77888, 33.68454], [-117.77898, 33.68444], [-117.77919, 33.68459], [-117.77926, 33.68459], [-117.78039, 33.68536], [-117.78065, 33.6851], [-117.78048, 33.68498], [-117.7805, 33.68495], [-117.78068, 33.68507], [-117.78119, 33.68456], [-117.78102, 33.68443], [-117.78104, 33.6844], [-117.78122, 33.68452], [-117.78147, 33.68426], [-117.78112, 33.68403], [-117.78111, 33.68385], [-117.78008, 33.68313], [-117.78006, 33.68314], [-117.78001, 33.68342], [-117.77997, 33.68341], [-117.78003, 33.68311], [-117.77961, 33.68281], [-117.77947, 33.68295], [-117.77945, 33.68293], [-117.77958, 33.68278], [-117.77898, 33.68235], [-117.77882, 33.6825], [-117.7788, 33.68248], [-117.77894, 33.68233], [-117.77833, 33.6819], [-117.77818, 33.68204], [-117.77816, 33.68202], [-117.7783, 33.68187], [-117.77777, 33.6815], [-117.7779, 33.68141], [-117.78042, 33.6832], [-117.78069, 33.68339], [-117.78073, 33.68337], [-117.78076, 33.68338], [-117.78074, 33.68342], [-117.78129, 33.6838], [-117.78148, 33.68369], [-117.78152, 33.68372], [-117.78158, 33.68374], [-117.78169, 33.68372], [-117.78172, 33.68369], [-117.78193, 33.68383], [-117.78258, 33.68318], [-117.78291, 33.6834], [-117.78225, 33.68406], [-117.78245, 33.6842], [-117.78241, 33.68426], [-117.78241, 33.68432], [-117.78244, 33.68437], [-117.78251, 33.68441], [-117.78241, 33.68457], [-117.78296, 33.68496], [-117.783, 33.68494], [-117.78302, 33.68496], [-117.78301, 33.68499], [-117.78357, 33.68538]]]} | Open Access 1 | 12573 | Ranch Park | 24124 | 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 | 7.646 | Ranch Park | 0 | Local Park 2 | 4 | |
8246 | 8246 | 8245 | {"type": "Polygon", "coordinates": [[[-117.82971, 33.6804], [-117.82942, 33.68094], [-117.8289, 33.68179], [-117.82811, 33.68143], [-117.82745, 33.68091], [-117.82878, 33.67987], [-117.82897, 33.68003], [-117.82921, 33.68014], [-117.82967, 33.68029], [-117.82971, 33.6804]]]} | Open Access 1 | 12589 | San Carlo Park | 24843 | 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 | 5.87 | San Carlo Park | 0 | Local Park 2 | 4 | |
8248 | 8248 | 8247 | {"type": "MultiPolygon", "coordinates": [[[[-117.7657, 33.6567], [-117.76552, 33.65686], [-117.76549, 33.657], [-117.76406, 33.65732], [-117.76326, 33.65648], [-117.76266, 33.65604], [-117.76202, 33.65574], [-117.76136, 33.65552], [-117.76104, 33.65555], [-117.76093, 33.65564], [-117.76042, 33.65566], [-117.76008, 33.65561], [-117.75956, 33.65542], [-117.76008, 33.65465], [-117.76064, 33.65413], [-117.76142, 33.65374], [-117.76165, 33.65446], [-117.76197, 33.65466], [-117.76218, 33.65489], [-117.76251, 33.65506], [-117.76295, 33.65524], [-117.76325, 33.65528], [-117.76408, 33.6551], [-117.7643, 33.65536], [-117.76502, 33.65568], [-117.7655, 33.65604], [-117.76569, 33.65643], [-117.7657, 33.6567]]], [[[-117.76731, 33.66046], [-117.76665, 33.66149], [-117.76639, 33.6614], [-117.76652, 33.66115], [-117.76509, 33.6588], [-117.76529, 33.65871], [-117.76452, 33.65754], [-117.76543, 33.65736], [-117.76731, 33.66046]]], [[[-117.77271, 33.65873], [-117.77113, 33.66034], [-117.77117, 33.66042], [-117.76946, 33.66215], [-117.77026, 33.66268], [-117.77092, 33.66303], [-117.77138, 33.66319], [-117.77185, 33.66348], [-117.77101, 33.66436], [-117.76746, 33.66192], [-117.76694, 33.66163], [-117.76753, 33.66076], [-117.76798, 33.66113], [-117.76838, 33.66088], [-117.76868, 33.66075], [-117.76904, 33.6607], [-117.76921, 33.66071], [-117.77144, 33.6585], [-117.77115, 33.65764], [-117.77162, 33.65793], [-117.77271, 33.65873]]], [[[-117.77431, 33.66638], [-117.77394, 33.66679], [-117.77336, 33.66614], [-117.77296, 33.66545], [-117.77271, 33.66508], [-117.77239, 33.66479], [-117.77199, 33.66505], [-117.77136, 33.66459], [-117.77211, 33.6638], [-117.77292, 33.66446], [-117.77322, 33.66498], [-117.77348, 33.66558], [-117.77398, 33.66616], [-117.77431, 33.66638]]], [[[-117.78701, 33.671], [-117.78659, 33.67147], [-117.78556, 33.67105], [-117.78486, 33.67093], [-117.78425, 33.67094], [-117.78366, 33.67101], [-117.78198, 33.67108], [-117.78142, 33.67103], [-117.78094, 33.67089], [-117.78034, 33.67057], [-117.77905, 33.66943], [-117.7783, 33.66896], [-117.7775, 33.66859], [-117.77569, 33.66783], [-117.77497, 33.66742], [-117.77421, 33.66692], [-117.77464, 33.66655], [-117.77573, 33.6673], [-117.7758, 33.66723], [-117.77807, 33.66826], [-117.77805, 33.6683], [-117.77835, 33.66845], [-117.77884, 33.66873], [-117.77888, 33.6687], [-117.77898, 33.66872], [-117.77898, 33.66874], [-117.77921, 33.66888], [-117.77968, 33.66924], [-117.78056, 33.67006], [-117.78101, 33.67034], [-117.78133, 33.67051], [-117.78181, 33.6706], [-117.78232, 33.6706], [-117.78258, 33.67052], [-117.78283, 33.67049], [-117.7836, 33.67032], [-117.78422, 33.67023], [-117.78472, 33.67021], [-117.78532, 33.67028], [-117.78591, 33.67046], [-117.78641, 33.67066], [-117.78701, 33.671]]], [[[-117.79009, 33.67262], [-117.78959, 33.67305], [-117.78688, 33.67156], [-117.78742, 33.67111], [-117.79009, 33.67262]]], [[[-117.79843, 33.67504], [-117.79777, 33.67556], [-117.79778, 33.67549], [-117.79777, 33.67541], [-117.79766, 33.67531], [-117.79694, 33.67501], [-117.79658, 33.67489], [-117.79582, 33.6747], [-117.79419, 33.67454], [-117.79366, 33.67451], [-117.7935, 33.67453], [-117.7932, 33.67452], [-117.7928, 33.67444], [-117.79242, 33.67435], [-117.79225, 33.67433], [-117.79195, 33.67426], [-117.79112, 33.67397], [-117.7904, 33.67369], [-117.79022, 33.6736], [-117.79023, 33.67358], [-117.7903, 33.6736], [-117.79034, 33.67353], [-117.78982, 33.67321], [-117.79008, 33.67294], [-117.79031, 33.67277], [-117.79043, 33.67287], [-117.79124, 33.67335], [-117.79212, 33.67363], [-117.79266, 33.67377], [-117.7945, 33.67395], [-117.79553, 33.67407], [-117.79685, 33.67433], [-117.79754, 33.67457], [-117.79843, 33.67504]]], [[[-117.80281, 33.67774], [-117.80236, 33.67822], [-117.80105, 33.67727], [-117.80068, 33.67698], [-117.80011, 33.67664], [-117.79948, 33.67629], [-117.79936, 33.67624], [-117.79818, 33.67556], [-117.7986, 33.67514], [-117.80036, 33.67588], [-117.80198, 33.6771], [-117.80273, 33.67773], [-117.80277, 33.6777], [-117.80281, 33.67774]]], [[[-117.80794, 33.68062], [-117.80733, 33.68111], [-117.80697, 33.68106], [-117.80621, 33.68083], [-117.80583, 33.6807], [-117.80507, 33.68037], [-117.80501, 33.68032], [-117.80465, 33.68012], [-117.80431, 33.67991], [-117.80388, 33.6796], [-117.80264, 33.67858], [-117.80249, 33.67838], [-117.80299, 33.67789], [-117.80453, 33.67918], [-117.80529, 33.67971], [-117.80602, 33.68009], [-117.80685, 33.68037], [-117.80794, 33.68062]]], [[[-117.8102, 33.68193], [-117.8098, 33.68223], [-117.80967, 33.68224], [-117.80885, 33.68168], [-117.80851, 33.68148], [-117.8083, 33.68139], [-117.80791, 33.68127], [-117.80774, 33.6812], [-117.80817, 33.68072], [-117.80879, 33.68094], [-117.80993, 33.68163], [-117.8102, 33.68193]]], [[[-117.81489, 33.68498], [-117.8144, 33.68537], [-117.81157, 33.68342], [-117.81151, 33.68345], [-117.81147, 33.68343], [-117.81026, 33.68255], [-117.81016, 33.68246], [-117.81057, 33.68209], [-117.81489, 33.68498]]], [[[-117.81899, 33.68782], [-117.81852, 33.68825], [-117.81465, 33.68554], [-117.81481, 33.68534], [-117.81512, 33.68517], [-117.81899, 33.68782]]], [[[-117.82318, 33.69181], [-117.81733, 33.6956], [-117.81633, 33.69621], [-117.81602, 33.69601], [-117.82277, 33.6915], [-117.82318, 33.69181]]], [[[-117.82895, 33.68655], [-117.82482, 33.69081], [-117.82437, 33.69116], [-117.82358, 33.69161], [-117.82292, 33.69127], [-117.82356, 33.69089], [-117.82436, 33.69024], [-117.82484, 33.68978], [-117.82493, 33.68965], [-117.82403, 33.68992], [-117.82308, 33.69005], [-117.82243, 33.69002], [-117.82148, 33.6899], [-117.82072, 33.68967], [-117.8188, 33.68844], [-117.81917, 33.68808], [-117.81971, 33.68845], [-117.82024, 33.68889], [-117.82066, 33.68914], [-117.8211, 33.68936], [-117.82155, 33.6895], [-117.82271, 33.68961], [-117.82307, 33.68961], [-117.82367, 33.68956], [-117.82421, 33.68942], [-117.82467, 33.68928], [-117.82513, 33.68911], [-117.82586, 33.68851], [-117.82833, 33.68608], [-117.82895, 33.68655]]], [[[-117.83552, 33.67927], [-117.83523, 33.67988], [-117.83501, 33.68023], [-117.83461, 33.68075], [-117.83426, 33.68112], [-117.82914, 33.68624], [-117.82852, 33.68582], [-117.82817, 33.68555], [-117.82839, 33.68536], [-117.82863, 33.6854], [-117.83214, 33.68197], [-117.83228, 33.68204], [-117.83252, 33.6818], [-117.83252, 33.68178], [-117.83238, 33.68171], [-117.83408, 33.68001], [-117.8342, 33.67982], [-117.83455, 33.67897], [-117.83552, 33.67927]]], [[[-117.83617, 33.67431], [-117.83598, 33.67719], [-117.83531, 33.6772], [-117.83506, 33.67716], [-117.8348, 33.67708], [-117.83448, 33.67688], [-117.83506, 33.67688], [-117.83521, 33.67442], [-117.8353, 33.67402], [-117.83617, 33.67431]]], [[[-117.83594, 33.67745], [-117.83589, 33.67794], [-117.83575, 33.67852], [-117.83557, 33.67895], [-117.83471, 33.67864], [-117.835, 33.67741], [-117.83594, 33.67745]]], [[[-117.8483, 33.65367], [-117.84718, 33.65446], [-117.84631, 33.65525], [-117.84575, 33.65589], [-117.83824, 33.66286], [-117.83798, 33.66313], [-117.83759, 33.66361], [-117.83746, 33.66379], [-117.83708, 33.66442], [-117.83681, 33.66498], [-117.83667, 33.6654], [-117.83654, 33.66585], [-117.83644, 33.66642], [-117.8364, 33.66689], [-117.8364, 33.66711], [-117.83652, 33.669], [-117.83635, 33.66902], [-117.83647, 33.67076], [-117.83649, 33.67375], [-117.83555, 33.67345], [-117.8353, 33.67084], [-117.83525, 33.67053], [-117.83507, 33.66877], [-117.83493, 33.66856], [-117.83514, 33.6664], [-117.83534, 33.66552], [-117.83561, 33.66473], [-117.83607, 33.66382], [-117.83643, 33.66324], [-117.83688, 33.66268], [-117.83786, 33.66172], [-117.83938, 33.66028], [-117.84169, 33.6582], [-117.84481, 33.65526], [-117.84507, 33.65497], [-117.84617, 33.65395], [-117.84674, 33.65347], [-117.84717, 33.65314], [-117.84759, 33.65285], [-117.8483, 33.65367]]]]} | Open Access 1 | 12593 | San Diego Creek & Bike Path | 4710 | 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 | http://en.wikipedia.org/wiki/San_Diego_Creek_bicycle_path | Orange 3 | 276.82 | San Diego Creek & Bike Path | 0 | Local Recreation Area 3 | 4 |
5378 | 5378 | 5377 | {"type": "Polygon", "coordinates": [[[-117.82218, 33.67671], [-117.82163, 33.67712], [-117.82156, 33.67713], [-117.82149, 33.6771], [-117.82123, 33.67686], [-117.82097, 33.67669], [-117.81984, 33.67628], [-117.82034, 33.67545], [-117.82218, 33.67671]]]} | Open Access 1 | 12609 | San Leandro Park | 24924 | 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 | 4.053 | San Leandro Park | 0 | Local Park 2 | 4 | |
1672 | 1672 | 1671 | {"type": "Polygon", "coordinates": [[[-117.8325, 33.68181], [-117.83229, 33.68203], [-117.83099, 33.68135], [-117.83031, 33.68207], [-117.82956, 33.68157], [-117.82945, 33.68151], [-117.82978, 33.68096], [-117.83001, 33.6805], [-117.83013, 33.68046], [-117.83091, 33.68084], [-117.83104, 33.68103], [-117.8325, 33.68181]]]} | Open Access 1 | 12615 | San Marco Park | 24943 | 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 | 5.005 | San Marco Park | 0 | Local Park 2 | 4 | |
1465 | 1465 | 1464 | {"type": "Polygon", "coordinates": [[[-117.77615, 33.66116], [-117.77292, 33.66446], [-117.77211, 33.6638], [-117.77533, 33.6606], [-117.77615, 33.66116]]]} | Open Access 1 | 12620 | Sand Canyon Bike Path | 25010 | 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 | 11.797 | Sand Canyon Bike Path | 0 | Local Recreation Area 3 | 4 | |
1673 | 1673 | 1672 | {"type": "Polygon", "coordinates": [[[-117.77093, 33.71548], [-117.77021, 33.71621], [-117.76879, 33.71521], [-117.76936, 33.71467], [-117.76948, 33.71465], [-117.77039, 33.7153], [-117.77055, 33.71535], [-117.77068, 33.71531], [-117.77093, 33.71548]]]} | Open Access 1 | 12635 | Silkwood Park | 25478 | 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 | 3.889 | Silkwood Park | 0 | Local Park 2 | 4 | |
8282 | 8282 | 8281 | {"type": "Polygon", "coordinates": [[[-117.76768, 33.70259], [-117.7671, 33.70293], [-117.76688, 33.70316], [-117.76682, 33.70343], [-117.76653, 33.70353], [-117.76634, 33.7037], [-117.76633, 33.70385], [-117.76636, 33.704], [-117.76646, 33.70411], [-117.76663, 33.70424], [-117.76638, 33.70419], [-117.76624, 33.70418], [-117.76602, 33.70419], [-117.7657, 33.70423], [-117.76538, 33.70434], [-117.76519, 33.70443], [-117.76502, 33.70455], [-117.76534, 33.70415], [-117.76561, 33.70363], [-117.76534, 33.70351], [-117.76541, 33.70338], [-117.76568, 33.70347], [-117.76587, 33.70308], [-117.76592, 33.70249], [-117.76603, 33.70223], [-117.76621, 33.70202], [-117.76652, 33.7022], [-117.76673, 33.70199], [-117.76685, 33.70205], [-117.7673, 33.7022], [-117.7675, 33.70235], [-117.76768, 33.70259]]]} | Open Access 1 | 12671 | Sycamore Park | 26135 | 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 | 6.61 | Sycamore Park | 0 | Local Park 2 | 4 | |
1687 | 1687 | 1686 | {"type": "Polygon", "coordinates": [[[-117.77833, 33.73648], [-117.77833, 33.73656], [-117.77818, 33.73668], [-117.778, 33.73687], [-117.77801, 33.73689], [-117.7779, 33.73699], [-117.7776, 33.73678], [-117.7773, 33.73707], [-117.77732, 33.7372], [-117.77749, 33.73738], [-117.77721, 33.73766], [-117.77602, 33.73683], [-117.77703, 33.73585], [-117.77701, 33.73582], [-117.77704, 33.73579], [-117.77701, 33.73576], [-117.77715, 33.73562], [-117.77719, 33.73564], [-117.77737, 33.73547], [-117.77759, 33.73572], [-117.77777, 33.73598], [-117.77795, 33.73619], [-117.77833, 33.73648]]]} | Open Access 1 | 12730 | Valencia Park | 26765 | 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 | 5.851 | Valencia Park | 0 | Local Park 2 | 4 | |
1688 | 1688 | 1687 | {"type": "Polygon", "coordinates": [[[-117.77315, 33.66762], [-117.77212, 33.66863], [-117.76938, 33.66672], [-117.77029, 33.66576], [-117.77079, 33.66612], [-117.77315, 33.66762]]]} | Open Access 1 | 12731 | Oak Creek Community Park | 22959 | 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 | 11.56 | Oak Creek Community Park | 0 | Local Park 2 | 4 | |
1689 | 1689 | 1688 | {"type": "Polygon", "coordinates": [[[-117.7763, 33.66668], [-117.77569, 33.66727], [-117.77493, 33.66675], [-117.77476, 33.6666], [-117.77473, 33.66662], [-117.77464, 33.66655], [-117.7746, 33.66658], [-117.77459, 33.66657], [-117.77521, 33.66592], [-117.7763, 33.66668]]]} | Open Access 1 | 12732 | Valley Oak Park | 26791 | 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 | 2.81 | Valley Oak Park | 0 | Local Park 2 | 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]);