superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
98 rows where MNG_AGENCY = 266 sorted by ACCESS_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
4938 | 4938 | 4937 | {"type": "MultiPolygon", "coordinates": [[[[-117.80234, 33.70103], [-117.80135, 33.70203], [-117.80127, 33.702], [-117.80126, 33.70198], [-117.8009, 33.70174], [-117.80202, 33.70065], [-117.80226, 33.70095], [-117.80234, 33.70103]]], [[[-117.80509, 33.69821], [-117.80475, 33.69858], [-117.80343, 33.69991], [-117.80262, 33.70065], [-117.80253, 33.7006], [-117.80232, 33.7003], [-117.80472, 33.69788], [-117.80495, 33.69803], [-117.80508, 33.69813], [-117.80509, 33.69821]]], [[[-117.81234, 33.69243], [-117.81224, 33.69249], [-117.81107, 33.69284], [-117.81049, 33.69311], [-117.81021, 33.69326], [-117.80983, 33.69354], [-117.80921, 33.69405], [-117.80835, 33.69488], [-117.80592, 33.69736], [-117.80528, 33.69796], [-117.80487, 33.69768], [-117.80662, 33.69598], [-117.80771, 33.69487], [-117.80827, 33.69466], [-117.80911, 33.69378], [-117.80955, 33.69341], [-117.80989, 33.69319], [-117.81018, 33.69302], [-117.8106, 33.69281], [-117.81076, 33.69271], [-117.81092, 33.69265], [-117.81149, 33.69246], [-117.81184, 33.69237], [-117.8123, 33.69228], [-117.81234, 33.69243]]], [[[-117.81821, 33.68858], [-117.8159, 33.69082], [-117.81523, 33.6914], [-117.81484, 33.69165], [-117.8145, 33.69184], [-117.81401, 33.69206], [-117.81367, 33.69218], [-117.81288, 33.69237], [-117.81274, 33.69234], [-117.81268, 33.69218], [-117.81322, 33.69206], [-117.81382, 33.69189], [-117.81415, 33.69176], [-117.81448, 33.6916], [-117.81491, 33.69134], [-117.81526, 33.69109], [-117.81542, 33.69095], [-117.81809, 33.68842], [-117.81819, 33.68848], [-117.81821, 33.68858]]]]} | Open Access 1 | Harvard Avenue Bike Path | 19714 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 18.357 | Harvard Avenue Bike Path | ||
4939 | 4939 | 4938 | {"type": "Polygon", "coordinates": [[[-117.80197, 33.70714], [-117.80175, 33.70745], [-117.80131, 33.7079], [-117.79986, 33.70899], [-117.79916, 33.70961], [-117.79838, 33.71045], [-117.79672, 33.71026], [-117.79707, 33.70831], [-117.79725, 33.70768], [-117.79754, 33.7069], [-117.7979, 33.70702], [-117.79818, 33.70707], [-117.80197, 33.70714]]]} | Open Access 1 | Harvard Community Athletic Park | 19715 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 26.773 | Harvard Community Athletic Park | ||
5061 | 5061 | 5060 | {"type": "Polygon", "coordinates": [[[-117.78086, 33.70027], [-117.78075, 33.70072], [-117.7807, 33.7008], [-117.7806, 33.70085], [-117.78027, 33.70086], [-117.78023, 33.70088], [-117.78016, 33.70097], [-117.77979, 33.70281], [-117.77977, 33.70299], [-117.77956, 33.70288], [-117.77939, 33.70284], [-117.77925, 33.70283], [-117.77909, 33.70284], [-117.77894, 33.70289], [-117.77872, 33.7031], [-117.77862, 33.7033], [-117.7785, 33.70404], [-117.77844, 33.70421], [-117.77816, 33.70418], [-117.77764, 33.70341], [-117.77759, 33.70343], [-117.77669, 33.70213], [-117.7772, 33.70185], [-117.7765, 33.70075], [-117.77767, 33.69954], [-117.77828, 33.69995], [-117.77854, 33.69994], [-117.77909, 33.69938], [-117.77899, 33.69929], [-117.77925, 33.69903], [-117.78064, 33.69999], [-117.78059, 33.70007], [-117.78086, 33.70027]]]} | Open Access 1 | Heritage Park | 19850 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 30.629 | Heritage Park | ||
5104 | 5104 | 5103 | {"type": "Polygon", "coordinates": [[[-117.77216, 33.72465], [-117.77188, 33.72493], [-117.77189, 33.72518], [-117.77188, 33.7253], [-117.77184, 33.72544], [-117.77215, 33.72568], [-117.77145, 33.72639], [-117.77131, 33.72639], [-117.77106, 33.72619], [-117.77081, 33.72577], [-117.77063, 33.72553], [-117.77048, 33.72538], [-117.77025, 33.72522], [-117.7701, 33.72513], [-117.76989, 33.72504], [-117.76961, 33.72496], [-117.76876, 33.72484], [-117.76849, 33.72476], [-117.76815, 33.72458], [-117.76814, 33.72448], [-117.76855, 33.7241], [-117.76874, 33.72388], [-117.76968, 33.72299], [-117.76979, 33.72298], [-117.77216, 33.72465]]]} | Open Access 1 | Hicks Canyon Community Park | 19899 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 16.0 | Hicks Canyon Community Park | ||
5195 | 5195 | 5194 | {"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.68581], [-117.77619, 33.68487], [-117.77644, 33.68504], [-117.77653, 33.68497], [-117.77725, 33.68548]]]} | Open Access 1 | Hoeptner Park | 20020 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 8.3 | Hoeptner Park | ||
5230 | 5230 | 5229 | {"type": "Polygon", "coordinates": [[[-117.78119, 33.73044], [-117.78104, 33.7306], [-117.78063, 33.73034], [-117.78042, 33.73055], [-117.78042, 33.73057], [-117.78053, 33.73064], [-117.78014, 33.73105], [-117.78022, 33.73111], [-117.78025, 33.73115], [-117.78031, 33.73116], [-117.78044, 33.73125], [-117.7804, 33.73129], [-117.78037, 33.73128], [-117.77951, 33.73068], [-117.78034, 33.72981], [-117.78073, 33.73007], [-117.78074, 33.73012], [-117.78071, 33.7302], [-117.78071, 33.73029], [-117.78074, 33.73036], [-117.78079, 33.73042], [-117.78088, 33.73047], [-117.78098, 33.73049], [-117.78109, 33.73048], [-117.78119, 33.73044]]]} | Open Access 1 | Homestead Park | 20063 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.075 | Homestead Park | ||
5366 | 5366 | 5365 | {"type": "Polygon", "coordinates": [[[-117.8353, 33.67402], [-117.83521, 33.67442], [-117.83503, 33.6743], [-117.83174, 33.6732], [-117.83183, 33.67292], [-117.8353, 33.67402]]]} | Open Access 1 | Irvine holding 32 | 20263 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 3.023 | Irvine holding 32 | ||
5367 | 5367 | 5366 | {"type": "Polygon", "coordinates": [[[-117.7653, 33.65872], [-117.76509, 33.6588], [-117.76437, 33.65776], [-117.76351, 33.65795], [-117.76318, 33.65841], [-117.76248, 33.65813], [-117.76217, 33.65813], [-117.76223, 33.65785], [-117.76297, 33.65781], [-117.76335, 33.65777], [-117.76452, 33.65754], [-117.7653, 33.65872]]]} | Open Access 1 | Irvine holding 33 | 20264 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.665 | Irvine holding 33 | ||
5377 | 5377 | 5376 | {"type": "Polygon", "coordinates": [[[-117.79077, 33.66722], [-117.79076, 33.66729], [-117.79012, 33.66793], [-117.78977, 33.66824], [-117.78914, 33.66875], [-117.78855, 33.66932], [-117.78847, 33.66933], [-117.78834, 33.66929], [-117.78856, 33.66907], [-117.78946, 33.66819], [-117.78951, 33.66822], [-117.78984, 33.66792], [-117.79065, 33.66712], [-117.79077, 33.66722]]]} | Open Access 1 | Irvine holding 1 | 20238 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1.522 | Irvine holding 1 | ||
5378 | 5378 | 5377 | {"type": "Polygon", "coordinates": [[[-117.79481, 33.69739], [-117.7932, 33.699], [-117.79305, 33.69888], [-117.78658, 33.6943], [-117.78474, 33.69306], [-117.7829, 33.69179], [-117.78395, 33.69068], [-117.78459, 33.69008], [-117.78537, 33.68931], [-117.78544, 33.68934], [-117.78455, 33.69029], [-117.78344, 33.69152], [-117.78457, 33.69234], [-117.79342, 33.6985], [-117.79476, 33.69731], [-117.79481, 33.69739]]]} | Open Access 1 | Irvine holding 10 | 20239 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 17.447 | Irvine holding 10 |
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]);