units_with_maps

Table actions

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

9 rows where AGNCY_NAME = 270 and DES_TP = 2

This data as json, copyable, CSV (advanced)

MNG_AG_TYP 1

DES_TP 1

  • Local Park · 9 ✖

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
823 823 822 {"type": "Polygon", "coordinates": [[[-118.36454, 33.7693], [-118.36407, 33.76975], [-118.36351, 33.76944], [-118.36368, 33.76924], [-118.36401, 33.76894], [-118.36407, 33.76895], [-118.36454, 33.7693]]]} Open Access 1 5929 Levitt Park 29836 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 1.118 Levitt Park 0 Local Park 2 4
2238 2238 2237 {"type": "Polygon", "coordinates": [[[-118.3601, 33.7881], [-118.35853, 33.78827], [-118.35845, 33.78793], [-118.3585, 33.78785], [-118.35958, 33.78763], [-118.35961, 33.7877], [-118.35968, 33.78774], [-118.35976, 33.78774], [-118.3598, 33.78772], [-118.3601, 33.7881]]]} Open Access 1 5920 Rockbluff Park 24514 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 1.71 Rockbluff Park 0 Local Park 2 4
2243 2243 2242 {"type": "Polygon", "coordinates": [[[-118.38472, 33.7674], [-118.38471, 33.76744], [-118.38366, 33.76744], [-118.38366, 33.7679], [-118.38267, 33.76803], [-118.38088, 33.76799], [-118.3811, 33.76595], [-118.38166, 33.7661], [-118.38244, 33.76619], [-118.38244, 33.76675], [-118.3835, 33.76676], [-118.3835, 33.7674], [-118.38472, 33.7674]]]} Open Access 1 5924 Highridge Park 19951 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 10.711 Highridge Park 0 Local Park 2 4
3254 3254 3253 {"type": "Polygon", "coordinates": [[[-118.32627, 33.7734], [-118.32628, 33.77344], [-118.32626, 33.77352], [-118.32612, 33.77383], [-118.32571, 33.77354], [-118.32607, 33.77337], [-118.32618, 33.77335], [-118.32624, 33.77337], [-118.32627, 33.7734]]]} Open Access 1 48162 Butcher Park 32701 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 0.369 Butcher Park 0 Local Park 2 4
6961 6961 6960 {"type": "Polygon", "coordinates": [[[-118.36382, 33.79119], [-118.36363, 33.79154], [-118.36332, 33.79142], [-118.36294, 33.79131], [-118.36295, 33.79126], [-118.36382, 33.79119]]]} Open Access 1 5923 Silver Spur Park 25494 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 0.398 Silver Spur Park 0 Local Park 2 4
6987 6987 6986 {"type": "Polygon", "coordinates": [[[-118.32787, 33.77344], [-118.3276, 33.77346], [-118.32728, 33.77365], [-118.32683, 33.77368], [-118.32694, 33.77336], [-118.32699, 33.77308], [-118.32778, 33.77278], [-118.32787, 33.77344]]]} Open Access 1 5911 Dapplegray Park 17924 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 1.464 Dapplegray Park 0 Local Park 2 4
6990 6990 6989 {"type": "Polygon", "coordinates": [[[-118.35465, 33.79521], [-118.35105, 33.7952], [-118.34951, 33.7939], [-118.34964, 33.7937], [-118.34986, 33.79344], [-118.35, 33.7933], [-118.35031, 33.79305], [-118.35058, 33.79289], [-118.354, 33.79099], [-118.35465, 33.79521]]]} Open Access 1 5916 Ernie Howlett Park 18697 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 34.41 Ernie Howlett Park 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
15353 15353 15352 {"type": "Polygon", "coordinates": [[[-118.35279, 33.78319], [-118.35247, 33.78351], [-118.35212, 33.78326], [-118.35234, 33.78291], [-118.35239, 33.78291], [-118.35279, 33.78319]]]} Open Access 1 46539 Pepper Wood Park 29833 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 0.537 Pepper Wood 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]);