units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 138
This data as json, copyable, CSV (advanced)
DES_TP 5
- Local Other or Unknown 17
- Local Park 15
- Local Recreation Area 2
- None 1
- None 1
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
- Orange, County of · 36 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12974 | 12974 | 12973 | {"type": "Polygon", "coordinates": [[[-117.70336, 33.46304], [-117.70315, 33.46314], [-117.70309, 33.46314], [-117.70304, 33.46313], [-117.70269, 33.46299], [-117.7024, 33.46291], [-117.70217, 33.46291], [-117.70183, 33.46292], [-117.70152, 33.46295], [-117.70114, 33.46296], [-117.70088, 33.4629], [-117.70063, 33.4628], [-117.7, 33.4624], [-117.6998, 33.46235], [-117.69981, 33.4623], [-117.6991, 33.46214], [-117.69895, 33.46208], [-117.69898, 33.46201], [-117.70336, 33.46304]]]} | Open Access 1 | 30536 | Dana Cove Park | 17908 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.383 | Dana Cove Park | 0 | Local Park 2 | 4 | |
12977 | 12977 | 12976 | {"type": "Polygon", "coordinates": [[[-117.78424, 33.86528], [-117.78305, 33.86527], [-117.78304, 33.8649], [-117.78267, 33.86486], [-117.78237, 33.86485], [-117.78238, 33.86457], [-117.78242, 33.86453], [-117.78244, 33.86454], [-117.78255, 33.86453], [-117.7837, 33.8643], [-117.78397, 33.86429], [-117.78402, 33.86476], [-117.78407, 33.86489], [-117.7841, 33.86489], [-117.78419, 33.86506], [-117.78423, 33.86516], [-117.78424, 33.86528]]]} | Open Access 1 | 30443 | Woodgate Park | 27710 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.092 | Woodgate Park | 0 | Local Park 2 | 4 | |
12982 | 12982 | 12981 | {"type": "Polygon", "coordinates": [[[-117.88557, 33.90604], [-117.88552, 33.9061], [-117.88537, 33.90606], [-117.88523, 33.90589], [-117.8851, 33.9056], [-117.88475, 33.90521], [-117.88437, 33.90554], [-117.88411, 33.9054], [-117.88466, 33.90489], [-117.88471, 33.90482], [-117.8847, 33.90456], [-117.88463, 33.90446], [-117.88463, 33.9043], [-117.88473, 33.90417], [-117.88498, 33.90406], [-117.8852, 33.90402], [-117.88534, 33.90411], [-117.88542, 33.90436], [-117.88526, 33.90474], [-117.88526, 33.90495], [-117.88544, 33.9058], [-117.88557, 33.90604]]]} | Open Access 1 | 30439 | Craig Regional Park | 17752 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.996 | Craig RP | 0 | Local Park 2 | 4 | |
12987 | 12987 | 12986 | {"type": "Polygon", "coordinates": [[[-117.95443, 33.73019], [-117.95436, 33.73026], [-117.95426, 33.73026], [-117.94777, 33.73043], [-117.94169, 33.73062], [-117.9416, 33.72608], [-117.94053, 33.72571], [-117.94052, 33.72461], [-117.94155, 33.72372], [-117.94153, 33.72203], [-117.94128, 33.72199], [-117.94098, 33.72168], [-117.94094, 33.72129], [-117.9419, 33.71991], [-117.94347, 33.71884], [-117.94402, 33.71875], [-117.94344, 33.71734], [-117.94412, 33.71715], [-117.94413, 33.71651], [-117.95425, 33.71643], [-117.95433, 33.71648], [-117.95437, 33.72142], [-117.95382, 33.72148], [-117.95241, 33.72317], [-117.95049, 33.72413], [-117.94943, 33.72413], [-117.94859, 33.72456], [-117.94665, 33.72493], [-117.94676, 33.72783], [-117.94853, 33.72841], [-117.94947, 33.7276], [-117.95442, 33.72763], [-117.95443, 33.73019]]]} | Restricted Access 2 | 30459 | Mile Square Golf Course | 33098 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 362.625 | Mile Square GC | 0 | Local Recreation Area 3 | 4 | |
12988 | 12988 | 12987 | {"type": "MultiPolygon", "coordinates": [[[[-117.94078, 33.72981], [-117.94076, 33.72992], [-117.94065, 33.72997], [-117.94042, 33.72998], [-117.94018, 33.72995], [-117.93999, 33.73001], [-117.93965, 33.73022], [-117.93923, 33.73019], [-117.93905, 33.73009], [-117.939, 33.73], [-117.93904, 33.72987], [-117.93924, 33.72965], [-117.93929, 33.72954], [-117.93926, 33.72947], [-117.93917, 33.7294], [-117.93901, 33.72944], [-117.93881, 33.72953], [-117.93866, 33.72957], [-117.93843, 33.7295], [-117.9382, 33.72936], [-117.93814, 33.72924], [-117.93813, 33.72902], [-117.93826, 33.72888], [-117.93844, 33.72881], [-117.93862, 33.72866], [-117.93864, 33.72849], [-117.9386, 33.72838], [-117.9386, 33.72826], [-117.93866, 33.72817], [-117.93888, 33.72811], [-117.93937, 33.72832], [-117.93961, 33.72845], [-117.93968, 33.72854], [-117.9397, 33.7287], [-117.93975, 33.72889], [-117.93986, 33.729], [-117.94003, 33.72911], [-117.94034, 33.72921], [-117.94056, 33.7293], [-117.94064, 33.7294], [-117.94071, 33.72968], [-117.94078, 33.72981]]], [[[-117.94051, 33.71887], [-117.94046, 33.71902], [-117.94034, 33.71915], [-117.94015, 33.71919], [-117.9399, 33.7192], [-117.93971, 33.71917], [-117.93953, 33.71918], [-117.93936, 33.7193], [-117.93932, 33.71929], [-117.93906, 33.71943], [-117.93888, 33.71943], [-117.93871, 33.71935], [-117.93864, 33.71924], [-117.93864, 33.71908], [-117.93877, 33.71885], [-117.93875, 33.71864], [-117.93877, 33.71852], [-117.93887, 33.71841], [-117.93923, 33.71842], [-117.93936, 33.71837], [-117.93944, 33.71815], [-117.93955, 33.71808], [-117.9397, 33.71805], [-117.93983, 33.71807], [-117.93998, 33.71812], [-117.94011, 33.71824], [-117.94014, 33.71842], [-117.9403, 33.71855], [-117.94046, 33.71864], [-117.94051, 33.71887]]]]} | Open Access 1 | 30460 | Mile Square Regional Park | 22217 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 11.59 | Mile Square RP | 0 | Local Park 2 | 4 | |
13370 | 13370 | 13369 | {"type": "Polygon", "coordinates": [[[-117.64456, 33.55733], [-117.64456, 33.55832], [-117.64446, 33.55917], [-117.64411, 33.55996], [-117.64407, 33.55994], [-117.64408, 33.55991], [-117.64401, 33.55988], [-117.64398, 33.55992], [-117.64392, 33.55989], [-117.64387, 33.55995], [-117.64407, 33.56004], [-117.64406, 33.56007], [-117.64384, 33.55998], [-117.64352, 33.55741], [-117.64456, 33.55733]]]} | Open Access 1 | 35454 | Orange holding 11 | 23158 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 5.148 | Orange holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13372 | 13372 | 13371 | {"type": "Polygon", "coordinates": [[[-117.63857, 33.57457], [-117.63787, 33.57431], [-117.63727, 33.57449], [-117.63726, 33.57438], [-117.63751, 33.574], [-117.63751, 33.57405], [-117.63754, 33.57408], [-117.63777, 33.57416], [-117.63788, 33.57415], [-117.63799, 33.57409], [-117.63806, 33.57413], [-117.63814, 33.57414], [-117.63825, 33.57418], [-117.63855, 33.57422], [-117.63857, 33.57457]]]} | Open Access 1 | 35456 | Orange holding 5 | 23172 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.869 | Orange holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13373 | 13373 | 13372 | {"type": "Polygon", "coordinates": [[[-117.63726, 33.57438], [-117.63727, 33.57449], [-117.63717, 33.57496], [-117.63702, 33.57514], [-117.63615, 33.57531], [-117.63567, 33.5756], [-117.63515, 33.57558], [-117.63505, 33.57537], [-117.63485, 33.57548], [-117.63422, 33.57516], [-117.63384, 33.57494], [-117.63357, 33.57506], [-117.63345, 33.57529], [-117.63341, 33.57524], [-117.63358, 33.57484], [-117.63367, 33.57479], [-117.63511, 33.57517], [-117.63594, 33.57518], [-117.63671, 33.5749], [-117.63726, 33.57438]]]} | Open Access 1 | 35457 | Orange holding 6 | 23173 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.925 | Orange holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13375 | 13375 | 13374 | {"type": "Polygon", "coordinates": [[[-117.63554, 33.54852], [-117.63528, 33.54875], [-117.63505, 33.549], [-117.63502, 33.54901], [-117.63462, 33.54878], [-117.6346, 33.54874], [-117.63495, 33.54837], [-117.63516, 33.54819], [-117.63522, 33.5482], [-117.63553, 33.5485], [-117.63554, 33.54852]]]} | Open Access 1 | 35459 | Orange holding 7 | 23174 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.006 | Orange holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13376 | 13376 | 13375 | {"type": "Polygon", "coordinates": [[[-117.62419, 33.69092], [-117.62398, 33.69096], [-117.62396, 33.69093], [-117.62376, 33.69096], [-117.62351, 33.69104], [-117.62298, 33.69101], [-117.62301, 33.69097], [-117.62305, 33.69074], [-117.6231, 33.69026], [-117.62314, 33.69005], [-117.62321, 33.6899], [-117.62345, 33.6895], [-117.62353, 33.68947], [-117.62395, 33.68963], [-117.62408, 33.69006], [-117.62399, 33.69007], [-117.62398, 33.69008], [-117.62419, 33.69092]]]} | Open Access 1 | 35460 | Orange holding 8 | 23175 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.388 | Orange holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13377 | 13377 | 13376 | {"type": "Polygon", "coordinates": [[[-117.63832, 33.55179], [-117.63825, 33.55193], [-117.63806, 33.55195], [-117.63749, 33.55165], [-117.63722, 33.55113], [-117.63732, 33.55058], [-117.63776, 33.55016], [-117.63796, 33.55008], [-117.63803, 33.55011], [-117.63826, 33.55094], [-117.63832, 33.55179]]]} | Open Access 1 | 35462 | Orange holding 12 | 23159 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.606 | Orange holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13438 | 13438 | 13437 | {"type": "Polygon", "coordinates": [[[-117.62881, 33.68711], [-117.62823, 33.68765], [-117.62818, 33.6877], [-117.62837, 33.68738], [-117.62838, 33.68717], [-117.62881, 33.68711]]]} | Open Access 1 | 35571 | Orange holding 2 | 23167 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.227 | Orange holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13439 | 13439 | 13438 | {"type": "Polygon", "coordinates": [[[-117.62942, 33.68702], [-117.62839, 33.68717], [-117.62837, 33.68738], [-117.62818, 33.6877], [-117.62813, 33.68775], [-117.62743, 33.68762], [-117.62754, 33.6872], [-117.6276, 33.68684], [-117.62873, 33.68685], [-117.62887, 33.68684], [-117.62926, 33.68677], [-117.6293, 33.6868], [-117.62942, 33.68702]]]} | Open Access 1 | 35572 | Orange holding 3 | 23170 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.452 | Orange holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13478 | 13478 | 13477 | {"type": "Polygon", "coordinates": [[[-117.63733, 33.55174], [-117.6369, 33.55204], [-117.63667, 33.55227], [-117.63653, 33.55225], [-117.63645, 33.55234], [-117.63651, 33.55243], [-117.63629, 33.55265], [-117.63566, 33.55222], [-117.63428, 33.55282], [-117.63399, 33.55224], [-117.6338, 33.55163], [-117.63384, 33.55152], [-117.63396, 33.55146], [-117.63704, 33.55126], [-117.63716, 33.55152], [-117.63733, 33.55174]]]} | Open Access 1 | 35756 | Orange holding 13 | 23160 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 8.81 | Orange holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13482 | 13482 | 13481 | {"type": "Polygon", "coordinates": [[[-117.64438, 33.54846], [-117.64365, 33.54864], [-117.64349, 33.5483], [-117.64349, 33.54828], [-117.64352, 33.54825], [-117.64417, 33.54807], [-117.64421, 33.54807], [-117.64424, 33.5481], [-117.64438, 33.54846]]]} | Open Access 1 | 35767 | Orange holding 17 | 23164 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 0.821 | Orange holding 17 | 0 | Local Other or Unknown 14 | 4 | |
13483 | 13483 | 13482 | {"type": "Polygon", "coordinates": [[[-117.63393, 33.55687], [-117.63377, 33.55721], [-117.63341, 33.55741], [-117.63334, 33.55739], [-117.63329, 33.55683], [-117.63343, 33.55627], [-117.6335, 33.55627], [-117.63383, 33.55651], [-117.63393, 33.55687]]]} | Open Access 1 | 35768 | Orange holding 21 | 23169 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.279 | Orange holding 21 | 0 | Local Other or Unknown 14 | 4 | |
13484 | 13484 | 13483 | {"type": "Polygon", "coordinates": [[[-117.63313, 33.56218], [-117.63304, 33.56249], [-117.63298, 33.56252], [-117.63183, 33.56229], [-117.6318, 33.56224], [-117.63188, 33.56194], [-117.63193, 33.5619], [-117.6331, 33.56213], [-117.63313, 33.56218]]]} | Open Access 1 | 35769 | Orange holding 18 | 23165 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 1.289 | Orange holding 18 | 0 | Local Other or Unknown 14 | 4 | |
13485 | 13485 | 13484 | {"type": "Polygon", "coordinates": [[[-117.63608, 33.56053], [-117.63599, 33.56078], [-117.63595, 33.56079], [-117.63584, 33.561], [-117.63553, 33.56083], [-117.63503, 33.56079], [-117.63423, 33.56105], [-117.63372, 33.56095], [-117.63375, 33.56083], [-117.63376, 33.56069], [-117.63371, 33.56049], [-117.63382, 33.5605], [-117.63434, 33.56033], [-117.6345, 33.56025], [-117.63477, 33.56004], [-117.63505, 33.55994], [-117.6351, 33.55995], [-117.63526, 33.56023], [-117.63598, 33.56045], [-117.636, 33.5605], [-117.63608, 33.56053]]]} | Open Access 1 | 35770 | Orange holding 16 | 23163 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.721 | Orange holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13486 | 13486 | 13485 | {"type": "Polygon", "coordinates": [[[-117.63374, 33.56465], [-117.63372, 33.56475], [-117.63293, 33.56513], [-117.63284, 33.56515], [-117.63278, 33.5651], [-117.63282, 33.56506], [-117.63252, 33.5646], [-117.63244, 33.56458], [-117.63241, 33.56453], [-117.63243, 33.56448], [-117.6333, 33.56407], [-117.63336, 33.56409], [-117.63374, 33.56465]]]} | Open Access 1 | 35771 | Orange holding 20 | 23168 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 2.058 | Orange holding 20 | 0 | Local Other or Unknown 14 | 4 | |
13530 | 13530 | 13529 | {"type": "Polygon", "coordinates": [[[-117.63308, 33.68047], [-117.63275, 33.68098], [-117.63268, 33.68098], [-117.63235, 33.6812], [-117.63229, 33.68167], [-117.63149, 33.68159], [-117.63135, 33.68156], [-117.63122, 33.68152], [-117.63106, 33.68143], [-117.63107, 33.68139], [-117.63124, 33.6812], [-117.63246, 33.68007], [-117.63255, 33.68007], [-117.63308, 33.68047]]]} | Open Access 1 | 35831 | Orange holding 1 | 23155 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 3.943 | Orange holding 1 | 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]);