units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where LAYER = 11, MNG_AGENCY = 47 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- State Agency · 2 ✖
MNG_AGENCY 1
- California Department of Parks and Recreation · 2 ✖
DES_TP 1
ACCESS_TYP 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11255 | 11255 | 11254 | {"type": "Polygon", "coordinates": [[[-117.57335, 33.45319], [-117.5733, 33.45446], [-117.56712, 33.45446], [-117.56788, 33.45287], [-117.56793, 33.45246], [-117.57306, 33.45311], [-117.57317, 33.45312], [-117.57335, 33.45319]]]} | Open Access 1 | 25874 | San Onofre State Beach | 13878 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=647 | Orange 3 | 24.569 | San Onofre SB | 1971 | State Park 15 | 4 |
| 16492 | 16492 | 16491 | {"type": "MultiPolygon", "coordinates": [[[[-117.54775, 33.36682], [-117.54765, 33.36691], [-117.54715, 33.36659], [-117.52944, 33.3545], [-117.52868, 33.354], [-117.52813, 33.35358], [-117.52765, 33.35319], [-117.52745, 33.35299], [-117.52679, 33.35245], [-117.52421, 33.35012], [-117.5235, 33.34954], [-117.5231, 33.34925], [-117.52304, 33.34919], [-117.52225, 33.34865], [-117.52154, 33.34821], [-117.51759, 33.34608], [-117.51724, 33.3459], [-117.51653, 33.34549], [-117.51589, 33.34508], [-117.50239, 33.33524], [-117.50246, 33.33517], [-117.50775, 33.33902], [-117.50784, 33.33907], [-117.50791, 33.33913], [-117.508, 33.33925], [-117.50808, 33.33933], [-117.50954, 33.34038], [-117.50964, 33.34043], [-117.50981, 33.34047], [-117.50991, 33.34056], [-117.50995, 33.34066], [-117.51004, 33.34076], [-117.51121, 33.34162], [-117.51158, 33.34177], [-117.51199, 33.34205], [-117.51207, 33.34213], [-117.51218, 33.3423], [-117.51228, 33.34239], [-117.51344, 33.34324], [-117.51369, 33.34332], [-117.51377, 33.34336], [-117.51391, 33.34349], [-117.51403, 33.34366], [-117.51411, 33.34373], [-117.51527, 33.34457], [-117.51541, 33.34465], [-117.5157, 33.34474], [-117.51603, 33.34497], [-117.51611, 33.34504], [-117.51621, 33.34519], [-117.5163, 33.34527], [-117.51697, 33.34568], [-117.51782, 33.34617], [-117.52126, 33.34799], [-117.52253, 33.34877], [-117.5232, 33.34925], [-117.52332, 33.34931], [-117.52352, 33.34938], [-117.52358, 33.34942], [-117.52405, 33.3498], [-117.52422, 33.35007], [-117.52522, 33.35096], [-117.52532, 33.35102], [-117.52564, 33.35113], [-117.52588, 33.35135], [-117.52597, 33.35156], [-117.52606, 33.3517], [-117.52736, 33.35286], [-117.52805, 33.35343], [-117.5282, 33.35352], [-117.52841, 33.35358], [-117.5285, 33.35364], [-117.52859, 33.35372], [-117.52867, 33.35385], [-117.52873, 33.35392], [-117.53038, 33.35504], [-117.53051, 33.35511], [-117.53074, 33.35517], [-117.53131, 33.35557], [-117.53135, 33.35562], [-117.53142, 33.35574], [-117.53146, 33.35577], [-117.53374, 33.35735], [-117.5339, 33.35743], [-117.53423, 33.35753], [-117.53449, 33.35773], [-117.5346, 33.35791], [-117.53471, 33.35801], [-117.53537, 33.35847], [-117.54198, 33.36299], [-117.54219, 33.36308], [-117.54235, 33.36314], [-117.54251, 33.36326], [-117.54264, 33.36341], [-117.54662, 33.3661], [-117.5467, 33.36614], [-117.54696, 33.36633], [-117.54698, 33.36633], [-117.54773, 33.36682], [-117.54775, 33.36682]]], [[[-117.54934, 33.36477], [-117.54781, 33.36673], [-117.54762, 33.36661], [-117.54697, 33.36619], [-117.54672, 33.36602], [-117.54669, 33.36601], [-117.54424, 33.36434], [-117.54273, 33.36334], [-117.54261, 33.36318], [-117.54248, 33.36308], [-117.54232, 33.363], [-117.5422, 33.36297], [-117.54201, 33.36286], [-117.53758, 33.35982], [-117.53545, 33.35839], [-117.53477, 33.35791], [-117.53471, 33.35785], [-117.53459, 33.35764], [-117.53433, 33.35746], [-117.53428, 33.35742], [-117.53395, 33.35733], [-117.53384, 33.35728], [-117.53156, 33.35569], [-117.5315, 33.35564], [-117.53146, 33.35555], [-117.53138, 33.35547], [-117.53135, 33.35546], [-117.53078, 33.35506], [-117.53047, 33.35496], [-117.52883, 33.35383], [-117.52876, 33.35377], [-117.5287, 33.35365], [-117.52859, 33.35356], [-117.5285, 33.3535], [-117.52827, 33.35342], [-117.52816, 33.35336], [-117.52746, 33.35278], [-117.52616, 33.35163], [-117.52608, 33.35152], [-117.52603, 33.35137], [-117.52597, 33.35128], [-117.52574, 33.35106], [-117.52567, 33.35102], [-117.52534, 33.3509], [-117.52527, 33.35085], [-117.52437, 33.35006], [-117.52432, 33.35001], [-117.5242, 33.34979], [-117.52414, 33.3497], [-117.52372, 33.34937], [-117.52361, 33.3493], [-117.52337, 33.34921], [-117.5233, 33.34917], [-117.52261, 33.34869], [-117.52198, 33.34829], [-117.52133, 33.3479], [-117.51796, 33.34611], [-117.51723, 33.3457], [-117.51641, 33.3452], [-117.51631, 33.34511], [-117.5162, 33.34496], [-117.51611, 33.34489], [-117.51577, 33.34465], [-117.5154, 33.34452], [-117.51419, 33.34365], [-117.51415, 33.34361], [-117.51401, 33.34341], [-117.51391, 33.34332], [-117.51376, 33.34323], [-117.51351, 33.34315], [-117.51347, 33.34312], [-117.51237, 33.34231], [-117.51229, 33.34224], [-117.51211, 33.34199], [-117.51167, 33.34167], [-117.51127, 33.34151], [-117.51009, 33.34065], [-117.51001, 33.34049], [-117.50992, 33.3404], [-117.50982, 33.34035], [-117.50962, 33.34029], [-117.50816, 33.33924], [-117.50809, 33.33916], [-117.50803, 33.33908], [-117.50792, 33.33898], [-117.50787, 33.33896], [-117.50255, 33.33509], [-117.50537, 33.33236], [-117.50715, 33.33406], [-117.51033, 33.33691], [-117.5108, 33.3373], [-117.51129, 33.3377], [-117.51259, 33.33869], [-117.51641, 33.34171], [-117.51955, 33.34416], [-117.51998, 33.34452], [-117.52116, 33.34533], [-117.5218, 33.34587], [-117.52202, 33.34602], [-117.52251, 33.34632], [-117.5246, 33.34775], [-117.52503, 33.34808], [-117.52547, 33.34838], [-117.52688, 33.34924], [-117.5277, 33.34979], [-117.52827, 33.3502], [-117.52829, 33.3502], [-117.52856, 33.35042], [-117.52882, 33.35066], [-117.52901, 33.3508], [-117.52946, 33.35107], [-117.5309, 33.3521], [-117.53539, 33.35525], [-117.53607, 33.35578], [-117.53641, 33.35607], [-117.53714, 33.3566], [-117.53889, 33.35781], [-117.54499, 33.36222], [-117.54607, 33.36294], [-117.54711, 33.36359], [-117.54818, 33.36418], [-117.54934, 33.36477]]], [[[-117.57053, 33.37696], [-117.56991, 33.37733], [-117.56978, 33.37735], [-117.56951, 33.37746], [-117.56937, 33.3775], [-117.56883, 33.37754], [-117.56862, 33.3776], [-117.56851, 33.37767], [-117.56841, 33.37776], [-117.56815, 33.37811], [-117.55996, 33.37365], [-117.56045, 33.37298], [-117.56065, 33.37306], [-117.56093, 33.3732], [-117.56125, 33.37339], [-117.56175, 33.37373], [-117.56194, 33.37388], [-117.56217, 33.37408], [-117.56223, 33.37405], [-117.56223, 33.37396], [-117.56195, 33.37373], [-117.56162, 33.37349], [-117.56114, 33.37319], [-117.56083, 33.37302], [-117.56052, 33.37288], [-117.56073, 33.37259], [-117.56087, 33.37244], [-117.56206, 33.37081], [-117.56285, 33.37114], [-117.56404, 33.37152], [-117.56428, 33.37162], [-117.56453, 33.37175], [-117.56469, 33.37188], [-117.5656, 33.3725], [-117.56667, 33.37339], [-117.56725, 33.37383], [-117.56778, 33.37418], [-117.56816, 33.37441], [-117.56837, 33.37451], [-117.56862, 33.37467], [-117.5689, 33.37492], [-117.56911, 33.37514], [-117.56959, 33.37582], [-117.56991, 33.37622], [-117.57, 33.3763], [-117.57029, 33.37671], [-117.57053, 33.37696]]], [[[-117.59347, 33.39734], [-117.59314, 33.39871], [-117.59226, 33.40197], [-117.59224, 33.40209], [-117.59118, 33.4061], [-117.59107, 33.40652], [-117.591, 33.40663], [-117.59029, 33.40933], [-117.59028, 33.40934], [-117.58959, 33.41175], [-117.58965, 33.41177], [-117.57853, 33.45381], [-117.57335, 33.45305], [-117.57334, 33.45306], [-117.57335, 33.45319], [-117.57317, 33.45312], [-117.57306, 33.45311], [-117.56793, 33.45246], [-117.56811, 33.4511], [-117.56863, 33.44909], [-117.56866, 33.44474], [-117.56864, 33.44342], [-117.57021, 33.4409], [-117.57224, 33.436], [-117.57238, 33.4295], [-117.57242, 33.42813], [-117.57133, 33.42565], [-117.57419, 33.42353], [-117.57879, 33.41984], [-117.58222, 33.4135], [-117.58369, 33.41133], [-117.58475, 33.41178], [-117.58494, 33.41169], [-117.58594, 33.41049], [-117.5854, 33.40984], [-117.5852, 33.40937], [-117.58269, 33.40734], [-117.58274, 33.40661], [-117.58282, 33.40611], [-117.58355, 33.40494], [-117.58367, 33.40457], [-117.5839, 33.40431], [-117.5839, 33.404], [-117.58417, 33.40325], [-117.5853, 33.40227], [-117.58621, 33.40295], [-117.5875, 33.40317], [-117.58813, 33.40148], [-117.58763, 33.40133], [-117.59027, 33.39795], [-117.59025, 33.39567], [-117.5913, 33.39381], [-117.59139, 33.39394], [-117.59194, 33.39509], [-117.59208, 33.39556], [-117.59202, 33.39573], [-117.59173, 33.39599], [-117.59155, 33.3962], [-117.59151, 33.39629], [-117.59173, 33.39639], [-117.5918, 33.39637], [-117.59326, 33.39719], [-117.59347, 33.39734]]], [[[-117.59539, 33.3879], [-117.59529, 33.38798], [-117.59522, 33.38793], [-117.59356, 33.38905], [-117.59103, 33.39191], [-117.58947, 33.38984], [-117.5888, 33.38883], [-117.58771, 33.38765], [-117.58683, 33.38698], [-117.58494, 33.38534], [-117.58396, 33.38466], [-117.58341, 33.38456], [-117.58318, 33.38465], [-117.58238, 33.3845], [-117.58136, 33.3842], [-117.5783, 33.38323], [-117.57803, 33.38303], [-117.5778, 33.38296], [-117.57849, 33.38206], [-117.57861, 33.38152], [-117.57927, 33.38153], [-117.57998, 33.38159], [-117.58062, 33.38169], [-117.58148, 33.38188], [-117.58184, 33.38199], [-117.58244, 33.38221], [-117.59285, 33.38626], [-117.5935, 33.38657], [-117.59422, 33.38698], [-117.59481, 33.3874], [-117.59518, 33.38769], [-117.59539, 33.3879]]], [[[-117.59617, 33.38711], [-117.59594, 33.38795], [-117.59565, 33.38767], [-117.59519, 33.38729], [-117.59443, 33.38676], [-117.59373, 33.38635], [-117.59292, 33.38598], [-117.58258, 33.38195], [-117.5822, 33.38182], [-117.58142, 33.38159], [-117.58064, 33.38142], [-117.57977, 33.3813], [-117.57922, 33.38126], [-117.57864, 33.38124], [-117.57869, 33.38077], [-117.57889, 33.3808], [-117.5795, 33.38078], [-117.57996, 33.38082], [-117.58028, 33.38087], [-117.58049, 33.38092], [-117.58078, 33.38102], [-117.58095, 33.3811], [-117.58178, 33.38155], [-117.58218, 33.3817], [-117.58253, 33.38179], [-117.58531, 33.38216], [-117.58561, 33.38218], [-117.586, 33.38223], [-117.58637, 33.3823], [-117.58681, 33.38242], [-117.58753, 33.38255], [-117.58802, 33.3826], [-117.58885, 33.38262], [-117.58903, 33.38257], [-117.58925, 33.38243], [-117.58945, 33.38237], [-117.58958, 33.38237], [-117.58968, 33.3824], [-117.58982, 33.38251], [-117.58988, 33.38261], [-117.59007, 33.38288], [-117.59041, 33.38322], [-117.59103, 33.38378], [-117.59167, 33.38427], [-117.59205, 33.3845], [-117.5928, 33.3849], [-117.59311, 33.38503], [-117.5934, 33.3851], [-117.59361, 33.38517], [-117.59407, 33.3854], [-117.59523, 33.38616], [-117.59549, 33.38635], [-117.59589, 33.38672], [-117.59617, 33.38711]]]]} | Open Access 1 | 25875 | San Onofre State Beach | 13878 | 198 | United States Department of Defense 61 | Federal 1 | Federal Agency 1 | http://www.defense.gov/ | US Military/Defense 11 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=647 | San Diego 4 | 2018.265 | San Onofre SB | 1971 | State Park 15 | 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]);