units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
210 rows where ACCESS_TYP = 4 and LAYER = 4 sorted by DES_TP
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, MNG_AG_LEV, COUNTY, YR_EST, GAP_STS
DES_TP >30
MNG_AGENCY 16
- Mountains Recreation and Conservation Authority 136
- Yuba County Water Agency 48
- Santa Barbara Flood Control and Water Conserv. District 4
- San Joaquin River Parkway and Conservation Trust 4
- North County Transit District 4
- Sacramento and San Joaquin Drainage District 3
- Ramona Municipal Water District 2
- Monterey Peninsula Regional Park District 1
- Trabuco Canyon Water District 1
- Conejo Open Space Conservation Agency 1
- Sacramento Municipal Utility District 1
- Santa Fe Irrigation District 1
- Orange County Water District 1
- Helix Water District 1
- Santa Ynez River Water Conservation District 1
- Western Riverside County Regional Conservation Authority 1
MNG_AG_TYP 7
ACCESS_TYP 1
- Unknown Access · 210 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15240 | 15240 | 15239 | {"type": "Polygon", "coordinates": [[[-118.62073, 34.19735], [-118.62041, 34.19737], [-118.6201, 34.19741], [-118.6198, 34.19749], [-118.6194, 34.19763], [-118.6194, 34.19749], [-118.6193, 34.19749], [-118.6193, 34.19743], [-118.61926, 34.19743], [-118.61925, 34.19737], [-118.6188, 34.19737], [-118.6188, 34.19735], [-118.62073, 34.19735]]]} | Unknown Access 4 | 46238 | Bell Creek Park | 29516 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.384 | Bell Creek Park | 0 | Local Park 2 | 4 | |
15272 | 15272 | 15271 | {"type": "Polygon", "coordinates": [[[-118.60349, 34.03929], [-118.60304, 34.03933], [-118.60253, 34.03932], [-118.60254, 34.03911], [-118.60277, 34.03913], [-118.60296, 34.03912], [-118.60331, 34.03908], [-118.60345, 34.03903], [-118.60349, 34.03929]]]} | Unknown Access 4 | 46353 | Las Tunas Beach | 29634 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 0.511 | Las Tunas Beach | 0 | Local Park 2 | 4 | |
15283 | 15283 | 15282 | {"type": "Polygon", "coordinates": [[[-118.63258, 34.35354], [-118.62383, 34.35366], [-118.62373, 34.34997], [-118.63242, 34.34997], [-118.63258, 34.35354]]]} | Unknown Access 4 | 46403 | Ron Bishop & Judge Anderson Park | 29682 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 79.884 | Ron Bishop & Judge Anderson Park | 0 | Local Park 2 | 4 | |
2390 | 2390 | 2389 | {"type": "Polygon", "coordinates": [[[-118.71787, 34.45684], [-118.71569, 34.45684], [-118.71568, 34.46041], [-118.71122, 34.4604], [-118.70698, 34.46033], [-118.70695, 34.45676], [-118.70268, 34.45668], [-118.70267, 34.45669], [-118.70272, 34.46026], [-118.69843, 34.46019], [-118.6982, 34.45301], [-118.70692, 34.45318], [-118.70696, 34.44953], [-118.71123, 34.44959], [-118.71339, 34.44958], [-118.71341, 34.45326], [-118.71611, 34.45327], [-118.71787, 34.45684]]]} | Unknown Access 4 | 11474 | Holser Canyon Open Space | 29737 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 345.8 | Holser Canyon OS | 0 | Local Recreation Area 3 | 4 | |
7025 | 7025 | 7024 | {"type": "Polygon", "coordinates": [[[-118.00435, 34.00067], [-118.00072, 34.00684], [-117.99905, 34.00616], [-117.99865, 34.00604], [-117.99811, 34.00594], [-117.99769, 34.00592], [-117.9972, 34.00594], [-117.99674, 34.00602], [-117.99656, 34.00606], [-117.99617, 34.00619], [-117.99577, 34.00638], [-117.99538, 34.00662], [-117.995, 34.00693], [-117.99481, 34.00713], [-117.99462, 34.00739], [-117.99442, 34.00773], [-117.99436, 34.00788], [-117.99402, 34.00902], [-117.99395, 34.00922], [-117.99391, 34.0093], [-117.99494, 34.00555], [-117.99575, 34.0047], [-117.99784, 34.0031], [-117.99943, 34.00315], [-118.00071, 34.00186], [-118.00161, 34.00193], [-118.0024, 34.00178], [-118.00309, 34.0011], [-118.00371, 34.00108], [-118.00435, 34.00067]]]} | Unknown Access 4 | 6507 | Hacienda Hills Open Space | 29675 | 2332 | Puente Hills Habitat Preservation Authority 849 | Special District 4 | Conservation District 31 | http://www.habitatauthority.org | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 62.094 | Hacienda Hills OS | 0 | Local Recreation Area 3 | 4 | |
15308 | 15308 | 15307 | {"type": "Polygon", "coordinates": [[[-118.80384, 34.13634], [-118.80042, 34.13935], [-118.78741, 34.13631], [-118.777, 34.13531], [-118.77703, 34.13029], [-118.77642, 34.13028], [-118.77627, 34.13026], [-118.77605, 34.13018], [-118.77593, 34.1301], [-118.77583, 34.13001], [-118.77548, 34.12953], [-118.77573, 34.1294], [-118.77599, 34.12923], [-118.77622, 34.12904], [-118.77644, 34.12884], [-118.77663, 34.12862], [-118.77679, 34.12839], [-118.77694, 34.12813], [-118.77704, 34.12788], [-118.77712, 34.12763], [-118.77717, 34.12737], [-118.77785, 34.12235], [-118.77798, 34.12189], [-118.77811, 34.1216], [-118.77826, 34.12131], [-118.77855, 34.12091], [-118.77877, 34.12065], [-118.77951, 34.12141], [-118.79034, 34.12722], [-118.79411, 34.13556], [-118.80384, 34.13634]]]} | Unknown Access 4 | 46454 | Truinfo Canyon Open Space | 29730 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 525.504 | Truinfo Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16130 | 16130 | 16129 | {"type": "Polygon", "coordinates": [[[-118.87531, 34.20277], [-118.8746, 34.20316], [-118.87384, 34.2035], [-118.87306, 34.20327], [-118.87173, 34.20299], [-118.87011, 34.20208], [-118.86977, 34.20202], [-118.86977, 34.20128], [-118.87009, 34.20089], [-118.8705, 34.20068], [-118.8705, 34.20045], [-118.87138, 34.20058], [-118.87227, 34.20084], [-118.87308, 34.20101], [-118.87397, 34.20157], [-118.87374, 34.20181], [-118.87374, 34.20183], [-118.87445, 34.20231], [-118.8749, 34.20224], [-118.87531, 34.20277]]]} | Unknown Access 4 | 17173 | Labisco Hill Open Space | 20815 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | Ventura 8 | 23.9 | Labisco Hill OS | 0 | Local Recreation Area 3 | 4 | |
16248 | 16248 | 16247 | {"type": "Polygon", "coordinates": [[[-118.44985, 34.49555], [-118.44095, 34.49537], [-118.44088, 34.48111], [-118.44536, 34.48112], [-118.44537, 34.48476], [-118.44984, 34.48473], [-118.44985, 34.49555]]]} | Unknown Access 4 | 46434 | Texas Canyon Open Space | 29702 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 281.429 | Texas Canyon OS | 0 | Local Recreation Area 3 | 4 | |
16263 | 16263 | 16262 | {"type": "Polygon", "coordinates": [[[-118.6587, 34.05186], [-118.65574, 34.05186], [-118.65572, 34.0492], [-118.65578, 34.04919], [-118.65576, 34.04829], [-118.65868, 34.04827], [-118.6587, 34.05186]]]} | Unknown Access 4 | 46376 | Carbon Canyon Open Space | 29656 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 26.736 | Carbon Canyon OS | 0 | Local Recreation Area 3 | 4 | |
13166 | 13166 | 13165 | {"type": "Polygon", "coordinates": [[[-117.35743, 33.16745], [-117.35654, 33.16659], [-117.35654, 33.16659], [-117.35663, 33.16654], [-117.35665, 33.16649], [-117.35674, 33.16649], [-117.35696, 33.16668], [-117.35696, 33.1667], [-117.35728, 33.16704], [-117.35724, 33.16707], [-117.35727, 33.1671], [-117.35726, 33.16716], [-117.35728, 33.16723], [-117.3574, 33.16736], [-117.35743, 33.16745]]]} | Unknown Access 4 | 45147 | Buena Vista Lagoon Ecological Reserve | 16489 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 0.497 | Buena Vista Lagoon ER | 1968 | Local Conservation Area 4 | 2 | |
14768 | 14768 | 14767 | {"type": "Polygon", "coordinates": [[[-117.31758, 33.10576], [-117.31739, 33.10582], [-117.31597, 33.10271], [-117.3161, 33.10265], [-117.31758, 33.10576]]]} | Unknown Access 4 | 45154 | Poinsettia Lane Vernal Pools | 23843 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | San Diego 4 | 1.476 | Poinsettia Lane Vernal Pools | 0 | Local Conservation Area 4 | 2 | |
15234 | 15234 | 15233 | {"type": "Polygon", "coordinates": [[[-118.65002, 34.08174], [-118.64987, 34.08185], [-118.6439, 34.08195], [-118.64441, 34.0814], [-118.64487, 34.08123], [-118.64515, 34.08131], [-118.64532, 34.08135], [-118.64552, 34.08136], [-118.64571, 34.08135], [-118.64588, 34.08131], [-118.64667, 34.08106], [-118.64687, 34.08101], [-118.64823, 34.08085], [-118.64848, 34.08078], [-118.64869, 34.08068], [-118.64998, 34.08047], [-118.65001, 34.08047], [-118.65002, 34.08174]]]} | Unknown Access 4 | 46281 | Cold Creek Canyon Preserve | 29572 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 13.405 | Cold Creek Canyon Preserve | 0 | Local Conservation Area 4 | 2 | |
15297 | 15297 | 15296 | {"type": "Polygon", "coordinates": [[[-118.64114, 34.04646], [-118.64114, 34.04927], [-118.63883, 34.04927], [-118.6389, 34.04916], [-118.63895, 34.04894], [-118.63908, 34.04862], [-118.63914, 34.04837], [-118.63942, 34.04697], [-118.63947, 34.04677], [-118.63956, 34.04655], [-118.63956, 34.04642], [-118.63952, 34.04633], [-118.64114, 34.04646]]]} | Unknown Access 4 | 46435 | Tom & Giselle Hennesy Nature Preserve | 29704 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 13.881 | Tom & Giselle Hennesy Nature Preserve | 0 | Local Conservation Area 4 | 2 | |
15640 | 15640 | 15639 | {"type": "MultiPolygon", "coordinates": [[[[-117.31035, 33.08979], [-117.31028, 33.08985], [-117.31002, 33.08986], [-117.3097, 33.08907], [-117.30937, 33.08815], [-117.30811, 33.08419], [-117.30836, 33.08424], [-117.30846, 33.08445], [-117.30841, 33.08445], [-117.3084, 33.0845], [-117.30846, 33.08469], [-117.30861, 33.0851], [-117.30879, 33.0855], [-117.30911, 33.08636], [-117.30926, 33.08685], [-117.30936, 33.08707], [-117.30944, 33.08752], [-117.30948, 33.08757], [-117.30958, 33.0876], [-117.3098, 33.08825], [-117.3098, 33.08832], [-117.30977, 33.0884], [-117.30987, 33.08879], [-117.31004, 33.08917], [-117.31007, 33.08927], [-117.31015, 33.08935], [-117.31023, 33.08954], [-117.31034, 33.0897], [-117.31035, 33.08979]]], [[[-117.31092, 33.09038], [-117.31087, 33.09039], [-117.31078, 33.09031], [-117.31073, 33.09017], [-117.31058, 33.08993], [-117.31056, 33.0898], [-117.31043, 33.08945], [-117.31048, 33.08939], [-117.31045, 33.08926], [-117.31027, 33.08887], [-117.31021, 33.08862], [-117.31001, 33.08829], [-117.30994, 33.08824], [-117.30987, 33.08814], [-117.30966, 33.08762], [-117.30966, 33.08759], [-117.30968, 33.08746], [-117.30965, 33.0873], [-117.30953, 33.08701], [-117.30946, 33.08676], [-117.30932, 33.08638], [-117.30928, 33.0862], [-117.30915, 33.08591], [-117.30901, 33.08547], [-117.30893, 33.08529], [-117.30884, 33.08484], [-117.30877, 33.08464], [-117.30875, 33.08445], [-117.30868, 33.08417], [-117.30878, 33.08405], [-117.30986, 33.08748], [-117.31068, 33.08968], [-117.31077, 33.08988], [-117.31076, 33.08997], [-117.31079, 33.09011], [-117.3109, 33.09029], [-117.31092, 33.09038]]]]} | Unknown Access 4 | 45153 | Batiquitos Lagoon Ecological Reserve | 15865 | 2323 | North County Transit District 1046 | Special District 4 | Transportation Agency 32 | http://www.gonctd.com/ | Special District 4 | 2323 | North County Transit District 1006 | Special District 4 | Transportation Agency 34 | https://www.wildlife.ca.gov/Lands/Places-to-Visit/Batiquitos-Lagoon-ER | San Diego 4 | 7.116 | Batiquitos Lagoon ER | 1983 | Local Conservation Area 4 | 2 |
15951 | 15951 | 15950 | {"type": "MultiPolygon", "coordinates": [[[[-118.33807, 34.27306], [-118.33791, 34.27303], [-118.3371, 34.27278], [-118.33698, 34.27304], [-118.33535, 34.27254], [-118.33388, 34.27329], [-118.33264, 34.27327], [-118.33262, 34.27345], [-118.33394, 34.27349], [-118.33466, 34.27312], [-118.33435, 34.27471], [-118.33322, 34.27471], [-118.33273, 34.27646], [-118.33291, 34.27701], [-118.33276, 34.27755], [-118.33276, 34.27784], [-118.33277, 34.27785], [-118.33365, 34.27756], [-118.33494, 34.27756], [-118.33497, 34.27884], [-118.32953, 34.27884], [-118.32948, 34.27702], [-118.32203, 34.27702], [-118.32201, 34.27524], [-118.32227, 34.27509], [-118.322, 34.27457], [-118.3217, 34.27405], [-118.32007, 34.27399], [-118.32007, 34.27424], [-118.32047, 34.27455], [-118.31964, 34.27455], [-118.32, 34.27319], [-118.31998, 34.27318], [-118.3197, 34.27329], [-118.31952, 34.27322], [-118.31952, 34.27299], [-118.31761, 34.27368], [-118.31755, 34.27363], [-118.31747, 34.27359], [-118.31739, 34.27358], [-118.3173, 34.27358], [-118.31584, 34.27392], [-118.31553, 34.27404], [-118.31528, 34.27416], [-118.3152, 34.27417], [-118.3151, 34.27417], [-118.31508, 34.27422], [-118.31448, 34.27468], [-118.31398, 34.27475], [-118.31563, 34.27261], [-118.31564, 34.27263], [-118.31567, 34.27264], [-118.31568, 34.27309], [-118.31569, 34.2731], [-118.3189, 34.27071], [-118.31927, 34.27065], [-118.31971, 34.27053], [-118.31999, 34.27041], [-118.32037, 34.27019], [-118.3207, 34.26992], [-118.32133, 34.26926], [-118.32152, 34.26911], [-118.32171, 34.26899], [-118.32202, 34.26884], [-118.32229, 34.26875], [-118.32329, 34.26851], [-118.32366, 34.2684], [-118.32402, 34.26826], [-118.32452, 34.26801], [-118.32457, 34.26809], [-118.3246, 34.26819], [-118.32458, 34.26833], [-118.32452, 34.26841], [-118.3244, 34.26851], [-118.32392, 34.26874], [-118.32364, 34.26882], [-118.32334, 34.26885], [-118.32234, 34.26875], [-118.32228, 34.26877], [-118.322, 34.26906], [-118.32201, 34.26911], [-118.32244, 34.2694], [-118.32253, 34.2695], [-118.32256, 34.26963], [-118.32251, 34.27004], [-118.32255, 34.27025], [-118.32262, 34.27038], [-118.32294, 34.27092], [-118.32298, 34.27111], [-118.32305, 34.27117], [-118.32353, 34.27127], [-118.32389, 34.27133], [-118.32425, 34.27135], [-118.32462, 34.27135], [-118.32498, 34.27132], [-118.32534, 34.27126], [-118.32579, 34.27115], [-118.32625, 34.271], [-118.32646, 34.27096], [-118.32678, 34.27094], [-118.32747, 34.271], [-118.32755, 34.27103], [-118.32761, 34.27108], [-118.32779, 34.27137], [-118.32783, 34.27146], [-118.32786, 34.2716], [-118.32783, 34.27204], [-118.32784, 34.2721], [-118.32789, 34.27215], [-118.32795, 34.27218], [-118.32815, 34.27218], [-118.32832, 34.27215], [-118.33019, 34.27168], [-118.33063, 34.27154], [-118.33216, 34.27088], [-118.33291, 34.27042], [-118.33312, 34.27032], [-118.33334, 34.27024], [-118.33359, 34.27018], [-118.33403, 34.27012], [-118.33423, 34.27011], [-118.33443, 34.27013], [-118.33463, 34.27017], [-118.33482, 34.27023], [-118.33499, 34.27032], [-118.33523, 34.27046], [-118.3354, 34.27054], [-118.3368, 34.27101], [-118.33693, 34.27099], [-118.33707, 34.27091], [-118.33695, 34.27063], [-118.33714, 34.27057], [-118.33807, 34.27253], [-118.33785, 34.2726], [-118.33807, 34.27306]]], [[[-118.32554, 34.2667], [-118.32551, 34.26716], [-118.32418, 34.26786], [-118.3237, 34.26808], [-118.32319, 34.26825], [-118.32215, 34.2685], [-118.32187, 34.2686], [-118.32162, 34.26871], [-118.32127, 34.26893], [-118.32095, 34.26918], [-118.32093, 34.26922], [-118.32042, 34.26976], [-118.3201, 34.27001], [-118.31986, 34.27015], [-118.31961, 34.27027], [-118.31941, 34.27033], [-118.32008, 34.26983], [-118.32008, 34.26968], [-118.31883, 34.2706], [-118.31789, 34.2706], [-118.31789, 34.26925], [-118.31957, 34.26857], [-118.31979, 34.26865], [-118.32, 34.26826], [-118.32008, 34.26828], [-118.32009, 34.26821], [-118.32058, 34.26835], [-118.32057, 34.26842], [-118.32157, 34.26872], [-118.32201, 34.26839], [-118.32238, 34.26835], [-118.3232, 34.26792], [-118.3232, 34.26705], [-118.32526, 34.26723], [-118.32534, 34.26674], [-118.32537, 34.2667], [-118.32554, 34.2667]]]]} | Unknown Access 4 | 46259 | Big Tujunga Wash Open Space Preserve | 29544 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 281.948 | Big Tujunga Wash OSP | 0 | Local Conservation Area 4 | 2 | |
108 | 108 | 107 | {"type": "Polygon", "coordinates": [[[-119.80165, 34.44381], [-119.80106, 34.44387], [-119.79957, 34.44402], [-119.79959, 34.44377], [-119.80161, 34.44357], [-119.80165, 34.44381]]]} | Unknown Access 4 | 295 | San Antonio Creek | 24829 | 2141 | Santa Barbara Flood Control and Water Conserv. District 46 | Special District 4 | Flood District 8 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | Santa Barbara 7 | 1.291 | San Antonio Creek | 0 | Local Other or Unknown 14 | 4 | |
1208 | 1208 | 1207 | {"type": "Polygon", "coordinates": [[[-118.6372, 34.36427], [-118.62414, 34.36475], [-118.62394, 34.35736], [-118.63275, 34.35717], [-118.63292, 34.36076], [-118.63708, 34.36067], [-118.6372, 34.36427]]]} | Unknown Access 4 | 8425 | Unnamed site - Mountains Recreation and Conservation Authority | 28644 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 201.929 | 0 | Local Other or Unknown 14 | 4 | ||
3438 | 3438 | 3437 | {"type": "Polygon", "coordinates": [[[-121.27738, 39.49699], [-121.277, 39.49737], [-121.27617, 39.49697], [-121.2765, 39.49657], [-121.27738, 39.49699]]]} | Unknown Access 4 | 35476 | Yuba County Water Agency 3 | 27818 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.144 | Yuba County Water Agency 3 | 0 | Local Other or Unknown 14 | 4 | |
3457 | 3457 | 3456 | {"type": "Polygon", "coordinates": [[[-121.27854, 39.49693], [-121.27778, 39.49658], [-121.27854, 39.4958], [-121.27851, 39.49654], [-121.27854, 39.49693]]]} | Unknown Access 4 | 35580 | Yuba County Water Agency 47 | 27837 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 0.973 | Yuba County Water Agency 47 | 0 | Local Other or Unknown 14 | 4 | |
3465 | 3465 | 3464 | {"type": "Polygon", "coordinates": [[[-121.27748, 39.49831], [-121.27736, 39.49848], [-121.27711, 39.49873], [-121.27626, 39.49834], [-121.27659, 39.49789], [-121.27748, 39.49831]]]} | Unknown Access 4 | 35637 | Yuba County Water Agency 14 | 27802 | 2186 | Yuba County Water Agency 492 | Special District 4 | Water District 13 | http://www.ycwa.com/ | Special District 4 | 2186 | Yuba County Water Agency 483 | Special District 4 | Water District 13 | Yuba 25 | 1.259 | Yuba County Water Agency 14 | 0 | Local Other or Unknown 14 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
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]);