units_with_maps

Table actions

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

5 rows where DES_TP = 2, LAYER = 2 and MNG_AGENCY = 331

This data as json, copyable, CSV (advanced)

Suggested facets: YR_EST

MNG_AG_TYP 1

MNG_AGENCY 1

  • West Hollywood, City of · 5 ✖

DES_TP 1

  • Local Park · 5 ✖

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
1217 1217 1216 {"type": "Polygon", "coordinates": [[[-118.35173, 34.0933], [-118.35164, 34.09346], [-118.35164, 34.09393], [-118.35064, 34.09391], [-118.35063, 34.09304], [-118.35019, 34.09303], [-118.35019, 34.09276], [-118.35063, 34.09275], [-118.35062, 34.09086], [-118.35126, 34.09086], [-118.35125, 34.09183], [-118.35135, 34.09184], [-118.35136, 34.09223], [-118.35173, 34.09224], [-118.35173, 34.0933]]]} Open Access 1 8660 Plummer Park 23817 1375 West Hollywood, City of 334 City 2 City Agency 2 http://www.weho.org/residents/recreation-services/parks-and-facilities City 2 1375 West Hollywood, City of 331 City 2 City Agency 2   Los Angeles 6 7.175 Plummer Park 0 Local Park 2 4
9187 9187 9186 {"type": "Polygon", "coordinates": [[[-118.38539, 34.08326], [-118.38493, 34.08326], [-118.38493, 34.08361], [-118.38498, 34.08361], [-118.3842, 34.08415], [-118.38391, 34.08423], [-118.3839, 34.08399], [-118.38399, 34.08286], [-118.38399, 34.08271], [-118.38397, 34.08254], [-118.38392, 34.08238], [-118.38386, 34.08223], [-118.38374, 34.08203], [-118.38488, 34.08167], [-118.38491, 34.08173], [-118.38501, 34.0817], [-118.385, 34.08221], [-118.38492, 34.08222], [-118.38493, 34.08278], [-118.38539, 34.08279], [-118.38539, 34.08326]]]} Open Access 1 15253 West Hollywood Park 27363 1375 West Hollywood, City of 334 City 2 City Agency 2 http://www.weho.org/residents/recreation-services/parks-and-facilities City 2 1375 West Hollywood, City of 331 City 2 City Agency 2   Los Angeles 6 6.13 West Hollywood Park 0 Local Park 2 4
10866 10866 10865 {"type": "Polygon", "coordinates": [[[-118.37163, 34.08917], [-118.37097, 34.08918], [-118.37097, 34.08883], [-118.37163, 34.08882], [-118.37163, 34.08917]]]} Open Access 1 20665 Kings Road Park 20665 1375 West Hollywood, City of 334 City 2 City Agency 2 http://www.weho.org/residents/recreation-services/parks-and-facilities City 2 1375 West Hollywood, City of 331 City 2 City Agency 2   Los Angeles 6 0.594 Kings Road Park 0 Local Park 2 4
10867 10867 10866 {"type": "MultiPolygon", "coordinates": [[[[-118.37206, 34.09536], [-118.37183, 34.09553], [-118.37158, 34.09578], [-118.37119, 34.09547], [-118.37151, 34.09516], [-118.37176, 34.09498], [-118.37206, 34.09536]]], [[[-118.53446, 34.36948], [-118.5343, 34.36956], [-118.53408, 34.36933], [-118.53078, 34.36953], [-118.53105, 34.37018], [-118.52991, 34.37193], [-118.52938, 34.37276], [-118.52995, 34.37303], [-118.52982, 34.37493], [-118.52952, 34.3748], [-118.52942, 34.37494], [-118.52977, 34.37509], [-118.52978, 34.37519], [-118.5298, 34.37616], [-118.52905, 34.37584], [-118.52824, 34.37715], [-118.52458, 34.37558], [-118.52378, 34.37517], [-118.52284, 34.37396], [-118.52262, 34.37357], [-118.52252, 34.37331], [-118.52241, 34.37288], [-118.52238, 34.37267], [-118.52238, 34.37229], [-118.5224, 34.37214], [-118.52343, 34.36651], [-118.52697, 34.36695], [-118.52783, 34.36707], [-118.5277, 34.36776], [-118.52787, 34.36791], [-118.52915, 34.368], [-118.52959, 34.36827], [-118.53418, 34.36799], [-118.53427, 34.36895], [-118.53438, 34.36938], [-118.53446, 34.36948]]]]} Open Access 1 20666 William S Hart Park 27557 1375 West Hollywood, City of 334 City 2 City Agency 2 http://www.weho.org/residents/recreation-services/parks-and-facilities City 2 1375 West Hollywood, City of 331 City 2 City Agency 2   Los Angeles 6 176.583 William S Hart Park 0 Local Park 2 4
11459 11459 11458 {"type": "Polygon", "coordinates": [[[-118.36519, 34.09549], [-118.36478, 34.0955], [-118.36479, 34.09569], [-118.36502, 34.09571], [-118.36502, 34.09582], [-118.36457, 34.09582], [-118.36457, 34.09538], [-118.36518, 34.09538], [-118.36519, 34.09549]]]} Open Access 1 48159 Laurel Park 32697 1375 West Hollywood, City of 334 City 2 City Agency 2 http://www.weho.org/residents/recreation-services/parks-and-facilities City 2 1375 West Hollywood, City of 331 City 2 City Agency 2   Los Angeles 6 0.43 Laurel Park 2011 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]);