units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, AGNCY_ID = 1148 and MNG_AGENCY = 790
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15880 | 15880 | 15879 | {"type": "MultiPolygon", "coordinates": [[[[-117.78835, 33.64454], [-117.78646, 33.64642], [-117.78655, 33.64735], [-117.78633, 33.64761], [-117.78513, 33.64894], [-117.78475, 33.64943], [-117.78393, 33.64893], [-117.78367, 33.64919], [-117.78317, 33.64846], [-117.78248, 33.648], [-117.78202, 33.64772], [-117.78166, 33.64753], [-117.78096, 33.64727], [-117.78028, 33.64704], [-117.7799, 33.64687], [-117.77942, 33.64662], [-117.77881, 33.64625], [-117.77868, 33.64594], [-117.77848, 33.64596], [-117.77846, 33.64594], [-117.77845, 33.64589], [-117.77836, 33.64584], [-117.77806, 33.64556], [-117.77785, 33.64539], [-117.77772, 33.64513], [-117.7774, 33.64425], [-117.77737, 33.64402], [-117.77737, 33.64367], [-117.77731, 33.64337], [-117.77657, 33.64159], [-117.77598, 33.64079], [-117.77567, 33.64041], [-117.77526, 33.64001], [-117.77408, 33.63906], [-117.77336, 33.63862], [-117.773, 33.63844], [-117.77278, 33.63835], [-117.77257, 33.63829], [-117.7722, 33.63823], [-117.77185, 33.63823], [-117.77148, 33.63828], [-117.77175, 33.63804], [-117.77204, 33.63725], [-117.77234, 33.63564], [-117.77299, 33.63473], [-117.77301, 33.63491], [-117.77304, 33.63507], [-117.7731, 33.63523], [-117.77318, 33.63537], [-117.77404, 33.63662], [-117.77421, 33.63678], [-117.77442, 33.6369], [-117.77458, 33.63696], [-117.77477, 33.63699], [-117.77494, 33.63699], [-117.77513, 33.63696], [-117.77658, 33.63641], [-117.77754, 33.6366], [-117.77791, 33.63676], [-117.77796, 33.63693], [-117.77798, 33.63732], [-117.77776, 33.63791], [-117.77807, 33.63876], [-117.77957, 33.64148], [-117.78073, 33.64275], [-117.78176, 33.64336], [-117.7844, 33.64454], [-117.78598, 33.64417], [-117.78664, 33.64341], [-117.78723, 33.6434], [-117.78793, 33.6442], [-117.78835, 33.64454]], [[-117.77297, 33.63584], [-117.77295, 33.63584], [-117.77284, 33.63598], [-117.77292, 33.63607], [-117.77298, 33.6361], [-117.77305, 33.63611], [-117.77314, 33.63608], [-117.77318, 33.63603], [-117.77319, 33.63599], [-117.77317, 33.63592], [-117.7731, 33.63586], [-117.77297, 33.63584]], [[-117.77516, 33.63846], [-117.77504, 33.63848], [-117.77494, 33.63853], [-117.77487, 33.63861], [-117.77484, 33.6387], [-117.77486, 33.6388], [-117.77491, 33.63888], [-117.775, 33.63894], [-117.77512, 33.63897], [-117.77524, 33.63896], [-117.77534, 33.63891], [-117.77542, 33.63883], [-117.77545, 33.63873], [-117.77544, 33.63865], [-117.77538, 33.63856], [-117.77527, 33.63848], [-117.77516, 33.63846]]], [[[-117.80292, 33.65785], [-117.80263, 33.65772], [-117.80235, 33.65776], [-117.8024, 33.65812], [-117.80155, 33.6583], [-117.80085, 33.6585], [-117.80018, 33.65875], [-117.79954, 33.65904], [-117.79905, 33.65932], [-117.79859, 33.65961], [-117.79815, 33.65994], [-117.79773, 33.66029], [-117.79768, 33.66026], [-117.79761, 33.66027], [-117.79724, 33.66055], [-117.79703, 33.66066], [-117.79644, 33.66129], [-117.79628, 33.66142], [-117.79591, 33.66167], [-117.79547, 33.66185], [-117.79499, 33.66218], [-117.79476, 33.66229], [-117.79445, 33.66238], [-117.79414, 33.66242], [-117.79307, 33.66239], [-117.7924, 33.66231], [-117.79146, 33.662], [-117.79124, 33.66195], [-117.7905, 33.66171], [-117.79038, 33.66173], [-117.79031, 33.66179], [-117.79017, 33.66224], [-117.78896, 33.66209], [-117.78795, 33.66192], [-117.78728, 33.66177], [-117.7863, 33.66149], [-117.78566, 33.66128], [-117.78472, 33.66091], [-117.7838, 33.66049], [-117.78293, 33.66003], [-117.78227, 33.65965], [-117.78086, 33.65867], [-117.78061, 33.65844], [-117.7804, 33.65818], [-117.78132, 33.65882], [-117.78134, 33.65881], [-117.78132, 33.65868], [-117.78133, 33.6586], [-117.78148, 33.65847], [-117.7816, 33.65847], [-117.78166, 33.65849], [-117.78171, 33.65844], [-117.78178, 33.65825], [-117.78175, 33.65809], [-117.78184, 33.65797], [-117.78191, 33.65775], [-117.78194, 33.65755], [-117.78199, 33.65742], [-117.78205, 33.65735], [-117.78211, 33.65733], [-117.78201, 33.65722], [-117.78201, 33.65713], [-117.78198, 33.65705], [-117.78199, 33.65698], [-117.78205, 33.65685], [-117.78205, 33.6567], [-117.78215, 33.6566], [-117.78206, 33.65636], [-117.78189, 33.65624], [-117.78191, 33.65622], [-117.78169, 33.65606], [-117.78129, 33.65563], [-117.78126, 33.65557], [-117.78136, 33.65554], [-117.782, 33.655], [-117.78204, 33.65502], [-117.78198, 33.65512], [-117.78249, 33.65538], [-117.78264, 33.65518], [-117.78277, 33.65524], [-117.78299, 33.65494], [-117.78287, 33.65487], [-117.78292, 33.65475], [-117.78297, 33.6547], [-117.78298, 33.65463], [-117.78392, 33.65368], [-117.78306, 33.65309], [-117.78338, 33.65273], [-117.78357, 33.65249], [-117.78384, 33.65208], [-117.78403, 33.65174], [-117.78458, 33.65042], [-117.78491, 33.64977], [-117.78502, 33.64961], [-117.78487, 33.6495], [-117.78537, 33.64888], [-117.78657, 33.64755], [-117.78658, 33.64763], [-117.78742, 33.64821], [-117.78767, 33.64829], [-117.78784, 33.64832], [-117.78797, 33.64831], [-117.78814, 33.64829], [-117.78841, 33.64819], [-117.78991, 33.64736], [-117.79046, 33.64636], [-117.79073, 33.64541], [-117.7909, 33.64506], [-117.79178, 33.64436], [-117.79236, 33.64423], [-117.79258, 33.64426], [-117.79247, 33.64432], [-117.79246, 33.64438], [-117.7928, 33.64447], [-117.79321, 33.64438], [-117.79367, 33.64446], [-117.79377, 33.64452], [-117.79389, 33.64455], [-117.79414, 33.64455], [-117.79501, 33.6447], [-117.79537, 33.645], [-117.79544, 33.64521], [-117.79517, 33.64533], [-117.79478, 33.64589], [-117.79493, 33.646], [-117.7948, 33.64601], [-117.79452, 33.6463], [-117.79437, 33.64623], [-117.79356, 33.64641], [-117.79337, 33.64651], [-117.79315, 33.64682], [-117.79313, 33.64712], [-117.79317, 33.64756], [-117.79327, 33.64773], [-117.79332, 33.64792], [-117.79328, 33.64824], [-117.79367, 33.64834], [-117.79388, 33.64851], [-117.79451, 33.64878], [-117.79557, 33.65098], [-117.79667, 33.6526], [-117.80009, 33.65338], [-117.80164, 33.65459], [-117.80292, 33.65785]], [[-117.78925, 33.65327], [-117.78944, 33.65323], [-117.78963, 33.65315], [-117.78979, 33.65305], [-117.78992, 33.65291], [-117.79002, 33.65276], [-117.79008, 33.65259], [-117.79009, 33.65242], [-117.79006, 33.65224], [-117.78999, 33.65208], [-117.78988, 33.65193], [-117.78973, 33.65181], [-117.78956, 33.65171], [-117.78937, 33.65165], [-117.78916, 33.65162], [-117.78895, 33.65162], [-117.78875, 33.65167], [-117.78855, 33.65175], [-117.78837, 33.65188], [-117.78823, 33.65204], [-117.78814, 33.65221], [-117.7881, 33.65241], [-117.78812, 33.65261], [-117.7882, 33.6528], [-117.78833, 33.65298], [-117.78818, 33.65328], [-117.78912, 33.65357], [-117.78925, 33.65327]]]]} | Open Access 1 | 47478 | South-Quail Hill Open Space Preserve | 31198 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3257 | Irvine Ranch Conservancy 790 | Non Profit 6 | Non Profit - Conservation 12 | Orange 3 | 734.119 | South-Quail Hill OSP | None 1369 | |||
| 15893 | 15893 | 15892 | {"type": "Polygon", "coordinates": [[[-117.81962, 33.61813], [-117.81951, 33.61818], [-117.81938, 33.61821], [-117.81928, 33.61821], [-117.81893, 33.61814], [-117.81863, 33.61813], [-117.81847, 33.61815], [-117.81813, 33.61823], [-117.81785, 33.61836], [-117.81684, 33.61861], [-117.81668, 33.61869], [-117.81655, 33.61881], [-117.81646, 33.61894], [-117.8164, 33.61914], [-117.81636, 33.61922], [-117.81605, 33.61955], [-117.81584, 33.61972], [-117.81552, 33.61988], [-117.81527, 33.61996], [-117.81508, 33.61998], [-117.8146, 33.61999], [-117.81446, 33.62003], [-117.81428, 33.62013], [-117.81416, 33.62017], [-117.81381, 33.62013], [-117.81336, 33.62012], [-117.81285, 33.62016], [-117.81245, 33.62023], [-117.8121, 33.6202], [-117.81097, 33.62083], [-117.8109, 33.62094], [-117.81089, 33.62103], [-117.81096, 33.62172], [-117.80905, 33.62377], [-117.80884, 33.62409], [-117.80873, 33.62432], [-117.80865, 33.62455], [-117.8086, 33.62491], [-117.80861, 33.62532], [-117.80871, 33.62571], [-117.80887, 33.62607], [-117.80885, 33.6262], [-117.80875, 33.6264], [-117.80872, 33.62652], [-117.8087, 33.62664], [-117.80871, 33.62686], [-117.80876, 33.62701], [-117.80886, 33.62721], [-117.80898, 33.62735], [-117.80912, 33.62747], [-117.80915, 33.62752], [-117.80914, 33.62755], [-117.80903, 33.62765], [-117.80894, 33.62778], [-117.80888, 33.62793], [-117.80886, 33.62805], [-117.80886, 33.62818], [-117.80891, 33.62832], [-117.80897, 33.62844], [-117.80906, 33.62855], [-117.80859, 33.62925], [-117.80879, 33.62973], [-117.80845, 33.62988], [-117.80813, 33.63004], [-117.80699, 33.6307], [-117.80676, 33.63044], [-117.80662, 33.63025], [-117.80654, 33.63009], [-117.80637, 33.62966], [-117.80636, 33.62965], [-117.80639, 33.63], [-117.80667, 33.63052], [-117.80697, 33.63085], [-117.80641, 33.63119], [-117.80586, 33.63155], [-117.80516, 33.6319], [-117.80553, 33.63157], [-117.80604, 33.63033], [-117.80589, 33.62977], [-117.80561, 33.62915], [-117.80484, 33.62869], [-117.80491, 33.62835], [-117.80494, 33.62806], [-117.80393, 33.62709], [-117.80372, 33.62684], [-117.80351, 33.62655], [-117.80335, 33.62628], [-117.8035, 33.62577], [-117.80351, 33.62564], [-117.80349, 33.62555], [-117.80332, 33.62517], [-117.80324, 33.62505], [-117.80315, 33.62498], [-117.80281, 33.62478], [-117.8027, 33.62473], [-117.80259, 33.62471], [-117.80248, 33.62471], [-117.8023, 33.62475], [-117.80222, 33.62472], [-117.80219, 33.62449], [-117.8021, 33.62435], [-117.802, 33.62427], [-117.8016, 33.6241], [-117.8014, 33.62388], [-117.80091, 33.62341], [-117.80088, 33.62325], [-117.80077, 33.62312], [-117.80055, 33.62299], [-117.80022, 33.62286], [-117.79964, 33.62243], [-117.79957, 33.62235], [-117.79959, 33.62213], [-117.79958, 33.62203], [-117.79953, 33.62192], [-117.79932, 33.6216], [-117.79914, 33.62145], [-117.7986, 33.62122], [-117.798, 33.62138], [-117.79767, 33.62152], [-117.79714, 33.62192], [-117.79705, 33.62208], [-117.79664, 33.62214], [-117.79654, 33.62154], [-117.79604, 33.62068], [-117.79566, 33.62059], [-117.79534, 33.62021], [-117.79535, 33.62001], [-117.79533, 33.6199], [-117.79525, 33.61974], [-117.79516, 33.61964], [-117.79502, 33.61954], [-117.7949, 33.6195], [-117.79475, 33.61947], [-117.79456, 33.61947], [-117.79401, 33.61955], [-117.79385, 33.62019], [-117.79367, 33.61996], [-117.79351, 33.61979], [-117.79286, 33.61925], [-117.79295, 33.61907], [-117.79299, 33.61896], [-117.793, 33.61878], [-117.79298, 33.61863], [-117.78857, 33.60386], [-117.78887, 33.604], [-117.78953, 33.60444], [-117.79025, 33.60471], [-117.79079, 33.6046], [-117.79212, 33.60517], [-117.79241, 33.60512], [-117.79262, 33.60531], [-117.79273, 33.60565], [-117.79272, 33.60584], [-117.79286, 33.60623], [-117.79306, 33.60628], [-117.79334, 33.60624], [-117.7936, 33.60626], [-117.79374, 33.60639], [-117.79415, 33.60648], [-117.79446, 33.60638], [-117.7948, 33.60647], [-117.79526, 33.60675], [-117.79541, 33.60709], [-117.79537, 33.60735], [-117.79583, 33.60731], [-117.79661, 33.60688], [-117.79717, 33.60676], [-117.79784, 33.6069], [-117.79777, 33.60711], [-117.798, 33.6075], [-117.79806, 33.60772], [-117.79867, 33.60796], [-117.79926, 33.60808], [-117.79936, 33.60811], [-117.7994, 33.60837], [-117.79937, 33.60852], [-117.79947, 33.60854], [-117.80009, 33.60821], [-117.80066, 33.60806], [-117.80096, 33.60864], [-117.80099, 33.60895], [-117.80138, 33.60936], [-117.80142, 33.60959], [-117.8016, 33.6098], [-117.80155, 33.60994], [-117.80175, 33.61004], [-117.8021, 33.61044], [-117.80225, 33.61075], [-117.80238, 33.61071], [-117.80245, 33.61011], [-117.80261, 33.60983], [-117.80274, 33.60982], [-117.80295, 33.60973], [-117.80311, 33.60974], [-117.8033, 33.60972], [-117.80356, 33.60988], [-117.80381, 33.61014], [-117.80386, 33.61047], [-117.80395, 33.61076], [-117.80405, 33.61087], [-117.80476, 33.61056], [-117.80498, 33.6104], [-117.80531, 33.61005], [-117.80544, 33.61006], [-117.80558, 33.60998], [-117.8059, 33.6095], [-117.80669, 33.60961], [-117.80711, 33.61013], [-117.80761, 33.61045], [-117.80787, 33.61039], [-117.80814, 33.61052], [-117.80849, 33.61059], [-117.80871, 33.61074], [-117.81049, 33.61078], [-117.81089, 33.61098], [-117.8103, 33.61012], [-117.81124, 33.61026], [-117.81189, 33.6104], [-117.81268, 33.61063], [-117.8133, 33.61086], [-117.8136, 33.61098], [-117.81418, 33.61126], [-117.81474, 33.61157], [-117.81501, 33.61174], [-117.81553, 33.6121], [-117.8159, 33.61238], [-117.81624, 33.61269], [-117.81668, 33.61312], [-117.81698, 33.61345], [-117.81726, 33.6138], [-117.81752, 33.61416], [-117.8179, 33.61479], [-117.81899, 33.61691], [-117.81902, 33.6169], [-117.81913, 33.61711], [-117.8191, 33.61713], [-117.81962, 33.61813]]]} | Open Access 1 | 6723 | South-Bommer Canyon Open Space Preserve | 31196 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3257 | Irvine Ranch Conservancy 790 | Non Profit 6 | Non Profit - Conservation 12 | http://www.cityofirvine.org/cityhall/cs/openspace/bommer_canyon.asp | Orange 3 | 923.74 | South-Bommer Canyon OSP | None 1370 | ||
| 15942 | 15942 | 15941 | {"type": "MultiPolygon", "coordinates": [[[[-117.79722, 33.62314], [-117.7972, 33.62335], [-117.79701, 33.6234], [-117.79689, 33.62348], [-117.79683, 33.62356], [-117.79654, 33.62404], [-117.79645, 33.62405], [-117.79564, 33.62387], [-117.79547, 33.62389], [-117.79534, 33.62394], [-117.79528, 33.62398], [-117.79518, 33.62408], [-117.79514, 33.62418], [-117.79512, 33.62425], [-117.79514, 33.6244], [-117.79506, 33.62482], [-117.79504, 33.62486], [-117.79499, 33.6249], [-117.7945, 33.62499], [-117.79432, 33.62499], [-117.79417, 33.62497], [-117.79368, 33.62507], [-117.79237, 33.62418], [-117.79197, 33.62362], [-117.79151, 33.62315], [-117.79046, 33.62292], [-117.78989, 33.62287], [-117.78917, 33.62309], [-117.78924, 33.62332], [-117.78953, 33.62365], [-117.78961, 33.62395], [-117.78936, 33.62414], [-117.78871, 33.6241], [-117.78761, 33.62515], [-117.78782, 33.62624], [-117.78783, 33.62775], [-117.78618, 33.62798], [-117.78553, 33.6277], [-117.78474, 33.6281], [-117.78403, 33.6281], [-117.78303, 33.62762], [-117.78202, 33.62841], [-117.78196, 33.63062], [-117.78292, 33.63264], [-117.78219, 33.63294], [-117.78155, 33.63185], [-117.78121, 33.6318], [-117.78094, 33.63179], [-117.78063, 33.63181], [-117.7804, 33.63186], [-117.78014, 33.63193], [-117.77993, 33.63201], [-117.77968, 33.63214], [-117.77947, 33.63228], [-117.77919, 33.63254], [-117.77854, 33.63327], [-117.77783, 33.63367], [-117.77765, 33.63373], [-117.77744, 33.63377], [-117.77725, 33.63376], [-117.77706, 33.63373], [-117.77687, 33.63366], [-117.77676, 33.6336], [-117.77665, 33.63352], [-117.77656, 33.63342], [-117.77639, 33.63318], [-117.77623, 33.63301], [-117.77602, 33.63286], [-117.77577, 33.63274], [-117.77553, 33.63267], [-117.77522, 33.63263], [-117.77486, 33.63265], [-117.77453, 33.63273], [-117.77416, 33.63288], [-117.77388, 33.63305], [-117.77374, 33.63318], [-117.77361, 33.63331], [-117.77352, 33.63343], [-117.77341, 33.63361], [-117.77307, 33.63433], [-117.77301, 33.63453], [-117.77299, 33.63473], [-117.77234, 33.63565], [-117.77204, 33.63725], [-117.77175, 33.63804], [-117.77147, 33.63828], [-117.77125, 33.63834], [-117.77108, 33.63841], [-117.77076, 33.63856], [-117.77051, 33.63872], [-117.77043, 33.63864], [-117.77032, 33.63859], [-117.7702, 33.63858], [-117.77007, 33.63861], [-117.76998, 33.63866], [-117.76993, 33.63871], [-117.76989, 33.63879], [-117.76987, 33.63888], [-117.76976, 33.639], [-117.76959, 33.63909], [-117.76941, 33.63913], [-117.76926, 33.63912], [-117.76913, 33.63903], [-117.76887, 33.63874], [-117.76755, 33.63857], [-117.76633, 33.63844], [-117.76593, 33.63854], [-117.76528, 33.63857], [-117.76533, 33.6395], [-117.76577, 33.64067], [-117.76559, 33.64163], [-117.76585, 33.64231], [-117.76557, 33.6432], [-117.76422, 33.63967], [-117.76417, 33.63889], [-117.76113, 33.63868], [-117.76103, 33.63793], [-117.76101, 33.63738], [-117.76102, 33.637], [-117.76099, 33.63682], [-117.76104, 33.63633], [-117.76115, 33.63567], [-117.76176, 33.63333], [-117.76188, 33.63271], [-117.76192, 33.63219], [-117.76192, 33.63172], [-117.76186, 33.63125], [-117.76177, 33.63079], [-117.76159, 33.63023], [-117.7614, 33.62979], [-117.76117, 33.62936], [-117.76086, 33.6289], [-117.76059, 33.62855], [-117.75949, 33.62727], [-117.75934, 33.62721], [-117.75758, 33.62504], [-117.77435, 33.61839], [-117.77601, 33.60166], [-117.77732, 33.60018], [-117.77901, 33.6015], [-117.78, 33.60154], [-117.7802, 33.60167], [-117.78022, 33.60175], [-117.78055, 33.60195], [-117.78067, 33.60201], [-117.78083, 33.60195], [-117.78124, 33.60203], [-117.78104, 33.60231], [-117.78079, 33.60237], [-117.78041, 33.60226], [-117.78031, 33.60243], [-117.78078, 33.60274], [-117.7812, 33.6027], [-117.7814, 33.60247], [-117.78168, 33.60253], [-117.78216, 33.60238], [-117.78348, 33.60271], [-117.78377, 33.60288], [-117.78408, 33.60293], [-117.78495, 33.60291], [-117.78547, 33.60291], [-117.78582, 33.60302], [-117.78573, 33.60339], [-117.78575, 33.60354], [-117.786, 33.60367], [-117.78643, 33.60369], [-117.78671, 33.60366], [-117.78718, 33.60367], [-117.78736, 33.60371], [-117.78815, 33.60359], [-117.7885, 33.60383], [-117.78857, 33.60386], [-117.79291, 33.61845], [-117.79284, 33.61834], [-117.79272, 33.61822], [-117.79247, 33.61804], [-117.79215, 33.6176], [-117.7918, 33.61753], [-117.79093, 33.6178], [-117.79078, 33.61809], [-117.79077, 33.6183], [-117.79088, 33.61865], [-117.79102, 33.61943], [-117.7912, 33.61985], [-117.79126, 33.61994], [-117.79135, 33.62003], [-117.7916, 33.62015], [-117.79181, 33.62029], [-117.79199, 33.62048], [-117.79212, 33.62068], [-117.7924, 33.62142], [-117.7926, 33.6221], [-117.79253, 33.62229], [-117.79252, 33.62239], [-117.79253, 33.6225], [-117.7926, 33.62264], [-117.79269, 33.62274], [-117.79276, 33.6228], [-117.79355, 33.62325], [-117.79394, 33.62326], [-117.794, 33.62322], [-117.79422, 33.6234], [-117.79435, 33.62348], [-117.79443, 33.6235], [-117.79478, 33.62354], [-117.79556, 33.62335], [-117.79628, 33.62346], [-117.79655, 33.62343], [-117.79709, 33.62321], [-117.79722, 33.62314]], [[-117.79011, 33.61595], [-117.79014, 33.61582], [-117.79013, 33.61574], [-117.79011, 33.61569], [-117.79007, 33.61567], [-117.78991, 33.61564], [-117.78989, 33.61565], [-117.7898, 33.61597], [-117.7898, 33.61598], [-117.79006, 33.61609], [-117.79011, 33.61605], [-117.79011, 33.61595]]], [[[-117.76677, 33.64717], [-117.76659, 33.64711], [-117.76653, 33.64681], [-117.76642, 33.64646], [-117.76589, 33.64506], [-117.76567, 33.64456], [-117.76538, 33.64408], [-117.76515, 33.64377], [-117.76497, 33.64355], [-117.76455, 33.64313], [-117.76425, 33.64288], [-117.76401, 33.6427], [-117.7634, 33.64232], [-117.76435, 33.64202], [-117.76436, 33.642], [-117.76155, 33.6399], [-117.76063, 33.6401], [-117.76059, 33.63987], [-117.76057, 33.63959], [-117.76064, 33.63882], [-117.76388, 33.63904], [-117.76393, 33.63972], [-117.76677, 33.64717]]]]} | Open Access 1 | 35783 | South-Shady Canyon Open Space Preserve | 31197 | 1148 | Irvine, City of 271 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3257 | Irvine Ranch Conservancy 790 | Non Profit 6 | Non Profit - Conservation 12 | Orange 3 | 1730.226 | South-Shady Canyon OSP | None 1371 |
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]);