superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
98 rows where LAYER = 2 and MNG_AGENCY = 266
This data as json, copyable, CSV (advanced)
| Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 615 | 615 | 614 | {"type": "MultiPolygon", "coordinates": [[[[-117.7657, 33.6567], [-117.76552, 33.65686], [-117.76549, 33.657], [-117.76406, 33.65732], [-117.76326, 33.65647], [-117.76266, 33.65604], [-117.76202, 33.65574], [-117.76136, 33.65552], [-117.76104, 33.65555], [-117.76092, 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.76651, 33.66115], [-117.76509, 33.6588], [-117.76529, 33.6587], [-117.76452, 33.65754], [-117.76543, 33.65736], [-117.76731, 33.66046]]], [[[-117.77271, 33.65873], [-117.77114, 33.66034], [-117.77117, 33.66042], [-117.76946, 33.66214], [-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.76922, 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.7724, 33.6648], [-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.77572, 33.66729], [-117.7758, 33.66723], [-117.77807, 33.66826], [-117.77806, 33.66831], [-117.77835, 33.66845], [-117.77883, 33.66873], [-117.77888, 33.6687], [-117.77898, 33.66872], [-117.77898, 33.66874], [-117.77921, 33.66888], [-117.77968, 33.66924], [-117.78055, 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.67542], [-117.79765, 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.67445], [-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.79033, 33.67352], [-117.78982, 33.67321], [-117.79008, 33.67294], [-117.79031, 33.67277], [-117.79043, 33.67287], [-117.79124, 33.67334], [-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.67663], [-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.80272, 33.67772], [-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.80852, 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.68979], [-117.82491, 33.68966], [-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.6891], [-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.82864, 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.66314], [-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.66903], [-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 | San Diego Creek & Bike Path | http://en.wikipedia.org/wiki/San_Diego_Creek_bicycle_path | 4710 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 276.865 | San Diego Creek & Bike Path | |
| 1015 | 1015 | 1014 | {"type": "Polygon", "coordinates": [[[-117.76013, 33.71081], [-117.75939, 33.71031], [-117.76, 33.70971], [-117.75993, 33.71001], [-117.75993, 33.71029], [-117.75998, 33.71054], [-117.76013, 33.71081]]]} | Open Access 1 | Alderwood Park | 15349 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 0.689 | Alderwood Park | ||
| 2073 | 2073 | 2072 | {"type": "Polygon", "coordinates": [[[-117.76214, 33.70303], [-117.76191, 33.70324], [-117.76187, 33.7033], [-117.76186, 33.70337], [-117.76172, 33.70337], [-117.76123, 33.70387], [-117.76122, 33.70391], [-117.76115, 33.70398], [-117.76079, 33.70376], [-117.76079, 33.70373], [-117.76049, 33.70352], [-117.76146, 33.70258], [-117.76214, 33.70303]]]} | Open Access 1 | Blue Gum Park | 16176 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.69 | Blue Gum Park | ||
| 2317 | 2317 | 2316 | {"type": "Polygon", "coordinates": [[[-117.77409, 33.71255], [-117.7732, 33.71343], [-117.77171, 33.71241], [-117.77169, 33.71233], [-117.77257, 33.71147], [-117.77409, 33.71255]]]} | Open Access 1 | Brywood Park | 16463 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 5.92 | Brywood Park | ||
| 2458 | 2458 | 2457 | {"type": "Polygon", "coordinates": [[[-117.77094, 33.74041], [-117.77055, 33.74081], [-117.77019, 33.74055], [-117.77005, 33.74048], [-117.77001, 33.74041], [-117.77015, 33.7402], [-117.77037, 33.73998], [-117.77093, 33.74037], [-117.77094, 33.74041]]]} | Open Access 1 | Comstock Park | 17573 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1.03 | Comstock Park | ||
| 2601 | 2601 | 2600 | {"type": "Polygon", "coordinates": [[[-117.80729, 33.64338], [-117.80672, 33.64397], [-117.80653, 33.6441], [-117.80609, 33.64423], [-117.8057, 33.64424], [-117.8056, 33.64404], [-117.80559, 33.6439], [-117.80564, 33.64372], [-117.80575, 33.64351], [-117.80584, 33.6434], [-117.8064, 33.6429], [-117.80645, 33.6429], [-117.80729, 33.64338]]]} | Open Access 1 | Canyon Park | 16824 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.433 | Canyon Park | ||
| 2665 | 2665 | 2664 | {"type": "Polygon", "coordinates": [[[-117.76119, 33.70774], [-117.76076, 33.70816], [-117.76051, 33.70835], [-117.76025, 33.70818], [-117.76017, 33.70825], [-117.75947, 33.70777], [-117.7597, 33.70754], [-117.75967, 33.7074], [-117.75973, 33.70737], [-117.75987, 33.70726], [-117.76013, 33.70701], [-117.76119, 33.70774]]]} | Open Access 1 | Carrotwood Park | 16920 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.092 | Carrotwood Park | ||
| 2761 | 2761 | 2760 | {"type": "Polygon", "coordinates": [[[-117.76612, 33.67667], [-117.76534, 33.67745], [-117.76468, 33.67701], [-117.76546, 33.67622], [-117.76612, 33.67667]]]} | Open Access 1 | Central Bark | 17045 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.186 | Central Bark | ||
| 2838 | 2838 | 2837 | {"type": "Polygon", "coordinates": [[[-117.817, 33.6335], [-117.81679, 33.63419], [-117.81523, 33.63392], [-117.81415, 33.63424], [-117.81405, 33.63482], [-117.8138, 33.63483], [-117.81329, 33.6346], [-117.81344, 33.63359], [-117.81313, 33.63353], [-117.81317, 33.63287], [-117.81436, 33.633], [-117.81478, 33.63303], [-117.81598, 33.63317], [-117.81644, 33.63328], [-117.817, 33.6335]]]} | Open Access 1 | Chaparral Park | 17129 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 10.45 | Chaparral Park | ||
| 2964 | 2964 | 2963 | {"type": "Polygon", "coordinates": [[[-117.75119, 33.72167], [-117.75027, 33.7226], [-117.75014, 33.72251], [-117.75, 33.72252], [-117.7486, 33.72155], [-117.75011, 33.72153], [-117.75056, 33.72156], [-117.75119, 33.72167]]]} | Open Access 1 | Citrusglen Park | 17289 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.72 | Citrusglen Park | ||
| 3095 | 3095 | 3094 | {"type": "Polygon", "coordinates": [[[-117.79666, 33.70592], [-117.79664, 33.70598], [-117.79635, 33.70627], [-117.79619, 33.70614], [-117.79468, 33.70508], [-117.79443, 33.70532], [-117.79308, 33.7044], [-117.79318, 33.70427], [-117.79187, 33.70334], [-117.79207, 33.70313], [-117.79214, 33.70311], [-117.79243, 33.70331], [-117.79264, 33.70349], [-117.79273, 33.70352], [-117.7928, 33.70351], [-117.79285, 33.70349], [-117.79292, 33.70342], [-117.79295, 33.70343], [-117.79348, 33.7038], [-117.79351, 33.70381], [-117.79358, 33.7039], [-117.7937, 33.70395], [-117.79381, 33.70402], [-117.79392, 33.7041], [-117.79402, 33.70421], [-117.79409, 33.70424], [-117.79418, 33.70425], [-117.79419, 33.70428], [-117.79472, 33.70465], [-117.79486, 33.70463], [-117.79492, 33.7047], [-117.79514, 33.70481], [-117.79662, 33.70585], [-117.79666, 33.70592]]]} | Open Access 1 | College Park | 17508 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 7.421 | College Park | ||
| 3107 | 3107 | 3106 | {"type": "Polygon", "coordinates": [[[-117.82591, 33.68843], [-117.82569, 33.68864], [-117.82544, 33.68883], [-117.82511, 33.68905], [-117.8249, 33.68915], [-117.82441, 33.68932], [-117.82382, 33.68946], [-117.82354, 33.6895], [-117.82297, 33.68955], [-117.82261, 33.68955], [-117.82202, 33.6895], [-117.82163, 33.68944], [-117.82136, 33.68937], [-117.821, 33.68924], [-117.82057, 33.68903], [-117.81908, 33.68801], [-117.81952, 33.68765], [-117.81976, 33.68748], [-117.82, 33.68734], [-117.82025, 33.6872], [-117.82072, 33.687], [-117.82085, 33.68701], [-117.82102, 33.68695], [-117.82109, 33.68686], [-117.8216, 33.68672], [-117.82327, 33.68646], [-117.82406, 33.68627], [-117.82456, 33.68608], [-117.82461, 33.68609], [-117.82498, 33.6867], [-117.82516, 33.68692], [-117.82537, 33.68713], [-117.82483, 33.68764], [-117.82591, 33.68843]]]} | Open Access 1 | Colonel Bill Barber Marine Corps Memorial Park | 17526 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 37.952 | Colonel Bill Barber Marine Corps Memorial Park | ||
| 3180 | 3180 | 3179 | {"type": "Polygon", "coordinates": [[[-117.77156, 33.70403], [-117.77163, 33.70412], [-117.77165, 33.7042], [-117.77163, 33.70443], [-117.77151, 33.70528], [-117.77148, 33.70543], [-117.7714, 33.70567], [-117.77112, 33.7056], [-117.77078, 33.70554], [-117.77069, 33.70546], [-117.77061, 33.70546], [-117.77055, 33.70549], [-117.77034, 33.70526], [-117.77156, 33.70403]]]} | Open Access 1 | Coralwood Park | 17633 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.798 | Coralwood Park | ||
| 3306 | 3306 | 3305 | {"type": "Polygon", "coordinates": [[[-117.79034, 33.67353], [-117.7903, 33.6736], [-117.79023, 33.67359], [-117.79005, 33.67382], [-117.78944, 33.67348], [-117.7898, 33.6732], [-117.79034, 33.67353]]]} | Open Access 1 | Creekview Park | 17787 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 0.68 | Creekview Park | ||
| 3375 | 3375 | 3374 | {"type": "Polygon", "coordinates": [[[-117.83152, 33.67279], [-117.83133, 33.67315], [-117.83052, 33.67296], [-117.83016, 33.67265], [-117.82986, 33.67252], [-117.82273, 33.67034], [-117.823, 33.6703], [-117.82332, 33.6703], [-117.82367, 33.67033], [-117.8246, 33.67054], [-117.83152, 33.67279]]]} | Open Access 1 | Culverdale Wilderness Park | 17856 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 7.091 | Culverdale Wilderness Park | ||
| 3513 | 3513 | 3512 | {"type": "Polygon", "coordinates": [[[-117.79385, 33.69078], [-117.79381, 33.69084], [-117.79257, 33.69208], [-117.79239, 33.69222], [-117.79235, 33.69228], [-117.79235, 33.69234], [-117.79224, 33.69234], [-117.79206, 33.69251], [-117.79072, 33.69157], [-117.79092, 33.69136], [-117.79099, 33.69135], [-117.79104, 33.69131], [-117.79118, 33.69114], [-117.7925, 33.68983], [-117.79254, 33.68983], [-117.79257, 33.68985], [-117.79279, 33.6901], [-117.79298, 33.69026], [-117.79338, 33.69052], [-117.79383, 33.69074], [-117.79385, 33.69078]]]} | Open Access 1 | Deerfield Community Park | 18008 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 10.245 | Deerfield Community Park | ||
| 3690 | 3690 | 3689 | {"type": "Polygon", "coordinates": [[[-117.78277, 33.6636], [-117.78243, 33.66392], [-117.78272, 33.66416], [-117.7826, 33.66428], [-117.78273, 33.66438], [-117.78253, 33.66457], [-117.78248, 33.66456], [-117.78175, 33.66524], [-117.78151, 33.66504], [-117.78119, 33.66474], [-117.781, 33.66452], [-117.78071, 33.66412], [-117.78148, 33.66335], [-117.78185, 33.66295], [-117.78277, 33.6636]]]} | Open Access 1 | Dovecreek Park | 18250 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 6.681 | Dovecreek Park | ||
| 4255 | 4255 | 4254 | {"type": "Polygon", "coordinates": [[[-117.79707, 33.70016], [-117.79689, 33.70036], [-117.79686, 33.70044], [-117.79687, 33.70049], [-117.79677, 33.70052], [-117.7967, 33.70048], [-117.79666, 33.70047], [-117.79649, 33.70063], [-117.79647, 33.70062], [-117.79639, 33.70077], [-117.79622, 33.70094], [-117.79604, 33.70079], [-117.7955, 33.70028], [-117.79537, 33.70008], [-117.79535, 33.69985], [-117.79538, 33.69985], [-117.79556, 33.69966], [-117.79612, 33.70005], [-117.7964, 33.70021], [-117.79662, 33.70038], [-117.79669, 33.70036], [-117.79698, 33.70006], [-117.79706, 33.70012], [-117.79707, 33.70016]]]} | Open Access 1 | Flagstone Park | 18936 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.212 | Flagstone Park | ||
| 4324 | 4324 | 4323 | {"type": "Polygon", "coordinates": [[[-117.83137, 33.6759], [-117.83143, 33.67615], [-117.83143, 33.67634], [-117.83138, 33.67665], [-117.83126, 33.67707], [-117.83108, 33.6774], [-117.83082, 33.67732], [-117.83104, 33.67696], [-117.83113, 33.67673], [-117.83121, 33.67648], [-117.83122, 33.67629], [-117.8312, 33.6759], [-117.83137, 33.6759]]]} | Open Access 1 | Irvine holding 16 | 20245 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 0.872 | Irvine holding 16 | ||
| 4325 | 4325 | 4324 | {"type": "Polygon", "coordinates": [[[-117.77295, 33.68528], [-117.76975, 33.68834], [-117.76927, 33.68793], [-117.77229, 33.68487], [-117.77295, 33.68528]]]} | Open Access 1 | Irvine holding 21 | 20251 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 7.652 | Irvine holding 21 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps(
id INT,
map,
ACCESS_TYP INT,
PARK_NAME TEXT,
PARK_URL TEXT,
SUID_NMA INT,
MNG_AG_ID INT,
MNG_AGENCY INT,
MNG_AG_LEV INT,
MNG_AG_TYP INT,
AGNCY_WEB TEXT,
LAYER INT,
ACRES REAL,
LABEL_NAME TEXT,
YR_EST INT,
FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id])
);
CREATE INDEX [idx_superunits_with_maps_LAYER]
ON [superunits_with_maps] ([LAYER]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP]
ON [superunits_with_maps] ([MNG_AG_TYP]);
CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV]
ON [superunits_with_maps] ([MNG_AG_LEV]);
CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY]
ON [superunits_with_maps] ([MNG_AGENCY]);
CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP]
ON [superunits_with_maps] ([ACCESS_TYP]);