units_with_maps

Table actions

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

1 row where AGNCY_TYP = 2 and DES_TP = 527

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 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
6565 6565 6564 {"type": "MultiPolygon", "coordinates": [[[[-118.89397, 34.07022], [-118.89392, 34.07022], [-118.89392, 34.06902], [-118.89424, 34.0693], [-118.8943, 34.06938], [-118.89437, 34.06951], [-118.8944, 34.06966], [-118.89437, 34.06984], [-118.89429, 34.06997], [-118.89418, 34.07009], [-118.89397, 34.07022]]], [[[-118.89424, 34.06843], [-118.89421, 34.06851], [-118.89416, 34.06857], [-118.89392, 34.06868], [-118.89393, 34.06852], [-118.89419, 34.0684], [-118.89423, 34.0684], [-118.89424, 34.06843]]], [[[-118.89441, 34.06763], [-118.89439, 34.06795], [-118.89436, 34.06803], [-118.89414, 34.06829], [-118.89404, 34.06835], [-118.89393, 34.0684], [-118.89393, 34.06737], [-118.89425, 34.06737], [-118.89424, 34.06743], [-118.89426, 34.06749], [-118.89438, 34.06759], [-118.89441, 34.06763]]], [[[-118.89828, 34.06848], [-118.89618, 34.06848], [-118.89617, 34.06963], [-118.89527, 34.06963], [-118.89526, 34.06967], [-118.89453, 34.06967], [-118.8945, 34.06947], [-118.8944, 34.06929], [-118.89394, 34.06886], [-118.89393, 34.06883], [-118.89396, 34.0688], [-118.8942, 34.06868], [-118.8943, 34.06859], [-118.8945, 34.06817], [-118.89449, 34.06815], [-118.89442, 34.06815], [-118.89448, 34.06807], [-118.89452, 34.06799], [-118.89454, 34.0676], [-118.89449, 34.06752], [-118.89438, 34.06743], [-118.89438, 34.06741], [-118.89441, 34.06739], [-118.8946, 34.06741], [-118.89473, 34.0674], [-118.89492, 34.06732], [-118.89502, 34.06723], [-118.89507, 34.06713], [-118.89509, 34.06704], [-118.89508, 34.06695], [-118.89504, 34.06685], [-118.89504, 34.0668], [-118.89536, 34.06652], [-118.89543, 34.06639], [-118.89543, 34.06625], [-118.89533, 34.06606], [-118.89533, 34.066], [-118.89537, 34.06597], [-118.89562, 34.06585], [-118.89569, 34.0658], [-118.89595, 34.06545], [-118.89598, 34.06535], [-118.89604, 34.06467], [-118.89608, 34.0646], [-118.89623, 34.06445], [-118.89628, 34.06437], [-118.89641, 34.06383], [-118.89646, 34.06375], [-118.89688, 34.06375], [-118.89689, 34.06458], [-118.89738, 34.06458], [-118.89737, 34.06376], [-118.89828, 34.06377], [-118.89828, 34.06848]]], [[[-118.89433, 34.07012], [-118.89432, 34.07022], [-118.8942, 34.07022], [-118.89427, 34.07017], [-118.89433, 34.07012]]]]} Open Access 1 3476 Decker Canyon Camp 17985 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 40.674 Decker Canyon Camp   None 527  

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