units_with_maps

Table actions

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

1 row where AGNCY_TYP = 31, DES_TP = 1345 and MNG_AG_TYP = 6

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • Open Space District · 1 ✖

DES_TP 1

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
15282 15282 15281 {"type": "MultiPolygon", "coordinates": [[[[-118.01566, 33.97164], [-118.01565, 33.97527], [-118.01129, 33.97522], [-118.01115, 33.98076], [-118.01084, 33.98063], [-118.01028, 33.98102], [-118.00999, 33.982], [-118.01005, 33.9824], [-117.9948, 33.9824], [-117.99477, 33.9823], [-117.99471, 33.9822], [-117.99452, 33.98203], [-117.99442, 33.98198], [-117.99428, 33.98195], [-117.99397, 33.98193], [-117.99359, 33.98169], [-117.99375, 33.97568], [-117.99376, 33.97516], [-117.9848, 33.97512], [-117.98554, 33.97458], [-117.98606, 33.97426], [-117.98662, 33.97397], [-117.98857, 33.97305], [-117.98896, 33.97284], [-117.98942, 33.97254], [-117.98976, 33.97228], [-117.99001, 33.97207], [-117.99024, 33.97185], [-117.99173, 33.97028], [-117.9921, 33.96997], [-117.99243, 33.96974], [-117.99382, 33.9689], [-117.99382, 33.96927], [-117.99384, 33.96928], [-117.9948, 33.96871], [-117.99517, 33.96823], [-117.99565, 33.96816], [-117.99626, 33.96747], [-117.99656, 33.96738], [-117.99668, 33.96732], [-117.99694, 33.96746], [-117.99761, 33.96689], [-117.99784, 33.9669], [-117.9991, 33.9668], [-118.00017, 33.9661], [-118.00034, 33.9661], [-118.00104, 33.96561], [-118.00152, 33.96516], [-118.00193, 33.96458], [-118.00592, 33.96477], [-118.00774, 33.96578], [-118.00796, 33.96556], [-118.00827, 33.96532], [-118.00839, 33.96528], [-118.00875, 33.96504], [-118.00875, 33.96502], [-118.00951, 33.96456], [-118.00958, 33.96441], [-118.0098, 33.96413], [-118.0099, 33.96386], [-118.00989, 33.96384], [-118.01017, 33.96353], [-118.01029, 33.9636], [-118.01004, 33.96394], [-118.01053, 33.9642], [-118.00966, 33.9653], [-118.0101, 33.96556], [-118.00944, 33.96637], [-118.00857, 33.96682], [-118.00824, 33.96752], [-118.00951, 33.96824], [-118.00918, 33.96867], [-118.00952, 33.96888], [-118.00921, 33.96926], [-118.00846, 33.96884], [-118.00843, 33.96896], [-118.00792, 33.9694], [-118.00795, 33.9695], [-118.00887, 33.97002], [-118.00827, 33.97078], [-118.0088, 33.97086], [-118.00905, 33.97078], [-118.01025, 33.96928], [-118.01347, 33.97108], [-118.01348, 33.97164], [-118.01566, 33.97164]]], [[[-117.99476, 33.9824], [-117.99357, 33.98241], [-117.99359, 33.98173], [-117.99379, 33.98188], [-117.99396, 33.98196], [-117.99427, 33.98198], [-117.9945, 33.98206], [-117.99468, 33.98222], [-117.99473, 33.98231], [-117.99476, 33.9824]]]]} Open Access 1 46392 Arroyo Pescadero 29674 2332 Puente Hills Habitat Preservation Authority 849 Special District 4 Conservation District 31 http://www.habitatauthority.org Special District 4 2088 Mountains Recreation and Conservation Authority 27 Special District 4 Open Space District 6   Los Angeles 6 812.555 Arroyo Pescadero 0 None 1345  

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