units_with_maps

Table actions

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

1 row where AGNCY_LEV = 2, AGNCY_NAME = 24 and DES_TP = 595

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
7237 7237 7236 {"type": "MultiPolygon", "coordinates": [[[[-118.55818, 34.13732], [-118.55805, 34.13735], [-118.55778, 34.13748], [-118.55756, 34.13763], [-118.55748, 34.13771], [-118.5574, 34.13771], [-118.55739, 34.1377], [-118.55725, 34.13764], [-118.55703, 34.13758], [-118.55689, 34.13756], [-118.55665, 34.13757], [-118.55673, 34.13719], [-118.55677, 34.1368], [-118.55676, 34.13634], [-118.55671, 34.13596], [-118.55725, 34.13596], [-118.5575, 34.13677], [-118.55753, 34.13684], [-118.55762, 34.13692], [-118.55773, 34.13699], [-118.55806, 34.13707], [-118.55818, 34.13732]]], [[[-118.56666, 34.13809], [-118.56661, 34.139], [-118.56617, 34.13812], [-118.56555, 34.13792], [-118.56564, 34.13781], [-118.56568, 34.13772], [-118.56571, 34.1376], [-118.56571, 34.13751], [-118.56554, 34.13751], [-118.56445, 34.1368], [-118.56445, 34.13532], [-118.56411, 34.13534], [-118.56315, 34.13469], [-118.56485, 34.13297], [-118.56527, 34.13384], [-118.56529, 34.134], [-118.56523, 34.13409], [-118.56516, 34.13415], [-118.56502, 34.13421], [-118.56482, 34.13434], [-118.56471, 34.13447], [-118.56463, 34.13467], [-118.56462, 34.13491], [-118.56467, 34.13506], [-118.56476, 34.1352], [-118.56494, 34.13536], [-118.56496, 34.13539], [-118.56495, 34.1355], [-118.5648, 34.13565], [-118.5647, 34.13583], [-118.56468, 34.13592], [-118.5647, 34.13614], [-118.56476, 34.13629], [-118.56483, 34.13638], [-118.56501, 34.13651], [-118.56514, 34.13657], [-118.56583, 34.13677], [-118.56587, 34.1368], [-118.56589, 34.13752], [-118.56592, 34.1376], [-118.56598, 34.13774], [-118.56609, 34.13786], [-118.56627, 34.13799], [-118.56649, 34.13807], [-118.56666, 34.13809]]], [[[-118.58822, 34.14163], [-118.58781, 34.14164], [-118.58781, 34.14219], [-118.5865, 34.14232], [-118.58598, 34.1426], [-118.58569, 34.14264], [-118.58568, 34.13904], [-118.58632, 34.13904], [-118.58633, 34.13991], [-118.58822, 34.13984], [-118.58822, 34.14163]]], [[[-118.58781, 34.14233], [-118.58694, 34.14234], [-118.58678, 34.14236], [-118.5866, 34.14241], [-118.58636, 34.14253], [-118.58588, 34.14293], [-118.5858, 34.14297], [-118.5857, 34.14299], [-118.58569, 34.1427], [-118.58602, 34.14266], [-118.58652, 34.14236], [-118.58779, 34.14226], [-118.58781, 34.14226], [-118.58781, 34.14233]]]]} Open Access 1 6409 Mulholland Gateway Park of Los Angeles 22593 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 31.36 Mulholland Gateway Park of Los Angeles   None 595  

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