units_with_maps

Table actions

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

5 rows where AGNCY_TYP = 4, DES_TP = 2 and MNG_AGENCY = 885

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

MNG_AGENCY 1

  • Miraleste Recreation and Park District · 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
9506 9506 9505 {"type": "Polygon", "coordinates": [[[-118.32587, 33.74382], [-118.32587, 33.74461], [-118.32566, 33.74466], [-118.32561, 33.74453], [-118.3255, 33.74455], [-118.32553, 33.74468], [-118.32546, 33.7447], [-118.32526, 33.74439], [-118.3258, 33.74434], [-118.32581, 33.74381], [-118.32587, 33.74382]]]} Open Access 1 47829 Frog Pond Park 31771 2080 Miraleste Recreation and Park District 912 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4   Los Angeles 6 0.434 Frog Pond Park 0 Local Park 2 4
9528 9528 9527 {"type": "Polygon", "coordinates": [[[-118.32092, 33.74221], [-118.32011, 33.74357], [-118.32016, 33.74372], [-118.32001, 33.74376], [-118.31987, 33.74401], [-118.31997, 33.74414], [-118.32048, 33.74413], [-118.32055, 33.74404], [-118.32057, 33.74405], [-118.32058, 33.74434], [-118.32056, 33.7444], [-118.32044, 33.74452], [-118.32027, 33.74456], [-118.32011, 33.74436], [-118.31968, 33.74442], [-118.3195, 33.74476], [-118.31965, 33.74515], [-118.31998, 33.74517], [-118.32002, 33.74548], [-118.31996, 33.74555], [-118.31991, 33.74557], [-118.31983, 33.74557], [-118.31939, 33.74542], [-118.31919, 33.74477], [-118.3197, 33.74396], [-118.32074, 33.74221], [-118.32092, 33.74221]]]} Open Access 1 47833 Harter Park 31774 2080 Miraleste Recreation and Park District 912 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4   Los Angeles 6 2.945 Harter Park 0 Local Park 2 4
9541 9541 9540 {"type": "Polygon", "coordinates": [[[-118.32587, 33.74953], [-118.32572, 33.74942], [-118.32569, 33.74937], [-118.32556, 33.74827], [-118.32549, 33.74805], [-118.32543, 33.74795], [-118.32579, 33.74783], [-118.32587, 33.74783], [-118.32587, 33.74785], [-118.32587, 33.74953]]]} Open Access 1 47837 Miltenberger Park 31779 2080 Miraleste Recreation and Park District 912 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4   Los Angeles 6 1.104 Miltenberger Park 0 Local Park 2 4
9547 9547 9546 {"type": "Polygon", "coordinates": [[[-118.319, 33.74614], [-118.31877, 33.74618], [-118.31864, 33.74623], [-118.31846, 33.74607], [-118.31846, 33.74603], [-118.31855, 33.74586], [-118.3188, 33.74581], [-118.31892, 33.74587], [-118.319, 33.74614]]]} Open Access 1 47838 Miraleste Park 31780 2080 Miraleste Recreation and Park District 912 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4   Los Angeles 6 0.395 Miraleste Park 0 Local Park 2 4
9549 9549 9548 {"type": "Polygon", "coordinates": [[[-118.32588, 33.7512], [-118.32569, 33.75113], [-118.32582, 33.75079], [-118.32552, 33.75069], [-118.32515, 33.75073], [-118.32511, 33.75097], [-118.32475, 33.75096], [-118.32453, 33.75099], [-118.32427, 33.75107], [-118.32405, 33.75118], [-118.32387, 33.75099], [-118.32318, 33.75133], [-118.32271, 33.75141], [-118.32252, 33.7515], [-118.32265, 33.75175], [-118.32264, 33.75176], [-118.32258, 33.75178], [-118.32244, 33.75154], [-118.32133, 33.75207], [-118.32135, 33.75226], [-118.32116, 33.75229], [-118.32107, 33.75233], [-118.32097, 33.75239], [-118.3208, 33.75223], [-118.32044, 33.75241], [-118.31947, 33.75237], [-118.31861, 33.75275], [-118.31877, 33.753], [-118.31873, 33.75321], [-118.31842, 33.75321], [-118.31842, 33.75196], [-118.3186, 33.7517], [-118.31861, 33.75181], [-118.3187, 33.7517], [-118.31875, 33.75173], [-118.31876, 33.75212], [-118.31926, 33.75203], [-118.32016, 33.75204], [-118.32047, 33.75195], [-118.32125, 33.7514], [-118.32161, 33.75107], [-118.32246, 33.75079], [-118.32385, 33.75045], [-118.32372, 33.75006], [-118.32393, 33.75001], [-118.32411, 33.75038], [-118.32457, 33.75026], [-118.32529, 33.75014], [-118.32553, 33.74992], [-118.32587, 33.75017], [-118.32588, 33.7512]]]} Open Access 1 47840 Canada Park 31781 2080 Miraleste Recreation and Park District 912 Special District 4 Recreation/Parks District 4 https://www.rpvca.gov/ Special District 4 2080 Miraleste Recreation and Park District 885 Special District 4 Recreation/Parks District 4   Los Angeles 6 13.159 Canada 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]);