units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
198 rows where MNG_AG_TYP = 17 sorted by COUNTY descending
This data as json, copyable, CSV (advanced)
MNG_AGENCY >30
- Consumnes Community Services District 87
- El Dorado Hills Community Service District 25
- Jurupa Community Services District 10
- Cameron Park Community Services District 8
- Mountain House Community Services District 7
- Tamalpais Community Services District 4
- Brooktrails Community Services District 3
- Marinwood Community Service District 3
- Rossmore Community Services District 2
- Twain Harte Community Services District 2
- Groveland Community Services District 2
- Truckee Tahoe Airport District 2
- Helendale Community Services District 2
- Pajaro Community Services District 2
- Salton Community Services District 2
- Templeton Community Services District 2
- Discovery Bay Community Service District 1
- Bear Valley Springs Community Services District 1
- Morongo Valley Community Services District 1
- Cambria Community Services District 1
- Rosamond Community Services District 1
- Los Alamos Community Services District 1
- Golden Hills Community Service District 1
- Happy Camp Community Services District 1
- McCloud Community Services District 1
- Lake Shastina 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
- Bel Marin Keys Community Services District 1
- …
DES_TP 12
- Local Park 157
- Local Recreation Area 10
- Local Other or Unknown 2
- Local Conservation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 175
- Restricted Access 3
MNG_AG_TYP 1
- Community Services District · 178 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4122 | 4122 | 4121 | {"type": "Polygon", "coordinates": [[[-121.45166, 38.42828], [-121.45123, 38.42827], [-121.45104, 38.42799], [-121.45153, 38.428], [-121.45166, 38.42828]]]} | Open Access 1 | 47130 | Harris Ranch Park | 30807 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.311 | Harris Ranch Park | 0 | Local Park 2 | 4 | |
11737 | 11737 | 11736 | {"type": "Polygon", "coordinates": [[[-121.3624, 38.41993], [-121.3624, 38.42089], [-121.36205, 38.4209], [-121.36201, 38.42086], [-121.36188, 38.42039], [-121.36186, 38.4202], [-121.36186, 38.41995], [-121.3624, 38.41993]]]} | Open Access 1 | 24063 | Van Doren Park | 26826 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.115 | Van Doren Park | 0 | Local Park 2 | 4 | |
11750 | 11750 | 11749 | {"type": "Polygon", "coordinates": [[[-121.3732, 38.44851], [-121.37316, 38.44858], [-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 | 24043 | Gage Park | 19170 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.148 | Gage Park | 0 | Local Park 2 | 4 | |
11751 | 11751 | 11750 | {"type": "Polygon", "coordinates": [[[-121.35789, 38.44863], [-121.35783, 38.44864], [-121.35668, 38.44864], [-121.35664, 38.4486], [-121.35664, 38.44812], [-121.35783, 38.44803], [-121.35789, 38.44863]]]} | Open Access 1 | 24044 | Perry Park | 23615 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.657 | Perry Park | 0 | Local Park 2 | 4 | |
11752 | 11752 | 11751 | {"type": "Polygon", "coordinates": [[[-121.37676, 38.44496], [-121.37635, 38.44544], [-121.37599, 38.44529], [-121.37572, 38.44522], [-121.37544, 38.44519], [-121.37541, 38.44517], [-121.37539, 38.44514], [-121.3754, 38.44476], [-121.376, 38.44477], [-121.37675, 38.4449], [-121.37676, 38.44496]]]} | Open Access 1 | 24045 | Hrepich Park | 20128 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.488 | Hrepich Park | 0 | Local Park 2 | 4 | |
11753 | 11753 | 11752 | {"type": "Polygon", "coordinates": [[[-121.37143, 38.44052], [-121.36803, 38.44054], [-121.36802, 38.43895], [-121.36868, 38.43893], [-121.36868, 38.4382], [-121.37135, 38.43818], [-121.3714, 38.43819], [-121.37143, 38.43822], [-121.37144, 38.43825], [-121.37142, 38.43839], [-121.37143, 38.44052]]]} | Open Access 1 | 24046 | Rau Park | 24197 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 17.845 | Rau Park | 0 | Local Park 2 | 4 | |
11754 | 11754 | 11753 | {"type": "Polygon", "coordinates": [[[-121.43863, 38.43772], [-121.43838, 38.43792], [-121.43823, 38.43809], [-121.43811, 38.43825], [-121.43804, 38.43825], [-121.43772, 38.43819], [-121.43758, 38.43818], [-121.43758, 38.43792], [-121.4376, 38.43791], [-121.4376, 38.43763], [-121.43807, 38.43763], [-121.43828, 38.43757], [-121.43842, 38.4375], [-121.43863, 38.43772]]]} | Open Access 1 | 24047 | Rose Park | 24615 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.188 | Rose Park | 0 | Local Park 2 | 4 | |
11755 | 11755 | 11754 | {"type": "Polygon", "coordinates": [[[-121.3936, 38.43618], [-121.39359, 38.43719], [-121.39325, 38.4371], [-121.39304, 38.4371], [-121.39283, 38.43713], [-121.39241, 38.43713], [-121.39262, 38.43683], [-121.39273, 38.43665], [-121.3928, 38.43643], [-121.39284, 38.43623], [-121.39287, 38.43619], [-121.3936, 38.43618]]]} | Open Access 1 | 24048 | Lombardi Park | 21412 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 2.047 | Lombardi Park | 0 | Local Park 2 | 4 | |
11756 | 11756 | 11755 | {"type": "Polygon", "coordinates": [[[-121.37829, 38.43358], [-121.37803, 38.43438], [-121.37725, 38.4342], [-121.37708, 38.43413], [-121.37698, 38.43406], [-121.3769, 38.43397], [-121.37684, 38.43389], [-121.37674, 38.43366], [-121.37659, 38.4335], [-121.37687, 38.43332], [-121.37689, 38.43317], [-121.37718, 38.43323], [-121.37788, 38.43349], [-121.37829, 38.43358]]]} | Open Access 1 | 24049 | Mix Park | 22333 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 2.924 | Mix Park | 0 | Local Park 2 | 4 | |
11757 | 11757 | 11756 | {"type": "Polygon", "coordinates": [[[-121.42936, 38.43427], [-121.42939, 38.43439], [-121.4294, 38.4345], [-121.42939, 38.43453], [-121.42935, 38.43456], [-121.42833, 38.43455], [-121.42829, 38.43454], [-121.42826, 38.43451], [-121.42826, 38.43426], [-121.42828, 38.43405], [-121.42867, 38.43409], [-121.42881, 38.43413], [-121.42894, 38.43423], [-121.42903, 38.43435], [-121.42936, 38.43427]]]} | Open Access 1 | 24050 | Davis Park | 17953 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.996 | Davis Park | 0 | Local Park 2 | 4 | |
11758 | 11758 | 11757 | {"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 | 24051 | Herburger Park | 19831 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 1.877 | Herburger Park | 0 | Local Park 2 | 4 | |
11759 | 11759 | 11758 | {"type": "Polygon", "coordinates": [[[-121.43856, 38.4322], [-121.43773, 38.43316], [-121.43751, 38.43309], [-121.4383, 38.43218], [-121.43841, 38.43218], [-121.43856, 38.4322]]]} | Open Access 1 | 24052 | Betschart Park | 16049 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 0.634 | Betschart Park | 0 | Local Park 2 | 4 | |
11760 | 11760 | 11759 | {"type": "Polygon", "coordinates": [[[-121.40841, 38.42928], [-121.40823, 38.42936], [-121.40818, 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.40672, 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 | 24053 | Guttridge Park | 19575 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 4.174 | Guttridge Park | 0 | Local Park 2 | 4 | |
11761 | 11761 | 11760 | {"type": "Polygon", "coordinates": [[[-121.45444, 38.42969], [-121.45442, 38.43075], [-121.45442, 38.43083], [-121.45439, 38.43086], [-121.45317, 38.43087], [-121.45288, 38.43085], [-121.45288, 38.42967], [-121.45444, 38.42969]]]} | Open Access 1 | 24054 | Fite Park | 18926 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 4.401 | Fite Park | 0 | Local Park 2 | 4 | |
11762 | 11762 | 11761 | {"type": "Polygon", "coordinates": [[[-121.47927, 38.41762], [-121.47932, 38.41763], [-121.47945, 38.41771], [-121.4797, 38.41789], [-121.47992, 38.41809], [-121.47993, 38.41812], [-121.47992, 38.41815], [-121.4796, 38.41836], [-121.4777, 38.41986], [-121.47762, 38.41985], [-121.47711, 38.41945], [-121.4771, 38.41941], [-121.47712, 38.41938], [-121.4789, 38.41797], [-121.47907, 38.41781], [-121.47922, 38.41764], [-121.47927, 38.41762]]]} | Open Access 1 | 24066 | King Park | 20657 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 5.184 | King Park | 0 | Local Park 2 | 4 | |
11763 | 11763 | 11762 | {"type": "Polygon", "coordinates": [[[-121.44323, 38.42694], [-121.4431, 38.4271], [-121.4431, 38.42723], [-121.44297, 38.42724], [-121.44289, 38.42729], [-121.44285, 38.42739], [-121.44255, 38.42773], [-121.44244, 38.4278], [-121.44241, 38.42789], [-121.44201, 38.42836], [-121.44191, 38.4284], [-121.44188, 38.42844], [-121.44188, 38.42849], [-121.44144, 38.42899], [-121.44137, 38.429], [-121.44132, 38.42904], [-121.4413, 38.42909], [-121.4413, 38.42914], [-121.44064, 38.42988], [-121.44064, 38.43019], [-121.44049, 38.43016], [-121.44029, 38.43008], [-121.44017, 38.43007], [-121.44021, 38.42985], [-121.44019, 38.42961], [-121.4401, 38.42937], [-121.44001, 38.42922], [-121.44017, 38.4291], [-121.44111, 38.42818], [-121.44118, 38.4281], [-121.44123, 38.42797], [-121.44124, 38.42781], [-121.44122, 38.42771], [-121.44118, 38.42762], [-121.44103, 38.42746], [-121.44092, 38.42739], [-121.4408, 38.42734], [-121.44101, 38.42695], [-121.44323, 38.42694]]]} | Open Access 1 | 24055 | Wackman Park | 27204 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 9.073 | Wackman Park | 0 | Local Park 2 | 4 | |
11764 | 11764 | 11763 | {"type": "Polygon", "coordinates": [[[-121.42263, 38.43032], [-121.42199, 38.43036], [-121.4183, 38.43038], [-121.41825, 38.43037], [-121.41823, 38.43034], [-121.41821, 38.43031], [-121.41821, 38.43007], [-121.41818, 38.42964], [-121.41818, 38.42808], [-121.41822, 38.42804], [-121.41827, 38.42803], [-121.42137, 38.428], [-121.42168, 38.42804], [-121.4226, 38.4283], [-121.42263, 38.43032]]]} | Open Access 1 | 24056 | Laguna Community Park | 20849 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 24.556 | Laguna Community Park | 0 | Local Park 2 | 4 | |
11765 | 11765 | 11764 | {"type": "Polygon", "coordinates": [[[-121.43624, 38.42824], [-121.43613, 38.42847], [-121.43607, 38.42869], [-121.43432, 38.42814], [-121.43436, 38.42786], [-121.43441, 38.42782], [-121.43443, 38.42777], [-121.43441, 38.42771], [-121.43437, 38.42767], [-121.43431, 38.42739], [-121.4343, 38.42709], [-121.43435, 38.42705], [-121.43437, 38.427], [-121.43435, 38.42695], [-121.43431, 38.42691], [-121.43437, 38.42684], [-121.43486, 38.42685], [-121.43489, 38.42692], [-121.43498, 38.42697], [-121.43509, 38.42698], [-121.43543, 38.42709], [-121.4356, 38.42712], [-121.43582, 38.42713], [-121.43586, 38.42715], [-121.43588, 38.42718], [-121.43594, 38.42742], [-121.43602, 38.42757], [-121.43611, 38.4277], [-121.43638, 38.42801], [-121.43638, 38.42805], [-121.43624, 38.42824]]]} | Open Access 1 | 24057 | Case Park | 16942 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 6.076 | Case Park | 0 | Local Park 2 | 4 | |
11766 | 11766 | 11765 | {"type": "Polygon", "coordinates": [[[-121.40978, 38.42718], [-121.40877, 38.42737], [-121.40846, 38.42737], [-121.40744, 38.42639], [-121.40714, 38.42634], [-121.40819, 38.42567], [-121.40978, 38.42718]]]} | Open Access 1 | 24058 | Zimbelman Park | 27865 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 4.892 | Zimbelman Park | 0 | Local Park 2 | 4 | |
11767 | 11767 | 11766 | {"type": "Polygon", "coordinates": [[[-121.47885, 38.42529], [-121.47888, 38.42535], [-121.47879, 38.42573], [-121.47878, 38.42593], [-121.47875, 38.42596], [-121.47771, 38.42597], [-121.47764, 38.42594], [-121.47763, 38.42552], [-121.47762, 38.42534], [-121.47765, 38.42528], [-121.47798, 38.42524], [-121.47824, 38.42522], [-121.47848, 38.42524], [-121.47885, 38.42529]]]} | Open Access 1 | 24059 | Lawson Park | 21119 | 2194 | Consumnes Community Services District 567 | Special District 4 | Community Services District 19 | http://www.yourcsd.com/parks/parks_list.asp | Special District 4 | 2194 | Consumnes Community Services District 559 | Special District 4 | Community Services District 17 | Sacramento 41 | 2.044 | Lawson Park | 0 | Local Park 2 | 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]);