superunits_with_maps

Table actions

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

5 rows where ACCESS_TYP = 3, MNG_AGENCY = 407 and MNG_AG_TYP = 13

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Water District · 5 ✖

MNG_AGENCY 1

  • Metropolitan Water District of Southern California · 5 ✖

ACCESS_TYP 1

  • No Public 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
7897 7897 7896 {"type": "MultiPolygon", "coordinates": [[[[-118.31938, 33.77027], [-118.31914, 33.77032], [-118.31909, 33.77036], [-118.31907, 33.77043], [-118.31903, 33.77046], [-118.31865, 33.77054], [-118.31831, 33.77074], [-118.31831, 33.77026], [-118.31938, 33.77027]]], [[[-118.32632, 33.77272], [-118.3254, 33.77314], [-118.32507, 33.77327], [-118.32482, 33.77335], [-118.32046, 33.77449], [-118.32015, 33.77368], [-118.31841, 33.7731], [-118.31841, 33.77242], [-118.31838, 33.7724], [-118.31838, 33.77139], [-118.31843, 33.77137], [-118.31843, 33.77072], [-118.31867, 33.77057], [-118.31905, 33.77049], [-118.31911, 33.77045], [-118.31912, 33.7704], [-118.31915, 33.77036], [-118.31937, 33.77032], [-118.31941, 33.77029], [-118.31943, 33.77026], [-118.32399, 33.77026], [-118.32422, 33.77048], [-118.32453, 33.77071], [-118.32556, 33.7714], [-118.32574, 33.77154], [-118.32591, 33.77172], [-118.32611, 33.77201], [-118.32619, 33.77216], [-118.32629, 33.77248], [-118.32632, 33.77272]]]]} No Public Access 3 Palos Verdes Reservoir   23373 2078 Metropolitan Water District of Southern California 407 Special District 4 Water District 13 http://www.mwdh2o.com/ Special District 4 62.667 Palos Verdes Reservoir  
9424 9424 9423 {"type": "Polygon", "coordinates": [[[-114.81367, 33.47735], [-114.79635, 33.47757], [-114.79652, 33.49207], [-114.79165, 33.4923], [-114.78819, 33.4923], [-114.78801, 33.48436], [-114.77732, 33.48443], [-114.7774, 33.48827], [-114.77408, 33.4885], [-114.77397, 33.48142], [-114.7791, 33.48136], [-114.77898, 33.47792], [-114.75254, 33.47803], [-114.75242, 33.47459], [-114.74844, 33.47459], [-114.74846, 33.47067], [-114.74437, 33.47057], [-114.74437, 33.44131], [-114.74824, 33.44139], [-114.7483, 33.43375], [-114.79625, 33.43377], [-114.79621, 33.45528], [-114.81352, 33.45524], [-114.81365, 33.46296], [-114.81369, 33.472], [-114.81367, 33.47735]]]} No Public Access 3 SDG&E, Desert Land Ranch, 6,640 acres   25223 2078 Metropolitan Water District of Southern California 407 Special District 4 Water District 13 http://www.mwdh2o.com/ Special District 4 7164.494 SDG&E, Desert Land Ranch, 6,640 acres  
9426 9426 9425 {"type": "Polygon", "coordinates": [[[-114.74844, 33.47812], [-114.74841, 33.4852], [-114.74577, 33.48518], [-114.74432, 33.48512], [-114.74432, 33.49286], [-114.73948, 33.49292], [-114.73975, 33.49541], [-114.73977, 33.49613], [-114.73983, 33.49614], [-114.73985, 33.49618], [-114.74427, 33.49629], [-114.74435, 33.50013], [-114.73991, 33.50708], [-114.7268, 33.50695], [-114.72669, 33.50322], [-114.72193, 33.50328], [-114.72192, 33.5049], [-114.71804, 33.50491], [-114.7179, 33.49994], [-114.71371, 33.49994], [-114.71369, 33.50691], [-114.70388, 33.50702], [-114.70378, 33.50004], [-114.70891, 33.49998], [-114.7086, 33.49233], [-114.69972, 33.49249], [-114.69968, 33.49985], [-114.6909, 33.49991], [-114.69117, 33.49237], [-114.69368, 33.49238], [-114.69368, 33.48896], [-114.70427, 33.48907], [-114.70431, 33.48505], [-114.70829, 33.48524], [-114.70841, 33.48515], [-114.70856, 33.4778], [-114.71685, 33.47828], [-114.71712, 33.48115], [-114.72143, 33.48136], [-114.72143, 33.47782], [-114.717, 33.47781], [-114.71682, 33.47015], [-114.7264, 33.47012], [-114.72624, 33.47776], [-114.74844, 33.47812]]]} No Public Access 3 SDG&E, Henderson, 1,921 acres   25225 2078 Metropolitan Water District of Southern California 407 Special District 4 Water District 13 http://www.mwdh2o.com/ Special District 4 3064.232 SDG&E, Henderson, 1,921 acres  
9427 9427 9426 {"type": "Polygon", "coordinates": [[[-114.73212, 33.43458], [-114.7324, 33.43611], [-114.73141, 33.44813], [-114.73042, 33.45173], [-114.73028, 33.4553], [-114.72649, 33.45538], [-114.72627, 33.4629], [-114.71681, 33.46294], [-114.71678, 33.47024], [-114.70007, 33.47022], [-114.69999, 33.47644], [-114.70015, 33.47912], [-114.69985, 33.48542], [-114.69515, 33.48542], [-114.69522, 33.484], [-114.69093, 33.48404], [-114.69081, 33.47792], [-114.69437, 33.47284], [-114.69918, 33.47028], [-114.69919, 33.463], [-114.68225, 33.46298], [-114.68188, 33.43882], [-114.68407, 33.43876], [-114.68505, 33.43817], [-114.68671, 33.43603], [-114.68901, 33.43558], [-114.69107, 33.43362], [-114.70443, 33.43361], [-114.71809, 33.43367], [-114.72428, 33.42651], [-114.72643, 33.42661], [-114.72679, 33.43361], [-114.7269, 33.4337], [-114.73004, 33.43371], [-114.72547, 33.43649], [-114.72549, 33.43895], [-114.72778, 33.43891], [-114.73107, 33.4362], [-114.73212, 33.43458]]]} No Public Access 3 SDG&E, Norton, 2.164 acres   25226 2078 Metropolitan Water District of Southern California 407 Special District 4 Water District 13 http://www.mwdh2o.com/ Special District 4 4175.228 SDG&E, Norton, 2.164 acres  
9515 9515 9514 {"type": "MultiPolygon", "coordinates": [[[[-118.48094, 34.09499], [-118.48094, 34.09553], [-118.48028, 34.09636], [-118.48008, 34.09718], [-118.47968, 34.09851], [-118.47953, 34.0987], [-118.47943, 34.09891], [-118.47908, 34.09938], [-118.47893, 34.09944], [-118.47909, 34.099], [-118.47913, 34.09881], [-118.47915, 34.09861], [-118.47912, 34.09828], [-118.47902, 34.09795], [-118.47901, 34.09781], [-118.47894, 34.09758], [-118.47878, 34.09729], [-118.47866, 34.09715], [-118.47836, 34.0969], [-118.47831, 34.09687], [-118.47793, 34.09658], [-118.47718, 34.09576], [-118.47751, 34.09528], [-118.47856, 34.09537], [-118.47954, 34.09499], [-118.48094, 34.09499]]], [[[-118.47877, 34.09907], [-118.47863, 34.0994], [-118.47864, 34.09913], [-118.4786, 34.09867], [-118.47853, 34.09816], [-118.47848, 34.09794], [-118.47841, 34.09775], [-118.47806, 34.09705], [-118.47818, 34.09701], [-118.47824, 34.09704], [-118.47844, 34.09721], [-118.4786, 34.09739], [-118.47873, 34.09762], [-118.47883, 34.09791], [-118.47889, 34.09827], [-118.47889, 34.09856], [-118.47886, 34.09875], [-118.47878, 34.09899], [-118.47876, 34.09906], [-118.47877, 34.09907]]]]} No Public Access 3 Sepulveda Canyon MWD site   25303 2078 Metropolitan Water District of Southern California 407 Special District 4 Water District 13 http://www.mwdh2o.com/ Special District 4 19.601 Sepulveda Canyon MWD site  

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