units_with_maps

Table actions

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

7 rows where COUNTY = 6, DES_TP = 19 and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_NAME, AGNCY_WEB, MNG_AG_ID

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 7 ✖

DES_TP 1

  • Local Historic or Cultural Area · 7 ✖
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
1136 1136 1135 {"type": "Polygon", "coordinates": [[[-118.10845, 33.77696], [-118.10812, 33.77733], [-118.10811, 33.77767], [-118.1074, 33.77768], [-118.1063, 33.7776], [-118.10633, 33.77741], [-118.10608, 33.77704], [-118.10604, 33.77647], [-118.10563, 33.77642], [-118.10564, 33.77625], [-118.10604, 33.77629], [-118.10686, 33.77626], [-118.10722, 33.77607], [-118.10745, 33.77636], [-118.10787, 33.77635], [-118.10794, 33.77631], [-118.10845, 33.77696]]]} Open Access 1 6659 Rancho Los Alamitos Historic Site 24152 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 7.405 Rancho Los Alamitos Historic Site 0 Local Historic or Cultural Area 19 4
4225 4225 4224 {"type": "Polygon", "coordinates": [[[-118.47891, 34.01843], [-118.47761, 34.01948], [-118.47634, 34.0184], [-118.47499, 34.01949], [-118.47298, 34.01777], [-118.47616, 34.01607], [-118.47891, 34.01843]]]} Open Access 1 29311 Woodlawn Cemetery 27728 1323 Santa Monica, City of 184 City 2 City Agency 2 http://santa-monica.org/departments/ccs/content.aspx?id=32599 City 2 1323 Santa Monica, City of 180 City 2 City Agency 2   Los Angeles 6 26.5 Woodlawn Cemetery 0 Local Historic or Cultural Area 19 4
7127 7127 7126 {"type": "Polygon", "coordinates": [[[-118.24292, 33.94311], [-118.24258, 33.94313], [-118.24261, 33.94276], [-118.24292, 33.94277], [-118.24292, 33.94311]]]} Restricted Access 2 6216 Watts Historic Train Station 29326 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1717 Los Angeles - Community Redevelopment Agency, City of 829 City 2 City Agency 2   Los Angeles 6 0.287 Watts Historic Train Station 0 Local Historic or Cultural Area 19 4
7308 7308 7307 {"type": "Polygon", "coordinates": [[[-118.19678, 33.8389], [-118.19592, 33.84035], [-118.19458, 33.8398], [-118.1951, 33.83894], [-118.19568, 33.83917], [-118.19613, 33.8388], [-118.19607, 33.83861], [-118.19622, 33.83874], [-118.19634, 33.8388], [-118.19678, 33.8389]]]} Restricted Access 2 6595 Rancho Los Cerritos Historic Site 32776 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 4.786 Rancho Los Cerritos Historic Site 0 Local Historic or Cultural Area 19 4
7348 7348 7347 {"type": "Polygon", "coordinates": [[[-118.17741, 33.80621], [-118.17642, 33.80621], [-118.17642, 33.80452], [-118.17647, 33.80448], [-118.1774, 33.80448], [-118.17741, 33.80621]]]} Open Access 1 6670 Long Beach Municipal Cemetery 21448 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 4.336 Long Beach Municipal Cemetery 0 Local Historic or Cultural Area 19 4
8354 8354 8353 {"type": "MultiPolygon", "coordinates": [[[[-118.23804, 34.05665], [-118.23761, 34.05703], [-118.23757, 34.05704], [-118.23752, 34.05703], [-118.23751, 34.05698], [-118.23761, 34.05653], [-118.23783, 34.05657], [-118.23804, 34.05665]]], [[[-118.23804, 34.05645], [-118.23761, 34.05638], [-118.23763, 34.05623], [-118.23763, 34.05623], [-118.23804, 34.05645]]], [[[-118.23843, 34.05598], [-118.23816, 34.05631], [-118.23813, 34.05632], [-118.23806, 34.05631], [-118.23784, 34.05617], [-118.23768, 34.05611], [-118.23767, 34.05608], [-118.23775, 34.05566], [-118.23786, 34.05564], [-118.23797, 34.05568], [-118.23843, 34.05598]]], [[[-118.23875, 34.05625], [-118.23891, 34.05628], [-118.23901, 34.05635], [-118.23907, 34.05644], [-118.23909, 34.05655], [-118.23906, 34.05667], [-118.23897, 34.05676], [-118.23885, 34.05682], [-118.23872, 34.05683], [-118.23858, 34.0568], [-118.23849, 34.05673], [-118.23842, 34.05664], [-118.2384, 34.05653], [-118.23842, 34.05643], [-118.2385, 34.05634], [-118.23861, 34.05627], [-118.23875, 34.05625]]]]} Open Access 1 12941 El Pueblo de Los Angeles Historic Monument 28788 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 2.002 El Pueblo de Los Angeles Historic Monument 0 Local Historic or Cultural Area 19 4
11279 11279 11278 {"type": "Polygon", "coordinates": [[[-118.15783, 34.11516], [-118.15741, 34.1155], [-118.15725, 34.11565], [-118.15722, 34.11553], [-118.15722, 34.11543], [-118.15741, 34.11524], [-118.15742, 34.11513], [-118.15783, 34.11513], [-118.15783, 34.11516]]]} Open Access 1 48041 Ironwork Historical Museum and Park 32534 1340 South Pasadena, City of 309 City 2 City Agency 2 http://www.ci.south-pasadena.ca.us/ City 2 1340 South Pasadena, City of 306 City 2 City Agency 2 https://www.southpasadenaca.gov/government/departments/community-services/administration/south-pasadena-historical-museum Los Angeles 6 0.327 Ironwork Historical Museum and Park 0 Local Historic or Cultural Area 19 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]);