units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
101 rows where MNG_AGENCY = 266
This data as json, copyable, CSV (advanced)
DES_TP 7
- Local Park 35
- Local Other or Unknown 29
- Local Recreation Area 6
- Local Conservation Area 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 74
MNG_AGENCY 1
- Irvine, City of · 74 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2763 | 2763 | 2762 | {"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.69025], [-117.79338, 33.69052], [-117.79383, 33.69074], [-117.79385, 33.69078]]]} | Open Access 1 | 18466 | Deerfield Community Park | 18008 | 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 | 10.245 | Deerfield Community Park | 0 | Local Park 2 | 4 | |
3011 | 3011 | 3010 | {"type": "Polygon", "coordinates": [[[-117.71297, 33.70113], [-117.71281, 33.70134], [-117.71268, 33.70136], [-117.71263, 33.70123], [-117.71255, 33.70111], [-117.71244, 33.70099], [-117.71233, 33.70091], [-117.71232, 33.70082], [-117.7124, 33.70073], [-117.71297, 33.70113]]]} | Open Access 1 | 48660 | Orchard Trail Park | 33407 | 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.424 | Orchard Trail Park | 0 | Local Park 2 | 4 | |
3012 | 3012 | 3011 | {"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 | 48661 | Bommer Vista Point Park | 33408 | 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.662 | Bommer Vista Point Park | 0 | Local Park 2 | 4 | |
3013 | 3013 | 3012 | {"type": "Polygon", "coordinates": [[[-117.75861, 33.68706], [-117.75734, 33.68834], [-117.75725, 33.68835], [-117.75724, 33.68826], [-117.75719, 33.68819], [-117.7558, 33.68722], [-117.75572, 33.6872], [-117.7556, 33.6872], [-117.7556, 33.68713], [-117.75688, 33.68585], [-117.75861, 33.68706]]]} | Open Access 1 | 48662 | Cypress Grove Park | 33409 | 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 | 9.424 | Cypress Grove Park | 0 | Local Park 2 | 4 | |
3699 | 3699 | 3698 | {"type": "Polygon", "coordinates": [[[-117.79034, 33.67353], [-117.7903, 33.6736], [-117.79023, 33.67358], [-117.79005, 33.67382], [-117.78944, 33.67348], [-117.7898, 33.6732], [-117.79034, 33.67353]]]} | Open Access 1 | 30201 | Creekview Park | 17787 | 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.679 | Creekview Park | 0 | Local Park 2 | 4 | |
4040 | 4040 | 4039 | {"type": "Polygon", "coordinates": [[[-117.76064, 33.73966], [-117.76012, 33.74012], [-117.75743, 33.73842], [-117.75801, 33.73776], [-117.75829, 33.73758], [-117.75908, 33.73774], [-117.7599, 33.7381], [-117.76039, 33.73872], [-117.76064, 33.73966]]]} | Open Access 1 | 44285 | Settlers Park | 25324 | 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 | 10.852 | Settlers Park | 0 | Local Park 2 | 4 | |
4326 | 4326 | 4325 | {"type": "Polygon", "coordinates": [[[-117.74192, 33.7062], [-117.74122, 33.70692], [-117.74093, 33.70719], [-117.74067, 33.70702], [-117.74058, 33.70702], [-117.74049, 33.70706], [-117.74046, 33.70705], [-117.73924, 33.7062], [-117.73914, 33.70618], [-117.73906, 33.70623], [-117.739, 33.70619], [-117.73902, 33.70615], [-117.7402, 33.70496], [-117.74022, 33.70497], [-117.74028, 33.70492], [-117.74123, 33.70558], [-117.74119, 33.70562], [-117.74119, 33.70563], [-117.7414, 33.70581], [-117.74192, 33.70617], [-117.74191, 33.70619], [-117.74192, 33.7062]]]} | Open Access 1 | 45461 | Stonegate Park | 28267 | 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 | http://www.cityofirvine.org/cityhall/cs/commparks/nparks/default.asp | Orange 3 | 8.581 | Stonegate Park | 0 | Local Park 2 | 4 |
4327 | 4327 | 4326 | {"type": "Polygon", "coordinates": [[[-117.76611, 33.69081], [-117.76411, 33.69277], [-117.76228, 33.69163], [-117.76216, 33.69146], [-117.76347, 33.69013], [-117.76434, 33.69078], [-117.76503, 33.69011], [-117.76611, 33.69081]]]} | Open Access 1 | 45463 | Cypress Community Park | 28273 | 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 | http://www.cityofirvine.org/cityhall/cs/commparks/cparks/cypress_community_park.asp | Orange 3 | 14.139 | Cypress Community Park | 0 | Local Park 2 | 4 |
5035 | 5035 | 5034 | {"type": "Polygon", "coordinates": [[[-117.75315, 33.69738], [-117.75187, 33.69866], [-117.75179, 33.69867], [-117.75168, 33.69878], [-117.75168, 33.69884], [-117.75097, 33.69955], [-117.75091, 33.69955], [-117.74986, 33.69882], [-117.75088, 33.6978], [-117.75088, 33.69779], [-117.75082, 33.69775], [-117.75203, 33.69654], [-117.75314, 33.69732], [-117.75315, 33.69734], [-117.75315, 33.69738]]]} | Open Access 1 | 48664 | Woodbury Community Park | 33411 | 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 | 10.743 | Woodbury Community 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 | |
6253 | 6253 | 6252 | {"type": "Polygon", "coordinates": [[[-117.76966, 33.71137], [-117.76791, 33.7131], [-117.76493, 33.71103], [-117.76786, 33.71016], [-117.76789, 33.71016], [-117.76966, 33.71137]]]} | Open Access 1 | 5992 | Northwood Community Park | 22899 | 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.728 | Northwood Community Park | 0 | Local Park 2 | 4 | |
6312 | 6312 | 6311 | {"type": "Polygon", "coordinates": [[[-117.79635, 33.70627], [-117.79619, 33.70614], [-117.79467, 33.70508], [-117.79443, 33.70532], [-117.79308, 33.7044], [-117.79319, 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.79281, 33.70351], [-117.79285, 33.70349], [-117.79292, 33.70342], [-117.79295, 33.70343], [-117.79348, 33.70381], [-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], [-117.79664, 33.70598], [-117.79635, 33.70627]]]} | Open Access 1 | 1481 | College Park | 17508 | 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.415 | College 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 | |
7834 | 7834 | 7833 | {"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 | 12279 | Comstock Park | 17573 | 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.03 | Comstock Park | 0 | Local Park 2 | 4 | |
8077 | 8077 | 8076 | {"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 | 12290 | Culverdale Wilderness Park | 17856 | 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.092 | Culverdale Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
8123 | 8123 | 8122 | {"type": "Polygon", "coordinates": [[[-117.78277, 33.6636], [-117.78242, 33.66392], [-117.78272, 33.66416], [-117.7826, 33.66428], [-117.78273, 33.66438], [-117.78253, 33.66457], [-117.78248, 33.66455], [-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 | 12295 | Dovecreek Park | 18250 | 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 | 6.676 | Dovecreek Park | 0 | Local Park 2 | 4 | |
8145 | 8145 | 8144 | {"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.70096], [-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.81414, 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 | 12326 | Harvard Avenue Bike Path | 19714 | 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 | 18.358 | Harvard Avenue Bike Path | 0 | Local Recreation Area 3 | 4 | |
8146 | 8146 | 8145 | {"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 | 12327 | Harvard Community Athletic Park | 19715 | 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 | 26.774 | Harvard Community Athletic Park | 0 | Local Recreation Area 3 | 4 | |
8150 | 8150 | 8149 | {"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.68582], [-117.77619, 33.68487], [-117.77644, 33.68504], [-117.77653, 33.68497], [-117.77725, 33.68548]]]} | Open Access 1 | 12331 | Hoeptner Park | 20020 | 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 | 8.29 | Hoeptner Park | 0 | Local Park 2 | 4 | |
8224 | 8224 | 8223 | {"type": "Polygon", "coordinates": [[[-117.77483, 33.7005], [-117.77383, 33.70109], [-117.77349, 33.70135], [-117.77324, 33.70159], [-117.77313, 33.70161], [-117.77247, 33.70114], [-117.77246, 33.70105], [-117.77341, 33.70011], [-117.77363, 33.70005], [-117.77372, 33.7], [-117.77381, 33.69988], [-117.77382, 33.6998], [-117.7738, 33.69968], [-117.7741, 33.69938], [-117.77483, 33.7005]]]} | Open Access 1 | 12533 | Orchard Park | 23190 | 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.831 | Orchard 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]);