superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
12 rows where ACCESS_TYP = 1, MNG_AGENCY = 659 and MNG_AG_LEV = 4
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Carmichael Recreation and Park District · 12 ✖
ACCESS_TYP 1
- Open Access · 12 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2031 | 2031 | 2030 | {"type": "Polygon", "coordinates": [[[-121.3002, 38.65722], [-121.2998, 38.65714], [-121.29978, 38.65699], [-121.29972, 38.65688], [-121.2996, 38.65675], [-121.29948, 38.65669], [-121.29974, 38.65631], [-121.30018, 38.65631], [-121.3002, 38.65722]]]} | Open Access 1 | Bird Track Park | 16122 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 1.083 | Bird Track Park | ||
2623 | 2623 | 2622 | {"type": "Polygon", "coordinates": [[[-121.34082, 38.6109], [-121.34081, 38.61183], [-121.34, 38.61183], [-121.33997, 38.61183], [-121.33994, 38.61188], [-121.33996, 38.61197], [-121.33997, 38.61206], [-121.33999, 38.61208], [-121.33997, 38.61317], [-121.33935, 38.61316], [-121.33934, 38.61273], [-121.33909, 38.61272], [-121.33908, 38.61007], [-121.33922, 38.61007], [-121.33922, 38.61045], [-121.33965, 38.61046], [-121.33966, 38.61099], [-121.34022, 38.61095], [-121.34024, 38.61089], [-121.34082, 38.6109]]]} | Open Access 1 | Cardinal Oaks Park | 16847 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 7.092 | Cardinal Oaks Park | ||
2641 | 2641 | 2640 | {"type": "Polygon", "coordinates": [[[-121.33215, 38.62805], [-121.33208, 38.62807], [-121.33207, 38.6298], [-121.32886, 38.62976], [-121.32851, 38.62972], [-121.32845, 38.62969], [-121.32844, 38.62965], [-121.3285, 38.62802], [-121.32984, 38.62801], [-121.32988, 38.62449], [-121.33046, 38.62449], [-121.33046, 38.62624], [-121.33215, 38.62626], [-121.33215, 38.62805]]]} | Open Access 1 | Carmichael Park | 16880 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 27.343 | Carmichael Park | ||
3525 | 3525 | 3524 | {"type": "Polygon", "coordinates": [[[-121.3176, 38.6554], [-121.31538, 38.6554], [-121.31514, 38.65415], [-121.31512, 38.65414], [-121.31474, 38.65435], [-121.31456, 38.65358], [-121.31456, 38.65315], [-121.31542, 38.65314], [-121.31543, 38.65296], [-121.31536, 38.65295], [-121.31537, 38.65223], [-121.3162, 38.65222], [-121.3164, 38.65255], [-121.31665, 38.65287], [-121.31691, 38.65313], [-121.31757, 38.65368], [-121.3176, 38.6554]]]} | Open Access 1 | Del Campo Park | 18023 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 16.311 | Del Campo Park | ||
4576 | 4576 | 4575 | {"type": "Polygon", "coordinates": [[[-121.34327, 38.60448], [-121.34325, 38.60451], [-121.3432, 38.60453], [-121.34288, 38.60452], [-121.34282, 38.6045], [-121.3427, 38.6041], [-121.34268, 38.60395], [-121.34268, 38.60346], [-121.3427, 38.60341], [-121.34276, 38.60333], [-121.34276, 38.60327], [-121.34272, 38.60322], [-121.34266, 38.60319], [-121.34259, 38.6032], [-121.34252, 38.60323], [-121.34208, 38.60299], [-121.34208, 38.60274], [-121.34313, 38.60275], [-121.34323, 38.6032], [-121.34328, 38.60362], [-121.34327, 38.60448]]]} | Open Access 1 | Glancy Oaks Park | 19307 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 2.847 | Glancy Oaks Park | ||
5483 | 5483 | 5482 | {"type": "Polygon", "coordinates": [[[-121.32512, 38.64449], [-121.32504, 38.64446], [-121.32497, 38.6445], [-121.3249, 38.6445], [-121.32461, 38.64443], [-121.32443, 38.64435], [-121.32385, 38.64403], [-121.32369, 38.64391], [-121.32351, 38.64374], [-121.32331, 38.64347], [-121.3229, 38.64264], [-121.3228, 38.64248], [-121.32271, 38.64237], [-121.32256, 38.64223], [-121.32241, 38.64213], [-121.32223, 38.64204], [-121.32248, 38.64167], [-121.32483, 38.64163], [-121.32485, 38.64181], [-121.32489, 38.64196], [-121.32512, 38.64246], [-121.32522, 38.64271], [-121.3253, 38.64302], [-121.32533, 38.64323], [-121.32534, 38.64355], [-121.32531, 38.64387], [-121.32524, 38.64418], [-121.32512, 38.64449]]]} | Open Access 1 | Jan Park | 20358 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 13.503 | Jan Park | ||
5517 | 5517 | 5516 | {"type": "Polygon", "coordinates": [[[-121.30617, 38.63467], [-121.30615, 38.63569], [-121.30573, 38.6357], [-121.30571, 38.63635], [-121.30343, 38.63631], [-121.3036, 38.63462], [-121.30617, 38.63467]]]} | Open Access 1 | Jensen Botanical Gardens | 20395 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 10.002 | Jensen Botanical Gardens | ||
9402 | 9402 | 9401 | {"type": "Polygon", "coordinates": [[[-121.29784, 38.64354], [-121.29782, 38.64548], [-121.29476, 38.64548], [-121.29472, 38.64378], [-121.29511, 38.64377], [-121.29526, 38.64369], [-121.29575, 38.64368], [-121.29575, 38.64338], [-121.29616, 38.64337], [-121.29631, 38.64333], [-121.29688, 38.64333], [-121.29691, 38.64339], [-121.29731, 38.6433], [-121.29733, 38.64306], [-121.29776, 38.64306], [-121.29775, 38.64353], [-121.29784, 38.64354]]]} | Open Access 1 | Schweitzer Grove Nature Area | 25198 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 15.111 | Schweitzer Grove Nature Area | ||
13161 | 13161 | 13160 | {"type": "Polygon", "coordinates": [[[-121.30606, 38.66206], [-121.30435, 38.66208], [-121.30433, 38.66117], [-121.30604, 38.66117], [-121.30606, 38.66206]]]} | Open Access 1 | Patriots Park | https://www.carmichaelpark.com/patriots-park-and-wall-of-honor | 32008 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 3.678 | Patriots Park | |
13699 | 13699 | 13698 | {"type": "Polygon", "coordinates": [[[-121.30472, 38.63289], [-121.30468, 38.63464], [-121.30261, 38.6346], [-121.30211, 38.63414], [-121.30216, 38.63412], [-121.30219, 38.63284], [-121.30472, 38.63289]]]} | Open Access 1 | Sutter-Jensen Community Park | https://www.carmichaelpark.com/sutter-jensen-community-park | 33457 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 10.407 | Sutter-Jensen Community Park | |
13704 | 13704 | 13703 | {"type": "Polygon", "coordinates": [[[-121.34341, 38.63191], [-121.3434, 38.63221], [-121.34306, 38.63222], [-121.34306, 38.63252], [-121.34314, 38.63271], [-121.34314, 38.63312], [-121.34317, 38.63314], [-121.34314, 38.63542], [-121.33905, 38.63534], [-121.33907, 38.63187], [-121.34341, 38.63191]]]} | Open Access 1 | La Sierra Community Center | https://www.carmichaelpark.com/la-sierra-community-center | 33458 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 34.207 | La Sierra Community Ctr. | |
13709 | 13709 | 13708 | {"type": "Polygon", "coordinates": [[[-121.30933, 38.64699], [-121.30913, 38.64709], [-121.30827, 38.64762], [-121.30819, 38.64763], [-121.30716, 38.64636], [-121.30703, 38.64622], [-121.30687, 38.6461], [-121.30731, 38.64544], [-121.30925, 38.64544], [-121.30924, 38.64563], [-121.309, 38.64621], [-121.30911, 38.64661], [-121.30933, 38.64699]]]} | Open Access 1 | O'Donnell Heritage Park | http://carmichaelpark.com/odonnell-heritage-park/ | 31239 | 2306 | Carmichael Recreation and Park District 659 | Special District 4 | Recreation/Parks District 4 | http://www.carmichaelpark.com | Special District 4 | 8.413 | O'Donnell Heritage 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]);