units_with_maps

Table actions

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

4 rows where COUNTY = 35 and DES_TP = 15

This data as json, copyable, CSV (advanced)

Suggested facets: UNIT_NAME, SUID_NMA, PARK_URL, LABEL_NAME, YR_EST

MNG_AG_TYP 1

DES_TP 1

  • State Park · 4 ✖

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
2922 2922 2921 {"type": "Polygon", "coordinates": [[[-120.16849, 39.03849], [-120.16848, 39.03886], [-120.16671, 39.04246], [-120.16491, 39.04242], [-120.16487, 39.04239], [-120.16502, 39.03851], [-120.16849, 39.03849]]]} Open Access 1 23079 Ed Z'Berg Sugar Pine Point State Park 1524 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=510 Placer 35 25.622 Ed Z'Berg Sugar Pine Point SP 1965 State Park 15 4
11489 11489 11488 {"type": "MultiPolygon", "coordinates": [[[[-120.26401, 39.2926], [-120.26396, 39.29362], [-120.25629, 39.29639], [-120.25501, 39.2964], [-120.255, 39.29656], [-120.25291, 39.29721], [-120.25107, 39.29784], [-120.25109, 39.29637], [-120.255, 39.29628], [-120.25498, 39.29274], [-120.26401, 39.2926]]], [[[-120.30997, 39.28577], [-120.30997, 39.29659], [-120.30995, 39.30021], [-120.30991, 39.30289], [-120.30536, 39.30185], [-120.30172, 39.30106], [-120.30165, 39.30081], [-120.30153, 39.30059], [-120.30133, 39.30035], [-120.3011, 39.30016], [-120.30039, 39.29984], [-120.29965, 39.29957], [-120.29888, 39.29934], [-120.29791, 39.29911], [-120.29711, 39.29898], [-120.29631, 39.29889], [-120.29544, 39.29883], [-120.29465, 39.29883], [-120.29386, 39.29888], [-120.29308, 39.29899], [-120.29232, 39.29915], [-120.29164, 39.29935], [-120.29164, 39.29631], [-120.2779, 39.29616], [-120.2733, 39.29614], [-120.27331, 39.29473], [-120.27357, 39.29445], [-120.27377, 39.29414], [-120.27389, 39.29384], [-120.27397, 39.29353], [-120.27398, 39.2933], [-120.27397, 39.29306], [-120.27391, 39.29275], [-120.27381, 39.29251], [-120.28249, 39.29258], [-120.2825, 39.28896], [-120.29163, 39.28906], [-120.29162, 39.28546], [-120.30997, 39.28577]]], [[[-120.24766, 39.30036], [-120.24464, 39.30353], [-120.24158, 39.30669], [-120.24109, 39.30714], [-120.24043, 39.30768], [-120.23972, 39.30819], [-120.23897, 39.30865], [-120.23818, 39.30908], [-120.23762, 39.30949], [-120.23723, 39.30975], [-120.23663, 39.31012], [-120.23606, 39.31043], [-120.23606, 39.30765], [-120.23647, 39.30052], [-120.24607, 39.30042], [-120.24766, 39.30036]]], [[[-120.30864, 39.30373], [-120.30532, 39.30384], [-120.30517, 39.30603], [-120.30499, 39.30604], [-120.30497, 39.31016], [-120.30283, 39.31141], [-120.30228, 39.31179], [-120.30186, 39.31198], [-120.30134, 39.31216], [-120.30031, 39.31278], [-120.29999, 39.31289], [-120.29954, 39.31298], [-120.29897, 39.31297], [-120.29794, 39.31265], [-120.29757, 39.31247], [-120.29716, 39.31239], [-120.29669, 39.31225], [-120.29635, 39.31195], [-120.29605, 39.31155], [-120.29588, 39.3112], [-120.29579, 39.31093], [-120.29597, 39.31047], [-120.29655, 39.30925], [-120.29733, 39.30802], [-120.29736, 39.30721], [-120.2975, 39.30677], [-120.2974, 39.30612], [-120.29724, 39.30541], [-120.29748, 39.30483], [-120.2982, 39.3044], [-120.29897, 39.3041], [-120.29997, 39.3036], [-120.30042, 39.30344], [-120.30095, 39.30279], [-120.30113, 39.30211], [-120.3011, 39.30191], [-120.30864, 39.30373]]], [[[-120.30515, 39.31477], [-120.3005, 39.31469], [-120.29592, 39.31464], [-120.28675, 39.31465], [-120.28217, 39.31458], [-120.27756, 39.31462], [-120.27408, 39.31468], [-120.26364, 39.31479], [-120.26059, 39.31479], [-120.26122, 39.31464], [-120.262, 39.31454], [-120.26222, 39.31449], [-120.26286, 39.31431], [-120.2637, 39.31404], [-120.26451, 39.31373], [-120.2651, 39.31346], [-120.26566, 39.31317], [-120.26649, 39.31269], [-120.26685, 39.31251], [-120.26736, 39.31232], [-120.26791, 39.31219], [-120.26826, 39.31213], [-120.26868, 39.3121], [-120.26986, 39.3121], [-120.27069, 39.31203], [-120.2711, 39.31197], [-120.27164, 39.31186], [-120.27266, 39.31158], [-120.27296, 39.31153], [-120.2733, 39.3115], [-120.27381, 39.31149], [-120.27432, 39.31153], [-120.27489, 39.31163], [-120.27544, 39.3118], [-120.27597, 39.31183], [-120.27639, 39.31181], [-120.27676, 39.31176], [-120.27711, 39.31167], [-120.2775, 39.31153], [-120.27781, 39.31138], [-120.2781, 39.3112], [-120.27836, 39.31099], [-120.27862, 39.31071], [-120.27892, 39.31046], [-120.27934, 39.31017], [-120.2798, 39.30993], [-120.28029, 39.30972], [-120.2808, 39.30955], [-120.28133, 39.30942], [-120.28197, 39.30933], [-120.28261, 39.30912], [-120.28305, 39.30893], [-120.28339, 39.30876], [-120.28378, 39.30851], [-120.28408, 39.3083], [-120.28436, 39.30807], [-120.28461, 39.30783], [-120.28484, 39.30757], [-120.28506, 39.30729], [-120.28533, 39.30656], [-120.28557, 39.30604], [-120.28574, 39.30569], [-120.28604, 39.30519], [-120.28636, 39.3047], [-120.28665, 39.30439], [-120.28702, 39.30407], [-120.2875, 39.30376], [-120.28797, 39.30353], [-120.28854, 39.30332], [-120.28908, 39.30307], [-120.2896, 39.30278], [-120.29008, 39.30245], [-120.29052, 39.30209], [-120.29093, 39.3017], [-120.29135, 39.3012], [-120.29171, 39.30067], [-120.29182, 39.30056], [-120.29192, 39.30048], [-120.29208, 39.3004], [-120.29226, 39.30034], [-120.29348, 39.30014], [-120.29461, 39.30002], [-120.29575, 39.29997], [-120.29666, 39.30005], [-120.29737, 39.30015], [-120.29824, 39.30034], [-120.29908, 39.30059], [-120.29962, 39.30078], [-120.29974, 39.30084], [-120.29983, 39.30091], [-120.29991, 39.30099], [-120.29999, 39.30112], [-120.30002, 39.30124], [-120.30002, 39.30136], [-120.3, 39.30146], [-120.29996, 39.30155], [-120.29988, 39.30164], [-120.29976, 39.30175], [-120.29956, 39.30187], [-120.2986, 39.30239], [-120.29708, 39.30317], [-120.29696, 39.30326], [-120.29672, 39.30345], [-120.29646, 39.30373], [-120.29629, 39.30394], [-120.29613, 39.30421], [-120.29602, 39.30444], [-120.29595, 39.30463], [-120.29586, 39.30502], [-120.29584, 39.30537], [-120.29588, 39.30578], [-120.29587, 39.30614], [-120.29581, 39.30675], [-120.29573, 39.30721], [-120.29557, 39.30756], [-120.29539, 39.30788], [-120.29518, 39.30819], [-120.29494, 39.30849], [-120.29476, 39.30878], [-120.29457, 39.30921], [-120.29446, 39.30959], [-120.29441, 39.30991], [-120.29439, 39.31031], [-120.29444, 39.31076], [-120.29455, 39.31121], [-120.29456, 39.31131], [-120.29447, 39.31175], [-120.29449, 39.31181], [-120.29472, 39.31169], [-120.29476, 39.31171], [-120.29481, 39.31178], [-120.29502, 39.31214], [-120.29525, 39.31238], [-120.29546, 39.31256], [-120.29574, 39.31277], [-120.29604, 39.31296], [-120.29643, 39.31316], [-120.2967, 39.31328], [-120.29728, 39.31346], [-120.2978, 39.31358], [-120.29842, 39.31364], [-120.29904, 39.31364], [-120.29957, 39.31358], [-120.30017, 39.31345], [-120.30053, 39.31334], [-120.3016, 39.31293], [-120.30233, 39.31262], [-120.3034, 39.31213], [-120.30444, 39.31159], [-120.30512, 39.3112], [-120.30515, 39.31477]]], [[[-120.29067, 39.29994], [-120.29038, 39.30038], [-120.29, 39.30084], [-120.28957, 39.30127], [-120.28916, 39.30159], [-120.28872, 39.30189], [-120.28825, 39.30216], [-120.28795, 39.3023], [-120.28758, 39.30243], [-120.28721, 39.30258], [-120.28661, 39.30289], [-120.28629, 39.30309], [-120.28599, 39.30331], [-120.28551, 39.30373], [-120.28514, 39.30415], [-120.28488, 39.30454], [-120.28452, 39.30514], [-120.2841, 39.30596], [-120.28392, 39.30638], [-120.28375, 39.30683], [-120.28357, 39.30705], [-120.28339, 39.30724], [-120.28305, 39.30753], [-120.28283, 39.30769], [-120.28248, 39.30789], [-120.28217, 39.30804], [-120.28184, 39.30817], [-120.28164, 39.30824], [-120.28096, 39.30834], [-120.2803, 39.3085], [-120.27966, 39.30871], [-120.27916, 39.30893], [-120.27868, 39.30918], [-120.27831, 39.3094], [-120.27789, 39.30971], [-120.27745, 39.3101], [-120.27725, 39.31024], [-120.27682, 39.31052], [-120.27655, 39.31064], [-120.27628, 39.31069], [-120.27599, 39.31069], [-120.27588, 39.31067], [-120.27514, 39.31046], [-120.27459, 39.31036], [-120.27392, 39.31029], [-120.27325, 39.31029], [-120.27282, 39.31033], [-120.27239, 39.3104], [-120.272, 39.31051], [-120.27134, 39.3107], [-120.2709, 39.3108], [-120.27056, 39.31086], [-120.26989, 39.31093], [-120.26894, 39.31094], [-120.26855, 39.31096], [-120.26797, 39.31103], [-120.2674, 39.31115], [-120.26667, 39.31136], [-120.26607, 39.3116], [-120.26567, 39.3118], [-120.26522, 39.31207], [-120.26449, 39.31246], [-120.26396, 39.31271], [-120.26322, 39.313], [-120.26246, 39.31326], [-120.26188, 39.31342], [-120.26168, 39.31347], [-120.26115, 39.31354], [-120.26062, 39.31363], [-120.2601, 39.31376], [-120.2596, 39.31391], [-120.25899, 39.31413], [-120.25841, 39.3144], [-120.25797, 39.31464], [-120.25731, 39.31505], [-120.257, 39.31521], [-120.25667, 39.31535], [-120.25628, 39.31549], [-120.25583, 39.31561], [-120.25537, 39.3157], [-120.255, 39.31575], [-120.25443, 39.31578], [-120.25443, 39.31507], [-120.25253, 39.31503], [-120.25064, 39.31496], [-120.24995, 39.31485], [-120.24908, 39.31476], [-120.24834, 39.31474], [-120.24773, 39.31475], [-120.24707, 39.3147], [-120.24641, 39.31458], [-120.24618, 39.31452], [-120.24598, 39.31444], [-120.24581, 39.31432], [-120.24567, 39.3142], [-120.24557, 39.31406], [-120.24549, 39.31389], [-120.24545, 39.31368], [-120.24548, 39.31345], [-120.24557, 39.31327], [-120.24572, 39.31308], [-120.24585, 39.31298], [-120.24597, 39.31291], [-120.24641, 39.31271], [-120.24676, 39.31253], [-120.24733, 39.31216], [-120.24763, 39.31193], [-120.2479, 39.31169], [-120.24816, 39.31143], [-120.24844, 39.31109], [-120.24869, 39.31072], [-120.24882, 39.3102], [-120.24898, 39.30973], [-120.24924, 39.30916], [-120.2495, 39.30871], [-120.24972, 39.30839], [-120.24996, 39.30807], [-120.25023, 39.30776], [-120.25051, 39.30747], [-120.2515, 39.30608], [-120.25268, 39.30432], [-120.25287, 39.30412], [-120.25308, 39.30391], [-120.25337, 39.30368], [-120.25364, 39.3035], [-120.25422, 39.30318], [-120.25459, 39.30302], [-120.25485, 39.30292], [-120.25459, 39.30751], [-120.2545, 39.31113], [-120.26375, 39.31117], [-120.2639, 39.30743], [-120.26402, 39.30358], [-120.27321, 39.30346], [-120.27328, 39.29979], [-120.29067, 39.29994]]], [[[-120.27214, 39.29251], [-120.27233, 39.29267], [-120.27247, 39.29286], [-120.27255, 39.29309], [-120.27257, 39.29334], [-120.27252, 39.2936], [-120.27242, 39.2938], [-120.27225, 39.294], [-120.27205, 39.29416], [-120.26103, 39.2999], [-120.25503, 39.29994], [-120.25099, 39.30011], [-120.25071, 39.30504], [-120.25034, 39.30564], [-120.24995, 39.30622], [-120.24952, 39.30679], [-120.24888, 39.30756], [-120.24584, 39.30759], [-120.24574, 39.31171], [-120.24537, 39.31184], [-120.24502, 39.31203], [-120.24473, 39.31223], [-120.24447, 39.31249], [-120.24425, 39.31278], [-120.24412, 39.31305], [-120.24404, 39.31334], [-120.24401, 39.31363], [-120.24403, 39.31393], [-120.24411, 39.31422], [-120.24424, 39.3145], [-120.24441, 39.31476], [-120.2447, 39.31506], [-120.24494, 39.31524], [-120.24529, 39.31544], [-120.24558, 39.31557], [-120.24584, 39.31565], [-120.24675, 39.31573], [-120.24766, 39.31573], [-120.24856, 39.31566], [-120.24899, 39.31568], [-120.24935, 39.31572], [-120.25005, 39.31585], [-120.25064, 39.31603], [-120.25072, 39.31606], [-120.25065, 39.31606], [-120.25064, 39.31607], [-120.25089, 39.31626], [-120.23608, 39.31618], [-120.22669, 39.31615], [-120.22667, 39.31597], [-120.22818, 39.31578], [-120.22847, 39.31573], [-120.22896, 39.3156], [-120.22937, 39.31542], [-120.22961, 39.31529], [-120.22987, 39.31512], [-120.23011, 39.31492], [-120.23028, 39.31474], [-120.23044, 39.31455], [-120.2306, 39.31431], [-120.2307, 39.31412], [-120.23079, 39.31383], [-120.23095, 39.31356], [-120.23118, 39.31332], [-120.23147, 39.31311], [-120.23167, 39.31301], [-120.23189, 39.31292], [-120.23554, 39.31203], [-120.23657, 39.31148], [-120.23724, 39.31109], [-120.23822, 39.31047], [-120.23884, 39.31004], [-120.23942, 39.30962], [-120.24024, 39.3092], [-120.24071, 39.30892], [-120.24116, 39.30862], [-120.24187, 39.30809], [-120.24226, 39.30775], [-120.24264, 39.30739], [-120.24853, 39.30123], [-120.24871, 39.30099], [-120.24901, 39.30067], [-120.24931, 39.30041], [-120.24954, 39.30023], [-120.24989, 39.29989], [-120.25019, 39.29964], [-120.25057, 39.29937], [-120.25097, 39.29913], [-120.25212, 39.29863], [-120.25306, 39.29825], [-120.25402, 39.29791], [-120.25501, 39.2976], [-120.25501, 39.29805], [-120.25503, 39.29806], [-120.26391, 39.29486], [-120.2679, 39.29335], [-120.26859, 39.29301], [-120.26894, 39.29287], [-120.26941, 39.29271], [-120.2701, 39.29253], [-120.27214, 39.29251]]]]} Open Access 1 23132 Donner Memorial State Park 1503 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=503 Placer 35 2904.978 Donner Memorial SP 1928 State Park 15 4
12932 12932 12931 {"type": "Polygon", "coordinates": [[[-120.30986, 39.31656], [-120.30053, 39.31651], [-120.3005, 39.31469], [-120.30982, 39.31487], [-120.30986, 39.31656]]]} Open Access 1 44720 Donner Memorial State Park 1503 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=503 Placer 35 38.797 Donner Memorial SP 1928 State Park 15 4
16561 16561 16560 {"type": "MultiPolygon", "coordinates": [[[[-120.16091, 39.20563], [-120.14219, 39.2056], [-120.13286, 39.20564], [-120.13288, 39.202], [-120.13287, 39.1983], [-120.1235, 39.19836], [-120.1234, 39.19101], [-120.1234, 39.18726], [-120.12343, 39.18638], [-120.12492, 39.18637], [-120.12489, 39.1862], [-120.12479, 39.18593], [-120.12468, 39.18566], [-120.1242, 39.18509], [-120.12388, 39.18427], [-120.12374, 39.18407], [-120.1241, 39.18388], [-120.12454, 39.18368], [-120.12938, 39.18367], [-120.13495, 39.18369], [-120.13495, 39.18291], [-120.13236, 39.17826], [-120.13482, 39.17692], [-120.13491, 39.177], [-120.13492, 39.17642], [-120.13508, 39.17632], [-120.13891, 39.17636], [-120.13946, 39.17719], [-120.14358, 39.18372], [-120.15309, 39.18378], [-120.16086, 39.18398], [-120.16084, 39.19824], [-120.16091, 39.20563]]], [[[-120.14412, 39.16673], [-120.14389, 39.16687], [-120.14386, 39.16691], [-120.14377, 39.16692], [-120.14361, 39.16699], [-120.14339, 39.16715], [-120.1432, 39.16721], [-120.14286, 39.16718], [-120.14279, 39.16712], [-120.14264, 39.1669], [-120.14242, 39.16672], [-120.14231, 39.16659], [-120.14271, 39.16657], [-120.14288, 39.16642], [-120.14305, 39.16648], [-120.14312, 39.16645], [-120.14311, 39.16618], [-120.14331, 39.16597], [-120.14344, 39.16604], [-120.14357, 39.16608], [-120.14369, 39.1661], [-120.14375, 39.16607], [-120.14388, 39.16638], [-120.14412, 39.16673]]]]} Open Access 1 17050 Burton Creek State Park 1449 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=512 Placer 35 1902.333 Burton Creek SP 1976 State Park 15 4

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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