units_with_maps

Table actions

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

272 rows where ACCESS_TYP = 3 and MNG_AG_LEV = 4

This data as json, copyable, CSV (advanced)

Suggested facets: AGNCY_LEV, AGNCY_TYP, LAYER, COUNTY, GAP_STS

ACCESS_TYP 1

  • No Public Access · 272 ✖
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
1033 1033 1032 {"type": "Polygon", "coordinates": [[[-118.51157, 34.07731], [-118.51143, 34.07746], [-118.5104, 34.07684], [-118.5101, 34.07613], [-118.50988, 34.07539], [-118.50872, 34.07481], [-118.50845, 34.0745], [-118.50826, 34.07401], [-118.50761, 34.07364], [-118.50763, 34.07328], [-118.50737, 34.07296], [-118.50731, 34.07284], [-118.50737, 34.07275], [-118.50746, 34.07269], [-118.50778, 34.07276], [-118.50866, 34.0734], [-118.50892, 34.0734], [-118.50898, 34.07385], [-118.50974, 34.07406], [-118.50989, 34.07443], [-118.50989, 34.07475], [-118.51067, 34.07526], [-118.51068, 34.07637], [-118.51099, 34.07669], [-118.51107, 34.07682], [-118.5113, 34.07702], [-118.51157, 34.07731]]]} No Public Access 3 6378 Sullivan Canyon Creek & Dam 25948 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 10.67 Sullivan Canyon Creek & Dam   None 93  
1115 1115 1114 {"type": "Polygon", "coordinates": [[[-117.8843, 33.96567], [-117.88426, 33.96587], [-117.88394, 33.96616], [-117.88344, 33.96606], [-117.88359, 33.96552], [-117.8843, 33.96567]]]} No Public Access 3 6558 Roland Area County Water District Land 24569 2054 Kinneloa Irrigation District 320 Special District 4 Irrigation District 17 http://www.kinneloairrigationdistrict.info/ Special District 4 2054 Kinneloa Irrigation District 317 Special District 4 Irrigation District 16   Los Angeles 6 0.931 Roland Area County Water District Land   None 101  
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
1573 1573 1572 {"type": "Polygon", "coordinates": [[[-122.6827, 38.37594], [-122.67746, 38.37597], [-122.67742, 38.37485], [-122.67626, 38.37485], [-122.67625, 38.37486], [-122.67626, 38.37627], [-122.67517, 38.37592], [-122.67173, 38.37464], [-122.67171, 38.3738], [-122.67535, 38.37375], [-122.67531, 38.37112], [-122.67644, 38.37111], [-122.67646, 38.37237], [-122.68263, 38.37226], [-122.6827, 38.37594]]]} No Public Access 3 47544 Oken 31257 2155 Sonoma County Agricultural Preservation and Open Space District 387 Special District 4 Recreation/Parks District 4 http://www.sonomaopenspace.org/ Special District 4 2155 Sonoma County Agricultural Preservation and Open Space District 383 Special District 4 Recreation/Parks District 4   Sonoma 16 77.773 Oken 1998 None 126  
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
1702 1702 1701 {"type": "MultiPolygon", "coordinates": [[[[-118.10957, 33.99118], [-118.10841, 33.99393], [-118.10812, 33.99414], [-118.10776, 33.99428], [-118.10723, 33.99468], [-118.1056, 33.99616], [-118.1049, 33.99713], [-118.10463, 33.99726], [-118.10446, 33.99744], [-118.10439, 33.99781], [-118.104, 33.99834], [-118.10373, 33.99899], [-118.1034, 33.99955], [-118.09727, 34.00134], [-118.09715, 34.00171], [-118.09154, 33.99932], [-118.09273, 33.99735], [-118.09448, 33.99594], [-118.09703, 33.99726], [-118.09734, 33.99688], [-118.09773, 33.99673], [-118.09793, 33.99653], [-118.10047, 33.99561], [-118.10232, 33.9928], [-118.10204, 33.99241], [-118.10691, 33.99146], [-118.10957, 33.99118]]], [[[-118.10991, 33.9911], [-118.1069, 33.99141], [-118.102, 33.99238], [-118.10139, 33.99156], [-118.10665, 33.98858], [-118.10706, 33.9888], [-118.10745, 33.98908], [-118.10935, 33.99074], [-118.10962, 33.99093], [-118.10991, 33.9911]]]]} No Public Access 3 6693 Rio Hondo & Bike Trail 24380 2272 Los Angeles County Flood Control District 287 Special District 4 Flood District 8 http://dpw.lacounty.gov/lacfcd/ Special District 4 2272 Los Angeles County Flood Control District 284 Special District 4 Flood District 9   Los Angeles 6 234.812 Rio Hondo & Bike Trail 0 Local Recreation Area 3 4
1708 1708 1707 {"type": "Polygon", "coordinates": [[[-117.93744, 33.98131], [-117.93677, 33.98161], [-117.93629, 33.98086], [-117.93696, 33.98056], [-117.93744, 33.98131]]]} No Public Access 3 6551 Roland Area County Water District Land 24569 2054 Kinneloa Irrigation District 320 Special District 4 Irrigation District 17 http://www.kinneloairrigationdistrict.info/ Special District 4 2054 Kinneloa Irrigation District 317 Special District 4 Irrigation District 16   Los Angeles 6 1.632 Roland Area County Water District Land   None 136  
1759 1759 1758 {"type": "Polygon", "coordinates": [[[-117.93234, 33.9866], [-117.93168, 33.98689], [-117.93158, 33.98688], [-117.93166, 33.98615], [-117.93219, 33.9861], [-117.93223, 33.98635], [-117.93234, 33.9866]]]} No Public Access 3 6552 Roland Area County Water District Land 24569 2054 Kinneloa Irrigation District 320 Special District 4 Irrigation District 17 http://www.kinneloairrigationdistrict.info/ Special District 4 2054 Kinneloa Irrigation District 317 Special District 4 Irrigation District 16   Los Angeles 6 1.052 Roland Area County Water District Land   None 137  
1760 1760 1759 {"type": "Polygon", "coordinates": [[[-117.91753, 33.96603], [-117.91639, 33.96877], [-117.91516, 33.96861], [-117.91523, 33.96842], [-117.91541, 33.96808], [-117.91555, 33.96763], [-117.91605, 33.96696], [-117.91648, 33.9667], [-117.91691, 33.96636], [-117.91753, 33.96603]]]} No Public Access 3 6553 Roland Area County Water District Land 24569 2054 Kinneloa Irrigation District 320 Special District 4 Irrigation District 17 http://www.kinneloairrigationdistrict.info/ Special District 4 2054 Kinneloa Irrigation District 317 Special District 4 Irrigation District 16   Los Angeles 6 6.905 Roland Area County Water District Land   None 138  
1761 1761 1760 {"type": "Polygon", "coordinates": [[[-117.92305, 33.97679], [-117.92297, 33.97736], [-117.92178, 33.97689], [-117.92181, 33.97667], [-117.92244, 33.97672], [-117.92249, 33.97669], [-117.92258, 33.97673], [-117.92265, 33.97671], [-117.92276, 33.97676], [-117.92305, 33.97679]]]} No Public Access 3 6554 Roland Area County Water District Land 24569 2054 Kinneloa Irrigation District 320 Special District 4 Irrigation District 17 http://www.kinneloairrigationdistrict.info/ Special District 4 2054 Kinneloa Irrigation District 317 Special District 4 Irrigation District 16   Los Angeles 6 1.271 Roland Area County Water District Land   None 139  
1762 1762 1761 {"type": "Polygon", "coordinates": [[[-117.90135, 33.9591], [-117.90114, 33.95933], [-117.90097, 33.95918], [-117.90029, 33.95921], [-117.90038, 33.95914], [-117.90053, 33.95907], [-117.89969, 33.95857], [-117.89885, 33.95773], [-117.89826, 33.95783], [-117.89766, 33.95753], [-117.89771, 33.95684], [-117.89761, 33.9564], [-117.89643, 33.95562], [-117.89634, 33.95554], [-117.89624, 33.95542], [-117.89618, 33.95531], [-117.89616, 33.9552], [-117.89626, 33.95518], [-117.89661, 33.95555], [-117.89745, 33.95579], [-117.89819, 33.95616], [-117.89868, 33.95697], [-117.89953, 33.95806], [-117.90094, 33.959], [-117.90126, 33.95894], [-117.90135, 33.9591]]]} No Public Access 3 6555 Roland Area County Water District Land 24569 2054 Kinneloa Irrigation District 320 Special District 4 Irrigation District 17 http://www.kinneloairrigationdistrict.info/ Special District 4 2054 Kinneloa Irrigation District 317 Special District 4 Irrigation District 16   Los Angeles 6 7.601 Roland Area County Water District Land   None 140  
2014 2014 2013 {"type": "MultiPolygon", "coordinates": [[[[-118.65797, 34.15108], [-118.65776, 34.15113], [-118.65762, 34.15114], [-118.65756, 34.15098], [-118.65791, 34.15089], [-118.65797, 34.15108]]], [[[-118.65916, 34.15322], [-118.65899, 34.15369], [-118.65869, 34.15384], [-118.65822, 34.15383], [-118.65821, 34.15311], [-118.6587, 34.15288], [-118.65916, 34.15322]]]]} No Public Access 3 12419 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 1.898 Las Virgenes Municipal Water District OS 0 Local Recreation Area 3 4
2063 2063 2062 {"type": "Polygon", "coordinates": [[[-121.72757, 37.22352], [-121.71451, 37.23235], [-121.71451, 37.23236], [-121.7172, 37.23464], [-121.70907, 37.23466], [-121.70896, 37.22768], [-121.68349, 37.20613], [-121.66781, 37.20618], [-121.67335, 37.20336], [-121.6791, 37.20242], [-121.67911, 37.20067], [-121.69238, 37.20067], [-121.70295, 37.20346], [-121.70715, 37.20748], [-121.71486, 37.20753], [-121.71586, 37.20847], [-121.71755, 37.20724], [-121.71888, 37.2083], [-121.72001, 37.20859], [-121.72022, 37.20878], [-121.71982, 37.20964], [-121.71971, 37.21025], [-121.71956, 37.2107], [-121.71982, 37.21106], [-121.71977, 37.21154], [-121.71979, 37.21168], [-121.71983, 37.21181], [-121.7199, 37.21193], [-121.71999, 37.21205], [-121.72039, 37.21246], [-121.72062, 37.21273], [-121.72078, 37.21297], [-121.72108, 37.21354], [-121.72124, 37.21377], [-121.72235, 37.2151], [-121.72259, 37.21534], [-121.72293, 37.21561], [-121.7233, 37.21586], [-121.72358, 37.216], [-121.72322, 37.21628], [-121.72303, 37.21652], [-121.72234, 37.21764], [-121.72235, 37.21797], [-121.72757, 37.22352]]]} No Public Access 3 47761 Coyote Ridge Open Space Preserve 31566 2142 Santa Clara Valley Open Space Authority 475 Special District 4 Recreation/Parks District 4 http://www.openspaceauthority.org/ Special District 4 2142 Santa Clara Valley Open Space Authority 468 Special District 4 Recreation/Parks District 4 http://www.openspaceauthority.org/ Santa Clara 19 1829.785 Coyote Ridge OSP 2015 Local Conservation Area 4 2
2066 2066 2065 {"type": "Polygon", "coordinates": [[[-118.67437, 34.13917], [-118.67424, 34.13936], [-118.67408, 34.13928], [-118.67422, 34.13909], [-118.67437, 34.13917]]]} No Public Access 3 12422 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.103 Las Virgenes Municipal Water District OS 0 Local Recreation Area 3 4
2236 2236 2235 {"type": "Polygon", "coordinates": [[[-118.34876, 33.79283], [-118.34853, 33.79307], [-118.3421, 33.78766], [-118.34362, 33.78659], [-118.34783, 33.79015], [-118.34783, 33.79205], [-118.34876, 33.79283]]]} No Public Access 3 5918 South Coast Park/former Palos Verdes Landfill site 29032 2139 Sanitation Districts of Los Angeles County 290 Special District 4 Sanitation District 18 http://www.lacsd.org/ Special District 4 2139 Sanitation Districts of Los Angeles County 490 Special District 4 Sanitation District 19 http://www.lacsd.org/solidwaste/swfacilities/landfills/palos_verdes/ Los Angeles 6 30.5 South Coast Park/former Palos Verdes Landfill site   None 184  
2329 2329 2328 {"type": "Polygon", "coordinates": [[[-119.51345, 34.48686], [-119.51326, 34.49394], [-119.4989, 34.49389], [-119.49892, 34.49041], [-119.49005, 34.49037], [-119.49007, 34.4868], [-119.49489, 34.48683], [-119.51345, 34.48686]]]} No Public Access 3 17019 Jameson Lake 20355 2082 Montecito Water District 513 Special District 4 Water District 13 http://www.montecitowater.com/ Special District 4 2082 Montecito Water District 506 Special District 4 Water District 13   Santa Barbara 7 336.515 Jameson Lake   None 196  
2565 2565 2564 {"type": "Polygon", "coordinates": [[[-117.90918, 33.95983], [-117.90918, 33.95986], [-117.90916, 33.95988], [-117.90863, 33.95999], [-117.90848, 33.95973], [-117.90893, 33.95954], [-117.90906, 33.95966], [-117.90914, 33.95975], [-117.90918, 33.95983]]]} No Public Access 3 6556 Roland Area County Water District Land 24569 2054 Kinneloa Irrigation District 320 Special District 4 Irrigation District 17 http://www.kinneloairrigationdistrict.info/ Special District 4 2054 Kinneloa Irrigation District 317 Special District 4 Irrigation District 16   Los Angeles 6 0.487 Roland Area County Water District Land   None 210  
2593 2593 2592 {"type": "Polygon", "coordinates": [[[-117.89197, 33.96438], [-117.89183, 33.96505], [-117.89141, 33.96512], [-117.8911, 33.96526], [-117.89075, 33.96497], [-117.89062, 33.96475], [-117.89062, 33.96444], [-117.89119, 33.96426], [-117.89197, 33.96438]]]} No Public Access 3 6557 Roland Area County Water District Land 24569 2054 Kinneloa Irrigation District 320 Special District 4 Irrigation District 17 http://www.kinneloairrigationdistrict.info/ Special District 4 2054 Kinneloa Irrigation District 317 Special District 4 Irrigation District 16   Los Angeles 6 2.479 Roland Area County Water District Land   None 214  
2606 2606 2605 {"type": "MultiPolygon", "coordinates": [[[[-118.65203, 34.0785], [-118.65188, 34.07884], [-118.65156, 34.07893], [-118.65122, 34.07868], [-118.65139, 34.07845], [-118.65163, 34.07837], [-118.65203, 34.0785]]], [[[-118.68181, 34.15509], [-118.68163, 34.15516], [-118.68156, 34.155], [-118.68174, 34.15494], [-118.68181, 34.15509]]]]} No Public Access 3 12427 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.817 Las Virgenes Municipal Water District OS 0 Local Recreation Area 3 4
2686 2686 2685 {"type": "Polygon", "coordinates": [[[-122.47796, 37.56987], [-122.46847, 37.57003], [-122.46834, 37.56631], [-122.47791, 37.56619], [-122.47796, 37.56987]]]} No Public Access 3 18237 North Coast Water Dist 22815 2093 North Coast Water District 544 Special District 4 Water District 13 http://www.nccwd.com Special District 4 2093 North Coast Water District 537 Special District 4 Water District 13   San Mateo 15 85.384 North Coast Water Dist   None 220  

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