superunits_with_maps

Table actions

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

5 rows where ACCESS_TYP = 1, MNG_AGENCY = 47 and YR_EST = 1958

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, MNG_AG_TYP

ACCESS_TYP 1

  • Open Access · 5 ✖
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
179 179 178 {"type": "MultiPolygon", "coordinates": [[[[-121.17499, 35.68531], [-121.17428, 35.68603], [-121.17415, 35.6862], [-121.17414, 35.68622], [-121.17415, 35.68623], [-121.17399, 35.68664], [-121.17108, 35.68826], [-121.16914, 35.68787], [-121.16843, 35.68807], [-121.16748, 35.68808], [-121.16448, 35.6873], [-121.16456, 35.68718], [-121.16449, 35.68716], [-121.16435, 35.68718], [-121.16346, 35.68632], [-121.16347, 35.68618], [-121.16876, 35.68171], [-121.1693, 35.68134], [-121.17032, 35.68159], [-121.17037, 35.68158], [-121.17039, 35.68162], [-121.17134, 35.68152], [-121.1721, 35.68198], [-121.17249, 35.68257], [-121.17279, 35.68263], [-121.17302, 35.6829], [-121.17295, 35.68321], [-121.17315, 35.68345], [-121.17395, 35.68317], [-121.17447, 35.68317], [-121.17482, 35.68379], [-121.17472, 35.68505], [-121.17499, 35.68531]]], [[[-121.18934, 35.64976], [-121.1891, 35.65034], [-121.18847, 35.65114], [-121.18756, 35.65158], [-121.18665, 35.65173], [-121.18567, 35.65347], [-121.18527, 35.65333], [-121.18594, 35.65211], [-121.18519, 35.65173], [-121.18538, 35.65127], [-121.18525, 35.65068], [-121.18532, 35.65019], [-121.18418, 35.64917], [-121.18375, 35.64877], [-121.18322, 35.64804], [-121.18306, 35.64748], [-121.18366, 35.64675], [-121.18728, 35.64913], [-121.18777, 35.64861], [-121.18934, 35.64976]]]]} Open Access 1 Hearst San Simeon State Historical Monument http://www.parks.ca.gov/default.asp?page_id=591 1559 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 165.527 Hearst San Simeon State Historical Monument 1958
15154 15154 15153 {"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.27721], [-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.26647], [-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.25983], [-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.25674], [-122.41443, 37.25914], [-122.41453, 37.25948], [-122.41451, 37.25951], [-122.41457, 37.25979], [-122.41726, 37.26075]]]]} Open Access 1 Pescadero State Beach http://www.parks.ca.gov/?page_id=522 1674 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 90.513 Pescadero SB 1958
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
15224 15224 15223 {"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.48436, 39.08444], [-123.48525, 39.08509], [-123.48456, 39.0858], [-123.48364, 39.08558], [-123.48367, 39.0826], [-123.48077, 39.08161], [-123.48076, 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.46022, 39.05711], [-123.46482, 39.05712], [-123.46487, 39.05796], [-123.4658, 39.05801], [-123.46596, 39.06175], [-123.46949, 39.06165], [-123.46951, 39.06546], [-123.46948, 39.06926], [-123.4742, 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 Hendy Woods State Park http://www.parks.ca.gov/?page_id=438 1562 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 827.769 Hendy Woods SP 1958
15279 15279 15278 {"type": "Polygon", "coordinates": [[[-123.82852, 40.06923], [-123.8284, 40.06931], [-123.82833, 40.06939], [-123.82828, 40.06949], [-123.82826, 40.06959], [-123.82827, 40.07021], [-123.82842, 40.07231], [-123.82843, 40.07264], [-123.8284, 40.07297], [-123.82833, 40.0733], [-123.82808, 40.07413], [-123.82689, 40.07376], [-123.82676, 40.07407], [-123.82658, 40.07434], [-123.8256, 40.07545], [-123.82526, 40.07581], [-123.82483, 40.07622], [-123.82452, 40.07647], [-123.82412, 40.07673], [-123.82374, 40.06607], [-123.80985, 40.06641], [-123.80979, 40.06534], [-123.80793, 40.06484], [-123.80484, 40.06488], [-123.80483, 40.06483], [-123.80472, 40.06483], [-123.8042, 40.06509], [-123.80364, 40.06525], [-123.80347, 40.06558], [-123.80301, 40.06575], [-123.80266, 40.06613], [-123.80256, 40.06617], [-123.80256, 40.06644], [-123.80025, 40.06774], [-123.80024, 40.0678], [-123.80016, 40.06779], [-123.79981, 40.06784], [-123.7995, 40.06776], [-123.79917, 40.06752], [-123.79772, 40.06758], [-123.79738, 40.06753], [-123.79627, 40.06769], [-123.79588, 40.0676], [-123.79569, 40.06768], [-123.79552, 40.06801], [-123.79547, 40.06804], [-123.79533, 40.0674], [-123.7951, 40.06749], [-123.79484, 40.06755], [-123.79474, 40.06762], [-123.7947, 40.0676], [-123.79467, 40.06756], [-123.79458, 40.06756], [-123.79453, 40.06765], [-123.79448, 40.06771], [-123.79439, 40.06774], [-123.79427, 40.06772], [-123.79413, 40.06777], [-123.79392, 40.06782], [-123.79367, 40.06795], [-123.79372, 40.06816], [-123.79287, 40.06815], [-123.7926, 40.06816], [-123.79233, 40.06823], [-123.79192, 40.06816], [-123.79158, 40.06816], [-123.79115, 40.06823], [-123.79111, 40.06822], [-123.79117, 40.06798], [-123.79118, 40.06779], [-123.79115, 40.0676], [-123.79108, 40.06741], [-123.79098, 40.06723], [-123.79085, 40.06707], [-123.7907, 40.06692], [-123.79042, 40.06673], [-123.7903, 40.06668], [-123.79021, 40.06679], [-123.78984, 40.06661], [-123.78964, 40.06684], [-123.78808, 40.06607], [-123.78779, 40.06582], [-123.7876, 40.0656], [-123.78713, 40.06543], [-123.78523, 40.0648], [-123.78464, 40.06456], [-123.78358, 40.06403], [-123.78338, 40.06392], [-123.7832, 40.06379], [-123.78213, 40.06291], [-123.78185, 40.06274], [-123.78164, 40.06264], [-123.78142, 40.06256], [-123.78119, 40.0625], [-123.78087, 40.06245], [-123.78032, 40.06239], [-123.77935, 40.06218], [-123.77916, 40.06213], [-123.77899, 40.06205], [-123.77875, 40.06191], [-123.77863, 40.06179], [-123.77854, 40.06167], [-123.77837, 40.06134], [-123.77835, 40.06121], [-123.77835, 40.06109], [-123.77838, 40.06096], [-123.77863, 40.06044], [-123.7787, 40.06024], [-123.77874, 40.06006], [-123.77886, 40.05898], [-123.77926, 40.05863], [-123.7813, 40.05827], [-123.78128, 40.05728], [-123.7815, 40.05719], [-123.78192, 40.05699], [-123.78352, 40.05645], [-123.78374, 40.0564], [-123.78396, 40.05637], [-123.78418, 40.05636], [-123.7847, 40.05642], [-123.78558, 40.05629], [-123.78578, 40.05624], [-123.78663, 40.05596], [-123.78729, 40.05583], [-123.78786, 40.05578], [-123.78825, 40.05577], [-123.78946, 40.05585], [-123.79003, 40.05584], [-123.79041, 40.0558], [-123.7918, 40.05562], [-123.79169, 40.05432], [-123.79151, 40.05406], [-123.79142, 40.05389], [-123.79137, 40.05372], [-123.79135, 40.05354], [-123.79137, 40.05336], [-123.79164, 40.05219], [-123.79172, 40.0517], [-123.79141, 40.05008], [-123.79106, 40.04968], [-123.79508, 40.05025], [-123.80534, 40.05096], [-123.80536, 40.05429], [-123.81047, 40.05452], [-123.81046, 40.06236], [-123.81511, 40.06221], [-123.82203, 40.06227], [-123.82216, 40.06203], [-123.82224, 40.06162], [-123.82227, 40.06152], [-123.82239, 40.06132], [-123.82246, 40.06124], [-123.82272, 40.06102], [-123.82291, 40.06089], [-123.82318, 40.06078], [-123.82344, 40.06072], [-123.82362, 40.06223], [-123.8255, 40.06223], [-123.82538, 40.06249], [-123.82526, 40.06297], [-123.82519, 40.06337], [-123.82524, 40.06358], [-123.82541, 40.06413], [-123.82557, 40.06458], [-123.8257, 40.06488], [-123.82606, 40.06571], [-123.82615, 40.06587], [-123.82649, 40.06624], [-123.8272, 40.0669], [-123.82734, 40.06707], [-123.82746, 40.06728], [-123.8276, 40.06762], [-123.82788, 40.06854], [-123.82796, 40.06897], [-123.82789, 40.06922], [-123.82852, 40.06923]]]} Open Access 1 Benbow State Recreation Area http://www.parks.ca.gov/?page_id=426 30556 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 1138.013 Benbow SRA 1958

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);