units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
58 rows where ACCESS_TYP = 3 and MNG_AG_TYP = 9 sorted by ACRES descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_TYP, AGNCY_WEB, MNG_AG_ID, COUNTY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11266 | 11266 | 11265 | {"type": "MultiPolygon", "coordinates": [[[[-121.51211, 38.73594], [-121.5053, 38.73594], [-121.4936, 38.73517], [-121.49357, 38.73261], [-121.492, 38.73261], [-121.492, 38.73089], [-121.49354, 38.73089], [-121.49355, 38.73073], [-121.49199, 38.73072], [-121.49192, 38.73045], [-121.49182, 38.73023], [-121.49167, 38.73], [-121.49147, 38.72979], [-121.49128, 38.72963], [-121.49109, 38.72951], [-121.49064, 38.72931], [-121.49032, 38.72913], [-121.49007, 38.72895], [-121.49007, 38.72887], [-121.49617, 38.72886], [-121.49617, 38.7293], [-121.49615, 38.72941], [-121.49619, 38.72953], [-121.49628, 38.72963], [-121.49641, 38.72969], [-121.49656, 38.72971], [-121.49671, 38.72969], [-121.49683, 38.72962], [-121.49685, 38.72975], [-121.49753, 38.72982], [-121.49755, 38.72954], [-121.49765, 38.72954], [-121.4977, 38.72935], [-121.49818, 38.72939], [-121.49818, 38.72885], [-121.51206, 38.72883], [-121.51211, 38.73594]], [[-121.5041, 38.72946], [-121.50409, 38.72906], [-121.50368, 38.72907], [-121.50368, 38.72947], [-121.5041, 38.72946]], [[-121.50716, 38.72915], [-121.50715, 38.72913], [-121.50677, 38.7291], [-121.50648, 38.72911], [-121.50584, 38.72909], [-121.50595, 38.72985], [-121.5059, 38.72993], [-121.5059, 38.73022], [-121.50588, 38.73035], [-121.50575, 38.73041], [-121.50568, 38.73055], [-121.50563, 38.7312], [-121.50567, 38.73125], [-121.50695, 38.73036], [-121.50694, 38.73024], [-121.50705, 38.72956], [-121.50716, 38.72915]]], [[[-121.56722, 38.72886], [-121.55826, 38.7289], [-121.55829, 38.73595], [-121.54081, 38.73595], [-121.54077, 38.72191], [-121.5486, 38.7219], [-121.54862, 38.72894], [-121.54863, 38.72895], [-121.55825, 38.7289], [-121.55823, 38.72189], [-121.56715, 38.72188], [-121.56722, 38.72886]]]]} | No Public Access 3 | 21709 | Central Basin | 17046 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 883.433 | Central Basin | None 984 | |||
11274 | 11274 | 11273 | {"type": "MultiPolygon", "coordinates": [[[[-121.56274, 38.64215], [-121.55175, 38.64219], [-121.55177, 38.63957], [-121.56212, 38.63953], [-121.56243, 38.64112], [-121.56256, 38.64159], [-121.56274, 38.64215]]], [[[-121.56974, 38.6564], [-121.5697, 38.66347], [-121.5552, 38.66347], [-121.55514, 38.66338], [-121.55569, 38.66199], [-121.55597, 38.6616], [-121.55662, 38.66106], [-121.55701, 38.66063], [-121.55734, 38.66024], [-121.55755, 38.65989], [-121.55802, 38.65871], [-121.55839, 38.65818], [-121.55884, 38.65793], [-121.55993, 38.65762], [-121.56053, 38.65731], [-121.56097, 38.65689], [-121.56108, 38.65639], [-121.56974, 38.6564]]], [[[-121.56061, 38.631], [-121.55811, 38.631], [-121.55878, 38.63463], [-121.55707, 38.63464], [-121.55706, 38.63442], [-121.55574, 38.62732], [-121.55758, 38.62732], [-121.55858, 38.62737], [-121.56002, 38.62737], [-121.56004, 38.62778], [-121.5601, 38.62831], [-121.56061, 38.631]]], [[[-121.56747, 38.64782], [-121.56742, 38.65624], [-121.56279, 38.65624], [-121.56281, 38.65341], [-121.55849, 38.65339], [-121.5583, 38.65285], [-121.55758, 38.65156], [-121.55699, 38.65089], [-121.55642, 38.64912], [-121.56515, 38.6491], [-121.56711, 38.64756], [-121.56747, 38.64782]]]]} | No Public Access 3 | 21780 | Fisherman's Lake | 18921 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 461.997 | Fisherman's Lake | None 986 | |||
12713 | 12713 | 12712 | {"type": "Polygon", "coordinates": [[[-121.5792, 38.79911], [-121.57248, 38.80318], [-121.56408, 38.80822], [-121.56355, 38.80823], [-121.55976, 38.81045], [-121.5595, 38.80998], [-121.55948, 38.80977], [-121.55947, 38.80965], [-121.55888, 38.80918], [-121.55872, 38.80892], [-121.55869, 38.80876], [-121.5588, 38.8086], [-121.55929, 38.80831], [-121.55957, 38.80806], [-121.56043, 38.80555], [-121.56042, 38.80542], [-121.56024, 38.80506], [-121.55948, 38.80369], [-121.55935, 38.80338], [-121.55935, 38.80321], [-121.55964, 38.80302], [-121.56279, 38.802], [-121.56309, 38.80189], [-121.56556, 38.80015], [-121.56849, 38.79901], [-121.56869, 38.79887], [-121.56881, 38.79871], [-121.56961, 38.79649], [-121.57279, 38.79732], [-121.5738, 38.79791], [-121.57594, 38.7985], [-121.57902, 38.79894], [-121.5792, 38.79911]]]} | No Public Access 3 | 29724 | Lucich North | 21579 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 259.302 | Lucich North | None 1109 | |||
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 | |
12718 | 12718 | 12717 | {"type": "Polygon", "coordinates": [[[-121.59372, 38.74945], [-121.59374, 38.74956], [-121.5937, 38.74972], [-121.59337, 38.75048], [-121.59196, 38.75395], [-121.59179, 38.7545], [-121.59167, 38.75505], [-121.59145, 38.75654], [-121.57989, 38.75672], [-121.57986, 38.75654], [-121.57698, 38.75393], [-121.57695, 38.74977], [-121.58419, 38.7496], [-121.58418, 38.75113], [-121.58333, 38.75114], [-121.58331, 38.75313], [-121.58574, 38.75314], [-121.58577, 38.74956], [-121.59366, 38.74939], [-121.59372, 38.74945]]]} | No Public Access 3 | 29734 | Huffman West | 20139 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 232.676 | Huffman West | 0 | None 1114 | ||
12714 | 12714 | 12713 | {"type": "MultiPolygon", "coordinates": [[[[-121.56761, 38.79009], [-121.55865, 38.79021], [-121.55838, 38.7897], [-121.55831, 38.78945], [-121.55828, 38.78913], [-121.5583, 38.78872], [-121.55898, 38.78631], [-121.55907, 38.78572], [-121.559, 38.78306], [-121.5628, 38.78305], [-121.56282, 38.78417], [-121.56754, 38.78412], [-121.56761, 38.79009]]], [[[-121.5769, 38.7889], [-121.5769, 38.79001], [-121.5678, 38.79009], [-121.56773, 38.78412], [-121.57225, 38.78407], [-121.57227, 38.7866], [-121.57639, 38.78658], [-121.57654, 38.78666], [-121.57683, 38.78666], [-121.57683, 38.78685], [-121.5765, 38.78685], [-121.57631, 38.78675], [-121.57514, 38.78676], [-121.57513, 38.7889], [-121.57514, 38.78891], [-121.5769, 38.7889]]]]} | No Public Access 3 | 29726 | Nestor | 22702 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 229.848 | Nestor | None 1110 | |||
13174 | 13174 | 13173 | {"type": "MultiPolygon", "coordinates": [[[[-121.56754, 38.78412], [-121.56281, 38.78417], [-121.56279, 38.78305], [-121.559, 38.78306], [-121.55896, 38.78247], [-121.55883, 38.78192], [-121.55796, 38.77936], [-121.56749, 38.77925], [-121.56754, 38.78412]]], [[[-121.57688, 38.7791], [-121.57685, 38.78379], [-121.57658, 38.7838], [-121.57635, 38.78385], [-121.57612, 38.78398], [-121.57591, 38.78415], [-121.57575, 38.78438], [-121.57562, 38.78465], [-121.5756, 38.78501], [-121.57605, 38.78658], [-121.57227, 38.7866], [-121.57225, 38.78407], [-121.56773, 38.78412], [-121.56767, 38.77925], [-121.57688, 38.7791]]]]} | No Public Access 3 | 35158 | Bennett North | 16014 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 220.308 | Bennett North | None 1145 | |||
12719 | 12719 | 12718 | {"type": "Polygon", "coordinates": [[[-121.57188, 38.7717], [-121.56259, 38.77184], [-121.56254, 38.76466], [-121.56254, 38.76083], [-121.56867, 38.76072], [-121.5687, 38.76451], [-121.57185, 38.76444], [-121.57188, 38.7717]]]} | No Public Access 3 | 29735 | Lucich Ranch | 21580 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 215.926 | Lucich Ranch | 0 | Local Other or Unknown 14 | 4 | |
12717 | 12717 | 12716 | {"type": "MultiPolygon", "coordinates": [[[[-121.6007, 38.7384], [-121.59981, 38.74049], [-121.59115, 38.74058], [-121.59023, 38.74346], [-121.58935, 38.74635], [-121.58496, 38.74644], [-121.58503, 38.74523], [-121.58488, 38.74496], [-121.58336, 38.74324], [-121.58352, 38.74306], [-121.58355, 38.74272], [-121.58366, 38.74229], [-121.5843, 38.74056], [-121.58581, 38.73629], [-121.59247, 38.73626], [-121.59185, 38.73841], [-121.59185, 38.73842], [-121.6007, 38.7384]]], [[[-121.58903, 38.7474], [-121.58849, 38.74926], [-121.58654, 38.7493], [-121.5865, 38.74746], [-121.58903, 38.7474]]]]} | No Public Access 3 | 29732 | Atkinson | 15671 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 207.413 | Atkinson | None 1113 | |||
3385 | 3385 | 3384 | {"type": "Polygon", "coordinates": [[[-121.55826, 38.7289], [-121.54862, 38.72895], [-121.5486, 38.7219], [-121.55823, 38.72189], [-121.55826, 38.7289]]]} | No Public Access 3 | 35038 | Natomas Basin Conservancy | 22668 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 161.591 | Natomas Basin Conservancy | None 279 | |||
11572 | 11572 | 11571 | {"type": "Polygon", "coordinates": [[[-121.56715, 38.72188], [-121.55823, 38.72189], [-121.5582, 38.71449], [-121.56014, 38.7145], [-121.56708, 38.71449], [-121.56715, 38.72188]]]} | No Public Access 3 | 29738 | Elsie | 18605 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 156.937 | Elsie | None 1031 | |||
12705 | 12705 | 12704 | {"type": "MultiPolygon", "coordinates": [[[[-121.59008, 38.78617], [-121.59003, 38.79179], [-121.58388, 38.78653], [-121.58388, 38.78637], [-121.59008, 38.78617]]], [[[-121.59012, 38.77873], [-121.59011, 38.78228], [-121.59002, 38.78231], [-121.58999, 38.78603], [-121.58388, 38.78623], [-121.58389, 38.77893], [-121.59012, 38.77873]]]]} | No Public Access 3 | 29733 | Bolen West | 16239 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 150.027 | Bolen West | None 1107 | |||
8353 | 8353 | 8352 | {"type": "Polygon", "coordinates": [[[-117.30775, 34.06867], [-117.30766, 34.06901], [-117.30769, 34.06982], [-117.30768, 34.07016], [-117.30758, 34.07063], [-117.30747, 34.07094], [-117.3073, 34.07133], [-117.30711, 34.07166], [-117.30698, 34.07184], [-117.30659, 34.07226], [-117.30613, 34.07269], [-117.30491, 34.07389], [-117.3049, 34.07457], [-117.30531, 34.07488], [-117.30526, 34.07493], [-117.3048, 34.07525], [-117.30449, 34.07581], [-117.3042, 34.07624], [-117.30421, 34.07678], [-117.3039, 34.07712], [-117.30332, 34.07721], [-117.30308, 34.07734], [-117.30273, 34.07744], [-117.30258, 34.07757], [-117.30151, 34.07756], [-117.30119, 34.07793], [-117.30111, 34.07804], [-117.30081, 34.07893], [-117.30044, 34.07934], [-117.30036, 34.07934], [-117.2989, 34.0811], [-117.29768, 34.07934], [-117.29728, 34.07871], [-117.29742, 34.07871], [-117.29748, 34.07809], [-117.29775, 34.07788], [-117.3005, 34.07406], [-117.30051, 34.07392], [-117.30064, 34.07392], [-117.30065, 34.07123], [-117.30052, 34.07122], [-117.30052, 34.0704], [-117.30255, 34.0704], [-117.30257, 34.06864], [-117.30775, 34.06867]]]} | No Public Access 3 | 12938 | Lytle-Cajon Channel/Warm Creek Confluence | 21616 | 2131 | San Bernardino County Flood Control District 891 | Special District 4 | Flood District 8 | http://www.sbcounty.gov/dpw/floodcontrol/ | Special District 4 | 2131 | San Bernardino County Flood Control District 865 | Special District 4 | Flood District 9 | San Bernardino 22 | 143.889 | Lytle-Cajon Channel/Warm Creek Confluence | 0 | None 697 | ||
16176 | 16176 | 16175 | {"type": "Polygon", "coordinates": [[[-118.02569, 34.09575], [-118.02561, 34.09631], [-118.0254, 34.0964], [-118.02208, 34.09808], [-118.02179, 34.09823], [-118.0218, 34.09825], [-118.02158, 34.09831], [-118.02096, 34.09882], [-118.02033, 34.0991], [-118.01846, 34.10006], [-118.01705, 34.10123], [-118.01607, 34.10226], [-118.01593, 34.10244], [-118.01581, 34.10265], [-118.01572, 34.10293], [-118.01569, 34.1031], [-118.01568, 34.1033], [-118.01569, 34.10344], [-118.01573, 34.10351], [-118.01587, 34.10418], [-118.01498, 34.10449], [-118.01309, 34.10512], [-118.01166, 34.10633], [-118.00712, 34.10626], [-118.00748, 34.10553], [-118.00754, 34.10551], [-118.00771, 34.10517], [-118.009, 34.10473], [-118.01107, 34.10048], [-118.01157, 34.10064], [-118.01175, 34.10074], [-118.01186, 34.10077], [-118.01189, 34.10083], [-118.01193, 34.10108], [-118.01201, 34.1012], [-118.01216, 34.10128], [-118.01232, 34.10131], [-118.01245, 34.1014], [-118.01249, 34.1015], [-118.01263, 34.10171], [-118.01281, 34.10171], [-118.01293, 34.10166], [-118.01317, 34.10165], [-118.01335, 34.10167], [-118.01359, 34.10176], [-118.01382, 34.10181], [-118.01404, 34.10192], [-118.01426, 34.10188], [-118.01451, 34.10145], [-118.0146, 34.10103], [-118.01469, 34.10074], [-118.01459, 34.10065], [-118.01441, 34.1004], [-118.0142, 34.10023], [-118.01418, 34.10009], [-118.01404, 34.09992], [-118.01387, 34.09979], [-118.01388, 34.09971], [-118.01385, 34.0997], [-118.01378, 34.09965], [-118.01376, 34.09954], [-118.01382, 34.09936], [-118.01377, 34.09909], [-118.0136, 34.09887], [-118.01357, 34.09879], [-118.01362, 34.0986], [-118.01381, 34.09841], [-118.01431, 34.09815], [-118.01466, 34.09789], [-118.01612, 34.09729], [-118.01658, 34.09718], [-118.01761, 34.0972], [-118.01891, 34.09694], [-118.01911, 34.09701], [-118.01959, 34.0969], [-118.0198, 34.09688], [-118.02015, 34.09689], [-118.02013, 34.09658], [-118.02021, 34.09675], [-118.02082, 34.09668], [-118.02534, 34.09589], [-118.02569, 34.09575]]]} | No Public Access 3 | 48171 | Los Angeles County Flood Control District Open Space | 32704 | 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 | 143.431 | Los Angeles County Flood Control District OS | 0 | Local Other or Unknown 14 | 4 | |
13175 | 13175 | 13174 | {"type": "Polygon", "coordinates": [[[-121.57686, 38.77162], [-121.57188, 38.7717], [-121.57185, 38.76445], [-121.5687, 38.76451], [-121.56867, 38.76072], [-121.57182, 38.76066], [-121.57184, 38.76246], [-121.57684, 38.76237], [-121.57686, 38.77162]]]} | No Public Access 3 | 35159 | Lucich Ranch | 21580 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 138.582 | Lucich Ranch | 0 | Local Other or Unknown 14 | 4 | |
12715 | 12715 | 12714 | {"type": "Polygon", "coordinates": [[[-121.58089, 38.76428], [-121.58083, 38.77153], [-121.58085, 38.77515], [-121.58084, 38.7788], [-121.57707, 38.77889], [-121.57707, 38.77795], [-121.57912, 38.77792], [-121.57912, 38.77662], [-121.57911, 38.77661], [-121.57706, 38.77662], [-121.57704, 38.76432], [-121.58089, 38.76428]]]} | No Public Access 3 | 29729 | Bennett South | 16015 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 125.162 | Bennett South | None 1111 | |||
8226 | 8226 | 8225 | {"type": "MultiPolygon", "coordinates": [[[[-118.39803, 34.33154], [-118.3977, 34.33187], [-118.39753, 34.33221], [-118.39757, 34.33239], [-118.39737, 34.33259], [-118.39713, 34.33296], [-118.39723, 34.33309], [-118.39705, 34.33349], [-118.39717, 34.33365], [-118.39712, 34.3337], [-118.39693, 34.33361], [-118.39669, 34.32974], [-118.39678, 34.32974], [-118.39673, 34.32982], [-118.39691, 34.33018], [-118.39675, 34.33035], [-118.39698, 34.33065], [-118.39722, 34.33079], [-118.39714, 34.33099], [-118.39747, 34.3312], [-118.39755, 34.3313], [-118.39803, 34.33154]]], [[[-118.40538, 34.33402], [-118.40103, 34.33386], [-118.40101, 34.33713], [-118.39708, 34.33708], [-118.39693, 34.33374], [-118.39715, 34.33384], [-118.39734, 34.33366], [-118.3972, 34.33348], [-118.39737, 34.33307], [-118.39728, 34.33295], [-118.39748, 34.33265], [-118.39771, 34.33242], [-118.39766, 34.33222], [-118.39781, 34.33192], [-118.39822, 34.33152], [-118.39805, 34.33141], [-118.39764, 34.33122], [-118.39757, 34.33112], [-118.39729, 34.33095], [-118.39738, 34.33074], [-118.39707, 34.33057], [-118.39691, 34.33035], [-118.39707, 34.3302], [-118.39687, 34.32982], [-118.39693, 34.32974], [-118.39846, 34.32976], [-118.39852, 34.32957], [-118.39898, 34.32907], [-118.39906, 34.32891], [-118.40003, 34.32864], [-118.40055, 34.32838], [-118.40086, 34.32802], [-118.40088, 34.32853], [-118.4008, 34.32863], [-118.40014, 34.32961], [-118.40005, 34.32969], [-118.39991, 34.32975], [-118.39991, 34.32977], [-118.40014, 34.32977], [-118.40022, 34.3297], [-118.40089, 34.32872], [-118.40095, 34.32978], [-118.40521, 34.32981], [-118.40538, 34.33402]]]]} | No Public Access 3 | 12544 | Pacoima Wash | 23311 | 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 | 125.037 | Pacoima Wash | None 686 | |||
13169 | 13169 | 13168 | {"type": "Polygon", "coordinates": [[[-121.52167, 38.73375], [-121.5121, 38.73375], [-121.51206, 38.72883], [-121.52163, 38.72882], [-121.52167, 38.73375]]]} | No Public Access 3 | 35140 | Natomas Basin Conservancy | 22668 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 112.326 | Natomas Basin Conservancy | None 1143 | |||
13176 | 13176 | 13175 | {"type": "Polygon", "coordinates": [[[-121.58368, 38.77894], [-121.58367, 38.78624], [-121.57862, 38.78635], [-121.57859, 38.78626], [-121.57859, 38.78505], [-121.57857, 38.78483], [-121.57847, 38.78457], [-121.57822, 38.78433], [-121.57798, 38.78417], [-121.57743, 38.78397], [-121.57704, 38.78389], [-121.57707, 38.7791], [-121.58368, 38.77894]]]} | No Public Access 3 | 35162 | Bolen North | 16237 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sutter 47 | 107.055 | Bolen North | None 1146 | |||
3674 | 3674 | 3673 | {"type": "Polygon", "coordinates": [[[-121.5396, 38.7289], [-121.53955, 38.73052], [-121.53953, 38.73375], [-121.53067, 38.73375], [-121.53068, 38.72896], [-121.5396, 38.7289]]]} | No Public Access 3 | 29739 | Bianchi West | 16062 | 2092 | Natomas Basin Conservancy 634 | Special District 4 | Flood District 8 | http://www.natomasbasin.org/ | Special District 4 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | Sacramento 41 | 102.179 | Bianchi West | 0 | None 307 |
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]);