superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=529"
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15160 | 15160 | 15159 | {"type": "MultiPolygon", "coordinates": [[[[-122.40251, 37.3184], [-122.40245, 37.31872], [-122.40101, 37.32145], [-122.40017, 37.32173], [-122.39991, 37.32221], [-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.3235], [-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.31452], [-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.317], [-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.3211], [-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.32276], [-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.40366, 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.32107], [-122.40269, 37.32054], [-122.40339, 37.31784], [-122.40414, 37.31224], [-122.40477, 37.31225]]]]} | Open Access 1 | San Gregorio State Beach | http://www.parks.ca.gov/?page_id=529 | 1728 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 161.509 | San Gregorio SB | 1958 |
15182 | 15182 | 15181 | {"type": "Polygon", "coordinates": [[[-122.40354, 37.31222], [-122.40323, 37.31448], [-122.40291, 37.31618], [-122.40251, 37.3184], [-122.39697, 37.31667], [-122.39389, 37.31659], [-122.39354, 37.31685], [-122.39214, 37.31832], [-122.39244, 37.31914], [-122.39273, 37.31943], [-122.39299, 37.31965], [-122.39422, 37.32051], [-122.39521, 37.32098], [-122.3963, 37.32204], [-122.3959, 37.32353], [-122.39537, 37.32452], [-122.39399, 37.32451], [-122.39363, 37.32444], [-122.3933, 37.32461], [-122.39188, 37.32464], [-122.39118, 37.32492], [-122.39117, 37.32495], [-122.39068, 37.32516], [-122.39047, 37.32532], [-122.38951, 37.32584], [-122.38902, 37.32488], [-122.38967, 37.32484], [-122.38989, 37.32465], [-122.38979, 37.32431], [-122.38976, 37.32402], [-122.38984, 37.32379], [-122.39092, 37.32343], [-122.39104, 37.32332], [-122.39103, 37.32322], [-122.38864, 37.32389], [-122.38852, 37.32388], [-122.38854, 37.3238], [-122.38853, 37.32371], [-122.38836, 37.3232], [-122.38829, 37.32305], [-122.38774, 37.32208], [-122.38761, 37.3219], [-122.38738, 37.32163], [-122.38733, 37.32151], [-122.38733, 37.32137], [-122.3874, 37.32121], [-122.38762, 37.321], [-122.3877, 37.32088], [-122.38772, 37.32077], [-122.38771, 37.32048], [-122.38773, 37.32041], [-122.38777, 37.32037], [-122.38786, 37.32032], [-122.38822, 37.32023], [-122.38852, 37.32006], [-122.38875, 37.31997], [-122.38886, 37.31991], [-122.38894, 37.31981], [-122.38918, 37.31934], [-122.38925, 37.31927], [-122.38935, 37.31925], [-122.38968, 37.31928], [-122.38987, 37.31923], [-122.39, 37.31915], [-122.39053, 37.31867], [-122.3909, 37.31855], [-122.39104, 37.31846], [-122.39111, 37.31833], [-122.39112, 37.31825], [-122.39111, 37.31818], [-122.39074, 37.31753], [-122.39073, 37.3175], [-122.39075, 37.31745], [-122.39079, 37.31742], [-122.39107, 37.31734], [-122.39118, 37.31728], [-122.39124, 37.31718], [-122.39125, 37.31711], [-122.39124, 37.31706], [-122.39117, 37.31695], [-122.39074, 37.31664], [-122.39064, 37.31643], [-122.39052, 37.31625], [-122.38968, 37.3152], [-122.38904, 37.3148], [-122.38889, 37.31473], [-122.38871, 37.31462], [-122.38858, 37.31452], [-122.38842, 37.31436], [-122.38828, 37.31427], [-122.38806, 37.31417], [-122.38731, 37.314], [-122.38721, 37.31396], [-122.38703, 37.31382], [-122.38684, 37.31376], [-122.38541, 37.31366], [-122.38532, 37.31363], [-122.38528, 37.31358], [-122.38528, 37.31352], [-122.38539, 37.31336], [-122.38546, 37.3132], [-122.3855, 37.31306], [-122.3855, 37.31289], [-122.38545, 37.31265], [-122.38533, 37.31248], [-122.38516, 37.31229], [-122.38515, 37.31224], [-122.38517, 37.31221], [-122.38523, 37.31219], [-122.38543, 37.3122], [-122.38558, 37.31224], [-122.38575, 37.31235], [-122.38585, 37.31239], [-122.38599, 37.31241], [-122.38612, 37.31239], [-122.38622, 37.31234], [-122.38694, 37.31189], [-122.38703, 37.3118], [-122.38707, 37.31165], [-122.40354, 37.31222]]]} | No Public Access 3 | San Gregorio State Beach | http://www.parks.ca.gov/?page_id=529 | 24904 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 291.042 | San Gregorio SB | 1958 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);