units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LAYER = 3 and PARK_URL = "http://ocparks.com/parks/whiting"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6610 | 6610 | 6609 | {"type": "MultiPolygon", "coordinates": [[[[-117.65033, 33.66096], [-117.64922, 33.6629], [-117.64908, 33.6629], [-117.64911, 33.66256], [-117.64893, 33.66234], [-117.64824, 33.66234], [-117.64813, 33.66236], [-117.64803, 33.66247], [-117.64764, 33.66258], [-117.64634, 33.66263], [-117.64627, 33.66269], [-117.64627, 33.66282], [-117.64623, 33.66297], [-117.64612, 33.66303], [-117.64594, 33.66297], [-117.64577, 33.663], [-117.64559, 33.66312], [-117.64531, 33.66313], [-117.64509, 33.66307], [-117.64493, 33.66311], [-117.64445, 33.66303], [-117.64418, 33.66302], [-117.64394, 33.66306], [-117.64383, 33.66298], [-117.64369, 33.66297], [-117.64361, 33.66299], [-117.64364, 33.66279], [-117.64362, 33.66266], [-117.64353, 33.66247], [-117.64338, 33.66232], [-117.64325, 33.66224], [-117.64311, 33.66218], [-117.64295, 33.66215], [-117.64279, 33.66215], [-117.64231, 33.66222], [-117.64211, 33.66228], [-117.64184, 33.66241], [-117.64162, 33.66259], [-117.64145, 33.66281], [-117.64135, 33.66306], [-117.64133, 33.66332], [-117.64137, 33.66358], [-117.64118, 33.66354], [-117.64081, 33.66335], [-117.64035, 33.66315], [-117.64011, 33.6632], [-117.63958, 33.66293], [-117.63906, 33.66265], [-117.64203, 33.66222], [-117.64204, 33.66117], [-117.64234, 33.6612], [-117.64324, 33.66138], [-117.64469, 33.66135], [-117.64488, 33.66138], [-117.64575, 33.6616], [-117.64596, 33.66163], [-117.64618, 33.66163], [-117.64639, 33.66161], [-117.64963, 33.66113], [-117.64992, 33.66107], [-117.65033, 33.66096]], [[-117.64326, 33.6615], [-117.6432, 33.66149], [-117.6432, 33.66158], [-117.64326, 33.66158], [-117.64326, 33.6615]], [[-117.64376, 33.66143], [-117.6437, 33.66142], [-117.6437, 33.66149], [-117.64376, 33.66149], [-117.64376, 33.66143]]], [[[-117.63527, 33.66546], [-117.63426, 33.66589], [-117.63337, 33.6673], [-117.62925, 33.66919], [-117.62773, 33.67017], [-117.62765, 33.67032], [-117.62718, 33.67024], [-117.62672, 33.67012], [-117.6269, 33.66981], [-117.63455, 33.66511], [-117.63497, 33.66488], [-117.63527, 33.66546]]], [[[-117.65743, 33.67111], [-117.65572, 33.67203], [-117.65423, 33.67248], [-117.65355, 33.67208], [-117.65373, 33.67186], [-117.65384, 33.67177], [-117.65499, 33.67107], [-117.65563, 33.67131], [-117.65598, 33.67136], [-117.65617, 33.67133], [-117.65628, 33.67128], [-117.65671, 33.67092], [-117.657, 33.67111], [-117.65732, 33.67107], [-117.65743, 33.67111]]], [[[-117.64436, 33.67356], [-117.64426, 33.67364], [-117.6442, 33.67364], [-117.63957, 33.66465], [-117.63899, 33.66339], [-117.63941, 33.6636], [-117.63947, 33.66375], [-117.6401, 33.66411], [-117.64055, 33.66417], [-117.64116, 33.6647], [-117.64147, 33.66483], [-117.64107, 33.66534], [-117.6409, 33.66561], [-117.6408, 33.66595], [-117.64158, 33.66749], [-117.642, 33.66788], [-117.64262, 33.6689], [-117.64264, 33.66899], [-117.64261, 33.66912], [-117.64248, 33.6693], [-117.6423, 33.66945], [-117.64309, 33.67074], [-117.64318, 33.67081], [-117.64316, 33.67089], [-117.64318, 33.67101], [-117.6433, 33.67118], [-117.64374, 33.67203], [-117.64391, 33.67248], [-117.64426, 33.67317], [-117.64432, 33.67336], [-117.64436, 33.67356]]], [[[-117.64325, 33.67362], [-117.64289, 33.67363], [-117.64254, 33.67367], [-117.64014, 33.67408], [-117.63967, 33.67414], [-117.63946, 33.67373], [-117.63962, 33.67373], [-117.63989, 33.67389], [-117.64057, 33.67344], [-117.64131, 33.67369], [-117.64286, 33.67306], [-117.64298, 33.6731], [-117.64325, 33.67362]]], [[[-117.62933, 33.67264], [-117.62921, 33.67291], [-117.62904, 33.67296], [-117.62902, 33.67324], [-117.62916, 33.6734], [-117.62909, 33.67337], [-117.62811, 33.6739], [-117.62741, 33.67443], [-117.6274, 33.67445], [-117.62742, 33.67454], [-117.62713, 33.67635], [-117.62769, 33.67748], [-117.62828, 33.6782], [-117.62825, 33.67847], [-117.62584, 33.67843], [-117.62624, 33.6778], [-117.62581, 33.67774], [-117.62509, 33.67727], [-117.62411, 33.6771], [-117.62332, 33.67849], [-117.62262, 33.67874], [-117.62302, 33.67832], [-117.62312, 33.67815], [-117.62321, 33.6779], [-117.62323, 33.67763], [-117.62319, 33.67729], [-117.62319, 33.67693], [-117.6233, 33.67558], [-117.62334, 33.6754], [-117.62341, 33.67522], [-117.62454, 33.67293], [-117.62465, 33.67273], [-117.6248, 33.67255], [-117.62609, 33.67111], [-117.62625, 33.67089], [-117.62656, 33.67039], [-117.62711, 33.67054], [-117.6275, 33.6706], [-117.62801, 33.67065], [-117.62852, 33.67064], [-117.62831, 33.67076], [-117.62819, 33.6715], [-117.62814, 33.67166], [-117.62819, 33.67192], [-117.62831, 33.67197], [-117.62839, 33.67193], [-117.6288, 33.67221], [-117.6289, 33.67225], [-117.62892, 33.67235], [-117.62911, 33.67256], [-117.62933, 33.67264]]], [[[-117.62818, 33.67926], [-117.62816, 33.67951], [-117.62785, 33.67967], [-117.62793, 33.68043], [-117.62796, 33.68056], [-117.62747, 33.67986], [-117.62724, 33.67942], [-117.62762, 33.67919], [-117.62818, 33.67926]]], [[[-117.67003, 33.69267], [-117.66497, 33.69736], [-117.66518, 33.69668], [-117.66527, 33.696], [-117.6653, 33.69544], [-117.66545, 33.69503], [-117.66563, 33.69481], [-117.66562, 33.69444], [-117.66582, 33.69421], [-117.66548, 33.69361], [-117.66517, 33.69345], [-117.66481, 33.69282], [-117.66409, 33.69308], [-117.66377, 33.69299], [-117.66341, 33.69274], [-117.66317, 33.69252], [-117.66279, 33.69231], [-117.66343, 33.69231], [-117.66409, 33.69284], [-117.66469, 33.69278], [-117.66531, 33.69207], [-117.66632, 33.69194], [-117.66744, 33.69202], [-117.66785, 33.69213], [-117.66811, 33.69265], [-117.67003, 33.69267]]], [[[-117.66278, 33.6923], [-117.66253, 33.69217], [-117.66251, 33.69236], [-117.662, 33.6933], [-117.6617, 33.69418], [-117.66131, 33.69456], [-117.66157, 33.69554], [-117.66238, 33.69629], [-117.66316, 33.69673], [-117.66412, 33.69756], [-117.66445, 33.69758], [-117.66484, 33.69736], [-117.66494, 33.69738], [-117.65489, 33.70668], [-117.64798, 33.70618], [-117.64242, 33.70397], [-117.64241, 33.70309], [-117.64214, 33.70266], [-117.64233, 33.7021], [-117.64229, 33.70182], [-117.64211, 33.70155], [-117.64141, 33.70127], [-117.64118, 33.70066], [-117.64083, 33.70051], [-117.64053, 33.7004], [-117.64052, 33.69999], [-117.64034, 33.69985], [-117.63921, 33.6992], [-117.63894, 33.69899], [-117.6381, 33.69847], [-117.63739, 33.69845], [-117.63687, 33.69835], [-117.63647, 33.69813], [-117.6363, 33.69811], [-117.64125, 33.6841], [-117.64074, 33.6846], [-117.63789, 33.69264], [-117.63754, 33.69249], [-117.63753, 33.69249], [-117.63562, 33.69804], [-117.63504, 33.69794], [-117.63454, 33.69778], [-117.63403, 33.69747], [-117.6334, 33.69687], [-117.63306, 33.69641], [-117.63294, 33.69617], [-117.63268, 33.6958], [-117.63247, 33.69554], [-117.63209, 33.6952], [-117.63182, 33.69499], [-117.63148, 33.69479], [-117.63048, 33.6943], [-117.62999, 33.69403], [-117.62972, 33.69386], [-117.62948, 33.69367], [-117.62789, 33.69231], [-117.62674, 33.69061], [-117.62905, 33.68955], [-117.63084, 33.68945], [-117.63082, 33.68827], [-117.63099, 33.68826], [-117.63097, 33.68812], [-117.63099, 33.688], [-117.63113, 33.6876], [-117.63114, 33.68749], [-117.63121, 33.68741], [-117.63145, 33.68724], [-117.63154, 33.68712], [-117.63165, 33.68717], [-117.632, 33.68712], [-117.63204, 33.68703], [-117.632, 33.68806], [-117.63276, 33.68804], [-117.63335, 33.6877], [-117.63373, 33.68669], [-117.63605, 33.68639], [-117.63553, 33.68544], [-117.63558, 33.68513], [-117.63647, 33.68432], [-117.63916, 33.68441], [-117.64016, 33.68348], [-117.64012, 33.68057], [-117.64039, 33.6806], [-117.6404, 33.68059], [-117.64008, 33.68034], [-117.64158, 33.67948], [-117.64048, 33.67786], [-117.63978, 33.67829], [-117.63914, 33.67832], [-117.63918, 33.67806], [-117.63918, 33.67781], [-117.63914, 33.67755], [-117.63902, 33.67727], [-117.63907, 33.67725], [-117.63919, 33.67741], [-117.63945, 33.67739], [-117.63963, 33.67749], [-117.64005, 33.67737], [-117.64039, 33.67708], [-117.6405, 33.67681], [-117.64036, 33.67652], [-117.64023, 33.67637], [-117.64016, 33.67635], [-117.64031, 33.67601], [-117.64034, 33.67574], [-117.64033, 33.67562], [-117.64024, 33.67544], [-117.63998, 33.67516], [-117.63986, 33.67495], [-117.63973, 33.67483], [-117.63955, 33.67471], [-117.6386, 33.67441], [-117.63912, 33.67445], [-117.63947, 33.67445], [-117.6398, 33.67443], [-117.6398, 33.6744], [-117.64021, 33.67435], [-117.64258, 33.67394], [-117.64289, 33.67391], [-117.64336, 33.67389], [-117.64357, 33.67431], [-117.64289, 33.67635], [-117.6429, 33.67636], [-117.64403, 33.67567], [-117.64451, 33.67424], [-117.64435, 33.67392], [-117.64464, 33.67393], [-117.64478, 33.67421], [-117.64504, 33.67421], [-117.64506, 33.67393], [-117.64575, 33.6739], [-117.6462, 33.67384], [-117.64665, 33.67375], [-117.64709, 33.67364], [-117.64774, 33.67342], [-117.64951, 33.67274], [-117.651, 33.67218], [-117.6514, 33.67201], [-117.65197, 33.67169], [-117.65229, 33.67172], [-117.65252, 33.67189], [-117.65276, 33.67206], [-117.65394, 33.67274], [-117.65382, 33.67289], [-117.65304, 33.67289], [-117.65296, 33.67317], [-117.65275, 33.67324], [-117.65232, 33.67322], [-117.65223, 33.67339], [-117.65167, 33.67342], [-117.65144, 33.67336], [-117.65108, 33.67338], [-117.6507, 33.67333], [-117.65032, 33.67353], [-117.65009, 33.67373], [-117.64999, 33.67394], [-117.64975, 33.67409], [-117.64953, 33.67438], [-117.64934, 33.67458], [-117.6492, 33.67488], [-117.64907, 33.67534], [-117.64904, 33.67538], [-117.64898, 33.67563], [-117.64882, 33.67569], [-117.64867, 33.67616], [-117.6485, 33.6764], [-117.6485, 33.67655], [-117.64834, 33.67672], [-117.64831, 33.67681], [-117.64831, 33.6769], [-117.64834, 33.67698], [-117.64858, 33.67725], [-117.64899, 33.67747], [-117.64893, 33.67765], [-117.6491, 33.67782], [-117.64902, 33.67826], [-117.64887, 33.67829], [-117.64886, 33.67835], [-117.64902, 33.67855], [-117.64923, 33.6787], [-117.6492, 33.67894], [-117.64916, 33.67898], [-117.64922, 33.67901], [-117.64916, 33.67906], [-117.64905, 33.67907], [-117.649, 33.6791], [-117.64899, 33.67915], [-117.6491, 33.67933], [-117.64909, 33.67938], [-117.64825, 33.67924], [-117.64765, 33.67973], [-117.64765, 33.67977], [-117.64773, 33.67987], [-117.64771, 33.68004], [-117.64789, 33.68031], [-117.64801, 33.68038], [-117.64806, 33.68042], [-117.64791, 33.68056], [-117.64784, 33.68109], [-117.6479, 33.68174], [-117.64796, 33.68184], [-117.64791, 33.68198], [-117.64785, 33.68266], [-117.64788, 33.6828], [-117.64786, 33.6831], [-117.64788, 33.68375], [-117.64798, 33.68464], [-117.64804, 33.68468], [-117.64799, 33.68472], [-117.6481, 33.6854], [-117.64828, 33.6858], [-117.64826, 33.68628], [-117.64833, 33.68654], [-117.6483, 33.68659], [-117.64834, 33.68681], [-117.64837, 33.68685], [-117.64838, 33.68694], [-117.64851, 33.68744], [-117.64882, 33.68769], [-117.64885, 33.68769], [-117.6489, 33.68781], [-117.64882, 33.68783], [-117.64859, 33.68805], [-117.64879, 33.68904], [-117.6495, 33.68971], [-117.64982, 33.68991], [-117.6505, 33.6898], [-117.65081, 33.6899], [-117.65094, 33.68999], [-117.65101, 33.69007], [-117.65105, 33.69017], [-117.65107, 33.69028], [-117.65105, 33.69037], [-117.65101, 33.69041], [-117.65095, 33.69045], [-117.65087, 33.69044], [-117.65077, 33.69037], [-117.65066, 33.69033], [-117.65058, 33.69034], [-117.65047, 33.69038], [-117.65041, 33.69047], [-117.6504, 33.69058], [-117.65045, 33.69067], [-117.65055, 33.69074], [-117.65068, 33.69075], [-117.6508, 33.69071], [-117.65086, 33.69066], [-117.65094, 33.69055], [-117.65109, 33.69042], [-117.65113, 33.69035], [-117.65114, 33.69027], [-117.65111, 33.69015], [-117.65103, 33.69], [-117.65089, 33.68988], [-117.65066, 33.68979], [-117.65087, 33.68978], [-117.65111, 33.68985], [-117.6515, 33.69013], [-117.65188, 33.69036], [-117.65227, 33.69051], [-117.65258, 33.69052], [-117.65312, 33.6904], [-117.65406, 33.69068], [-117.65431, 33.69144], [-117.6551, 33.69154], [-117.65621, 33.6909], [-117.6565, 33.69061], [-117.65657, 33.69052], [-117.65661, 33.69041], [-117.65661, 33.6903], [-117.65655, 33.69015], [-117.65663, 33.69011], [-117.65686, 33.69005], [-117.65701, 33.68986], [-117.65705, 33.68989], [-117.65737, 33.68989], [-117.65677, 33.68942], [-117.65682, 33.68903], [-117.65669, 33.6889], [-117.6567, 33.68886], [-117.65661, 33.68874], [-117.657, 33.6886], [-117.65709, 33.68855], [-117.65702, 33.68835], [-117.65774, 33.68792], [-117.65788, 33.68767], [-117.65788, 33.68748], [-117.65805, 33.68737], [-117.65913, 33.68535], [-117.65959, 33.68511], [-117.65959, 33.68507], [-117.65979, 33.68504], [-117.6601, 33.68509], [-117.66043, 33.68508], [-117.66092, 33.68471], [-117.6609, 33.68449], [-117.66086, 33.68437], [-117.66111, 33.68414], [-117.66145, 33.68412], [-117.66171, 33.68395], [-117.66181, 33.68382], [-117.66184, 33.68369], [-117.6618, 33.68354], [-117.66188, 33.68354], [-117.66218, 33.68338], [-117.66216, 33.68335], [-117.66309, 33.68287], [-117.66447, 33.68141], [-117.66446, 33.68139], [-117.66373, 33.68134], [-117.66378, 33.6809], [-117.6646, 33.68053], [-117.66503, 33.68126], [-117.66534, 33.68182], [-117.66466, 33.68197], [-117.66427, 33.68226], [-117.66442, 33.68243], [-117.66419, 33.68257], [-117.66405, 33.68271], [-117.66392, 33.68292], [-117.66378, 33.68338], [-117.66338, 33.68334], [-117.66335, 33.68351], [-117.66329, 33.68358], [-117.66273, 33.68383], [-117.66199, 33.6843], [-117.66177, 33.68431], [-117.66137, 33.68444], [-117.66104, 33.68474], [-117.66088, 33.68508], [-117.66087, 33.68542], [-117.66129, 33.68621], [-117.66104, 33.68641], [-117.66071, 33.68586], [-117.66028, 33.68583], [-117.65981, 33.68594], [-117.65902, 33.68647], [-117.65877, 33.68677], [-117.65869, 33.6873], [-117.65883, 33.68796], [-117.65876, 33.68874], [-117.65826, 33.68956], [-117.65825, 33.68994], [-117.6579, 33.69017], [-117.65791, 33.69018], [-117.65857, 33.69019], [-117.65905, 33.69033], [-117.65955, 33.69106], [-117.66032, 33.69165], [-117.66093, 33.69153], [-117.66248, 33.69179], [-117.66278, 33.6923]]]]} | Open Access 1 | 4176 | Whiting Ranch Wilderness Park | 32175 | 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 | http://ocparks.com/parks/whiting | Orange 3 | 1644.529 | Whiting Ranch Wilderness Park | 0 | Local Conservation Area 4 | 2 |
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]);