units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
94 rows where MNG_AGENCY = 559 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_LEV, AGNCY_WEB, LAYER
DES_TP 2
AGNCY_TYP 2 ✖
AGNCY_NAME 2 ✖
MNG_AG_TYP 1
MNG_AGENCY 1
- Consumnes Community Services District · 94 ✖
ACCESS_TYP 1
- Open Access 94
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 | |
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 | |
12548 | 12548 | 12547 | {"type": "Polygon", "coordinates": [[[-121.3714, 38.4211], [-121.3709, 38.4211], [-121.37034, 38.42063], [-121.3714, 38.42063], [-121.3714, 38.4211]]]} | Open Access 1 | 29052 | Del Meyer Park | 18039 | 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.886 | Del Meyer Park | 0 | Local Park 2 | 4 | |
14474 | 14474 | 14473 | {"type": "Polygon", "coordinates": [[[-121.40937, 38.39491], [-121.40933, 38.39492], [-121.40931, 38.39494], [-121.40931, 38.39518], [-121.40915, 38.39516], [-121.40907, 38.39518], [-121.40901, 38.39524], [-121.409, 38.39531], [-121.40903, 38.39538], [-121.40903, 38.39545], [-121.40856, 38.39544], [-121.40857, 38.39481], [-121.40908, 38.39481], [-121.40937, 38.39491]]]} | Open Access 1 | 47132 | Bridgeview Park | 30809 | 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 | http://www.yourcsd.com/595/Bridgeview-Park | Sacramento 41 | 0.925 | Bridgeview Park | 0 | Local Park 2 | 4 |
11785 | 11785 | 11784 | {"type": "Polygon", "coordinates": [[[-121.36093, 38.40781], [-121.36092, 38.40783], [-121.36087, 38.40785], [-121.36024, 38.40785], [-121.36023, 38.4072], [-121.36073, 38.4072], [-121.36073, 38.40729], [-121.36076, 38.40741], [-121.3609, 38.40767], [-121.36093, 38.40781]]]} | Open Access 1 | 24080 | Russell Park | 24740 | 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.931 | Russell 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 | |
14481 | 14481 | 14480 | {"type": "Polygon", "coordinates": [[[-121.4142, 38.3979], [-121.41422, 38.39797], [-121.41419, 38.39807], [-121.41414, 38.39816], [-121.41406, 38.39824], [-121.41396, 38.39831], [-121.41384, 38.39835], [-121.41365, 38.39839], [-121.41344, 38.39836], [-121.41326, 38.39828], [-121.41313, 38.39816], [-121.41307, 38.39807], [-121.41304, 38.39796], [-121.41306, 38.3979], [-121.41333, 38.39793], [-121.41363, 38.39795], [-121.41394, 38.39793], [-121.4142, 38.3979]]]} | Open Access 1 | 47136 | Rose Garden Park | 30813 | 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 | http://www.yourcsd.com/624/Rose-Garden-Park | Sacramento 41 | 0.996 | Rose Garden 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 | |
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 | |
12552 | 12552 | 12551 | {"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 | 29055 | Fales Park | 18830 | 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.212 | Fales Park | 0 | Local Park 2 | 4 | |
12504 | 12504 | 12503 | {"type": "Polygon", "coordinates": [[[-121.42725, 38.38731], [-121.42685, 38.38738], [-121.42634, 38.38715], [-121.42628, 38.3868], [-121.42631, 38.38663], [-121.42635, 38.3866], [-121.42638, 38.3866], [-121.42673, 38.38667], [-121.42716, 38.38672], [-121.42718, 38.38676], [-121.42719, 38.38706], [-121.42725, 38.38725], [-121.42725, 38.38731]]]} | Open Access 1 | 28335 | Schauer Park | 25180 | 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.345 | Schauer Park | 0 | Local Park 2 | 4 | |
11776 | 11776 | 11775 | {"type": "Polygon", "coordinates": [[[-121.36833, 38.41587], [-121.36808, 38.41626], [-121.36736, 38.41626], [-121.36722, 38.41588], [-121.36764, 38.41547], [-121.3682, 38.41581], [-121.36833, 38.41587]]]} | Open Access 1 | 24071 | Mendoza Park | 22154 | 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.364 | Mendoza 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 | |
12560 | 12560 | 12559 | {"type": "Polygon", "coordinates": [[[-121.46779, 38.42567], [-121.4669, 38.42567], [-121.4669, 38.42497], [-121.46779, 38.42497], [-121.46779, 38.42567]]]} | Open Access 1 | 29063 | Lippincott Park | 21330 | 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.495 | Lippincott Park | 0 | Local Park 2 | 4 | |
12555 | 12555 | 12554 | {"type": "Polygon", "coordinates": [[[-121.38958, 38.44284], [-121.38952, 38.44286], [-121.38879, 38.44286], [-121.38879, 38.44208], [-121.38952, 38.44207], [-121.38957, 38.44209], [-121.38959, 38.44213], [-121.38959, 38.4428], [-121.38958, 38.44284]]]} | Open Access 1 | 29058 | Karamanos Park | 20552 | 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.499 | Karamanos Park | 0 | Local Park 2 | 4 | |
12545 | 12545 | 12544 | {"type": "Polygon", "coordinates": [[[-121.45641, 38.41232], [-121.45637, 38.41233], [-121.45607, 38.41261], [-121.45601, 38.41264], [-121.45598, 38.41269], [-121.45598, 38.41275], [-121.45568, 38.41281], [-121.45527, 38.41284], [-121.4552, 38.41222], [-121.45618, 38.41213], [-121.45635, 38.41206], [-121.45638, 38.41206], [-121.45641, 38.41232]]]} | Open Access 1 | 29049 | Caterino Park | 16972 | 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.507 | Caterino Park | 0 | Local Park 2 | 4 | |
12544 | 12544 | 12543 | {"type": "Polygon", "coordinates": [[[-121.44595, 38.39725], [-121.44596, 38.39751], [-121.44588, 38.39779], [-121.44581, 38.39779], [-121.44572, 38.39782], [-121.44567, 38.39788], [-121.44566, 38.39795], [-121.44533, 38.39799], [-121.445, 38.39799], [-121.44499, 38.39769], [-121.44494, 38.39755], [-121.44486, 38.39741], [-121.44485, 38.39738], [-121.44487, 38.39736], [-121.44495, 38.39732], [-121.44509, 38.39729], [-121.44595, 38.39725]]]} | Open Access 1 | 29048 | Bradford Park | 16325 | 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.547 | Bradford Park | 0 | Local Park 2 | 4 | |
11781 | 11781 | 11780 | {"type": "Polygon", "coordinates": [[[-121.40107, 38.41322], [-121.401, 38.41339], [-121.40095, 38.41356], [-121.39933, 38.41331], [-121.39933, 38.41265], [-121.39966, 38.41265], [-121.39971, 38.41282], [-121.39981, 38.41296], [-121.39995, 38.41307], [-121.40013, 38.41315], [-121.40034, 38.4132], [-121.40068, 38.4132], [-121.40084, 38.41325], [-121.40091, 38.41324], [-121.40099, 38.41319], [-121.40107, 38.41322]]]} | Open Access 1 | 24076 | Oneto Park | 23144 | 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.613 | Oneto 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 |
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]);