superunits_with_maps

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

5 rows where MNG_AG_TYP = 30

View and edit SQL

MNG_AG_TYP

  • Conservation District · 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
3728 3727 {"type": "MultiPolygon", "coordinates": [[[[-118.00813, 34.04674], [-118.00572, 34.05101], [-118.00492, 34.05209], [-118.0047, 34.05243], [-118.0044, 34.0526], [-118.00459, 34.05168], [-118.00482, 34.05171], [-118.00497, 34.05149], [-118.00512, 34.0508], [-118.00515, 34.05058], [-118.00476, 34.0505], [-118.0049, 34.04995], [-118.0053, 34.05002], [-118.00522, 34.05038], [-118.00569, 34.05046], [-118.0062, 34.04859], [-118.00572, 34.04847], [-118.00597, 34.04755], [-118.00643, 34.04763], [-118.00676, 34.04715], [-118.00675, 34.0471], [-118.00614, 34.04697], [-118.00621, 34.04672], [-118.00813, 34.04674]]], [[[-118.00544, 34.05569], [-118.00531, 34.05604], [-118.00476, 34.05566], [-118.00479, 34.05563], [-118.00491, 34.05568], [-118.00516, 34.05571], [-118.00544, 34.05569]]], [[[-118.01108, 34.04633], [-118.01063, 34.04682], [-118.01023, 34.0473], [-118.00996, 34.04766], [-118.00948, 34.04832], [-118.00896, 34.04912], [-118.00849, 34.04996], [-118.00809, 34.05077], [-118.00783, 34.05135], [-118.00756, 34.05208], [-118.00753, 34.05213], [-118.00733, 34.05273], [-118.00733, 34.05252], [-118.00732, 34.05251], [-118.00646, 34.054], [-118.0063, 34.05548], [-118.00608, 34.05535], [-118.00619, 34.05523], [-118.00629, 34.055], [-118.00632, 34.05481], [-118.0063, 34.05458], [-118.00622, 34.05439], [-118.00584, 34.0537], [-118.00577, 34.05354], [-118.00572, 34.05337], [-118.00571, 34.05316], [-118.00576, 34.05288], [-118.00613, 34.05187], [-118.00634, 34.05139], [-118.00709, 34.04998], [-118.00954, 34.04563], [-118.00963, 34.04567], [-118.00967, 34.04563], [-118.01026, 34.04597], [-118.00951, 34.04673], [-118.00951, 34.04682], [-118.01046, 34.04607], [-118.01087, 34.0463], [-118.01098, 34.04633], [-118.01108, 34.04633]]], [[[-118.01723, 34.04177], [-118.01626, 34.04227], [-118.01533, 34.04283], [-118.01464, 34.04327], [-118.0137, 34.04395], [-118.01315, 34.04438], [-118.01261, 34.04483], [-118.01196, 34.04542], [-118.01122, 34.04617], [-118.01112, 34.0462], [-118.01097, 34.0462], [-118.01088, 34.04618], [-118.01064, 34.04602], [-118.01055, 34.04599], [-118.01434, 34.04296], [-118.01443, 34.04302], [-118.01471, 34.04276], [-118.01723, 34.04177]]], [[[-118.02425, 34.03824], [-118.01421, 34.04219], [-118.01399, 34.04191], [-118.02388, 34.03802], [-118.02425, 34.03824]]], [[[-118.02362, 34.03786], [-118.02295, 34.03812], [-118.02142, 34.03872], [-118.02185, 34.03848], [-118.02227, 34.03822], [-118.02267, 34.03795], [-118.02315, 34.03758], [-118.02362, 34.03786]]]]} Restricted Access 2 Duck Farm Property   18295 2177 Watershed Conservation Authority 838 Special District 4 Conservation District 30 https://www.wca.ca.gov/ Special District 4 59.901 Duck Farm Property  
7992 7991 {"type": "Polygon", "coordinates": [[[-118.17772, 33.93261], [-118.1772, 33.93362], [-118.17654, 33.93439], [-118.17624, 33.93465], [-118.17643, 33.93339], [-118.17627, 33.93335], [-118.17638, 33.93265], [-118.17663, 33.93236], [-118.17674, 33.93177], [-118.17687, 33.93092], [-118.177, 33.93101], [-118.1771, 33.93112], [-118.17768, 33.93213], [-118.17772, 33.93261]]]} Restricted Access 2 Parque Dos Rios   23480 2177 Watershed Conservation Authority 838 Special District 4 Conservation District 30 https://www.wca.ca.gov/ Special District 4 7.012 Parque Dos Rios  
8773 8772 {"type": "MultiPolygon", "coordinates": [[[[-117.8957, 34.16384], [-117.89546, 34.1639], [-117.8952, 34.16394], [-117.89433, 34.16395], [-117.89319, 34.16241], [-117.89005, 34.16241], [-117.89005, 34.16128], [-117.89046, 34.16131], [-117.89059, 34.16129], [-117.89099, 34.16119], [-117.89118, 34.16117], [-117.89138, 34.16116], [-117.8917, 34.16119], [-117.89194, 34.16124], [-117.89227, 34.16133], [-117.89254, 34.16143], [-117.89292, 34.16192], [-117.89309, 34.16205], [-117.89327, 34.16213], [-117.89369, 34.16221], [-117.89395, 34.1623], [-117.89427, 34.16243], [-117.89453, 34.16259], [-117.8947, 34.16275], [-117.89484, 34.16291], [-117.89496, 34.16313], [-117.89504, 34.16336], [-117.89514, 34.16349], [-117.89525, 34.16359], [-117.89539, 34.16365], [-117.89552, 34.16376], [-117.8957, 34.16384]]], [[[-117.89687, 34.1626], [-117.89652, 34.16308], [-117.89636, 34.16321], [-117.89621, 34.16328], [-117.89607, 34.16332], [-117.89588, 34.16334], [-117.89572, 34.16332], [-117.89551, 34.16325], [-117.89533, 34.16313], [-117.89522, 34.163], [-117.89514, 34.16285], [-117.895, 34.16266], [-117.89489, 34.16254], [-117.89472, 34.1624], [-117.89463, 34.1624], [-117.89435, 34.16223], [-117.89405, 34.16211], [-117.89319, 34.1619], [-117.89315, 34.16185], [-117.89312, 34.16172], [-117.89306, 34.16161], [-117.89294, 34.16146], [-117.8928, 34.16136], [-117.89233, 34.16111], [-117.89207, 34.16104], [-117.89153, 34.16095], [-117.89136, 34.16094], [-117.89105, 34.16098], [-117.89046, 34.16113], [-117.8903, 34.16111], [-117.89028, 34.16113], [-117.89005, 34.16112], [-117.89005, 34.15966], [-117.89127, 34.15925], [-117.89224, 34.15922], [-117.89264, 34.15949], [-117.89276, 34.15977], [-117.89324, 34.15995], [-117.89368, 34.16002], [-117.89387, 34.16008], [-117.89416, 34.16019], [-117.89441, 34.16033], [-117.89459, 34.16034], [-117.8961, 34.16015], [-117.8966, 34.15994], [-117.8966, 34.16153], [-117.89595, 34.16238], [-117.89645, 34.16255], [-117.89687, 34.1626]]], [[[-117.89267, 34.16401], [-117.89244, 34.16404], [-117.89223, 34.16412], [-117.89222, 34.16349], [-117.89233, 34.1637], [-117.89267, 34.16401]]], [[[-117.89812, 34.16211], [-117.89703, 34.16364], [-117.89674, 34.16391], [-117.89656, 34.16403], [-117.89638, 34.16413], [-117.89617, 34.16422], [-117.89596, 34.16429], [-117.89459, 34.16456], [-117.89305, 34.16475], [-117.89289, 34.16481], [-117.89224, 34.1651], [-117.89224, 34.16445], [-117.89235, 34.16437], [-117.8925, 34.16431], [-117.89269, 34.16428], [-117.89515, 34.16422], [-117.89538, 34.16419], [-117.89558, 34.16415], [-117.8958, 34.16408], [-117.89598, 34.164], [-117.89628, 34.16382], [-117.89656, 34.1636], [-117.89669, 34.16347], [-117.89685, 34.16327], [-117.89704, 34.1629], [-117.89727, 34.16258], [-117.89736, 34.16249], [-117.8975, 34.16238], [-117.8977, 34.16226], [-117.89788, 34.16211], [-117.89812, 34.16211]]], [[[-117.89881, 34.16211], [-117.8988, 34.16512], [-117.89253, 34.16513], [-117.89299, 34.16492], [-117.89312, 34.16488], [-117.89462, 34.1647], [-117.89601, 34.16442], [-117.89642, 34.16427], [-117.89667, 34.16413], [-117.89686, 34.164], [-117.89703, 34.16386], [-117.89719, 34.16369], [-117.89831, 34.16211], [-117.89881, 34.16211]]]]} Open Access 1 River Wilderness Park   24432 2177 Watershed Conservation Authority 838 Special District 4 Conservation District 30 https://www.wca.ca.gov/ Special District 4 70.531 River Wilderness Park  
12671 12670 {"type": "MultiPolygon", "coordinates": [[[[-117.66732, 34.22279], [-117.66316, 34.22277], [-117.66446, 34.21765], [-117.66565, 34.21765], [-117.66559, 34.21786], [-117.66561, 34.21808], [-117.66565, 34.21819], [-117.66588, 34.21856], [-117.66591, 34.21867], [-117.66591, 34.21879], [-117.66578, 34.21952], [-117.6657, 34.21961], [-117.66545, 34.21974], [-117.66533, 34.21984], [-117.66529, 34.21994], [-117.66518, 34.22033], [-117.66518, 34.22044], [-117.66523, 34.22053], [-117.66559, 34.22088], [-117.66576, 34.22103], [-117.66595, 34.22115], [-117.66646, 34.2214], [-117.66663, 34.2215], [-117.66676, 34.2216], [-117.66719, 34.22202], [-117.66728, 34.22215], [-117.66735, 34.22235], [-117.66735, 34.2225], [-117.66732, 34.22279]]], [[[-117.67108, 34.21766], [-117.67083, 34.21815], [-117.67063, 34.21843], [-117.67044, 34.21863], [-117.66996, 34.21907], [-117.66975, 34.2193], [-117.66812, 34.22121], [-117.66797, 34.22142], [-117.66788, 34.22158], [-117.66781, 34.22175], [-117.66774, 34.22208], [-117.66774, 34.22233], [-117.66781, 34.22279], [-117.66752, 34.22279], [-117.66755, 34.22246], [-117.66753, 34.22227], [-117.66744, 34.22205], [-117.66729, 34.22186], [-117.66688, 34.22147], [-117.66673, 34.22136], [-117.66656, 34.22125], [-117.66609, 34.22103], [-117.6659, 34.22091], [-117.66574, 34.22077], [-117.66537, 34.2204], [-117.66537, 34.22037], [-117.66548, 34.21998], [-117.66551, 34.21992], [-117.66556, 34.21987], [-117.66585, 34.21972], [-117.66595, 34.21961], [-117.66598, 34.21951], [-117.66611, 34.2188], [-117.66611, 34.21866], [-117.66605, 34.21848], [-117.66583, 34.21813], [-117.6658, 34.21805], [-117.66579, 34.21788], [-117.66582, 34.21775], [-117.66586, 34.21765], [-117.67108, 34.21766]]], [[[-117.68059, 34.21768], [-117.68058, 34.22283], [-117.66801, 34.22279], [-117.66795, 34.22236], [-117.66795, 34.22206], [-117.66802, 34.22176], [-117.66816, 34.22147], [-117.66828, 34.22131], [-117.66992, 34.21939], [-117.67009, 34.2192], [-117.67077, 34.21856], [-117.67091, 34.21837], [-117.67102, 34.2182], [-117.67129, 34.21766], [-117.68059, 34.21768]]]]} Open Access 1 Mount Baldy Wilderness Preserve   29808 2177 Watershed Conservation Authority 838 Special District 4 Conservation District 30 https://www.wca.ca.gov/ Special District 4 211.802 Mount Baldy Wilderness Preserve  
14959 14958 {"type": "Polygon", "coordinates": [[[-117.8387, 34.08748], [-117.83646, 34.08843], [-117.83671, 34.08887], [-117.83579, 34.08925], [-117.83468, 34.0888], [-117.83421, 34.08815], [-117.8299, 34.08931], [-117.82966, 34.08906], [-117.82897, 34.08923], [-117.82825, 34.08925], [-117.82779, 34.09009], [-117.82414, 34.09106], [-117.82236, 34.0914], [-117.82146, 34.09037], [-117.82932, 34.08826], [-117.82932, 34.08848], [-117.82926, 34.08877], [-117.82967, 34.08891], [-117.82981, 34.08892], [-117.82997, 34.08875], [-117.83024, 34.08881], [-117.83059, 34.08863], [-117.83098, 34.08845], [-117.83139, 34.08831], [-117.83181, 34.08819], [-117.83225, 34.08809], [-117.83269, 34.08803], [-117.83313, 34.08799], [-117.83349, 34.08798], [-117.83349, 34.08776], [-117.83355, 34.08758], [-117.83341, 34.08717], [-117.83793, 34.08595], [-117.8387, 34.08748]]]} Restricted Access 2 Walnut Creek Habitat & Open Space   27225 2177 Watershed Conservation Authority 838 Special District 4 Conservation District 30 https://www.wca.ca.gov/ Special District 4 53.644 Walnut Creek Habitat & OS  

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]);
Powered by Datasette · Query took 34.528ms · Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette