units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where DES_TP = 14 and MNG_AGENCY = 266 sorted by ACRES
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 29
MNG_AGENCY 1
- Irvine, City of · 29 ✖
DES_TP 1
- Local Other or Unknown · 29 ✖
ACCESS_TYP 1
- Open Access 29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13407 | 13407 | 13406 | {"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 | 35519 | Irvine holding 24 | 20254 | 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 | 0.731 | Irvine holding 24 | 0 | Local Other or Unknown 14 | 4 | |
13412 | 13412 | 13411 | {"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 | 35522 | Irvine holding 25 | 20255 | 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 | 0.741 | Irvine holding 25 | 0 | Local Other or Unknown 14 | 4 | |
13492 | 13492 | 13491 | {"type": "Polygon", "coordinates": [[[-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.74965, 33.70017], [-117.74995, 33.70038], [-117.75004, 33.70042], [-117.75006, 33.70045], [-117.75004, 33.70051], [-117.74995, 33.70056], [-117.74985, 33.70067]]]} | Open Access 1 | 35779 | Irvine holding 2 | 20249 | 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 | 0.858 | Irvine holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13557 | 13557 | 13556 | {"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 | 35872 | Irvine holding 16 | 20245 | 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 | 0.872 | Irvine holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13555 | 13555 | 13554 | {"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 | 35912 | Irvine holding 31 | 20262 | 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 | 0.95 | Irvine holding 31 | 0 | Local Other or Unknown 14 | 4 | |
13512 | 13512 | 13511 | {"type": "Polygon", "coordinates": [[[-117.78292, 33.69678], [-117.78254, 33.69715], [-117.78266, 33.69726], [-117.78264, 33.69728], [-117.78249, 33.69721], [-117.78198, 33.6977], [-117.7821, 33.69782], [-117.78207, 33.69784], [-117.78192, 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.69881], [-117.78086, 33.69882], [-117.78098, 33.69892], [-117.78096, 33.69894], [-117.78081, 33.69886], [-117.78042, 33.69927], [-117.78031, 33.69919], [-117.78044, 33.69904], [-117.78047, 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 | 35803 | Irvine holding 19 | 20248 | 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 | 1.037 | Irvine holding 19 | 0 | Local Other or Unknown 14 | 4 | |
13491 | 13491 | 13490 | {"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.66823], [-117.78984, 33.66792], [-117.79065, 33.66712], [-117.79077, 33.66722]]]} | Open Access 1 | 35778 | Irvine holding 1 | 20238 | 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 | 1.522 | Irvine holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13569 | 13569 | 13568 | {"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.67364], [-117.83119, 33.67456], [-117.83127, 33.67498], [-117.83137, 33.67533], [-117.83143, 33.67563]]]} | Open Access 1 | 35913 | Irvine holding 30 | 20261 | 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 | 1.639 | Irvine holding 30 | 0 | Local Other or Unknown 14 | 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 | |
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 | |
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 | |
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 | |
12866 | 12866 | 12865 | {"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 | 35914 | Irvine holding 21 | 20251 | 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 | 7.653 | Irvine holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13515 | 13515 | 13514 | {"type": "Polygon", "coordinates": [[[-117.78515, 33.68914], [-117.78474, 33.68958], [-117.78336, 33.69101], [-117.78269, 33.69169], [-117.78253, 33.69155], [-117.77583, 33.6869], [-117.77623, 33.68652], [-117.78293, 33.69117], [-117.78514, 33.68913], [-117.78515, 33.68914]]]} | Open Access 1 | 35806 | Irvine holding 22 | 20252 | 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 | 12.376 | Irvine holding 22 | 0 | Local Other or Unknown 14 | 4 | |
13514 | 13514 | 13513 | {"type": "Polygon", "coordinates": [[[-117.80121, 33.70223], [-117.79981, 33.70359], [-117.7935, 33.69912], [-117.79623, 33.69641], [-117.79642, 33.69642], [-117.7941, 33.69898], [-117.79535, 33.69986], [-117.79537, 33.70008], [-117.7955, 33.70028], [-117.79604, 33.70079], [-117.79621, 33.70094], [-117.79639, 33.70077], [-117.79646, 33.70062], [-117.79971, 33.7029], [-117.80074, 33.7019], [-117.80121, 33.70223]]]} | Open Access 1 | 35805 | Irvine holding 23 | 20253 | 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 | 12.696 | Irvine holding 23 | 0 | Local Other or Unknown 14 | 4 | |
13414 | 13414 | 13413 | {"type": "Polygon", "coordinates": [[[-117.78445, 33.67361], [-117.78185, 33.6762], [-117.78054, 33.67755], [-117.77874, 33.67928], [-117.77823, 33.67892], [-117.78126, 33.67592], [-117.78385, 33.67328], [-117.78445, 33.67361]]]} | Open Access 1 | 35525 | Irvine holding 27 | 20257 | 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 | 12.985 | Irvine holding 27 | 0 | Local Other or Unknown 14 | 4 | |
12622 | 12622 | 12621 | {"type": "Polygon", "coordinates": [[[-117.77841, 33.67962], [-117.77312, 33.68506], [-117.77251, 33.68462], [-117.77792, 33.67926], [-117.77841, 33.67962]]]} | Open Access 1 | 35835 | Irvine holding 3 | 20260 | 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 | 12.992 | Irvine holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13495 | 13495 | 13494 | {"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.78343, 33.69152], [-117.78457, 33.69234], [-117.79266, 33.69796], [-117.79343, 33.69851], [-117.79476, 33.69731], [-117.79481, 33.69739]]]} | Open Access 1 | 35782 | Irvine holding 10 | 20239 | 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 | 17.552 | Irvine holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13581 | 13581 | 13580 | {"type": "Polygon", "coordinates": [[[-117.82618, 33.62079], [-117.82531, 33.62145], [-117.82379, 33.62061], [-117.82443, 33.62051], [-117.82478, 33.62026], [-117.82498, 33.61989], [-117.82509, 33.61926], [-117.82491, 33.61905], [-117.82477, 33.61886], [-117.82468, 33.61853], [-117.82468, 33.61806], [-117.82476, 33.61702], [-117.82445, 33.61717], [-117.82345, 33.61752], [-117.82274, 33.61757], [-117.82201, 33.6176], [-117.82157, 33.61755], [-117.82103, 33.61764], [-117.82074, 33.61773], [-117.82058, 33.6171], [-117.82105, 33.61684], [-117.82151, 33.61674], [-117.82196, 33.61684], [-117.82232, 33.61688], [-117.82271, 33.61698], [-117.82322, 33.61703], [-117.82374, 33.61671], [-117.82405, 33.61637], [-117.82432, 33.61626], [-117.82473, 33.61636], [-117.82497, 33.61655], [-117.82524, 33.61666], [-117.82549, 33.61668], [-117.8257, 33.61658], [-117.82578, 33.61658], [-117.82593, 33.61808], [-117.82596, 33.61921], [-117.82618, 33.62079]]]} | Open Access 1 | 35915 | Irvine holding 28 | 20258 | 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 | 22.328 | Irvine holding 28 | 0 | Local Other or Unknown 14 | 4 | |
13501 | 13501 | 13500 | {"type": "Polygon", "coordinates": [[[-117.81321, 33.64251], [-117.81302, 33.64277], [-117.81281, 33.64297], [-117.81241, 33.64324], [-117.81217, 33.64336], [-117.81034, 33.644], [-117.80987, 33.64413], [-117.80942, 33.64423], [-117.80844, 33.64442], [-117.80836, 33.64437], [-117.80828, 33.64415], [-117.80819, 33.64398], [-117.80804, 33.64378], [-117.80767, 33.64338], [-117.80736, 33.64317], [-117.80679, 33.64284], [-117.80642, 33.64263], [-117.80633, 33.64255], [-117.80619, 33.64244], [-117.80578, 33.64201], [-117.80533, 33.64158], [-117.80517, 33.64139], [-117.80482, 33.64112], [-117.80442, 33.6409], [-117.80462, 33.64049], [-117.80467, 33.64034], [-117.80476, 33.63961], [-117.80482, 33.63946], [-117.80491, 33.63934], [-117.80509, 33.6392], [-117.80533, 33.63909], [-117.80545, 33.63906], [-117.80563, 33.63904], [-117.80585, 33.63905], [-117.80512, 33.63939], [-117.80504, 33.63949], [-117.80495, 33.63984], [-117.80492, 33.64023], [-117.80485, 33.64024], [-117.80481, 33.64043], [-117.80486, 33.64061], [-117.80499, 33.64069], [-117.80503, 33.64082], [-117.80535, 33.64094], [-117.80566, 33.64082], [-117.80575, 33.64095], [-117.80593, 33.64088], [-117.80608, 33.6407], [-117.8061, 33.64066], [-117.80615, 33.64065], [-117.80617, 33.64062], [-117.80682, 33.64088], [-117.8069, 33.64136], [-117.80705, 33.64158], [-117.80725, 33.64149], [-117.80731, 33.64153], [-117.80742, 33.64153], [-117.80748, 33.6415], [-117.80751, 33.64146], [-117.80833, 33.64167], [-117.80846, 33.64189], [-117.80866, 33.64194], [-117.80863, 33.64213], [-117.80892, 33.64247], [-117.80872, 33.64264], [-117.80896, 33.64289], [-117.8089, 33.64325], [-117.80917, 33.64342], [-117.80939, 33.64348], [-117.80962, 33.64351], [-117.8097, 33.64362], [-117.80983, 33.64373], [-117.81002, 33.64371], [-117.81051, 33.64356], [-117.81073, 33.64336], [-117.81107, 33.6433], [-117.81158, 33.64308], [-117.81179, 33.64316], [-117.81224, 33.64304], [-117.81256, 33.64285], [-117.81267, 33.64283], [-117.81321, 33.64251]]]} | Open Access 1 | 35785 | Irvine holding 12 | 20241 | 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 | 23.017 | Irvine holding 12 | 0 | Local Other or Unknown 14 | 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]);