calands: units_with_maps: 6 rows where ACCESS_TYP = 3, MNG_AGENCY = 407 and MNG_AG

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

6 rows where ACCESS_TYP = 3, MNG_AGENCY = 407 and MNG_AG_LEV = 4

Search:

descending

This data as json, copyable, CSV (advanced)

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	COUNTY	ACRES	LABEL_NAME	YR_EST	DES_TP	GAP_STS
5448	5448	5447	{"type": "Polygon", "coordinates": [[[-114.81367, 33.47735], [-114.79638, 33.47756], [-114.79635, 33.47757], [-114.79652, 33.49207], [-114.79165, 33.4923], [-114.78819, 33.4923], [-114.78802, 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.47458], [-114.74844, 33.47459], [-114.74847, 33.47067], [-114.74437, 33.47057], [-114.74437, 33.44131], [-114.74824, 33.4414], [-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	11970	SDG&E, Desert Land Ranch, 6,640 acres	25223	2078	Metropolitan Water District of Southern California 413	Special District 4	Water District 13	http://www.mwdh2o.com/	Special District 4	2078	Metropolitan Water District of Southern California 407	Special District 4	Water District 13	Riverside 10	7163.793	SDG&E, Desert Land Ranch, 6,640 acres		None 440
6982	6982	6981	{"type": "MultiPolygon", "coordinates": [[[[-118.31938, 33.77027], [-118.31935, 33.77028], [-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.77138], [-118.31843, 33.77072], [-118.31867, 33.77057], [-118.31905, 33.77049], [-118.31911, 33.77044], [-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	5905	Palos Verdes Reservoir	23373	2078	Metropolitan Water District of Southern California 413	Special District 4	Water District 13	http://www.mwdh2o.com/	Special District 4	2078	Metropolitan Water District of Southern California 407	Special District 4	Water District 13	Los Angeles 6	62.667	Palos Verdes Reservoir	0	Local Recreation Area 3	4
8071	8071	8070	{"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.73976, 33.49613], [-114.73983, 33.49614], [-114.73984, 33.49618], [-114.74427, 33.49629], [-114.74435, 33.50013], [-114.73991, 33.50708], [-114.7268, 33.50695], [-114.7267, 33.50322], [-114.72192, 33.50328], [-114.72192, 33.5049], [-114.71804, 33.50491], [-114.71791, 33.49994], [-114.7137, 33.49993], [-114.71369, 33.50691], [-114.70388, 33.50702], [-114.70378, 33.50004], [-114.70891, 33.49999], [-114.70861, 33.49233], [-114.69972, 33.49249], [-114.69968, 33.49985], [-114.6909, 33.49991], [-114.69117, 33.49237], [-114.69368, 33.49239], [-114.69368, 33.48896], [-114.70428, 33.48907], [-114.70431, 33.48505], [-114.7083, 33.48524], [-114.70841, 33.48515], [-114.70856, 33.4778], [-114.71685, 33.47828], [-114.71712, 33.48116], [-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	11994	SDG&E, Henderson, 1,921 acres	25225	2078	Metropolitan Water District of Southern California 413	Special District 4	Water District 13	http://www.mwdh2o.com/	Special District 4	2078	Metropolitan Water District of Southern California 407	Special District 4	Water District 13	Riverside 10	3063.6	SDG&E, Henderson, 1,921 acres		None 670
8073	8073	8072	{"type": "Polygon", "coordinates": [[[-114.72689, 33.4337], [-114.71809, 33.43367], [-114.71809, 33.43366], [-114.72428, 33.42651], [-114.72643, 33.42661], [-114.72679, 33.43361], [-114.72689, 33.4337]]]}	No Public Access 3	12006	SDG&E, Norton, 2.164 acres	25226	2078	Metropolitan Water District of Southern California 413	Special District 4	Water District 13	http://www.mwdh2o.com/	Special District 4	2078	Metropolitan Water District of Southern California 407	Special District 4	Water District 13	Imperial 20	99.083	SDG&E, Norton, 2.164 acres		None 671
8075	8075	8074	{"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.45537], [-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.69523, 33.484], [-114.69093, 33.48404], [-114.69081, 33.47792], [-114.69437, 33.47284], [-114.69918, 33.47028], [-114.69919, 33.46299], [-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.73004, 33.43371], [-114.72547, 33.4365], [-114.72549, 33.43895], [-114.7255, 33.43896], [-114.72777, 33.43891], [-114.73107, 33.4362], [-114.73212, 33.43458]]]}	No Public Access 3	12018	SDG&E, Norton, 2.164 acres	25226	2078	Metropolitan Water District of Southern California 413	Special District 4	Water District 13	http://www.mwdh2o.com/	Special District 4	2078	Metropolitan Water District of Southern California 407	Special District 4	Water District 13	Riverside 10	4075.639	SDG&E, Norton, 2.164 acres		None 672
8280	8280	8279	{"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.09714], [-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.4789, 34.09827], [-118.47889, 34.09857], [-118.47886, 34.09875], [-118.47878, 34.09899], [-118.47876, 34.09906], [-118.47877, 34.09907]]]]}	No Public Access 3	12704	Sepulveda Canyon MWD site	25303	2078	Metropolitan Water District of Southern California 413	Special District 4	Water District 13	http://www.mwdh2o.com/	Special District 4	2078	Metropolitan Water District of Southern California 407	Special District 4	Water District 13	Los Angeles 6	19.6	Sepulveda Canyon MWD site		None 690

Advanced export

JSON shape: default, array, newline-delimited

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