units_with_maps

Table actions

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

1 row where ACCESS_TYP = 1, DES_TP = 2 and LABEL_NAME = "King Gillette Ranch"

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Park · 1 ✖

ACCESS_TYP 1

  • Open Access · 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
938 938 937 {"type": "MultiPolygon", "coordinates": [[[[-118.69792, 34.10714], [-118.69353, 34.10711], [-118.68501, 34.10711], [-118.68487, 34.09988], [-118.69337, 34.09987], [-118.69287, 34.10126], [-118.69282, 34.10153], [-118.69283, 34.10168], [-118.69285, 34.10183], [-118.69297, 34.10211], [-118.69307, 34.10225], [-118.69318, 34.10237], [-118.69338, 34.10253], [-118.69352, 34.10262], [-118.69383, 34.10273], [-118.69404, 34.10277], [-118.69426, 34.10279], [-118.69447, 34.10278], [-118.69662, 34.10254], [-118.69692, 34.10254], [-118.69721, 34.10256], [-118.69791, 34.10269], [-118.69792, 34.10714]]], [[[-118.71106, 34.10003], [-118.711, 34.10008], [-118.711, 34.1006], [-118.71099, 34.10061], [-118.71099, 34.10066], [-118.711, 34.10067], [-118.71101, 34.10229], [-118.70867, 34.10291], [-118.70755, 34.10261], [-118.70751, 34.10269], [-118.70732, 34.10264], [-118.70735, 34.10256], [-118.70735, 34.10227], [-118.70701, 34.10227], [-118.70646, 34.10285], [-118.70647, 34.10286], [-118.70927, 34.1046], [-118.70848, 34.10476], [-118.70774, 34.10486], [-118.70724, 34.10489], [-118.70674, 34.10489], [-118.706, 34.10485], [-118.70526, 34.10476], [-118.70453, 34.1046], [-118.70406, 34.10447], [-118.70337, 34.10423], [-118.70141, 34.10334], [-118.70104, 34.10319], [-118.70066, 34.10306], [-118.70008, 34.10291], [-118.69741, 34.10236], [-118.69709, 34.10233], [-118.69661, 34.10232], [-118.69444, 34.10256], [-118.69422, 34.10257], [-118.69401, 34.10254], [-118.69371, 34.10245], [-118.69353, 34.10235], [-118.69339, 34.10223], [-118.69327, 34.1021], [-118.69318, 34.10195], [-118.69312, 34.10179], [-118.6931, 34.10163], [-118.6931, 34.10146], [-118.69314, 34.1013], [-118.69364, 34.09988], [-118.70399, 34.09987], [-118.7067, 34.09985], [-118.71106, 34.0999], [-118.71106, 34.10003]]], [[[-118.70669, 34.09625], [-118.7023, 34.09625], [-118.70229, 34.09806], [-118.70011, 34.09807], [-118.7001, 34.09625], [-118.70228, 34.09625], [-118.70228, 34.09551], [-118.70342, 34.09546], [-118.70406, 34.09465], [-118.70491, 34.09451], [-118.70605, 34.09381], [-118.70636, 34.09308], [-118.70669, 34.09361], [-118.70669, 34.09625]]], [[[-118.70669, 34.09336], [-118.70649, 34.09304], [-118.70669, 34.09297], [-118.70669, 34.09329], [-118.70669, 34.09336]]]]} Open Access 1 6489 King Gillette Ranch 7140 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.mrca.ca.gov/ Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6 http://www.lamountains.com/parks.asp?parkid=670 Los Angeles 6 383.837 King Gillette Ranch 0 Local Park 2 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]);