units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
17 rows where DES_TP = 14, GAP_STS = 4 and MNG_AGENCY = 569
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 17
MNG_AGENCY 1
- Rocklin, City of · 17 ✖
DES_TP 1
- Local Other or Unknown · 17 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13819 | 13819 | 13818 | {"type": "Polygon", "coordinates": [[[-121.24719, 38.81519], [-121.24708, 38.81533], [-121.24646, 38.8156], [-121.24592, 38.81606], [-121.24517, 38.81673], [-121.245, 38.81686], [-121.24396, 38.81756], [-121.2436, 38.81739], [-121.24366, 38.81718], [-121.24319, 38.81681], [-121.24303, 38.81679], [-121.24263, 38.81688], [-121.24243, 38.81721], [-121.24148, 38.81704], [-121.24115, 38.81686], [-121.24339, 38.81598], [-121.24411, 38.81634], [-121.24679, 38.81499], [-121.24719, 38.81519]]]} | Open Access 1 | 36402 | Rocklin holding 10 | 24517 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 10.403 | Rocklin holding 10 | 0 | Local Other or Unknown 14 | 4 | |
13825 | 13825 | 13824 | {"type": "Polygon", "coordinates": [[[-121.24919, 38.81208], [-121.2487, 38.81358], [-121.24804, 38.81312], [-121.24792, 38.81356], [-121.24762, 38.81346], [-121.24623, 38.81314], [-121.24608, 38.81307], [-121.24592, 38.81295], [-121.24581, 38.81281], [-121.24574, 38.81265], [-121.24628, 38.8128], [-121.2474, 38.81263], [-121.24827, 38.81222], [-121.24889, 38.81175], [-121.24919, 38.81208]]]} | Open Access 1 | 36413 | Rocklin holding 14 | 24521 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 6.343 | Rocklin holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13827 | 13827 | 13826 | {"type": "Polygon", "coordinates": [[[-121.24892, 38.8153], [-121.24897, 38.8155], [-121.24892, 38.81582], [-121.24833, 38.81574], [-121.24679, 38.81499], [-121.2441, 38.81634], [-121.24339, 38.81598], [-121.24492, 38.81284], [-121.2456, 38.81269], [-121.24565, 38.81283], [-121.24574, 38.81296], [-121.24586, 38.81308], [-121.24603, 38.81319], [-121.24624, 38.81327], [-121.24735, 38.81352], [-121.24739, 38.81355], [-121.24739, 38.81359], [-121.24733, 38.81369], [-121.24724, 38.81379], [-121.24696, 38.81361], [-121.24617, 38.8139], [-121.24582, 38.8135], [-121.2454, 38.81359], [-121.24521, 38.81368], [-121.24499, 38.81384], [-121.24486, 38.81433], [-121.24475, 38.81453], [-121.24446, 38.81475], [-121.24438, 38.8149], [-121.24467, 38.8153], [-121.24495, 38.81532], [-121.24537, 38.81525], [-121.24564, 38.81501], [-121.24615, 38.81471], [-121.24668, 38.81448], [-121.24698, 38.81468], [-121.24811, 38.81527], [-121.24841, 38.8153], [-121.24892, 38.8153]]]} | Open Access 1 | 36414 | Rocklin holding 13 | 24520 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 13.445 | Rocklin holding 13 | 0 | Local Other or Unknown 14 | 4 | |
13828 | 13828 | 13827 | {"type": "Polygon", "coordinates": [[[-121.23974, 38.82421], [-121.23937, 38.82442], [-121.23779, 38.82586], [-121.2375, 38.82602], [-121.2368, 38.82659], [-121.23489, 38.82856], [-121.23477, 38.82889], [-121.23305, 38.83123], [-121.23265, 38.83258], [-121.23247, 38.83254], [-121.23254, 38.83146], [-121.23391, 38.82914], [-121.23607, 38.82689], [-121.23607, 38.82687], [-121.23568, 38.82667], [-121.23601, 38.82647], [-121.23626, 38.82593], [-121.2368, 38.82579], [-121.23684, 38.82608], [-121.23686, 38.82609], [-121.23924, 38.82425], [-121.23974, 38.82421]]]} | Open Access 1 | 36415 | Rocklin holding 11 | 24518 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 10.485 | Rocklin holding 11 | 0 | Local Other or Unknown 14 | 4 | |
13829 | 13829 | 13828 | {"type": "Polygon", "coordinates": [[[-121.24491, 38.81284], [-121.24339, 38.81598], [-121.24115, 38.81686], [-121.24144, 38.81658], [-121.24264, 38.81567], [-121.2435, 38.81429], [-121.24363, 38.81434], [-121.24393, 38.81353], [-121.24396, 38.81278], [-121.24348, 38.81269], [-121.24337, 38.81273], [-121.24361, 38.81234], [-121.24491, 38.81284]]]} | Open Access 1 | 36416 | Rocklin holding 12 | 24519 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 7.883 | Rocklin holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13840 | 13840 | 13839 | {"type": "Polygon", "coordinates": [[[-121.28098, 38.81077], [-121.28052, 38.81145], [-121.28007, 38.81207], [-121.28027, 38.81237], [-121.27713, 38.81374], [-121.27617, 38.81277], [-121.27661, 38.8125], [-121.27652, 38.81214], [-121.27694, 38.81167], [-121.27795, 38.81167], [-121.28073, 38.81046], [-121.28098, 38.81077]]]} | Open Access 1 | 36431 | Rocklin holding 15 | 24522 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 16.753 | Rocklin holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13849 | 13849 | 13848 | {"type": "Polygon", "coordinates": [[[-121.23015, 38.83665], [-121.22932, 38.83664], [-121.2292, 38.8355], [-121.22932, 38.8355], [-121.22944, 38.83578], [-121.22963, 38.8361], [-121.22986, 38.83639], [-121.23015, 38.83665]]]} | Open Access 1 | 36438 | Rocklin holding 5 | 24528 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.085 | Rocklin holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13850 | 13850 | 13849 | {"type": "Polygon", "coordinates": [[[-121.24892, 38.81582], [-121.24882, 38.81637], [-121.24871, 38.81741], [-121.2486, 38.81755], [-121.24816, 38.81736], [-121.24832, 38.81574], [-121.24892, 38.81582]]]} | Open Access 1 | 36439 | Rocklin holding 4 | 24527 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.26 | Rocklin holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13854 | 13854 | 13853 | {"type": "Polygon", "coordinates": [[[-121.26424, 38.82108], [-121.26403, 38.82133], [-121.26303, 38.82156], [-121.26234, 38.82151], [-121.26169, 38.82177], [-121.26083, 38.82268], [-121.26025, 38.82268], [-121.25958, 38.8232], [-121.25959, 38.82321], [-121.26023, 38.82329], [-121.26016, 38.8237], [-121.25865, 38.82437], [-121.25774, 38.82444], [-121.25753, 38.82471], [-121.25701, 38.82425], [-121.25747, 38.82401], [-121.25869, 38.82323], [-121.26023, 38.82202], [-121.26138, 38.82135], [-121.26194, 38.82112], [-121.26234, 38.82107], [-121.26424, 38.82108]]]} | No Public Access 3 | 36443 | Rocklin holding 3 | 24526 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 12.656 | Rocklin holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13855 | 13855 | 13854 | {"type": "Polygon", "coordinates": [[[-121.24832, 38.81574], [-121.24816, 38.81736], [-121.24554, 38.81955], [-121.24531, 38.82059], [-121.24477, 38.8206], [-121.24473, 38.81975], [-121.24493, 38.81919], [-121.24645, 38.81846], [-121.247, 38.81793], [-121.24738, 38.81759], [-121.24767, 38.81717], [-121.24777, 38.81673], [-121.24776, 38.81645], [-121.24751, 38.81583], [-121.24708, 38.81533], [-121.24719, 38.81519], [-121.24832, 38.81574]]]} | Open Access 1 | 36444 | Rocklin holding 1 | 24516 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 7.874 | Rocklin holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13876 | 13876 | 13875 | {"type": "Polygon", "coordinates": [[[-121.24992, 38.82075], [-121.24983, 38.82082], [-121.24969, 38.82069], [-121.24963, 38.82066], [-121.2494, 38.82074], [-121.24841, 38.82147], [-121.24809, 38.8218], [-121.24791, 38.82193], [-121.24786, 38.82189], [-121.24771, 38.82201], [-121.24661, 38.82235], [-121.24613, 38.82242], [-121.24608, 38.8224], [-121.24598, 38.82222], [-121.24676, 38.82199], [-121.24716, 38.82183], [-121.24748, 38.82164], [-121.24813, 38.82119], [-121.24848, 38.82097], [-121.24885, 38.82078], [-121.24924, 38.82062], [-121.24958, 38.8205], [-121.24963, 38.82049], [-121.24967, 38.82051], [-121.24979, 38.82064], [-121.24992, 38.82075]]]} | Open Access 1 | 36467 | Rocklin holding 16 | 24523 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.291 | Rocklin holding 16 | 0 | Local Other or Unknown 14 | 4 | |
13877 | 13877 | 13876 | {"type": "Polygon", "coordinates": [[[-121.26559, 38.82111], [-121.26234, 38.82106], [-121.26396, 38.81851], [-121.26338, 38.81563], [-121.26341, 38.81439], [-121.26407, 38.81448], [-121.26519, 38.8147], [-121.26558, 38.81763], [-121.26582, 38.81916], [-121.26559, 38.82111]]]} | No Public Access 3 | 36468 | Rocklin holding 17 | 24524 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 33.242 | Rocklin holding 17 | 0 | Local Other or Unknown 14 | 4 | |
13880 | 13880 | 13879 | {"type": "Polygon", "coordinates": [[[-121.25747, 38.82554], [-121.25724, 38.82581], [-121.25685, 38.82593], [-121.25694, 38.82622], [-121.25666, 38.82626], [-121.25656, 38.82592], [-121.25645, 38.82581], [-121.25608, 38.82602], [-121.25539, 38.82611], [-121.25449, 38.82674], [-121.25371, 38.82681], [-121.25267, 38.82716], [-121.25254, 38.82656], [-121.25284, 38.82645], [-121.25367, 38.82638], [-121.25449, 38.82624], [-121.25513, 38.82583], [-121.25571, 38.82557], [-121.25628, 38.82504], [-121.25671, 38.82444], [-121.25736, 38.82486], [-121.25717, 38.82502], [-121.25743, 38.82524], [-121.25747, 38.82554]]]} | No Public Access 3 | 36470 | Rocklin holding 7 | 24530 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 7.963 | Rocklin holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13881 | 13881 | 13880 | {"type": "Polygon", "coordinates": [[[-121.25251, 38.82722], [-121.25091, 38.82731], [-121.25113, 38.82719], [-121.25077, 38.82655], [-121.25226, 38.82667], [-121.25237, 38.82663], [-121.25251, 38.82722]]]} | No Public Access 3 | 36471 | Rocklin holding 6 | 24529 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.285 | Rocklin holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13882 | 13882 | 13881 | {"type": "Polygon", "coordinates": [[[-121.25806, 38.82755], [-121.25787, 38.82775], [-121.25752, 38.82708], [-121.25728, 38.82686], [-121.25697, 38.82662], [-121.25692, 38.82637], [-121.25716, 38.82632], [-121.25735, 38.82645], [-121.25806, 38.82755]]]} | No Public Access 3 | 36472 | Rocklin holding 8 | 24531 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.03 | Rocklin holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13883 | 13883 | 13882 | {"type": "Polygon", "coordinates": [[[-121.25613, 38.82953], [-121.25455, 38.83106], [-121.25434, 38.83148], [-121.25459, 38.83065], [-121.25495, 38.83003], [-121.25525, 38.82964], [-121.25526, 38.82948], [-121.25506, 38.82931], [-121.25526, 38.82919], [-121.25549, 38.82909], [-121.25567, 38.82935], [-121.25594, 38.82924], [-121.25613, 38.82953]]]} | No Public Access 3 | 36473 | Rocklin holding 9 | 24532 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 2.565 | Rocklin holding 9 | 0 | Local Other or Unknown 14 | 4 | |
13997 | 13997 | 13996 | {"type": "Polygon", "coordinates": [[[-121.2456, 38.81268], [-121.24492, 38.81284], [-121.24361, 38.81234], [-121.24371, 38.81213], [-121.24377, 38.81207], [-121.24383, 38.81206], [-121.24392, 38.81207], [-121.24399, 38.81206], [-121.24405, 38.81202], [-121.24407, 38.81195], [-121.24422, 38.81192], [-121.24438, 38.81185], [-121.24476, 38.81174], [-121.24491, 38.81171], [-121.24504, 38.81172], [-121.24516, 38.81175], [-121.24527, 38.81181], [-121.24533, 38.81185], [-121.2454, 38.81193], [-121.24543, 38.81202], [-121.2456, 38.81268]]]} | Open Access 1 | 36681 | Rocklin holding 2 | 24525 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 3.454 | Rocklin holding 2 | 0 | Local Other or Unknown 14 | 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]);