units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where MNG_AGENCY = 104 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, LABEL_NAME
DES_TP 6
- Local Other or Unknown 7
- Local Park 4
- Local Recreation Area 2
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency · 16 ✖
MNG_AGENCY 1
- Scotts Valley, City of · 16 ✖
ACCESS_TYP 1
- Open Access 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
260 | 260 | 259 | {"type": "MultiPolygon", "coordinates": [[[[-122.03147, 37.05364], [-122.03119, 37.05372], [-122.03074, 37.05397], [-122.03059, 37.05423], [-122.0306, 37.05358], [-122.03147, 37.05364]]], [[[-122.03519, 37.05382], [-122.03465, 37.05395], [-122.03443, 37.05404], [-122.03426, 37.05419], [-122.03406, 37.05445], [-122.03093, 37.05448], [-122.03136, 37.05427], [-122.0318, 37.05403], [-122.03213, 37.05418], [-122.03226, 37.05404], [-122.03245, 37.05415], [-122.03292, 37.05367], [-122.03343, 37.05332], [-122.03375, 37.05305], [-122.03394, 37.05284], [-122.03411, 37.05261], [-122.03426, 37.05236], [-122.03449, 37.05243], [-122.03454, 37.05232], [-122.03473, 37.05251], [-122.03519, 37.05382]]]]} | Open Access 1 | 876 | Skypark | 25545 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 9.029 | Skypark | None 28 | |||
610 | 610 | 609 | {"type": "Polygon", "coordinates": [[[-122.01752, 37.02001], [-122.01724, 37.02045], [-122.01717, 37.02042], [-122.01712, 37.02034], [-122.01683, 37.0203], [-122.01655, 37.02012], [-122.01641, 37.02009], [-122.01665, 37.0197], [-122.01675, 37.01958], [-122.01686, 37.01955], [-122.01698, 37.01966], [-122.01727, 37.01988], [-122.01752, 37.02001]]]} | Open Access 1 | 2139 | Camp Evers Fishing Park | 16774 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 1.271 | Camp Evers Fishing Park | 0 | Local Park 2 | 4 | |
2491 | 2491 | 2490 | {"type": "Polygon", "coordinates": [[[-122.02042, 37.05058], [-122.01927, 37.05073], [-122.01725, 37.04949], [-122.01756, 37.04915], [-122.01918, 37.0484], [-122.01941, 37.04831], [-122.01986, 37.0491], [-122.0197, 37.04917], [-122.02024, 37.05013], [-122.02042, 37.05058]]]} | Open Access 1 | 17503 | MacDorsa Park | 21626 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 10.057 | MacDorsa Park | 0 | Local Park 2 | 4 | |
2552 | 2552 | 2551 | {"type": "Polygon", "coordinates": [[[-122.04515, 37.0409], [-122.04469, 37.04113], [-122.04428, 37.0406], [-122.04472, 37.04039], [-122.04515, 37.0409]]]} | Open Access 1 | 17807 | Michael Gray Field Park | 22196 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 0.798 | Michael Gray Field Park | 0 | Local Recreation Area 3 | 4 | |
5909 | 5909 | 5908 | {"type": "Polygon", "coordinates": [[[-122.0098, 37.04994], [-122.00674, 37.05263], [-122.00643, 37.05287], [-122.00558, 37.05249], [-122.00373, 37.05169], [-122.00392, 37.05141], [-122.00392, 37.05139], [-122.00354, 37.05123], [-122.00334, 37.05152], [-122.00297, 37.05136], [-122.00491, 37.04863], [-122.00455, 37.04836], [-122.00462, 37.04814], [-122.00441, 37.048], [-122.00454, 37.04758], [-122.00856, 37.04869], [-122.00943, 37.04928], [-122.00975, 37.04968], [-122.0098, 37.04994]]]} | Open Access 1 | 17176 | Ladato Open Space | 20820 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 48.743 | Ladato OS | 0 | Local Recreation Area 3 | 4 | |
6068 | 6068 | 6067 | {"type": "MultiPolygon", "coordinates": [[[[-122.00375, 37.06802], [-122.00343, 37.06927], [-122.00086, 37.06884], [-122.0012, 37.06761], [-122.00375, 37.06802]]], [[[-122.00204, 37.06688], [-122.00186, 37.06759], [-122.00092, 37.06743], [-122.0011, 37.06672], [-122.00204, 37.06688]]]]} | Open Access 1 | 806 | Siltanen Park | 25479 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 9.802 | Siltanen Park | 0 | Local Park 2 | 4 | |
6083 | 6083 | 6082 | {"type": "MultiPolygon", "coordinates": [[[[-122.03315, 37.05095], [-122.03281, 37.0516], [-122.0327, 37.05176], [-122.03245, 37.05195], [-122.03227, 37.05182], [-122.03216, 37.05193], [-122.03207, 37.05206], [-122.03202, 37.05221], [-122.03199, 37.05235], [-122.03201, 37.0525], [-122.03205, 37.05265], [-122.03247, 37.05332], [-122.03224, 37.05356], [-122.03205, 37.0536], [-122.03196, 37.05369], [-122.03213, 37.05381], [-122.03213, 37.0539], [-122.03218, 37.05395], [-122.03226, 37.05397], [-122.03226, 37.05404], [-122.03213, 37.05419], [-122.0318, 37.05403], [-122.03136, 37.05427], [-122.03093, 37.05448], [-122.03059, 37.05448], [-122.03059, 37.05423], [-122.03074, 37.05397], [-122.03119, 37.05372], [-122.03147, 37.05364], [-122.03203, 37.05325], [-122.03165, 37.05261], [-122.03094, 37.05129], [-122.03064, 37.05122], [-122.03064, 37.05086], [-122.02946, 37.05085], [-122.02943, 37.05008], [-122.03105, 37.05005], [-122.0314, 37.05002], [-122.03174, 37.04996], [-122.03204, 37.04988], [-122.03315, 37.05095]]], [[[-122.03187, 37.04973], [-122.0314, 37.04983], [-122.03104, 37.04985], [-122.02999, 37.04987], [-122.03115, 37.04903], [-122.03187, 37.04973]]], [[[-122.03631, 37.0512], [-122.03628, 37.05127], [-122.03593, 37.05127], [-122.03585, 37.05136], [-122.03582, 37.0515], [-122.03566, 37.05167], [-122.03551, 37.05173], [-122.03551, 37.05182], [-122.03543, 37.05187], [-122.03543, 37.05195], [-122.03504, 37.05281], [-122.03455, 37.05232], [-122.03458, 37.05225], [-122.03465, 37.05225], [-122.03471, 37.05223], [-122.03499, 37.05231], [-122.03527, 37.0517], [-122.03534, 37.0516], [-122.03574, 37.05116], [-122.0358, 37.05101], [-122.03547, 37.05039], [-122.03537, 37.05026], [-122.0351, 37.05005], [-122.03437, 37.04976], [-122.03373, 37.04941], [-122.03358, 37.0493], [-122.03327, 37.04949], [-122.03294, 37.04964], [-122.0329, 37.04969], [-122.0329, 37.0498], [-122.03292, 37.04982], [-122.03295, 37.04982], [-122.03296, 37.04985], [-122.03292, 37.04985], [-122.03287, 37.04982], [-122.03288, 37.04967], [-122.03293, 37.04961], [-122.03333, 37.04943], [-122.03358, 37.04926], [-122.03375, 37.04908], [-122.03388, 37.04885], [-122.03394, 37.04877], [-122.03416, 37.04859], [-122.03411, 37.0489], [-122.03425, 37.04906], [-122.03488, 37.04953], [-122.03506, 37.04954], [-122.03528, 37.04967], [-122.03559, 37.04978], [-122.03568, 37.04988], [-122.03586, 37.04989], [-122.0356, 37.05018], [-122.03574, 37.05034], [-122.03591, 37.05041], [-122.03592, 37.05045], [-122.03582, 37.05054], [-122.03583, 37.05066], [-122.03604, 37.05092], [-122.03613, 37.05111], [-122.03631, 37.0512]]]]} | Open Access 1 | 885 | Skypark | 25545 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 22.469 | Skypark | None 490 | |||
9005 | 9005 | 9004 | {"type": "Polygon", "coordinates": [[[-122.00518, 37.06849], [-122.00503, 37.06988], [-122.00425, 37.06953], [-122.00373, 37.06955], [-122.00364, 37.0695], [-122.00328, 37.06951], [-122.00311, 37.06959], [-122.00224, 37.06979], [-122.00209, 37.06974], [-122.00216, 37.06947], [-122.00214, 37.06927], [-122.00209, 37.06916], [-122.00208, 37.06909], [-122.00211, 37.06905], [-122.00343, 37.06927], [-122.00375, 37.06802], [-122.00464, 37.06816], [-122.00459, 37.06839], [-122.00518, 37.06849]]]} | Open Access 1 | 16504 | Glenwood Meadows | 19340 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 7.027 | Glenwood Meadows | None 749 | |||
9883 | 9883 | 9882 | {"type": "Polygon", "coordinates": [[[-122.0279, 37.0411], [-122.02732, 37.04173], [-122.02735, 37.04175], [-122.02735, 37.04177], [-122.02728, 37.04187], [-122.02766, 37.04209], [-122.02743, 37.0423], [-122.02704, 37.04202], [-122.027, 37.04196], [-122.02708, 37.04187], [-122.02709, 37.04181], [-122.02726, 37.04161], [-122.02729, 37.04153], [-122.02684, 37.04119], [-122.02686, 37.04117], [-122.02711, 37.04119], [-122.0279, 37.0411]]]} | Open Access 1 | 16919 | Hocus Pocus Park | 20019 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 1.097 | Hocus Pocus Park | 0 | Local Park 2 | 4 | |
13260 | 13260 | 13259 | {"type": "Polygon", "coordinates": [[[-122.03502, 37.03122], [-122.03293, 37.03323], [-122.03274, 37.03239], [-122.03256, 37.03183], [-122.03206, 37.0318], [-122.0321, 37.03172], [-122.03201, 37.03169], [-122.03209, 37.03149], [-122.03209, 37.03129], [-122.03202, 37.0311], [-122.03196, 37.031], [-122.03196, 37.03096], [-122.03246, 37.03041], [-122.03201, 37.02973], [-122.03166, 37.0299], [-122.03121, 37.03053], [-122.03146, 37.03092], [-122.02985, 37.03093], [-122.02891, 37.03117], [-122.02888, 37.03114], [-122.03278, 37.02919], [-122.03502, 37.03122]]]} | Open Access 1 | 35307 | Scotts Valley holding 5 | 25211 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 18.344 | Scotts Valley holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13281 | 13281 | 13280 | {"type": "Polygon", "coordinates": [[[-121.99859, 37.06655], [-121.99847, 37.06705], [-121.99811, 37.06695], [-121.99814, 37.06685], [-121.99824, 37.06674], [-121.99859, 37.06655]]]} | Open Access 1 | 35335 | Scotts Valley holding 7 | 25213 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 0.3 | Scotts Valley holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13302 | 13302 | 13301 | {"type": "Polygon", "coordinates": [[[-122.03188, 37.03168], [-122.03188, 37.03172], [-122.03176, 37.03191], [-122.03156, 37.03235], [-122.03132, 37.03272], [-122.03101, 37.03338], [-122.03098, 37.0336], [-122.03107, 37.03381], [-122.0311, 37.03394], [-122.031, 37.03405], [-122.03097, 37.03406], [-122.03021, 37.03269], [-122.0307, 37.03251], [-122.03036, 37.03189], [-122.02955, 37.03246], [-122.02938, 37.03274], [-122.02926, 37.0327], [-122.02891, 37.03265], [-122.0287, 37.0326], [-122.02878, 37.03216], [-122.02774, 37.03172], [-122.02888, 37.03114], [-122.02929, 37.03214], [-122.0302, 37.03151], [-122.03026, 37.03157], [-122.03039, 37.03149], [-122.03108, 37.03165], [-122.03126, 37.03166], [-122.03153, 37.03163], [-122.03168, 37.03162], [-122.03184, 37.03166], [-122.03188, 37.03168]]]} | Open Access 1 | 35364 | Scotts Valley holding 1 | 25207 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 8.816 | Scotts Valley holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13340 | 13340 | 13339 | {"type": "Polygon", "coordinates": [[[-121.99514, 37.05375], [-121.99504, 37.05378], [-121.99487, 37.05355], [-121.99458, 37.05324], [-121.99485, 37.05316], [-121.99499, 37.05319], [-121.99502, 37.05361], [-121.99514, 37.05375]]]} | Open Access 1 | 35418 | Scotts Valley holding 2 | 25208 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 0.324 | Scotts Valley holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13341 | 13341 | 13340 | {"type": "Polygon", "coordinates": [[[-121.99808, 37.05018], [-121.99776, 37.05056], [-121.99753, 37.05077], [-121.99737, 37.05101], [-121.99762, 37.0513], [-121.99776, 37.05178], [-121.99705, 37.05155], [-121.99651, 37.05186], [-121.99548, 37.05262], [-121.99581, 37.05336], [-121.99485, 37.05316], [-121.99458, 37.05324], [-121.99423, 37.05383], [-121.99209, 37.05371], [-121.99208, 37.05138], [-121.99372, 37.05137], [-121.9937, 37.05014], [-121.99699, 37.05015], [-121.99808, 37.05018]]]} | Open Access 1 | 35419 | Scotts Valley holding 4 | 25210 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 33.56 | Scotts Valley holding 4 | 0 | Local Other or Unknown 14 | 4 | |
13342 | 13342 | 13341 | {"type": "Polygon", "coordinates": [[[-122.00556, 37.06268], [-122.0055, 37.06275], [-122.00535, 37.06284], [-122.00528, 37.06254], [-122.00532, 37.06251], [-122.00537, 37.06251], [-122.00552, 37.0626], [-122.00556, 37.06268]]]} | Open Access 1 | 35420 | Scotts Valley holding 3 | 25209 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 0.132 | Scotts Valley holding 3 | 0 | Local Other or Unknown 14 | 4 | |
13984 | 13984 | 13983 | {"type": "Polygon", "coordinates": [[[-121.99423, 37.05383], [-121.99408, 37.05456], [-121.99386, 37.05528], [-121.99284, 37.05628], [-121.99279, 37.05727], [-121.99213, 37.05728], [-121.99209, 37.05371], [-121.99423, 37.05383]]]} | Open Access 1 | 36665 | Scotts Valley holding 6 | 25212 | 1328 | Scotts Valley, City of 107 | City 2 | City Agency 2 | http://www.scottsvalley.org/parks/parks_recs.html | City 2 | 1328 | Scotts Valley, City of 104 | City 2 | City Agency 2 | Santa Cruz 5 | 11.96 | Scotts Valley holding 6 | 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]);