superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
20 rows where MNG_AGENCY = 623 and MNG_AG_TYP = 9
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4366 | 4366 | 4365 | {"type": "Polygon", "coordinates": [[[-121.55976, 38.81045], [-121.55308, 38.81447], [-121.5516, 38.81536], [-121.55163, 38.80843], [-121.55929, 38.80831], [-121.5588, 38.8086], [-121.55869, 38.80876], [-121.55872, 38.80892], [-121.55888, 38.80918], [-121.55948, 38.80966], [-121.55948, 38.80978], [-121.5595, 38.80998], [-121.55976, 38.81045]]]} | No Public Access 3 | Frazer | 19069 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 85.164 | Frazer | ||
5201 | 5201 | 5200 | {"type": "Polygon", "coordinates": [[[-121.58089, 38.76428], [-121.57704, 38.76432], [-121.57698, 38.75393], [-121.57986, 38.75654], [-121.57991, 38.75691], [-121.58081, 38.76113], [-121.58089, 38.76428]]]} | No Public Access 3 | Huffman East | 20138 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 74.081 | Huffman East | ||
5289 | 5289 | 5288 | {"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.57985, 38.75653], [-121.57698, 38.75393], [-121.57695, 38.74977], [-121.58419, 38.7496], [-121.58418, 38.75113], [-121.58333, 38.75115], [-121.58332, 38.75312], [-121.58573, 38.75314], [-121.58577, 38.74956], [-121.59366, 38.74939], [-121.59372, 38.74945]]]} | No Public Access 3 | Huffman West | 20139 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 232.744 | Huffman West | ||
6226 | 6226 | 6225 | {"type": "MultiPolygon", "coordinates": [[[[-121.52167, 38.73375], [-121.5121, 38.73375], [-121.51206, 38.72883], [-121.52163, 38.72882], [-121.52167, 38.73375]]], [[[-121.55826, 38.7289], [-121.54862, 38.72895], [-121.5486, 38.7219], [-121.55823, 38.72189], [-121.55826, 38.7289]]]]} | No Public Access 3 | Natomas Basin Conservancy | 22668 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 273.901 | Natomas Basin Conservancy | ||
6455 | 6455 | 6454 | {"type": "Polygon", "coordinates": [[[-121.5792, 38.79911], [-121.57248, 38.80318], [-121.56408, 38.80822], [-121.56354, 38.80823], [-121.55976, 38.81045], [-121.5595, 38.80998], [-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.56557, 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 | Lucich North | 21579 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 259.302 | Lucich North | ||
6456 | 6456 | 6455 | {"type": "Polygon", "coordinates": [[[-121.57686, 38.77162], [-121.56259, 38.77184], [-121.56254, 38.76466], [-121.56254, 38.76083], [-121.57182, 38.76066], [-121.57185, 38.76246], [-121.57684, 38.76237], [-121.57686, 38.77162]]]} | No Public Access 3 | Lucich Ranch | 21580 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 354.464 | Lucich Ranch | ||
7341 | 7341 | 7340 | {"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.56283, 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.57515, 38.78677], [-121.57513, 38.7889], [-121.57514, 38.78891], [-121.5769, 38.7889]]]]} | No Public Access 3 | Nestor | 22702 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 229.885 | Nestor | ||
9048 | 9048 | 9047 | {"type": "Polygon", "coordinates": [[[-121.58519, 38.73806], [-121.5843, 38.74056], [-121.58366, 38.74229], [-121.58355, 38.74272], [-121.58352, 38.74306], [-121.58331, 38.74329], [-121.5831, 38.74338], [-121.58271, 38.74346], [-121.57806, 38.7435], [-121.57789, 38.74347], [-121.57717, 38.7431], [-121.57692, 38.74306], [-121.5769, 38.73805], [-121.58519, 38.73806]]]} | No Public Access 3 | Ruby Ranch | 24724 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 93.989 | Ruby Ranch | ||
10543 | 10543 | 10542 | {"type": "Polygon", "coordinates": [[[-121.48575, 38.69996], [-121.48446, 38.69997], [-121.48434, 38.68531], [-121.48562, 38.68532], [-121.48575, 38.69996]]]} | No Public Access 3 | UEDA Parkway | 26644 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 45.049 | UEDA Parkway | ||
10796 | 10796 | 10795 | {"type": "Polygon", "coordinates": [[[-121.58503, 38.74523], [-121.58494, 38.74668], [-121.58484, 38.74681], [-121.58168, 38.74774], [-121.58154, 38.74784], [-121.58087, 38.74943], [-121.57695, 38.74952], [-121.57692, 38.74306], [-121.57717, 38.7431], [-121.57789, 38.74347], [-121.57807, 38.7435], [-121.5827, 38.74346], [-121.5831, 38.74338], [-121.5833, 38.74329], [-121.58335, 38.74324], [-121.58488, 38.74496], [-121.58503, 38.74523]]]} | No Public Access 3 | Vestal | 27009 | 2092 | Natomas Basin Conservancy 623 | Special District 4 | Flood District 9 | http://www.natomasbasin.org/ | Special District 4 | 93.79 | Vestal |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);