units_with_maps

Table actions

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

7 rows where DES_TP = 2 and MNG_AGENCY = 310

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER

MNG_AG_TYP 1

MNG_AGENCY 1

  • Calabasas, City of · 7 ✖

DES_TP 1

  • Local Park · 7 ✖

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
1080 1080 1079 {"type": "Polygon", "coordinates": [[[-118.63548, 34.13271], [-118.63507, 34.13343], [-118.6349, 34.13365], [-118.63473, 34.13381], [-118.6346, 34.13386], [-118.63442, 34.13401], [-118.63422, 34.1341], [-118.63227, 34.13452], [-118.63205, 34.13459], [-118.63184, 34.13468], [-118.63153, 34.13486], [-118.63126, 34.13508], [-118.63111, 34.13525], [-118.63078, 34.13573], [-118.63051, 34.13517], [-118.63032, 34.13484], [-118.63028, 34.13456], [-118.63017, 34.13442], [-118.63012, 34.13424], [-118.62991, 34.13418], [-118.6297, 34.13402], [-118.62951, 34.13395], [-118.62944, 34.13379], [-118.62924, 34.13362], [-118.62899, 34.13321], [-118.6287, 34.13306], [-118.62873, 34.1328], [-118.62865, 34.13271], [-118.63548, 34.13271]]]} Open Access 1 6455 Wild Walnut Park 27500 1040 Calabasas, City of 313 City 2 City Agency 2 http://www.cityofcalabasas.com/recreation.html City 2 1040 Calabasas, City of 310 City 2 City Agency 2   Los Angeles 6 26.523 Wild Walnut Park 0 Local Park 2 4
1245 1245 1244 {"type": "Polygon", "coordinates": [[[-118.69322, 34.16142], [-118.69181, 34.16257], [-118.69104, 34.16222], [-118.69115, 34.16183], [-118.69132, 34.16146], [-118.69151, 34.16115], [-118.69177, 34.16082], [-118.69208, 34.16051], [-118.69243, 34.16025], [-118.69282, 34.16001], [-118.6932, 34.15983], [-118.69322, 34.16142]]]} Open Access 1 7095 Gates Canyon Park 19232 1040 Calabasas, City of 313 City 2 City Agency 2 http://www.cityofcalabasas.com/recreation.html City 2 1040 Calabasas, City of 310 City 2 City Agency 2   Los Angeles 6 8.306 Gates Canyon Park 0 Local Park 2 4
1251 1251 1250 {"type": "Polygon", "coordinates": [[[-118.70902, 34.1269], [-118.70783, 34.12774], [-118.70746, 34.12721], [-118.70711, 34.12683], [-118.70688, 34.12662], [-118.70665, 34.12643], [-118.70665, 34.1264], [-118.70664, 34.12641], [-118.706, 34.12586], [-118.706, 34.12581], [-118.70618, 34.12564], [-118.70635, 34.12543], [-118.70855, 34.12542], [-118.70846, 34.12562], [-118.7083, 34.12571], [-118.7079, 34.12578], [-118.7076, 34.12579], [-118.70733, 34.12582], [-118.70712, 34.12589], [-118.70674, 34.12627], [-118.70675, 34.12628], [-118.70711, 34.12593], [-118.70734, 34.12586], [-118.7076, 34.12583], [-118.70792, 34.12583], [-118.70832, 34.12574], [-118.70854, 34.12563], [-118.70872, 34.12541], [-118.709, 34.12542], [-118.70902, 34.1269]], [[-118.70668, 34.12638], [-118.70667, 34.12637], [-118.70666, 34.12639], [-118.70667, 34.12639], [-118.70668, 34.12638]], [[-118.70671, 34.12634], [-118.7067, 34.12633], [-118.70669, 34.12634], [-118.7067, 34.12635], [-118.70671, 34.12634]], [[-118.70674, 34.1263], [-118.70673, 34.12629], [-118.70671, 34.12632], [-118.70672, 34.12632], [-118.70674, 34.1263]]]} Open Access 1 7098 Juan Bautista de Anza Park 20512 1040 Calabasas, City of 313 City 2 City Agency 2 http://www.cityofcalabasas.com/recreation.html City 2 1040 Calabasas, City of 310 City 2 City Agency 2 http://www.cityofcalabasas.com/recreation/deanza.html Los Angeles 6 11.191 Juan Bautista de Anza Park 0 Local Park 2 4
1252 1252 1251 {"type": "Polygon", "coordinates": [[[-118.71115, 34.14166], [-118.71115, 34.14319], [-118.71031, 34.14318], [-118.71032, 34.14181], [-118.71115, 34.14166]]]} Open Access 1 7099 Grape Arbor Park 19445 1040 Calabasas, City of 313 City 2 City Agency 2 http://www.cityofcalabasas.com/recreation.html City 2 1040 Calabasas, City of 310 City 2 City Agency 2   Los Angeles 6 3.056 Grape Arbor Park 0 Local Park 2 4
10864 10864 10863 {"type": "Polygon", "coordinates": [[[-118.61397, 34.14366], [-118.61376, 34.14394], [-118.6135, 34.14391], [-118.61317, 34.14406], [-118.61301, 34.14401], [-118.61292, 34.14407], [-118.61288, 34.14419], [-118.6128, 34.14428], [-118.61258, 34.14418], [-118.6127, 34.14403], [-118.61271, 34.14367], [-118.61341, 34.14365], [-118.61397, 34.14366]]]} Open Access 1 20662 Freedom Park 19083 1040 Calabasas, City of 313 City 2 City Agency 2 http://www.cityofcalabasas.com/recreation.html City 2 1040 Calabasas, City of 310 City 2 City Agency 2   Los Angeles 6 1.11 Freedom Park 0 Local Park 2 4
15200 15200 15199 {"type": "Polygon", "coordinates": [[[-118.70299, 34.13344], [-118.70263, 34.13507], [-118.70242, 34.13504], [-118.70246, 34.13481], [-118.70253, 34.13472], [-118.70254, 34.1346], [-118.70246, 34.13445], [-118.70233, 34.13449], [-118.70199, 34.13442], [-118.70197, 34.13438], [-118.70198, 34.1343], [-118.70207, 34.13416], [-118.70211, 34.13395], [-118.70221, 34.13372], [-118.70237, 34.13352], [-118.70261, 34.13343], [-118.70299, 34.13344]]]} Open Access 1 46078 Calabasas Bark Park 29419 2059 Las Virgenes Municipal Water District 398 Special District 4 Water District 13 http://www.lvmwd.com/ Special District 4 1040 Calabasas, City of 310 City 2 City Agency 2 http://www.cityofcalabasas.com/recreation/barkpark.html Los Angeles 6 2.209 Calabasas Bark Park 0 Local Park 2 4
15203 15203 15202 {"type": "Polygon", "coordinates": [[[-118.64244, 34.1297], [-118.64235, 34.12973], [-118.64225, 34.12975], [-118.6422, 34.12974], [-118.64217, 34.12971], [-118.64215, 34.12964], [-118.64215, 34.1295], [-118.64224, 34.12948], [-118.64238, 34.12949], [-118.64244, 34.12954], [-118.64246, 34.12966], [-118.64244, 34.1297]]]} Open Access 1 46083 Highlands Park 29426 1040 Calabasas, City of 313 City 2 City Agency 2 http://www.cityofcalabasas.com/recreation.html City 2 1040 Calabasas, City of 310 City 2 City Agency 2 http://www.cityofcalabasas.com/vtour/highlands/highlands.html Los Angeles 6 0.177 Highlands 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]);