units_with_maps

Table actions

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

8 rows where MNG_AGENCY = 366, MNG_AG_TYP = 2 and YR_EST = 0

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

  • City Agency · 8 ✖

MNG_AGENCY 1

  • Signal Hill, City of · 8 ✖

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
1460 1460 1459 {"type": "Polygon", "coordinates": [[[-118.17515, 33.81884], [-118.17416, 33.81885], [-118.17418, 33.81711], [-118.17514, 33.81709], [-118.17515, 33.81884]]]} Open Access 1 9832 Reservoir Park 24302 1334 Signal Hill, City of 371 City 2 City Agency 2 http://www.cityofsignalhill.org/index.aspx?nid=26 City 2 1334 Signal Hill, City of 366 City 2 City Agency 2   Los Angeles 6 4.305 Reservoir Park 0 Local Park 2 4
2954 2954 2953 {"type": "Polygon", "coordinates": [[[-118.16587, 33.79894], [-118.16596, 33.79897], [-118.1661, 33.79905], [-118.16619, 33.79908], [-118.16624, 33.79911], [-118.16627, 33.79915], [-118.16629, 33.79923], [-118.16621, 33.79945], [-118.16606, 33.79976], [-118.1658, 33.80013], [-118.16573, 33.80021], [-118.16535, 33.79997], [-118.16507, 33.79997], [-118.16502, 33.79995], [-118.165, 33.79992], [-118.16501, 33.7988], [-118.16506, 33.79879], [-118.16535, 33.79881], [-118.16587, 33.79894]]]} Open Access 1 20450 Hilltop Park 19991 1334 Signal Hill, City of 371 City 2 City Agency 2 http://www.cityofsignalhill.org/index.aspx?nid=26 City 2 1334 Signal Hill, City of 366 City 2 City Agency 2 http://www.cityofsignalhill.org/facilities/Facility/Details/3 Los Angeles 6 3.327 Hilltop Park 0 Local Park 2 4
2956 2956 2955 {"type": "Polygon", "coordinates": [[[-118.16393, 33.79882], [-118.16364, 33.79882], [-118.16357, 33.79876], [-118.16352, 33.79865], [-118.16345, 33.79857], [-118.16302, 33.79827], [-118.16309, 33.79825], [-118.16335, 33.79828], [-118.16356, 33.79833], [-118.16359, 33.79838], [-118.16364, 33.79841], [-118.16378, 33.79842], [-118.16379, 33.7987], [-118.16393, 33.79882]]]} Open Access 1 20451 Sunset View Park 26069 1334 Signal Hill, City of 371 City 2 City Agency 2 http://www.cityofsignalhill.org/index.aspx?nid=26 City 2 1334 Signal Hill, City of 366 City 2 City Agency 2 http://www.cityofsignalhill.org/Facilities/Facility/Details/4 Los Angeles 6 0.507 Sunset View Park 0 Local Park 2 4
2957 2957 2956 {"type": "Polygon", "coordinates": [[[-118.15958, 33.79117], [-118.15899, 33.79119], [-118.15902, 33.79082], [-118.15956, 33.79083], [-118.15958, 33.79117]]]} Open Access 1 20453 Hillbrook Park 19961 1334 Signal Hill, City of 371 City 2 City Agency 2 http://www.cityofsignalhill.org/index.aspx?nid=26 City 2 1334 Signal Hill, City of 366 City 2 City Agency 2   Los Angeles 6 0.509 Hillbrook Park 0 Local Park 2 4
2958 2958 2957 {"type": "Polygon", "coordinates": [[[-118.1811, 33.80179], [-118.18076, 33.80179], [-118.18076, 33.80122], [-118.18108, 33.80123], [-118.1811, 33.80179]]]} Open Access 1 20454 Calbrisas Park 16673 1334 Signal Hill, City of 371 City 2 City Agency 2 http://www.cityofsignalhill.org/index.aspx?nid=26 City 2 1334 Signal Hill, City of 366 City 2 City Agency 2   Los Angeles 6 0.475 Calbrisas Park 0 Local Park 2 4
8255 8255 8254 {"type": "Polygon", "coordinates": [[[-118.17034, 33.79537], [-118.17034, 33.79703], [-118.16786, 33.79703], [-118.16781, 33.797], [-118.16783, 33.79622], [-118.16787, 33.7957], [-118.16788, 33.79574], [-118.16921, 33.79574], [-118.16922, 33.79537], [-118.17034, 33.79537]]]} Open Access 1 12623 Signal Hill Park 25476 1334 Signal Hill, City of 371 City 2 City Agency 2 http://www.cityofsignalhill.org/index.aspx?nid=26 City 2 1334 Signal Hill, City of 366 City 2 City Agency 2   Los Angeles 6 9.217 Signal Hill Park 0 Local Park 2 4
10800 10800 10799 {"type": "Polygon", "coordinates": [[[-118.15891, 33.80072], [-118.15821, 33.80072], [-118.15821, 33.80066], [-118.15828, 33.8006], [-118.15833, 33.80064], [-118.15839, 33.80066], [-118.15846, 33.80065], [-118.15851, 33.80061], [-118.15857, 33.80065], [-118.15879, 33.80062], [-118.15874, 33.8002], [-118.15856, 33.79971], [-118.1584, 33.79923], [-118.15838, 33.79906], [-118.15812, 33.79913], [-118.1581, 33.79908], [-118.15831, 33.79901], [-118.15832, 33.799], [-118.15825, 33.79887], [-118.15815, 33.79875], [-118.15783, 33.79847], [-118.15778, 33.79837], [-118.15775, 33.79836], [-118.15758, 33.79851], [-118.15754, 33.79858], [-118.15748, 33.79856], [-118.15754, 33.79846], [-118.15756, 33.79831], [-118.15758, 33.79826], [-118.15727, 33.79812], [-118.15718, 33.79805], [-118.15697, 33.79771], [-118.15689, 33.79765], [-118.1567, 33.79738], [-118.15666, 33.79739], [-118.15665, 33.79759], [-118.15659, 33.79757], [-118.1566, 33.79745], [-118.15659, 33.79738], [-118.15656, 33.79731], [-118.15646, 33.7972], [-118.15875, 33.7972], [-118.15879, 33.79723], [-118.15879, 33.7976], [-118.15884, 33.79807], [-118.15879, 33.79813], [-118.1588, 33.79824], [-118.15884, 33.79856], [-118.15892, 33.79882], [-118.15891, 33.80072]]]} Open Access 1 20452 Discovery Well Park 18169 1334 Signal Hill, City of 371 City 2 City Agency 2 http://www.cityofsignalhill.org/index.aspx?nid=26 City 2 1334 Signal Hill, City of 366 City 2 City Agency 2   Los Angeles 6 8.232 Discovery Well Park 0 Local Park 2 4
14672 14672 14671 {"type": "Polygon", "coordinates": [[[-118.16494, 33.79101], [-118.16494, 33.7913], [-118.16449, 33.7913], [-118.1645, 33.79101], [-118.16494, 33.79101]]]} Open Access 1 44997 Raymond Arbor Park 29841 1334 Signal Hill, City of 371 City 2 City Agency 2 http://www.cityofsignalhill.org/index.aspx?nid=26 City 2 1334 Signal Hill, City of 366 City 2 City Agency 2 http://www.cityofsignalhill.org/Facilities/Facility/Details/6 Los Angeles 6 0.325 Raymond Arbor Park 0 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]);