units_with_maps

Table actions

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

2 rows where GAP_STS = 4 and MNG_AGENCY = 826

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Native Habitat Preservation Authority · 2 ✖

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
7018 7018 7017 {"type": "MultiPolygon", "coordinates": [[[[-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]]], [[[-117.92633, 33.95169], [-117.92624, 33.9518], [-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.9516], [-117.92585, 33.95156], [-117.92597, 33.95157], [-117.92633, 33.95169]]]]} Open Access 1 6496 Powder Canyon Open Space 7479 2091 Native Habitat Preservation Authority 848 Special District 4 Special District - Other 26 http://www.habitatauthority.org/ Special District 4 2091 Native Habitat Preservation Authority 826 Special District 4 Special District - Other 24 http://www.lamountains.com/parks.asp?parkid=45 Los Angeles 6 27.946 Powder Canyon OS 0 Local Recreation Area 3 4
16046 16046 16045 {"type": "MultiPolygon", "coordinates": [[[[-117.96288, 33.96984], [-117.96249, 33.9704], [-117.96226, 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.97086], [-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.96202, 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.97679, 33.96737], [-117.9768, 33.96723], [-117.97685, 33.96706], [-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.98041, 33.96705], [-117.98052, 33.96678], [-117.98059, 33.96681], [-117.98023, 33.96761], [-117.98084, 33.96788]]]]} Open Access 1 6504 Arroyo San Miguel Open Space 15625 2091 Native Habitat Preservation Authority 848 Special District 4 Special District - Other 26 http://www.habitatauthority.org/ Special District 4 2091 Native Habitat Preservation Authority 826 Special District 4 Special District - Other 24   Los Angeles 6 13.411 Arroyo San Miguel OS 0 Local Recreation Area 3 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]);