superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
193 rows where MNG_AG_TYP = 17
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Consumnes Community Services District 75
- El Dorado Hills Community Service District 19
- Cameron Park Community Services District 5
- Jurupa Community Services District 5
- McKinleyville Community Services District 4
- Brooktrails Community Services District 3
- Mountain House Community Services District 3
- Tamalpais Community Services District 3
- Rossmore Community Services District 2
- Groveland Community Services District 2
- Indian Valley Community Services District 2
- Templeton Community Services District 2
- Discovery Bay Community Service District 1
- Scotia Community Services District 1
- Twain Harte Community Services District 1
- Manila Community Services District 1
- Truckee Tahoe Airport District 1
- Cambria Community Services District 1
- Aromona Community Services District 1
- Rosamond Community Services District 1
- Los Alamos Community Services District 1
- Marinwood Community Service District 1
- Golden Hills Community Service District 1
- Pajaro Community Services District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Salton Community Services District 1
- Concord Landscaping and Lighting Maintenance District No. 3 1
- Tomales Village Community Services District 1
- Bolinas Community Public Utility District 1
- …
ACCESS_TYP 2
- Open Access 143
- Restricted Access 3
MNG_AG_TYP 1
- Community Services District · 146 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3939 | 3939 | 3938 | {"type": "Polygon", "coordinates": [[[-121.38042, 38.39718], [-121.37979, 38.39739], [-121.3716, 38.39746], [-121.37156, 38.38687], [-121.37157, 38.38683], [-121.37159, 38.3868], [-121.37166, 38.38678], [-121.37171, 38.3868], [-121.37191, 38.387], [-121.3731, 38.38823], [-121.37592, 38.39121], [-121.37624, 38.39157], [-121.37632, 38.39172], [-121.37658, 38.39199], [-121.37933, 38.39571], [-121.37925, 38.39598], [-121.37939, 38.39617], [-121.37984, 38.3964], [-121.38042, 38.39718]]]} | Open Access 1 | Elk Grove Park | 18562 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 123.144 | Elk Grove Park | ||
4109 | 4109 | 4108 | {"type": "Polygon", "coordinates": [[[-120.69928, 35.55395], [-120.69932, 35.55471], [-120.69929, 35.55506], [-120.69913, 35.5555], [-120.69877, 35.55592], [-120.69793, 35.5567], [-120.69731, 35.5564], [-120.69876, 35.55393], [-120.69928, 35.55395]]]} | Open Access 1 | Evers Park | 18770 | 2289 | Templeton Community Services District 1000 | Special District 4 | Community Services District 17 | http://templetoncsd.org | Special District 4 | 6.748 | Evers Park | ||
4129 | 4129 | 4128 | {"type": "Polygon", "coordinates": [[[-121.07765, 38.70194], [-121.07763, 38.70294], [-121.07756, 38.70315], [-121.07742, 38.70337], [-121.07664, 38.70416], [-121.07656, 38.70403], [-121.07645, 38.70406], [-121.0764, 38.70397], [-121.07654, 38.70354], [-121.07666, 38.70356], [-121.07671, 38.7034], [-121.07675, 38.70231], [-121.07662, 38.70208], [-121.07721, 38.70193], [-121.07765, 38.70194]]]} | Open Access 1 | Fairchild Park | 18792 | 2197 | El Dorado Hills Community Service District 560 | Special District 4 | Community Services District 17 | http://www.edhcsd.org/ | Special District 4 | 3.894 | Fairchild Park | ||
4168 | 4168 | 4167 | {"type": "Polygon", "coordinates": [[[-121.40167, 38.45148], [-121.40135, 38.45173], [-121.40124, 38.45177], [-121.40111, 38.45176], [-121.40101, 38.45171], [-121.40065, 38.45143], [-121.4006, 38.45134], [-121.4006, 38.45127], [-121.40065, 38.45118], [-121.40095, 38.45093], [-121.4011, 38.45103], [-121.40167, 38.45148]]]} | Open Access 1 | Fales Park | 18830 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.212 | Fales Park | ||
4190 | 4190 | 4189 | {"type": "Polygon", "coordinates": [[[-120.28014, 34.74428], [-120.28011, 34.74478], [-120.27969, 34.74476], [-120.27972, 34.74426], [-120.28014, 34.74428]]]} | Open Access 1 | Ferini Park | 18873 | 2065 | Los Alamos Community Services District 887 | Special District 4 | Community Services District 17 | http://www.losalamoscsd.com/ | Special District 4 | 0.526 | Ferini Park | ||
4198 | 4198 | 4197 | {"type": "Polygon", "coordinates": [[[-121.38669, 38.41831], [-121.38668, 38.41952], [-121.38566, 38.41969], [-121.38543, 38.4197], [-121.38524, 38.41969], [-121.3854, 38.41902], [-121.3854, 38.41831], [-121.38669, 38.41831]]]} | Open Access 1 | Feickert Park | 18864 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.177 | Feickert Park | ||
4257 | 4257 | 4256 | {"type": "Polygon", "coordinates": [[[-121.33921, 38.42094], [-121.33921, 38.42132], [-121.33772, 38.42183], [-121.33772, 38.4211], [-121.33809, 38.4211], [-121.3382, 38.42113], [-121.33828, 38.42112], [-121.33835, 38.42109], [-121.33839, 38.42105], [-121.33841, 38.42099], [-121.3384, 38.42094], [-121.33921, 38.42094]]]} | Open Access 1 | Fleming Park | 18945 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.992 | Fleming Park | ||
4293 | 4293 | 4292 | {"type": "Polygon", "coordinates": [[[-121.41121, 38.41686], [-121.41113, 38.41689], [-121.41094, 38.41704], [-121.41074, 38.41722], [-121.40884, 38.41677], [-121.40884, 38.41614], [-121.40911, 38.41612], [-121.4092, 38.41608], [-121.40925, 38.41612], [-121.40933, 38.41614], [-121.4094, 38.41614], [-121.40949, 38.41611], [-121.40979, 38.41609], [-121.41012, 38.41609], [-121.41024, 38.41612], [-121.4103, 38.41611], [-121.41038, 38.41606], [-121.41041, 38.41602], [-121.41084, 38.41602], [-121.41121, 38.41686]]]} | Open Access 1 | Foulks Park | 19017 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.879 | Foulks Park | ||
4463 | 4463 | 4462 | {"type": "Polygon", "coordinates": [[[-121.3732, 38.44851], [-121.37316, 38.44859], [-121.37318, 38.44904], [-121.37268, 38.44903], [-121.37246, 38.44899], [-121.37241, 38.44896], [-121.37244, 38.44875], [-121.37243, 38.44837], [-121.37309, 38.44836], [-121.37309, 38.44841], [-121.37312, 38.44846], [-121.3732, 38.44851]]]} | Open Access 1 | Gage Park | 19170 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.148 | Gage Park | ||
4465 | 4465 | 4464 | {"type": "Polygon", "coordinates": [[[-123.37488, 41.79526], [-123.37479, 41.79527], [-123.37464, 41.79551], [-123.37252, 41.79546], [-123.37205, 41.79325], [-123.3725, 41.79301], [-123.37448, 41.79406], [-123.37488, 41.79526]]]} | Open Access 1 | Gale Zinc Memorial Park | 19173 | 2226 | Happy Camp Community Services District 958 | Special District 4 | Community Services District 17 | Special District 4 | 10.657 | Gale Zinc Memorial Park | |||
4517 | 4517 | 4516 | {"type": "Polygon", "coordinates": [[[-121.34956, 38.40229], [-121.34941, 38.40396], [-121.34941, 38.40396], [-121.34939, 38.40367], [-121.34934, 38.40354], [-121.34925, 38.4034], [-121.34915, 38.40328], [-121.34904, 38.40318], [-121.34866, 38.40295], [-121.34848, 38.40278], [-121.3484, 38.40268], [-121.34832, 38.40255], [-121.34825, 38.40231], [-121.34827, 38.40227], [-121.34832, 38.40226], [-121.34882, 38.40229], [-121.34956, 38.40229]]]} | Open Access 1 | Gates Park | 19233 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2.445 | Gates Park | ||
4525 | 4525 | 4524 | {"type": "Polygon", "coordinates": [[[-121.00447, 38.69485], [-121.00424, 38.69495], [-121.00409, 38.6946], [-121.00391, 38.69442], [-121.00361, 38.69429], [-121.00345, 38.69439], [-121.00337, 38.69431], [-121.00352, 38.69419], [-121.00328, 38.69372], [-121.00274, 38.6933], [-121.00269, 38.693], [-121.00275, 38.69254], [-121.00265, 38.6919], [-121.0022, 38.69097], [-121.00192, 38.6906], [-121.0019, 38.69022], [-121.00147, 38.69024], [-121.00115, 38.68933], [-121.00361, 38.68935], [-121.00284, 38.69011], [-121.00321, 38.69093], [-121.00333, 38.69132], [-121.00341, 38.69159], [-121.00351, 38.6923], [-121.00395, 38.69379], [-121.00443, 38.69404], [-121.00427, 38.6946], [-121.00447, 38.69485]]]} | Open Access 1 | Gateway Park | 19240 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 13.441 | Gateway Park | ||
4803 | 4803 | 4802 | {"type": "Polygon", "coordinates": [[[-124.10901, 40.47901], [-124.10855, 40.47903], [-124.10832, 40.47893], [-124.10793, 40.47776], [-124.10611, 40.47501], [-124.10671, 40.47476], [-124.10793, 40.47525], [-124.1085, 40.47611], [-124.10879, 40.47677], [-124.10904, 40.47753], [-124.10909, 40.47838], [-124.10901, 40.47901]]]} | Open Access 1 | Scotia Fireman's Park | http://scotiacsd.com/parks-recreation/ | 33638 | 2438 | Scotia Community Services District 362 | Special District 4 | Community Services District 17 | http://scotiacsd.com/ | Special District 4 | 12.732 | Scotia Fireman's Park | |
4808 | 4808 | 4807 | {"type": "Polygon", "coordinates": [[[-121.40841, 38.42928], [-121.40823, 38.42936], [-121.40817, 38.42942], [-121.40814, 38.42949], [-121.40814, 38.42959], [-121.40833, 38.42983], [-121.40831, 38.43019], [-121.408, 38.43026], [-121.40767, 38.4304], [-121.40752, 38.4305], [-121.40738, 38.43061], [-121.40717, 38.43085], [-121.40692, 38.43073], [-121.40671, 38.43065], [-121.40651, 38.43059], [-121.40622, 38.43053], [-121.40622, 38.43039], [-121.40629, 38.43032], [-121.40632, 38.43021], [-121.40647, 38.43004], [-121.40665, 38.42992], [-121.40813, 38.42927], [-121.40824, 38.42925], [-121.40832, 38.42921], [-121.40841, 38.42928]]]} | Open Access 1 | Guttridge Park | 19575 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.174 | Guttridge Park | ||
4828 | 4828 | 4827 | {"type": "Polygon", "coordinates": [[[-120.97689, 38.66644], [-120.97662, 38.66629], [-120.97415, 38.66658], [-120.9732, 38.66697], [-120.97297, 38.66712], [-120.97286, 38.6669], [-120.97405, 38.6665], [-120.97542, 38.66631], [-120.97556, 38.66598], [-120.97435, 38.66468], [-120.9748, 38.6645], [-120.97485, 38.66452], [-120.9763, 38.66567], [-120.97663, 38.66601], [-120.97682, 38.66628], [-120.97689, 38.66644]]]} | Open Access 1 | Hacienda Park | 19590 | 2212 | Cameron Park Community Services District 604 | Special District 4 | Community Services District 17 | http://www.cameronpark.org/parks_and_facilities.html | Special District 4 | 4.939 | Hacienda Park | ||
4890 | 4890 | 4889 | {"type": "Polygon", "coordinates": [[[-117.57139, 33.96796], [-117.57095, 33.96793], [-117.57034, 33.96782], [-117.56983, 33.96767], [-117.56909, 33.96739], [-117.56852, 33.96724], [-117.56786, 33.96714], [-117.56726, 33.96712], [-117.56721, 33.96707], [-117.5672, 33.9647], [-117.57139, 33.9647], [-117.57139, 33.96796]]]} | Open Access 1 | Harada Heritage Park | 19658 | 2331 | Jurupa Community Services District 667 | Special District 4 | Community Services District 17 | http://parks.jcsd.us/ | Special District 4 | 29.708 | Harada Heritage Park | ||
4971 | 4971 | 4970 | {"type": "Polygon", "coordinates": [[[-122.53081, 37.88398], [-122.53063, 37.8842], [-122.53031, 37.88412], [-122.53022, 37.88447], [-122.53029, 37.88472], [-122.53028, 37.88478], [-122.53016, 37.88481], [-122.53018, 37.88471], [-122.53011, 37.88451], [-122.53018, 37.88407], [-122.52967, 37.88368], [-122.52953, 37.88365], [-122.52934, 37.88336], [-122.52941, 37.8832], [-122.52947, 37.88318], [-122.52956, 37.8833], [-122.52963, 37.88332], [-122.5297, 37.88329], [-122.52971, 37.88325], [-122.5297, 37.88322], [-122.52998, 37.88307], [-122.53035, 37.88305], [-122.53078, 37.88313], [-122.53081, 37.88398]]]} | Open Access 1 | Hawk Hill | 19744 | 2261 | Tamalpais Community Services District 708 | Special District 4 | Community Services District 17 | http://www.tcsd.us/ | Special District 4 | 2.923 | Hawk Hill | ||
4974 | 4974 | 4973 | {"type": "Polygon", "coordinates": [[[-121.48326, 38.42133], [-121.48259, 38.42144], [-121.48254, 38.42137], [-121.48225, 38.42115], [-121.48194, 38.42098], [-121.48157, 38.42093], [-121.48161, 38.42058], [-121.4816, 38.42011], [-121.48167, 38.42007], [-121.48196, 38.42004], [-121.48254, 38.41994], [-121.48293, 38.41993], [-121.48298, 38.41994], [-121.483, 38.41997], [-121.48303, 38.42014], [-121.48326, 38.42133]]]} | Open Access 1 | Hawkins Park | 19748 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 4.455 | Hawkins Park | ||
5027 | 5027 | 5026 | {"type": "Polygon", "coordinates": [[[-121.4788, 38.39746], [-121.47839, 38.39752], [-121.47822, 38.39759], [-121.47807, 38.39769], [-121.47801, 38.39769], [-121.4777, 38.39753], [-121.47736, 38.39742], [-121.47734, 38.3974], [-121.47733, 38.39728], [-121.47727, 38.39701], [-121.47866, 38.39681], [-121.4788, 38.39746]]]} | Open Access 1 | Henderson Park | 19814 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2.184 | Henderson Park | ||
5042 | 5042 | 5041 | {"type": "Polygon", "coordinates": [[[-121.42469, 38.4338], [-121.42405, 38.4338], [-121.42403, 38.43382], [-121.42397, 38.43381], [-121.42389, 38.43382], [-121.42386, 38.4338], [-121.42355, 38.4338], [-121.42354, 38.43312], [-121.42461, 38.43311], [-121.42466, 38.43313], [-121.42468, 38.43315], [-121.42469, 38.4338]]]} | Open Access 1 | Herburger Park | 19831 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 1.877 | Herburger Park |
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]);