calands: superunits_with_maps: 2 rows where ACCESS_TYP = 1 and MNG

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

2 rows where ACCESS_TYP = 1 and MNG_AGENCY = 826

Search:

descending

This data as json, copyable, CSV (advanced)

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
609	609	608	{"type": "MultiPolygon", "coordinates": [[[[-117.92633, 33.95169], [-117.92622, 33.9518], [-117.92621, 33.95185], [-117.92598, 33.95214], [-117.92521, 33.95305], [-117.923, 33.95593], [-117.92265, 33.95634], [-117.9225, 33.95639], [-117.92154, 33.95636], [-117.92414, 33.95009], [-117.92426, 33.95043], [-117.92458, 33.95062], [-117.9247, 33.95081], [-117.925, 33.95102], [-117.92517, 33.95146], [-117.92545, 33.95147], [-117.9257, 33.95159], [-117.92585, 33.95156], [-117.92597, 33.95157], [-117.92633, 33.95169]]], [[[-117.92563, 33.95386], [-117.92551, 33.95393], [-117.92534, 33.95397], [-117.92519, 33.95397], [-117.92506, 33.95395], [-117.92502, 33.95392], [-117.925, 33.95387], [-117.92501, 33.95383], [-117.92529, 33.95348], [-117.92549, 33.95359], [-117.92554, 33.95377], [-117.92563, 33.95386]]]]}	Open Access 1	Powder Canyon Open Space	http://www.lamountains.com/parks.asp?parkid=45	7479	2091	Native Habitat Preservation Authority 826	Special District 4	Special District - Other 24	http://www.habitatauthority.org/	Special District 4	27.946	Powder Canyon OS
14824	14824	14823	{"type": "MultiPolygon", "coordinates": [[[[-117.96288, 33.96984], [-117.96249, 33.9704], [-117.96227, 33.97064], [-117.96228, 33.97088], [-117.96219, 33.97105], [-117.96204, 33.97114], [-117.96194, 33.97104], [-117.96175, 33.97093], [-117.96168, 33.97085], [-117.96159, 33.97082], [-117.96145, 33.97083], [-117.96125, 33.97077], [-117.96113, 33.97071], [-117.96104, 33.97064], [-117.96095, 33.97051], [-117.96093, 33.97033], [-117.96147, 33.96993], [-117.96156, 33.97004], [-117.96201, 33.97003], [-117.96229, 33.96993], [-117.9626, 33.96994], [-117.9628, 33.96978], [-117.96288, 33.96984]]], [[[-117.96145, 33.96988], [-117.96145, 33.9699], [-117.96096, 33.97026], [-117.96096, 33.97024], [-117.961, 33.97017], [-117.96112, 33.97006], [-117.96145, 33.96988]]], [[[-117.96165, 33.97087], [-117.96164, 33.97088], [-117.96156, 33.97086], [-117.96159, 33.97086], [-117.96165, 33.97087]]], [[[-117.97696, 33.96632], [-117.9769, 33.9664], [-117.97684, 33.96644], [-117.97661, 33.96649], [-117.97661, 33.96619], [-117.97696, 33.96632]]], [[[-117.97702, 33.96785], [-117.97665, 33.96784], [-117.97661, 33.96655], [-117.97689, 33.96666], [-117.97687, 33.96681], [-117.97678, 33.96705], [-117.97674, 33.96723], [-117.97673, 33.96739], [-117.97679, 33.96759], [-117.97684, 33.96769], [-117.97691, 33.96778], [-117.97702, 33.96785]]], [[[-117.98084, 33.96788], [-117.97717, 33.96785], [-117.97699, 33.96778], [-117.97694, 33.96773], [-117.97683, 33.96751], [-117.9768, 33.96737], [-117.9768, 33.96723], [-117.97685, 33.96705], [-117.97694, 33.96682], [-117.97697, 33.96664], [-117.97672, 33.96652], [-117.9768, 33.96651], [-117.97689, 33.96648], [-117.97698, 33.9664], [-117.97701, 33.96633], [-117.97851, 33.96688], [-117.97904, 33.96694], [-117.97955, 33.96708], [-117.9798, 33.96713], [-117.98007, 33.96716], [-117.9804, 33.96705], [-117.98052, 33.96678], [-117.98059, 33.96681], [-117.98024, 33.96761], [-117.98084, 33.96788]]]]}	Open Access 1	Arroyo San Miguel Open Space		15625	2091	Native Habitat Preservation Authority 826	Special District 4	Special District - Other 24	http://www.habitatauthority.org/	Special District 4	13.42	Arroyo San Miguel OS

Advanced export

JSON shape: default, array, newline-delimited

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