units_with_maps

Table actions

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

3 rows where ACCESS_TYP = 1, LABEL_NAME = "Mtns. Restoration Trust Parkland" and MNG_AGENCY = 526

This data as json, copyable, CSV (advanced)

These facets timed out: MNG_AGENCY, DES_TP

MNG_AG_TYP 1

ACCESS_TYP 1

  • Open Access · 3 ✖
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
5006 5006 5005 {"type": "Polygon", "coordinates": [[[-118.62819, 34.09631], [-118.62814, 34.1035], [-118.62683, 34.10349], [-118.62683, 34.10402], [-118.62661, 34.10402], [-118.6266, 34.10349], [-118.6238, 34.10347], [-118.62382, 34.09987], [-118.62381, 34.09806], [-118.61947, 34.09805], [-118.61948, 34.09625], [-118.62381, 34.09625], [-118.62819, 34.09631]]]} Open Access 1 12508 Mountains Restoration Trust Parkland 22563 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 99.528 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
5407 5407 5406 {"type": "Polygon", "coordinates": [[[-118.44355, 34.10751], [-118.443, 34.10752], [-118.44352, 34.10878], [-118.44023, 34.10877], [-118.44022, 34.10977], [-118.43891, 34.10965], [-118.4389, 34.11005], [-118.43864, 34.11005], [-118.43799, 34.10993], [-118.43749, 34.10981], [-118.43745, 34.10968], [-118.43747, 34.10956], [-118.43721, 34.10939], [-118.43722, 34.10936], [-118.43714, 34.10934], [-118.43707, 34.10929], [-118.43709, 34.10922], [-118.43709, 34.10895], [-118.43705, 34.10884], [-118.43772, 34.10905], [-118.43841, 34.10906], [-118.4389, 34.1088], [-118.43891, 34.10871], [-118.44022, 34.10836], [-118.44023, 34.10745], [-118.44353, 34.10745], [-118.44355, 34.10751]]]} Open Access 1 12500 Mountains Restoration Trust Parkland 22563 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 18.111 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 4
15852 15852 15851 {"type": "Polygon", "coordinates": [[[-118.65341, 34.04402], [-118.65239, 34.04383], [-118.65222, 34.04364], [-118.65222, 34.04358], [-118.65237, 34.0435], [-118.65252, 34.04337], [-118.65338, 34.04326], [-118.65341, 34.04402]]]} Open Access 1 12524 Mountains Restoration Trust Parkland 22563 3044 Mountains Restoration Trust 533 Non Profit 6 Non Profit - Conservation 12 http://www.mountainstrust.org/ Non Governmental Organization 10 3044 Mountains Restoration Trust 526 Non Profit 6 Non Profit - Conservation 12   Los Angeles 6 1.603 Mtns. Restoration Trust Parkland 0 Private Recreation or Education 65 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]);