units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
21 rows where ACCESS_TYP = 1, AGNCY_NAME = 142 and DES_TP = 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
392 | 392 | 391 | {"type": "Polygon", "coordinates": [[[-117.64422, 33.55212], [-117.64418, 33.55263], [-117.64416, 33.55266], [-117.64412, 33.55267], [-117.64351, 33.55263], [-117.6435, 33.5526], [-117.64355, 33.55204], [-117.64422, 33.55212]]]} | Open Access 1 | 35760 | Orange holding 14 | 23161 | 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.99 | Orange holding 14 | 0 | Local Other or Unknown 14 | 4 | |
393 | 393 | 392 | {"type": "Polygon", "coordinates": [[[-117.63356, 33.5534], [-117.63355, 33.55342], [-117.63311, 33.55365], [-117.63308, 33.55364], [-117.63287, 33.55333], [-117.6327, 33.553], [-117.63271, 33.55298], [-117.63319, 33.55282], [-117.63322, 33.55283], [-117.63338, 33.55312], [-117.63356, 33.5534]]]} | Open Access 1 | 35761 | Orange holding 15 | 23162 | 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.023 | Orange holding 15 | 0 | Local Other or Unknown 14 | 4 | |
3887 | 3887 | 3886 | {"type": "Polygon", "coordinates": [[[-117.63605, 33.54568], [-117.63574, 33.54607], [-117.6355, 33.54619], [-117.63546, 33.54618], [-117.63543, 33.54597], [-117.63539, 33.54497], [-117.63543, 33.54495], [-117.6355, 33.54496], [-117.63596, 33.54523], [-117.63605, 33.54568]]]} | Open Access 1 | 35755 | Orange holding 9 | 23176 | 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.436 | Orange holding 9 | 0 | Local Other or Unknown 14 | 4 | |
12496 | 12496 | 12495 | {"type": "Polygon", "coordinates": [[[-117.77687, 33.7649], [-117.77713, 33.76457], [-117.77646, 33.76411], [-117.77593, 33.76388], [-117.77537, 33.76368], [-117.77447, 33.76339], [-117.77528, 33.76258], [-117.77535, 33.76253], [-117.77543, 33.76254], [-117.77665, 33.76339], [-117.77667, 33.76338], [-117.77774, 33.76413], [-117.77775, 33.76416], [-117.77773, 33.7642], [-117.7774, 33.76452], [-117.77704, 33.76493], [-117.77697, 33.76495], [-117.77687, 33.7649]]]} | Open Access 1 | 36503 | Orange holding 19 | 23166 | 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 | 6.636 | Orange holding 19 | 0 | Local Other or Unknown 14 | 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 | |
13546 | 13546 | 13545 | {"type": "Polygon", "coordinates": [[[-117.63087, 33.67292], [-117.63058, 33.67337], [-117.6304, 33.67329], [-117.63037, 33.67331], [-117.63009, 33.67319], [-117.62988, 33.67335], [-117.62977, 33.6733], [-117.62957, 33.67326], [-117.62939, 33.67329], [-117.62916, 33.6734], [-117.62909, 33.67337], [-117.62914, 33.67323], [-117.62913, 33.67308], [-117.62914, 33.67295], [-117.62924, 33.67274], [-117.62944, 33.67259], [-117.62946, 33.67244], [-117.62955, 33.67229], [-117.63087, 33.67292]]]} | Open Access 1 | 35861 | Orange holding 4 | 23171 | 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.903 | Orange holding 4 | 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]);