units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1, COUNTY = 41 and MNG_AGENCY = 539
This data as json, copyable, CSV (advanced)
DES_TP 3
MNG_AG_TYP 1
MNG_AGENCY 1
- Rio Linda Elverta Recreation and Park District · 8 ✖
ACCESS_TYP 1
- Open Access · 8 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2716 | 2716 | 2715 | {"type": "Polygon", "coordinates": [[[-121.44961, 38.69103], [-121.44923, 38.69102], [-121.44804, 38.68895], [-121.44776, 38.68837], [-121.44754, 38.68777], [-121.44743, 38.68735], [-121.44735, 38.68692], [-121.44729, 38.68642], [-121.44762, 38.68618], [-121.44767, 38.68671], [-121.44775, 38.68718], [-121.44789, 38.68772], [-121.4481, 38.68831], [-121.44826, 38.68865], [-121.44846, 38.68902], [-121.44961, 38.69103]]]} | Open Access 1 | 48535 | Depot Park | 33254 | 2190 | Rio Linda Elverta Recreation and Park District 546 | Special District 4 | Recreation/Parks District 4 | http://rleparks.com/ | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.172 | Depot Park | 0 | Local Park 2 | 4 | |
4373 | 4373 | 4372 | {"type": "MultiPolygon", "coordinates": [[[[-121.44629, 38.6806], [-121.44617, 38.6807], [-121.44599, 38.68135], [-121.44575, 38.68135], [-121.44595, 38.6815], [-121.44547, 38.68192], [-121.44547, 38.68118], [-121.44542, 38.68114], [-121.44541, 38.68016], [-121.44629, 38.68017], [-121.44629, 38.6806]]], [[[-121.44728, 38.67919], [-121.44661, 38.68009], [-121.44632, 38.68005], [-121.44609, 38.68005], [-121.44599, 38.68001], [-121.44594, 38.68008], [-121.44592, 38.68009], [-121.44591, 38.67941], [-121.44596, 38.67861], [-121.44727, 38.67861], [-121.44728, 38.67919]]]]} | Open Access 1 | 48537 | Roy E. Hayer Park | 33256 | 2190 | Rio Linda Elverta Recreation and Park District 546 | Special District 4 | Recreation/Parks District 4 | http://rleparks.com/ | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.475 | Roy E. Hayer Park | 0 | Local Park 2 | 4 | |
4374 | 4374 | 4373 | {"type": "Polygon", "coordinates": [[[-121.44728, 38.68325], [-121.44665, 38.68325], [-121.44664, 38.68384], [-121.44643, 38.68383], [-121.44643, 38.68325], [-121.444, 38.68323], [-121.44594, 38.6815], [-121.44594, 38.68149], [-121.44573, 38.68135], [-121.44599, 38.68134], [-121.44618, 38.68069], [-121.44629, 38.68061], [-121.44728, 38.68062], [-121.44728, 38.68325]]]} | Open Access 1 | 48538 | Central Park & Horse Arena | 33257 | 2187 | Solano Tri-City and County Cooperative Planning Group 74 | Special District 4 | Open Space District 6 | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 12.526 | Central Park & Horse Arena | None 388 | ||||
10269 | 10269 | 10268 | {"type": "Polygon", "coordinates": [[[-121.43376, 38.67376], [-121.43376, 38.67633], [-121.43232, 38.67631], [-121.43255, 38.6761], [-121.43296, 38.67604], [-121.43322, 38.67553], [-121.43286, 38.67517], [-121.43285, 38.67509], [-121.43298, 38.67493], [-121.43309, 38.675], [-121.43335, 38.67495], [-121.43336, 38.67475], [-121.43315, 38.67449], [-121.43263, 38.67406], [-121.43267, 38.67398], [-121.43273, 38.67393], [-121.4332, 38.67387], [-121.4335, 38.67379], [-121.43376, 38.67376]]]} | Open Access 1 | 48539 | Linda Creek Park | 33258 | 2190 | Rio Linda Elverta Recreation and Park District 546 | Special District 4 | Recreation/Parks District 4 | http://rleparks.com/ | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | https://www.rleparks.com/newpage3 | Sacramento 41 | 4.646 | Linda Creek Park | 0 | Local Park 2 | 4 |
10387 | 10387 | 10386 | {"type": "Polygon", "coordinates": [[[-121.39832, 38.72337], [-121.39831, 38.72412], [-121.39705, 38.72468], [-121.39676, 38.72468], [-121.39716, 38.72434], [-121.39743, 38.72397], [-121.39747, 38.72375], [-121.39747, 38.72349], [-121.39754, 38.72349], [-121.39755, 38.72336], [-121.39832, 38.72337]]]} | Open Access 1 | 48534 | Northbrook Park | 33253 | 2190 | Rio Linda Elverta Recreation and Park District 546 | Special District 4 | Recreation/Parks District 4 | http://rleparks.com/ | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.373 | Northbrook Park | 0 | Local Park 2 | 4 | |
10392 | 10392 | 10391 | {"type": "Polygon", "coordinates": [[[-121.44843, 38.68963], [-121.44756, 38.68962], [-121.44718, 38.68898], [-121.44634, 38.68824], [-121.44687, 38.68673], [-121.44729, 38.68642], [-121.44731, 38.68671], [-121.44738, 38.68714], [-121.44748, 38.68756], [-121.44761, 38.68797], [-121.44776, 38.68837], [-121.44794, 38.68876], [-121.44843, 38.68963]]]} | Open Access 1 | 48536 | Community Center & Park | 33255 | 2190 | Rio Linda Elverta Recreation and Park District 546 | Special District 4 | Recreation/Parks District 4 | http://rleparks.com/ | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.641 | Community Ctr. & Park | 0 | Local Recreation Area 3 | 4 | |
11612 | 11612 | 11611 | {"type": "Polygon", "coordinates": [[[-121.44526, 38.70242], [-121.44525, 38.7037], [-121.44303, 38.70368], [-121.44304, 38.7024], [-121.44526, 38.70242]]]} | Open Access 1 | 23892 | Babe Best Park | 15746 | 2190 | Rio Linda Elverta Recreation and Park District 546 | Special District 4 | Recreation/Parks District 4 | http://rleparks.com/ | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.785 | Babe Best Park | 0 | Local Park 2 | 4 | |
14194 | 14194 | 14193 | {"type": "Polygon", "coordinates": [[[-121.46844, 38.68767], [-121.46844, 38.68948], [-121.46728, 38.68947], [-121.46728, 38.68857], [-121.46621, 38.68855], [-121.46622, 38.68765], [-121.46844, 38.68767]]]} | Open Access 1 | 44029 | Westside Park | 27428 | 2190 | Rio Linda Elverta Recreation and Park District 546 | Special District 4 | Recreation/Parks District 4 | http://rleparks.com/ | Special District 4 | 2190 | Rio Linda Elverta Recreation and Park District 539 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 7.316 | Westside 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]);