units_with_maps

Table actions

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

4 rows where LABEL_NAME = "Rolling Hills City Parkland" and MNG_AG_TYP = 2

This data as json, copyable, CSV (advanced)

Suggested facets: SUID_NMA, AGNCY_WEB, MNG_AG_ID

ACCESS_TYP 2

MNG_AG_TYP 1

  • City Agency · 4 ✖

DES_TP 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
933 933 932 {"type": "Polygon", "coordinates": [[[-118.35507, 33.77194], [-118.35328, 33.77337], [-118.3527, 33.77336], [-118.35236, 33.77251], [-118.35281, 33.77202], [-118.35362, 33.7711], [-118.35507, 33.77194]]]} No Public Access 3 5936 Rolling Hills City Parkland 24574 1282 Rolling Hills, City of 288 City 2 City Agency 2 http://www.rolling-hills.org/ City 2 1282 Rolling Hills, City of 285 City 2 City Agency 2   Los Angeles 6 8.192 Rolling Hills City Parkland 0 Local Park 2 4
6999 6999 6998 {"type": "Polygon", "coordinates": [[[-118.35627, 33.76696], [-118.35581, 33.76818], [-118.35516, 33.7689], [-118.35493, 33.76928], [-118.35465, 33.76912], [-118.35469, 33.76907], [-118.35503, 33.76841], [-118.35508, 33.76827], [-118.35509, 33.7682], [-118.3552, 33.76791], [-118.35547, 33.7675], [-118.3558, 33.76678], [-118.35627, 33.76696]]]} No Public Access 3 5938 Rolling Hills City Parkland 24574 1282 Rolling Hills, City of 288 City 2 City Agency 2 http://www.rolling-hills.org/ City 2 1282 Rolling Hills, City of 285 City 2 City Agency 2   Los Angeles 6 3.334 Rolling Hills City Parkland 0 Local Park 2 4
7000 7000 6999 {"type": "Polygon", "coordinates": [[[-118.34321, 33.7627], [-118.34301, 33.76401], [-118.34289, 33.76533], [-118.34181, 33.76568], [-118.34103, 33.766], [-118.34091, 33.76615], [-118.34084, 33.76592], [-118.34013, 33.76572], [-118.33993, 33.76592], [-118.34015, 33.76629], [-118.34015, 33.76661], [-118.33955, 33.76629], [-118.33896, 33.76581], [-118.33863, 33.76543], [-118.33917, 33.76497], [-118.34028, 33.76519], [-118.34115, 33.76476], [-118.34115, 33.76475], [-118.34091, 33.7645], [-118.34081, 33.76415], [-118.34098, 33.76406], [-118.34132, 33.76401], [-118.34177, 33.76412], [-118.34181, 33.76404], [-118.34321, 33.7627]]]} No Public Access 3 5939 Rolling Hills City Parkland 24574 1282 Rolling Hills, City of 288 City 2 City Agency 2 http://www.rolling-hills.org/ City 2 1282 Rolling Hills, City of 285 City 2 City Agency 2   Los Angeles 6 15.507 Rolling Hills City Parkland 0 Local Park 2 4
7029 7029 7028 {"type": "MultiPolygon", "coordinates": [[[[-118.32142, 33.77464], [-118.32102, 33.77473], [-118.31834, 33.77544], [-118.31832, 33.77535], [-118.32123, 33.77458], [-118.32138, 33.77457], [-118.32142, 33.77464]]], [[[-118.32635, 33.77317], [-118.32602, 33.77328], [-118.32555, 33.77349], [-118.32506, 33.77368], [-118.32436, 33.77389], [-118.3217, 33.77457], [-118.32165, 33.77444], [-118.32332, 33.77403], [-118.32405, 33.77387], [-118.32459, 33.77371], [-118.32495, 33.77357], [-118.32545, 33.77341], [-118.32634, 33.77302], [-118.32635, 33.77317]]], [[[-118.32748, 33.77267], [-118.32699, 33.77284], [-118.32693, 33.77282], [-118.32689, 33.77274], [-118.3269, 33.77269], [-118.32738, 33.77249], [-118.32748, 33.77267]]], [[[-118.33179, 33.77213], [-118.33028, 33.77212], [-118.32945, 33.77218], [-118.32863, 33.77231], [-118.32785, 33.77252], [-118.32759, 33.77261], [-118.32751, 33.77246], [-118.3283, 33.77225], [-118.32871, 33.77216], [-118.32929, 33.77206], [-118.32984, 33.77201], [-118.33067, 33.77201], [-118.33179, 33.77205], [-118.33179, 33.77213]]], [[[-118.3694, 33.79003], [-118.36941, 33.79011], [-118.36939, 33.7902], [-118.36926, 33.79047], [-118.36907, 33.79074], [-118.36884, 33.79097], [-118.36868, 33.79111], [-118.36848, 33.79124], [-118.36816, 33.79136], [-118.36793, 33.79143], [-118.36743, 33.79149], [-118.36707, 33.79147], [-118.36666, 33.79136], [-118.36603, 33.79112], [-118.36584, 33.79107], [-118.3652, 33.79095], [-118.36475, 33.79093], [-118.36394, 33.79098], [-118.36362, 33.79099], [-118.36332, 33.79102], [-118.36329, 33.79096], [-118.36461, 33.79085], [-118.36504, 33.79085], [-118.36523, 33.79086], [-118.36567, 33.79092], [-118.36602, 33.79101], [-118.36694, 33.79133], [-118.36719, 33.79137], [-118.36741, 33.79139], [-118.36772, 33.79137], [-118.36794, 33.79133], [-118.36818, 33.79125], [-118.36845, 33.79112], [-118.3687, 33.79096], [-118.36898, 33.79067], [-118.36936, 33.78999], [-118.3694, 33.79003]]], [[[-118.37239, 33.78615], [-118.37228, 33.78674], [-118.37214, 33.78729], [-118.37186, 33.78788], [-118.37168, 33.78815], [-118.37146, 33.78838], [-118.37112, 33.78864], [-118.37056, 33.78896], [-118.37047, 33.78904], [-118.37019, 33.78919], [-118.37004, 33.78935], [-118.36988, 33.78945], [-118.36978, 33.78954], [-118.36968, 33.78965], [-118.36959, 33.7898], [-118.36949, 33.78975], [-118.36981, 33.78938], [-118.37023, 33.78902], [-118.37064, 33.78875], [-118.37131, 33.78829], [-118.37145, 33.78815], [-118.37164, 33.78792], [-118.3718, 33.78768], [-118.37197, 33.78735], [-118.37233, 33.78617], [-118.37239, 33.78615]]]]} Open Access 1 5981 Rolling Hills City Parkland 29837 1283 Rolling Hills Estates, City of 270 City 2 City Agency 2 http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 City 2 1283 Rolling Hills Estates, City of 265 City 2 City Agency 2   Los Angeles 6 7.203 Rolling Hills City Parkland 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]);