superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
98 rows where MNG_AGENCY = 266 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13244 | 13244 | 13243 | {"type": "Polygon", "coordinates": [[[-117.82541, 33.62489], [-117.82527, 33.62514], [-117.82498, 33.62504], [-117.82473, 33.62498], [-117.82493, 33.62461], [-117.8253, 33.62454], [-117.82541, 33.62489]]]} | Open Access 1 | Bommer Vista Point Park | 33408 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 0.661 | Bommer Vista Point 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 | ||
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 | ||
5393 | 5393 | 5392 | {"type": "Polygon", "coordinates": [[[-117.78659, 33.67147], [-117.78576, 33.67228], [-117.78562, 33.67234], [-117.78546, 33.67232], [-117.78633, 33.67136], [-117.78659, 33.67147]]]} | Open Access 1 | Irvine holding 24 | 20254 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 0.731 | Irvine holding 24 | ||
5394 | 5394 | 5393 | {"type": "Polygon", "coordinates": [[[-117.78567, 33.6724], [-117.78473, 33.67331], [-117.7845, 33.67323], [-117.78517, 33.67247], [-117.78547, 33.67249], [-117.78558, 33.67238], [-117.78567, 33.6724]]]} | Open Access 1 | Irvine holding 25 | 20255 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 0.741 | Irvine holding 25 | ||
5385 | 5385 | 5384 | {"type": "Polygon", "coordinates": [[[-117.75006, 33.70045], [-117.75004, 33.70051], [-117.74995, 33.70056], [-117.74985, 33.70067], [-117.74979, 33.70068], [-117.74977, 33.7007], [-117.74977, 33.70073], [-117.74983, 33.70073], [-117.74972, 33.70083], [-117.74968, 33.70083], [-117.74962, 33.7008], [-117.74957, 33.70074], [-117.7492, 33.70051], [-117.74918, 33.70045], [-117.74945, 33.70019], [-117.7495, 33.70012], [-117.74954, 33.7001], [-117.74959, 33.70011], [-117.74966, 33.70017], [-117.74994, 33.70038], [-117.75004, 33.70042], [-117.75006, 33.70045]]]} | Open Access 1 | Irvine holding 2 | 20249 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 0.858 | Irvine holding 2 | ||
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 | ||
5404 | 5404 | 5403 | {"type": "Polygon", "coordinates": [[[-117.7619, 33.65817], [-117.76161, 33.65818], [-117.76142, 33.65812], [-117.76107, 33.65789], [-117.76088, 33.65788], [-117.76065, 33.65783], [-117.76042, 33.65775], [-117.76, 33.65766], [-117.76008, 33.65751], [-117.76077, 33.6577], [-117.76132, 33.65782], [-117.76189, 33.65787], [-117.7619, 33.65817]]]} | Open Access 1 | Irvine holding 31 | 20262 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 0.95 | Irvine holding 31 | ||
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 | ||
5384 | 5384 | 5383 | {"type": "Polygon", "coordinates": [[[-117.78292, 33.69678], [-117.78255, 33.69714], [-117.78266, 33.69726], [-117.78264, 33.69728], [-117.78248, 33.69721], [-117.78198, 33.69769], [-117.7821, 33.69782], [-117.78207, 33.69784], [-117.78191, 33.69776], [-117.78142, 33.69825], [-117.78142, 33.69827], [-117.78154, 33.69837], [-117.78152, 33.69839], [-117.78136, 33.69831], [-117.78086, 33.6988], [-117.78087, 33.69882], [-117.78098, 33.69892], [-117.78096, 33.69894], [-117.7808, 33.69887], [-117.78042, 33.69927], [-117.78031, 33.69919], [-117.78044, 33.69904], [-117.78048, 33.69905], [-117.78231, 33.69719], [-117.78242, 33.6972], [-117.78248, 33.69717], [-117.78252, 33.69714], [-117.78257, 33.69702], [-117.78269, 33.69689], [-117.78282, 33.69681], [-117.78292, 33.69678]]]} | Open Access 1 | Irvine holding 19 | 20248 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1.046 | Irvine holding 19 | ||
8540 | 8540 | 8539 | {"type": "Polygon", "coordinates": [[[-117.83103, 33.66472], [-117.831, 33.66474], [-117.8309, 33.665], [-117.83032, 33.66485], [-117.83023, 33.66356], [-117.83051, 33.66373], [-117.83055, 33.66446], [-117.83101, 33.66446], [-117.83103, 33.66472]]]} | Open Access 1 | Rancho San Joaquin Community Park | 24172 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1.367 | Rancho San Joaquin Community Park | ||
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 | ||
9518 | 9518 | 9517 | {"type": "Polygon", "coordinates": [[[-117.82719, 33.63112], [-117.82621, 33.63118], [-117.82627, 33.63102], [-117.82636, 33.63057], [-117.82638, 33.63043], [-117.82687, 33.6304], [-117.82712, 33.63051], [-117.82719, 33.63112]]]} | Open Access 1 | Sepulveda Vista Point | 25308 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1.538 | Sepulveda Vista Point | ||
5403 | 5403 | 5402 | {"type": "Polygon", "coordinates": [[[-117.83143, 33.67563], [-117.83123, 33.6757], [-117.83111, 33.67534], [-117.83103, 33.67494], [-117.83089, 33.67409], [-117.83092, 33.6736], [-117.8311, 33.6731], [-117.83133, 33.67316], [-117.83119, 33.67365], [-117.83119, 33.67456], [-117.83127, 33.67498], [-117.83137, 33.67533], [-117.83143, 33.67563]]]} | Open Access 1 | Irvine holding 30 | 20261 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1.639 | Irvine holding 30 | ||
8479 | 8479 | 8478 | {"type": "Polygon", "coordinates": [[[-117.81469, 33.63844], [-117.81459, 33.6385], [-117.81419, 33.63862], [-117.81406, 33.63857], [-117.81395, 33.63861], [-117.81359, 33.63844], [-117.81361, 33.63826], [-117.81357, 33.63791], [-117.81388, 33.63786], [-117.814, 33.63768], [-117.8144, 33.63777], [-117.81466, 33.6381], [-117.81469, 33.63844]]]} | Open Access 1 | Ralph C Bren Memorial Park | 24098 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 1.993 | Ralph C Bren Memorial Park | ||
8158 | 8158 | 8157 | {"type": "Polygon", "coordinates": [[[-117.75764, 33.70435], [-117.75725, 33.70458], [-117.75723, 33.70464], [-117.75713, 33.70465], [-117.75709, 33.70469], [-117.75707, 33.70475], [-117.75701, 33.70474], [-117.75653, 33.705], [-117.75652, 33.70506], [-117.75644, 33.70506], [-117.7564, 33.70509], [-117.75635, 33.70514], [-117.75628, 33.70514], [-117.7558, 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 | Pinewood Park | 23693 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.053 | Pinewood 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 | ||
8456 | 8456 | 8455 | {"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.77889, 33.71279], [-117.77914, 33.71297]]]} | Open Access 1 | Racquet Club Park | 24067 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.082 | Racquet Club Park | ||
5406 | 5406 | 5405 | {"type": "Polygon", "coordinates": [[[-117.76951, 33.68855], [-117.76951, 33.68855], [-117.76852, 33.68958], [-117.76819, 33.68897], [-117.76902, 33.68816], [-117.76951, 33.68855]]]} | Open Access 1 | Irvine holding 4 | 20266 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | http://www.ci.irvine.ca.us/cityhall/cs/commparks/default.asp | City 2 | 2.118 | Irvine holding 4 | ||
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 |
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]);