units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACCESS_TYP = 1, DES_TP = 15, MNG_AG_TYP = 5 and YR_EST = 1958
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2967 | 2967 | 2966 | {"type": "Polygon", "coordinates": [[[-123.48833, 39.0803], [-123.48372, 39.08029], [-123.48373, 39.08107], [-123.48368, 39.0826], [-123.48432, 39.08313], [-123.48458, 39.08343], [-123.48463, 39.08384], [-123.48435, 39.08443], [-123.48525, 39.08509], [-123.48456, 39.0858], [-123.48364, 39.08558], [-123.48368, 39.0826], [-123.48077, 39.08161], [-123.48077, 39.08131], [-123.47893, 39.08028], [-123.47439, 39.08025], [-123.47436, 39.07788], [-123.4725, 39.07663], [-123.47113, 39.07659], [-123.46798, 39.0766], [-123.46492, 39.07508], [-123.46151, 39.07281], [-123.4601, 39.07284], [-123.46008, 39.07238], [-123.46007, 39.07014], [-123.46023, 39.06539], [-123.45537, 39.06534], [-123.45544, 39.06341], [-123.45545, 39.06159], [-123.45553, 39.05798], [-123.45553, 39.05708], [-123.45559, 39.05445], [-123.46023, 39.05439], [-123.46021, 39.05711], [-123.46482, 39.05712], [-123.46487, 39.05796], [-123.4658, 39.05801], [-123.46595, 39.06175], [-123.46949, 39.06165], [-123.46951, 39.06546], [-123.46948, 39.06926], [-123.47421, 39.06927], [-123.4742, 39.06549], [-123.47884, 39.06549], [-123.47901, 39.07289], [-123.47915, 39.07652], [-123.48371, 39.07663], [-123.48825, 39.07668], [-123.48833, 39.0803]]]} | Open Access 1 | 20484 | Hendy Woods State Park | 1562 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=438 | Mendocino 24 | 827.536 | Hendy Woods SP | 1958 | State Park 15 | 4 |
16423 | 16423 | 16422 | {"type": "MultiPolygon", "coordinates": [[[[-122.40251, 37.3184], [-122.40245, 37.31872], [-122.40101, 37.32145], [-122.40017, 37.32173], [-122.3999, 37.32222], [-122.40053, 37.32305], [-122.39964, 37.32438], [-122.39914, 37.3244], [-122.39762, 37.32442], [-122.39704, 37.32445], [-122.39696, 37.32408], [-122.3967, 37.32349], [-122.39634, 37.32362], [-122.3959, 37.32353], [-122.3963, 37.32204], [-122.39521, 37.32098], [-122.39422, 37.32051], [-122.39299, 37.31965], [-122.39273, 37.31943], [-122.39244, 37.31914], [-122.39213, 37.31831], [-122.39354, 37.31685], [-122.39389, 37.31659], [-122.39697, 37.31667], [-122.40251, 37.3184]]], [[[-122.40477, 37.31225], [-122.40472, 37.31286], [-122.40472, 37.31299], [-122.40474, 37.31313], [-122.40469, 37.31341], [-122.40457, 37.31367], [-122.40454, 37.31381], [-122.40454, 37.31409], [-122.40463, 37.31451], [-122.40459, 37.31507], [-122.40457, 37.31521], [-122.40441, 37.31576], [-122.40436, 37.31604], [-122.40433, 37.31617], [-122.40425, 37.31631], [-122.40424, 37.31644], [-122.40424, 37.31672], [-122.4042, 37.31701], [-122.4042, 37.31714], [-122.40422, 37.31729], [-122.40421, 37.31743], [-122.40423, 37.31798], [-122.4042, 37.31812], [-122.40421, 37.3184], [-122.40412, 37.31867], [-122.40406, 37.3188], [-122.40404, 37.31895], [-122.40399, 37.31908], [-122.404, 37.31936], [-122.40406, 37.31948], [-122.4041, 37.31961], [-122.40407, 37.31974], [-122.40391, 37.32001], [-122.40386, 37.32028], [-122.4038, 37.32042], [-122.4038, 37.32056], [-122.40384, 37.32083], [-122.40378, 37.32097], [-122.40376, 37.32111], [-122.40378, 37.32125], [-122.40378, 37.32138], [-122.40372, 37.32166], [-122.40371, 37.32194], [-122.40367, 37.32222], [-122.40359, 37.32249], [-122.40356, 37.32277], [-122.40356, 37.32305], [-122.40359, 37.32319], [-122.40375, 37.32345], [-122.40377, 37.32359], [-122.40369, 37.32386], [-122.40368, 37.32413], [-122.40372, 37.32427], [-122.4038, 37.3244], [-122.4038, 37.32454], [-122.40378, 37.32468], [-122.40367, 37.32479], [-122.40352, 37.32486], [-122.40346, 37.325], [-122.40343, 37.32513], [-122.40342, 37.32555], [-122.40339, 37.32573], [-122.40013, 37.32432], [-122.40138, 37.32245], [-122.40162, 37.32222], [-122.40181, 37.32197], [-122.40194, 37.32169], [-122.40205, 37.32124], [-122.40215, 37.32099], [-122.40236, 37.32108], [-122.40269, 37.32054], [-122.40339, 37.31784], [-122.40414, 37.31224], [-122.40477, 37.31225]]]]} | Open Access 1 | 421 | San Gregorio State Beach | 1728 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=529 | San Mateo 15 | 161.49 | San Gregorio SB | 1958 | State Park 15 | 4 |
16483 | 16483 | 16482 | {"type": "MultiPolygon", "coordinates": [[[[-122.41265, 37.2672], [-122.40974, 37.27787], [-122.40913, 37.28002], [-122.40878, 37.27989], [-122.40876, 37.2799], [-122.40834, 37.27976], [-122.40847, 37.27804], [-122.40847, 37.2777], [-122.40845, 37.27747], [-122.40836, 37.27722], [-122.40865, 37.27526], [-122.40921, 37.27443], [-122.40888, 37.27359], [-122.40926, 37.27212], [-122.40951, 37.27188], [-122.40971, 37.27095], [-122.40962, 37.27075], [-122.40991, 37.26961], [-122.41048, 37.26827], [-122.4117, 37.26621], [-122.41265, 37.2672]]], [[[-122.41726, 37.26075], [-122.41565, 37.26285], [-122.4136, 37.26215], [-122.41349, 37.26226], [-122.41294, 37.26316], [-122.41295, 37.26352], [-122.41291, 37.264], [-122.41298, 37.26486], [-122.41304, 37.26497], [-122.413, 37.26557], [-122.41293, 37.26574], [-122.41294, 37.26665], [-122.41268, 37.26702], [-122.41258, 37.26676], [-122.41229, 37.26646], [-122.41191, 37.26632], [-122.41178, 37.26601], [-122.4122, 37.26495], [-122.41233, 37.26448], [-122.41256, 37.26383], [-122.41302, 37.26154], [-122.41337, 37.25986], [-122.41338, 37.25984], [-122.41345, 37.25984], [-122.41417, 37.25641], [-122.41436, 37.25559], [-122.41443, 37.25537], [-122.41479, 37.25541], [-122.41485, 37.25544], [-122.41491, 37.25544], [-122.41524, 37.25549], [-122.41491, 37.25615], [-122.41466, 37.25673], [-122.41443, 37.25914], [-122.41453, 37.25948], [-122.41451, 37.25951], [-122.41457, 37.2598], [-122.41726, 37.26075]]]]} | Open Access 1 | 18617 | Pescadero State Beach | 1674 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=522 | San Mateo 15 | 90.497 | Pescadero SB | 1958 | 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]);