units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 2, AGNCY_LEV = 4 and MNG_AG_TYP = 17
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, LABEL_NAME
MNG_AGENCY 3
DES_TP 3
MNG_AG_TYP 1
- Community Services District · 4 ✖
ACCESS_TYP 1
- Restricted Access · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3586 | 3586 | 3585 | {"type": "Polygon", "coordinates": [[[-120.11203, 39.33019], [-120.08116, 39.33018], [-120.08102, 39.32357], [-120.08615, 39.32375], [-120.08611, 39.31645], [-120.10961, 39.31639], [-120.10962, 39.32423], [-120.10845, 39.3243], [-120.10845, 39.32716], [-120.11194, 39.32719], [-120.11203, 39.33019]]]} | Restricted Access 2 | 37007 | Waddle Ranch | 27205 | 2329 | Truckee Tahoe Airport District 663 | Special District 4 | Community Services District 19 | http://www.truckeetahoeairport.com/ | Special District 4 | 2329 | Truckee Tahoe Airport District 651 | Special District 4 | Community Services District 17 | Nevada 30 | 851.88 | Waddle Ranch | 0 | Local Other or Unknown 14 | 4 | |
7381 | 7381 | 7380 | {"type": "Polygon", "coordinates": [[[-124.07921, 40.91543], [-124.07916, 40.91219], [-124.08423, 40.91223], [-124.08337, 40.91339], [-124.08297, 40.91427], [-124.08271, 40.9151], [-124.08267, 40.91537], [-124.08199, 40.91665], [-124.07922, 40.91579], [-124.07921, 40.91543]]]} | Restricted Access 2 | 47595 | Riverfront Park | 31322 | 2238 | McKinleyville Community Services District 624 | Special District 4 | Community Services District 19 | http://mckinleyvillecsd.com/ | Special District 4 | 2238 | McKinleyville Community Services District 613 | Special District 4 | Community Services District 17 | Humboldt 45 | 36.389 | Riverfront Park | 0 | Local Park 2 | 4 | |
14007 | 14007 | 14006 | {"type": "Polygon", "coordinates": [[[-120.11431, 39.3076], [-120.11095, 39.30757], [-120.11095, 39.30942], [-120.11204, 39.30942], [-120.11192, 39.31386], [-120.10961, 39.3139], [-120.10961, 39.31638], [-120.08611, 39.31645], [-120.0861, 39.31577], [-120.09573, 39.31569], [-120.09559, 39.30119], [-120.1082, 39.30121], [-120.10955, 39.3018], [-120.11073, 39.30196], [-120.1143, 39.30215], [-120.11431, 39.3076]]]} | Restricted Access 2 | 37008 | Waddle Ranch | 27205 | 2329 | Truckee Tahoe Airport District 663 | Special District 4 | Community Services District 19 | http://www.truckeetahoeairport.com/ | Special District 4 | 2329 | Truckee Tahoe Airport District 651 | Special District 4 | Community Services District 17 | Placer 35 | 609.442 | Waddle Ranch | 0 | Local Other or Unknown 14 | 4 | |
15682 | 15682 | 15681 | {"type": "Polygon", "coordinates": [[[-123.38922, 39.4385], [-123.38888, 39.43888], [-123.38872, 39.43884], [-123.38836, 39.43885], [-123.38793, 39.43897], [-123.38765, 39.43907], [-123.38741, 39.43928], [-123.3873, 39.43956], [-123.38734, 39.43987], [-123.38754, 39.44014], [-123.3877, 39.44026], [-123.38802, 39.44001], [-123.38807, 39.44006], [-123.38775, 39.44032], [-123.38797, 39.44061], [-123.38759, 39.44096], [-123.38761, 39.44128], [-123.388, 39.44131], [-123.38802, 39.44139], [-123.38764, 39.44141], [-123.38763, 39.44142], [-123.38805, 39.44196], [-123.38808, 39.44209], [-123.38806, 39.44218], [-123.38809, 39.44229], [-123.38805, 39.44246], [-123.38806, 39.44262], [-123.38813, 39.44281], [-123.38816, 39.443], [-123.38838, 39.4434], [-123.38842, 39.44351], [-123.38827, 39.44357], [-123.38818, 39.44362], [-123.38805, 39.44375], [-123.38801, 39.44384], [-123.38798, 39.44392], [-123.38797, 39.44401], [-123.38799, 39.44409], [-123.38807, 39.44428], [-123.38809, 39.44438], [-123.38809, 39.44442], [-123.38806, 39.44446], [-123.38801, 39.44448], [-123.38793, 39.44447], [-123.38781, 39.44443], [-123.3876, 39.4443], [-123.38732, 39.44418], [-123.387, 39.44412], [-123.38674, 39.44413], [-123.38657, 39.44407], [-123.38611, 39.44381], [-123.38579, 39.44378], [-123.3855, 39.44386], [-123.38525, 39.44339], [-123.38602, 39.44232], [-123.38594, 39.44214], [-123.38582, 39.44212], [-123.38557, 39.4422], [-123.38542, 39.44243], [-123.38505, 39.44211], [-123.38493, 39.44192], [-123.38475, 39.44172], [-123.38457, 39.4416], [-123.38464, 39.44139], [-123.38474, 39.44121], [-123.38494, 39.44057], [-123.38514, 39.44025], [-123.38521, 39.44002], [-123.38521, 39.4397], [-123.38511, 39.43937], [-123.38498, 39.43905], [-123.3848, 39.43878], [-123.38465, 39.43848], [-123.3844, 39.43812], [-123.38446, 39.43793], [-123.38447, 39.43772], [-123.3842, 39.43699], [-123.38417, 39.43681], [-123.38423, 39.43652], [-123.3843, 39.43642], [-123.38476, 39.43627], [-123.38491, 39.43655], [-123.38532, 39.43638], [-123.3854, 39.43642], [-123.38569, 39.43623], [-123.38586, 39.43656], [-123.3856, 39.43664], [-123.38568, 39.43687], [-123.38579, 39.43704], [-123.38617, 39.43738], [-123.38637, 39.4375], [-123.3867, 39.43775], [-123.38694, 39.43788], [-123.38732, 39.43814], [-123.3875, 39.43829], [-123.38771, 39.43839], [-123.38824, 39.43852], [-123.38922, 39.4385]]]} | Restricted Access 2 | 48511 | Brooktrails Disc Golf Course | 33223 | 2208 | Brooktrails Community Services District 424 | Special District 4 | Community Services District 19 | http://www.btcsd.org/ | Special District 4 | 2208 | Brooktrails Community Services District 418 | Special District 4 | Community Services District 17 | Mendocino 24 | 47.2 | Brooktrails Disc GC | 0 | Local Recreation Area 3 | 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]);