units_with_maps

Table actions

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

373 rows where ACCESS_TYP = 3 and GAP_STS = 4

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, AGNCY_TYP, MNG_AG_LEV, PARK_URL

ACCESS_TYP 1

  • No Public Access · 373 ✖
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
208 208 207 {"type": "Polygon", "coordinates": [[[-117.09538, 33.13695], [-117.09362, 33.13752], [-117.09362, 33.1357], [-117.09365, 33.13567], [-117.09379, 33.1356], [-117.0939, 33.13563], [-117.09401, 33.1356], [-117.09406, 33.13557], [-117.09407, 33.13551], [-117.09406, 33.1355], [-117.09382, 33.13558], [-117.09362, 33.13548], [-117.09357, 33.13283], [-117.09348, 33.13177], [-117.09397, 33.13182], [-117.09425, 33.13159], [-117.09432, 33.13154], [-117.09436, 33.13154], [-117.09442, 33.13154], [-117.09451, 33.13179], [-117.09458, 33.13207], [-117.09474, 33.13462], [-117.09453, 33.13534], [-117.09455, 33.13535], [-117.0948, 33.13527], [-117.09484, 33.13577], [-117.09489, 33.13594], [-117.09494, 33.13615], [-117.09502, 33.13635], [-117.09522, 33.13672], [-117.0953, 33.13686], [-117.09538, 33.13695]]]} No Public Access 3 654 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 16.798 Reidy Canyon Creek 0 Local Other or Unknown 14 4
235 235 234 {"type": "MultiPolygon", "coordinates": [[[[-117.09432, 33.11987], [-117.09377, 33.1199], [-117.09333, 33.11988], [-117.09298, 33.11971], [-117.09292, 33.11957], [-117.0934, 33.11955], [-117.09432, 33.11987]]], [[[-117.09563, 33.1199], [-117.09552, 33.12002], [-117.09533, 33.1203], [-117.09524, 33.12049], [-117.09521, 33.1206], [-117.09497, 33.12181], [-117.09491, 33.12286], [-117.09486, 33.12319], [-117.09477, 33.12344], [-117.0946, 33.1235], [-117.09447, 33.1232], [-117.09458, 33.12282], [-117.0946, 33.12228], [-117.09473, 33.12119], [-117.09482, 33.12061], [-117.09498, 33.12015], [-117.09521, 33.11975], [-117.09563, 33.1199]]]]} No Public Access 3 684 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 4.055 Reidy Canyon Creek 0 Local Other or Unknown 14 4
236 236 235 {"type": "Polygon", "coordinates": [[[-117.09461, 33.12373], [-117.09348, 33.12592], [-117.09308, 33.12668], [-117.09291, 33.12629], [-117.09353, 33.12505], [-117.09345, 33.12492], [-117.09371, 33.12472], [-117.09415, 33.12388], [-117.09461, 33.12373]]]} No Public Access 3 687 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 2.732 Reidy Canyon Creek 0 Local Other or Unknown 14 4
251 251 250 {"type": "Polygon", "coordinates": [[[-117.0929, 33.12785], [-117.09258, 33.12797], [-117.09245, 33.12767], [-117.09253, 33.12696], [-117.09276, 33.12662], [-117.09289, 33.12693], [-117.09286, 33.12698], [-117.09278, 33.12727], [-117.09278, 33.12756], [-117.0929, 33.12785]]]} No Public Access 3 683 Reidy Canyon Creek 24281 1102 Escondido, City of 86 City 2 City Agency 2 http://www.escondido.org/parks-open-space.aspx City 2 1102 Escondido, City of 84 City 2 City Agency 2   San Diego 4 0.966 Reidy Canyon Creek 0 Local Other or Unknown 14 4
907 907 906 {"type": "Polygon", "coordinates": [[[-118.57306, 34.07116], [-118.57275, 34.07156], [-118.57161, 34.07199], [-118.57078, 34.07438], [-118.56939, 34.07481], [-118.56849, 34.07435], [-118.56719, 34.07493], [-118.56601, 34.07456], [-118.56562, 34.0739], [-118.56573, 34.07186], [-118.56463, 34.07084], [-118.56607, 34.0706], [-118.5687, 34.07091], [-118.56976, 34.07088], [-118.57133, 34.0713], [-118.57211, 34.07034], [-118.57306, 34.07116]]]} No Public Access 3 6358 Santa Ynez Reservoir 29145 1400 Los Angeles - Department of Water and Power, City of 282 City 2 City Agency 2 http://www.ladwp.com/ City 2 1400 Los Angeles - Department of Water and Power, City of 278 City 2 City Agency 2 https://www.ladwp.com Los Angeles 6 58.139 Santa Ynez Reservoir 0 Local Recreation Area 3 4
930 930 929 {"type": "Polygon", "coordinates": [[[-118.35399, 33.79067], [-118.35035, 33.79268], [-118.35001, 33.7929], [-118.34972, 33.79315], [-118.34952, 33.79335], [-118.34927, 33.7937], [-118.34853, 33.79307], [-118.34875, 33.79282], [-118.34783, 33.79205], [-118.34783, 33.79015], [-118.34362, 33.78659], [-118.34517, 33.78551], [-118.34559, 33.7853], [-118.34583, 33.7852], [-118.34609, 33.78513], [-118.34641, 33.78506], [-118.34996, 33.78455], [-118.35025, 33.78449], [-118.35084, 33.78427], [-118.35136, 33.78464], [-118.35157, 33.78445], [-118.3532, 33.7856], [-118.35399, 33.79067]]]} No Public Access 3 5917 South Coast Park/Peter Weber Equestrian Center 29016 305 Los Angeles, County of 16 County 3 County Agency 3 http://parks.lacounty.gov County 3 305 Los Angeles, County of 16 County 3 County Agency 3   Los Angeles 6 141.298 South Coast Park/Peter Weber Equestrian Ctr. 0 Local Recreation Area 3 4
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
1138 1138 1137 {"type": "Polygon", "coordinates": [[[-118.17117, 33.79377], [-118.1707, 33.79377], [-118.1707, 33.79348], [-118.17072, 33.79348], [-118.17117, 33.79377]]]} No Public Access 3 6684 Chittick Field 29944 1184 Long Beach, City of 298 City 2 City Agency 2 http://www.longbeach.gov/park/default.asp City 2 1184 Long Beach, City of 294 City 2 City Agency 2   Los Angeles 6 0.181 Chittick Field 2014 Local Recreation Area 3 4
1216 1216 1215 {"type": "Polygon", "coordinates": [[[-122.58991, 38.30992], [-122.57891, 38.32201], [-122.57277, 38.31852], [-122.58368, 38.30636], [-122.58991, 38.30992]]]} No Public Access 3 7007 Lafferty Ranch 20837 1249 Petaluma, City of 148 City 2 City Agency 2 http://cityofpetaluma.net/parksnrec/index.html City 2 1249 Petaluma, City of 144 City 2 City Agency 2   Sonoma 16 272.49 Lafferty Ranch 0 Local Other or Unknown 14 4
1270 1270 1269 {"type": "Polygon", "coordinates": [[[-118.56523, 34.13034], [-118.56473, 34.13106], [-118.56429, 34.13106], [-118.56418, 34.13093], [-118.56397, 34.13076], [-118.56397, 34.13019], [-118.56387, 34.13018], [-118.56387, 34.12948], [-118.5652, 34.12947], [-118.56479, 34.13017], [-118.56523, 34.13034]]]} No Public Access 3 7159 Los Angeles City Water Resource Parkland 21477 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 4.129 Los Angeles City Water Resource Parkland 0 Local Park 2 4
1271 1271 1270 {"type": "Polygon", "coordinates": [[[-118.44484, 34.1151], [-118.44483, 34.11604], [-118.44451, 34.11604], [-118.44418, 34.11581], [-118.44418, 34.11543], [-118.4445, 34.11515], [-118.44451, 34.1151], [-118.44484, 34.1151]]]} No Public Access 3 7160 Los Angeles City Water Resource Parkland 21477 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 1.317 Los Angeles City Water Resource Parkland 0 Local Park 2 4
1339 1339 1338 {"type": "Polygon", "coordinates": [[[-116.73714, 32.58342], [-116.74114, 32.58362], [-116.74116, 32.57636], [-116.73709, 32.57624], [-116.73707, 32.57262], [-116.74115, 32.5727], [-116.74116, 32.5691], [-116.73703, 32.56906], [-116.73696, 32.56738], [-116.75384, 32.56596], [-116.75385, 32.56579], [-116.80114, 32.56182], [-116.80119, 32.56352], [-116.79687, 32.56361], [-116.79696, 32.56738], [-116.78817, 32.56748], [-116.78397, 32.56787], [-116.78402, 32.57978], [-116.77099, 32.58015], [-116.76217, 32.58046], [-116.76212, 32.58426], [-116.75374, 32.58427], [-116.75371, 32.58796], [-116.75367, 32.59538], [-116.74509, 32.59534], [-116.74513, 32.59151], [-116.72846, 32.59121], [-116.72857, 32.58727], [-116.73278, 32.58732], [-116.7329, 32.5834], [-116.73714, 32.58342]]]} No Public Access 3 7398 Marron Valley Mitigation Bank 21885 1297 San Diego, City of 4 City 2 City Agency 2 http://www.sandiego.gov/park-and-recreation/ City 2 1297 San Diego, City of 4 City 2 City Agency 2   San Diego 4 2644.0 Marron Valley Mitigation Bank 0 Local Other or Unknown 14 4
1340 1340 1339 {"type": "Polygon", "coordinates": [[[-118.38142, 34.10854], [-118.38114, 34.10871], [-118.38103, 34.10855], [-118.38131, 34.10838], [-118.38142, 34.10854]]]} No Public Access 3 12809 Los Angeles City Water Resource Parkland 21477 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 0.163 Los Angeles City Water Resource Parkland 0 Local Park 2 4
1410 1410 1409 {"type": "Polygon", "coordinates": [[[-118.22677, 34.25192], [-118.22147, 34.25178], [-118.21696, 34.25173], [-118.21705, 34.24813], [-118.22159, 34.24846], [-118.22162, 34.24484], [-118.22168, 34.24273], [-118.22273, 34.24274], [-118.22322, 34.24194], [-118.22394, 34.24193], [-118.22353, 34.24295], [-118.22307, 34.24366], [-118.22309, 34.24373], [-118.22331, 34.24422], [-118.2239, 34.24472], [-118.22419, 34.24556], [-118.22416, 34.24562], [-118.22416, 34.24572], [-118.22422, 34.24582], [-118.22435, 34.24591], [-118.2245, 34.24592], [-118.22486, 34.24607], [-118.22514, 34.24612], [-118.22528, 34.24618], [-118.22546, 34.24632], [-118.22551, 34.24641], [-118.22555, 34.24651], [-118.22555, 34.24667], [-118.22531, 34.24754], [-118.22529, 34.24766], [-118.2253, 34.24776], [-118.22533, 34.24792], [-118.22539, 34.24805], [-118.22551, 34.24825], [-118.22539, 34.24843], [-118.22556, 34.24872], [-118.22597, 34.24856], [-118.22597, 34.25048], [-118.22621, 34.25075], [-118.22637, 34.251], [-118.22652, 34.2513], [-118.22672, 34.25162], [-118.22677, 34.25192]]]} No Public Access 3 12350 La Canada Irrigation District Open Space 20744 2055 La Canada Irrigation District 363 Special District 4 Irrigation District 17 http://lacanadairrigation.org/ Special District 4 2055 La Canada Irrigation District 359 Special District 4 Irrigation District 16   Los Angeles 6 120.857 La Canada Irrigation District OS 0 Local Recreation Area 3 4
1411 1411 1410 {"type": "Polygon", "coordinates": [[[-117.76876, 34.14961], [-117.76819, 34.14963], [-117.76817, 34.14987], [-117.76775, 34.14988], [-117.76775, 34.1492], [-117.76818, 34.14946], [-117.76819, 34.14957], [-117.76875, 34.14956], [-117.76876, 34.14961]]]} No Public Access 3 12352 La Verne City Parkland 20811 1162 La Verne, City of 305 City 2 City Agency 2 http://www.ci.la-verne.ca.us/index.php/residents/parks City 2 1162 La Verne, City of 301 City 2 City Agency 2   Los Angeles 6 0.671 La Verne City Parkland 0 Local Park 2 4
1437 1437 1436 {"type": "MultiPolygon", "coordinates": [[[[-118.34031, 34.12245], [-118.33893, 34.12345], [-118.33872, 34.12325], [-118.34008, 34.12224], [-118.34031, 34.12245]]], [[[-118.33885, 34.12352], [-118.33618, 34.12548], [-118.33607, 34.12549], [-118.33599, 34.12546], [-118.33595, 34.12544], [-118.3359, 34.12532], [-118.33855, 34.12337], [-118.33863, 34.12331], [-118.33885, 34.12352]]]]} No Public Access 3 12459 Los Angeles Department of Water and Power 21482 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 3.847 Los Angeles Department of Water and Power 0 Local Other or Unknown 14 4
1489 1489 1488 {"type": "Polygon", "coordinates": [[[-118.46789, 34.09611], [-118.46633, 34.09612], [-118.46623, 34.09617], [-118.46611, 34.09595], [-118.46593, 34.09571], [-118.46592, 34.09565], [-118.46593, 34.09559], [-118.46595, 34.09555], [-118.46601, 34.09548], [-118.46614, 34.09544], [-118.4678, 34.09543], [-118.46792, 34.09583], [-118.46789, 34.09611]]]} No Public Access 3 12701 Los Angeles City Water Resource Parkland 21477 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 3.182 Los Angeles City Water Resource Parkland 0 Local Park 2 4
1629 1629 1628 {"type": "Polygon", "coordinates": [[[-118.63073, 34.13978], [-118.63062, 34.1398], [-118.63058, 34.13967], [-118.63066, 34.13966], [-118.63073, 34.13978]]]} No Public Access 3 12421 Las Virgenes Municipal Water District Open Space 21072 2059 Las Virgenes Municipal Water District 398 Special District 4 Water District 13 http://www.lvmwd.com/ Special District 4 2059 Las Virgenes Municipal Water District 392 Special District 4 Water District 13   Los Angeles 6 0.034 Las Virgenes Municipal Water District OS 0 Local Recreation Area 3 4
1634 1634 1633 {"type": "Polygon", "coordinates": [[[-118.33735, 34.1239], [-118.33702, 34.12408], [-118.33683, 34.12383], [-118.33721, 34.12367], [-118.33731, 34.12385], [-118.33735, 34.1239]]]} No Public Access 3 12456 Los Angeles Department of Water and Power 21482 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 0.284 Los Angeles Department of Water and Power 0 Local Other or Unknown 14 4
1637 1637 1636 {"type": "Polygon", "coordinates": [[[-118.34683, 34.11999], [-118.34463, 34.11999], [-118.34429, 34.11994], [-118.34428, 34.12], [-118.34364, 34.12], [-118.3434, 34.12018], [-118.34321, 34.11995], [-118.34352, 34.11973], [-118.34369, 34.11972], [-118.3438, 34.11978], [-118.34393, 34.11981], [-118.34412, 34.1198], [-118.34424, 34.11974], [-118.34427, 34.11972], [-118.34662, 34.11971], [-118.34683, 34.11999]]]} No Public Access 3 12462 Los Angeles Department of Water and Power 21482 1188 Los Angeles, City of 24 City 2 City Agency 2 http://lacity.org/ City 2 1188 Los Angeles, City of 24 City 2 City Agency 2   Los Angeles 6 2.35 Los Angeles Department of Water and Power 0 Local Other or Unknown 14 4

Next page

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]);