units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where MNG_AGENCY = 266 sorted by ACRES
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12770 | 12770 | 12769 | {"type": "Polygon", "coordinates": [[[-117.78119, 33.73044], [-117.78104, 33.7306], [-117.78064, 33.73033], [-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 | 30202 | Homestead Park | 20063 | 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.07 | Homestead 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 | |
13538 | 13538 | 13537 | {"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 | 35844 | Irvine holding 4 | 20266 | 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.119 | Irvine holding 4 | 0 | Local Other or Unknown 14 | 4 | |
14643 | 14643 | 14642 | {"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 | 44891 | Central Bark | 17045 | 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.187 | Central Bark | None 1249 | |||
11155 | 11155 | 11154 | {"type": "Polygon", "coordinates": [[[-117.71514, 33.7026], [-117.71503, 33.70272], [-117.71348, 33.70165], [-117.71319, 33.70188], [-117.71283, 33.70221], [-117.71279, 33.70214], [-117.71274, 33.70194], [-117.71273, 33.70165], [-117.71268, 33.70136], [-117.71281, 33.70133], [-117.71297, 33.70113], [-117.71496, 33.70241], [-117.715, 33.70239], [-117.71508, 33.70244], [-117.71514, 33.7026]]]} | Open Access 1 | 48695 | Orchard Trail Park | 33407 | 6128 | Portola Springs Community Association 967 | Private 7 | Home Owners Association 16 | https://portolasprings.org/ | Private 14 | 1148 | Irvine, City of 266 | City 2 | City Agency 2 | Orange 3 | 2.227 | Orchard Trail Park | 0 | Local Park 2 | 4 | |
1694 | 1694 | 1693 | {"type": "Polygon", "coordinates": [[[-117.78468, 33.69615], [-117.78458, 33.69625], [-117.78392, 33.6958], [-117.78367, 33.69605], [-117.78377, 33.69614], [-117.78375, 33.69616], [-117.78362, 33.6961], [-117.78338, 33.69634], [-117.78339, 33.69637], [-117.78313, 33.69662], [-117.78299, 33.6966], [-117.78294, 33.69647], [-117.7828, 33.6963], [-117.783, 33.69609], [-117.78292, 33.69602], [-117.78319, 33.69576], [-117.7832, 33.69571], [-117.78345, 33.69547], [-117.78334, 33.69537], [-117.78217, 33.69454], [-117.78198, 33.69449], [-117.78203, 33.69437], [-117.78209, 33.6943], [-117.78234, 33.69449], [-117.78233, 33.69452], [-117.78397, 33.69566], [-117.78408, 33.6956], [-117.7841, 33.69562], [-117.78403, 33.69572], [-117.78457, 33.6961], [-117.78463, 33.69609], [-117.78468, 33.69615]]]} | Open Access 1 | 12756 | Willows Park | 27594 | 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.596 | Willows Park | 0 | Local Park 2 | 4 | |
13583 | 13583 | 13582 | {"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 | 35917 | Irvine holding 33 | 20264 | 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.659 | Irvine holding 33 | 0 | Local Other or Unknown 14 | 4 | |
826 | 826 | 825 | {"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.7608, 33.70374], [-117.76049, 33.70352], [-117.76146, 33.70258], [-117.76214, 33.70303]]]} | Open Access 1 | 5451 | Blue Gum Park | 16176 | 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.69 | Blue Gum Park | 0 | Local Park 2 | 4 | |
10286 | 10286 | 10285 | {"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 | 18133 | Coralwood Park | 17633 | 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.798 | Coralwood 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 | |
1233 | 1233 | 1232 | {"type": "Polygon", "coordinates": [[[-117.7808, 33.69515], [-117.78058, 33.69552], [-117.78043, 33.69574], [-117.78018, 33.69602], [-117.77968, 33.69653], [-117.77962, 33.69653], [-117.77956, 33.6965], [-117.77908, 33.69618], [-117.78028, 33.69497], [-117.7808, 33.69515]]]} | Open Access 1 | 8919 | Presley Park | 23995 | 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.887 | Presley Park | 0 | Local Park 2 | 4 | |
13582 | 13582 | 13581 | {"type": "Polygon", "coordinates": [[[-117.8353, 33.67402], [-117.83521, 33.67442], [-117.83504, 33.6743], [-117.83174, 33.6732], [-117.83183, 33.67292], [-117.8353, 33.67402]]]} | Open Access 1 | 35916 | Irvine holding 32 | 20263 | 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.024 | Irvine holding 32 | 0 | Local Other or Unknown 14 | 4 | |
2446 | 2446 | 2445 | {"type": "Polygon", "coordinates": [[[-117.76119, 33.70774], [-117.76076, 33.70816], [-117.76051, 33.70835], [-117.76025, 33.70817], [-117.76017, 33.70825], [-117.75947, 33.70777], [-117.75971, 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 | 12173 | Carrotwood Park | 16920 | 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.091 | Carrotwood Park | 0 | Local Park 2 | 4 | |
7751 | 7751 | 7750 | {"type": "Polygon", "coordinates": [[[-117.7672, 33.70657], [-117.76702, 33.70679], [-117.76688, 33.70675], [-117.76679, 33.70675], [-117.76672, 33.70678], [-117.76664, 33.70687], [-117.76658, 33.70705], [-117.76652, 33.70706], [-117.76539, 33.70628], [-117.76536, 33.70625], [-117.76535, 33.70622], [-117.76558, 33.70597], [-117.76559, 33.70591], [-117.76558, 33.70584], [-117.76581, 33.70561], [-117.7672, 33.70657]]]} | Open Access 1 | 8318 | Pepperwood Park | 23600 | 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.11 | Pepperwood Park | 0 | Local Park 2 | 4 | |
1596 | 1596 | 1595 | {"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 | 12168 | Canyon Park | 16824 | 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.434 | Canyon Park | 0 | Local Park 2 | 4 | |
2450 | 2450 | 2449 | {"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 | 12181 | Citrusglen Park | 17289 | 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.72 | Citrusglen Park | 0 | Local Park 2 | 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 | |
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 | |
13499 | 13499 | 13498 | {"type": "Polygon", "coordinates": [[[-117.75437, 33.70597], [-117.75271, 33.70675], [-117.75166, 33.70713], [-117.75164, 33.70707], [-117.75344, 33.70529], [-117.75437, 33.70597]]]} | Open Access 1 | 35784 | Irvine holding 9 | 20270 | 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.154 | Irvine holding 9 | 0 | Local Other or Unknown 14 | 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 |
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]);