units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
42 rows where MNG_AGENCY = 13 sorted by LABEL_NAME
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4130 | 4130 | 4129 | {"type": "Polygon", "coordinates": [[[-121.80347, 37.04255], [-121.80296, 37.04373], [-121.80276, 37.04499], [-121.80264, 37.04534], [-121.80233, 37.04573], [-121.80235, 37.04659], [-121.80223, 37.04686], [-121.80224, 37.04701], [-121.80228, 37.04703], [-121.80228, 37.04715], [-121.80279, 37.04754], [-121.80017, 37.04746], [-121.80028, 37.04454], [-121.80045, 37.04074], [-121.80194, 37.04076], [-121.80282, 37.04139], [-121.80342, 37.04205], [-121.80347, 37.04255]]]} | Open Access 1 | 36505 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 40.881 | 0 | Local Other or Unknown 14 | 4 | ||
4671 | 4671 | 4670 | {"type": "Polygon", "coordinates": [[[-121.77531, 36.91167], [-121.77503, 36.91227], [-121.77428, 36.91196], [-121.77397, 36.91189], [-121.77363, 36.91186], [-121.77326, 36.91191], [-121.77315, 36.91171], [-121.77244, 36.91195], [-121.77201, 36.91199], [-121.77149, 36.91185], [-121.77153, 36.91119], [-121.77249, 36.91129], [-121.77282, 36.9112], [-121.77299, 36.91105], [-121.77342, 36.91099], [-121.77355, 36.91109], [-121.77531, 36.91167]]]} | Open Access 1 | 36632 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 6.263 | 0 | Local Other or Unknown 14 | 4 | ||
4676 | 4676 | 4675 | {"type": "Polygon", "coordinates": [[[-121.78001, 36.90996], [-121.7796, 36.90977], [-121.77934, 36.90977], [-121.77883, 36.90994], [-121.77805, 36.91048], [-121.77599, 36.91021], [-121.77576, 36.91069], [-121.7756, 36.91016], [-121.77561, 36.91007], [-121.77568, 36.90995], [-121.77575, 36.90988], [-121.7759, 36.90981], [-121.7764, 36.90969], [-121.77693, 36.90981], [-121.77743, 36.90968], [-121.77756, 36.90959], [-121.77779, 36.90933], [-121.77802, 36.90919], [-121.77859, 36.90875], [-121.77882, 36.90864], [-121.77931, 36.90851], [-121.77936, 36.90846], [-121.77939, 36.90841], [-121.77938, 36.90832], [-121.78001, 36.90996]]]} | Open Access 1 | 36655 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 9.393 | 0 | Local Other or Unknown 14 | 4 | ||
15475 | 15475 | 15474 | {"type": "Polygon", "coordinates": [[[-121.80045, 37.04074], [-121.80028, 37.04454], [-121.80017, 37.04746], [-121.79151, 37.04743], [-121.79167, 37.0407], [-121.797, 37.04075], [-121.80045, 37.04074]]]} | Open Access 1 | 36626 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 142.753 | 0 | Local Other or Unknown 14 | 4 | ||
15477 | 15477 | 15476 | {"type": "Polygon", "coordinates": [[[-121.79104, 37.01528], [-121.79097, 37.01543], [-121.791, 37.01553], [-121.7909, 37.01571], [-121.79074, 37.01585], [-121.79048, 37.01595], [-121.78977, 37.01601], [-121.78875, 37.01643], [-121.78822, 37.01683], [-121.78806, 37.01702], [-121.78779, 37.01739], [-121.78779, 37.01786], [-121.78794, 37.01826], [-121.78733, 37.0187], [-121.78722, 37.01886], [-121.78726, 37.019], [-121.78736, 37.01911], [-121.78433, 37.01909], [-121.78606, 37.01588], [-121.78619, 37.01552], [-121.7865, 37.01535], [-121.78714, 37.01517], [-121.78795, 37.01487], [-121.78952, 37.01435], [-121.79104, 37.01528]], [[-121.79089, 37.01556], [-121.79089, 37.01554], [-121.7903, 37.01553], [-121.79029, 37.01554], [-121.79045, 37.01588], [-121.79068, 37.01579], [-121.79083, 37.01566], [-121.79089, 37.01556]]]} | Open Access 1 | 36629 | Unnamed site - Watsonville, City of | 28675 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 34.455 | 0 | Local Other or Unknown 14 | 4 | ||
15478 | 15478 | 15477 | {"type": "Polygon", "coordinates": [[[-121.79324, 36.88092], [-121.79324, 36.88092], [-121.78808, 36.88474], [-121.78767, 36.88399], [-121.79284, 36.88016], [-121.79324, 36.88092]]]} | No Public Access 3 | 36631 | Unnamed site - Watsonville, City of | 28700 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 13.356 | 0 | Local Other or Unknown 14 | 4 | ||
8798 | 8798 | 8797 | {"type": "Polygon", "coordinates": [[[-121.76555, 36.93039], [-121.76552, 36.93052], [-121.76555, 36.93069], [-121.7655, 36.93072], [-121.76538, 36.93075], [-121.76533, 36.93074], [-121.76526, 36.93064], [-121.76515, 36.93064], [-121.76509, 36.93057], [-121.76509, 36.93054], [-121.76526, 36.93038], [-121.76549, 36.93037], [-121.76555, 36.93039]]]} | Open Access 1 | 14315 | Arista Park | 15585 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.301 | Arista Park | 0 | Local Park 2 | 4 | |
9857 | 9857 | 9856 | {"type": "Polygon", "coordinates": [[[-121.74155, 36.91676], [-121.74127, 36.91714], [-121.7408, 36.91692], [-121.74152, 36.91674], [-121.74155, 36.91676]]]} | Open Access 1 | 16873 | Atri Park | 15677 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.316 | Atri Park | 0 | Local Park 2 | 4 | |
87 | 87 | 86 | {"type": "Polygon", "coordinates": [[[-121.74459, 36.92013], [-121.74445, 36.92037], [-121.74431, 36.92032], [-121.74415, 36.92034], [-121.744, 36.92028], [-121.74398, 36.92024], [-121.74411, 36.92], [-121.74416, 36.91997], [-121.7442, 36.91998], [-121.74459, 36.92013]]]} | Open Access 1 | 247 | Brentwood Park | 16362 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.377 | Brentwood Park | 0 | Local Park 2 | 4 | |
155 | 155 | 154 | {"type": "Polygon", "coordinates": [[[-121.7428, 36.9182], [-121.74279, 36.91824], [-121.7426, 36.9185], [-121.74256, 36.91853], [-121.7425, 36.91852], [-121.74237, 36.91846], [-121.74233, 36.91842], [-121.74234, 36.91838], [-121.74253, 36.91813], [-121.74258, 36.9181], [-121.74265, 36.9181], [-121.74277, 36.91816], [-121.7428, 36.9182]]]} | Open Access 1 | 417 | Bronte Park | 16417 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.287 | Bronte Park | 0 | Local Park 2 | 4 | |
6103 | 6103 | 6102 | {"type": "Polygon", "coordinates": [[[-121.803, 36.93287], [-121.80054, 36.93485], [-121.80069, 36.93581], [-121.80042, 36.94027], [-121.79899, 36.9403], [-121.79906, 36.93611], [-121.79906, 36.93551], [-121.79912, 36.93392], [-121.80104, 36.93237], [-121.80218, 36.93152], [-121.80231, 36.93209], [-121.80248, 36.93249], [-121.803, 36.93287]]]} | Open Access 1 | 1018 | Buena Vista Park | 16497 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 35.267 | Buena Vista Park | 0 | Local Park 2 | 4 | |
6358 | 6358 | 6357 | {"type": "Polygon", "coordinates": [[[-121.7604, 36.91664], [-121.75986, 36.918], [-121.75986, 36.918], [-121.75903, 36.91704], [-121.76019, 36.91639], [-121.7604, 36.91664]]]} | Open Access 1 | 1764 | Callaghan Park | 16732 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 2.53 | Callaghan Park | 0 | Local Park 2 | 4 | |
6985 | 6985 | 6984 | {"type": "Polygon", "coordinates": [[[-121.77997, 36.93361], [-121.77981, 36.9337], [-121.7796, 36.93345], [-121.77976, 36.93336], [-121.77997, 36.93361]]]} | Open Access 1 | 5908 | Cherry Blossom Pocket Park | 17165 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.151 | Cherry Blossom PP | 0 | Local Park 2 | 4 | |
7477 | 7477 | 7476 | {"type": "Polygon", "coordinates": [[[-121.75668, 36.91019], [-121.75601, 36.91068], [-121.75548, 36.91022], [-121.75616, 36.90974], [-121.75668, 36.91019]]]} | Open Access 1 | 6993 | City Plaza Park | 17345 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 1.381 | City Plaza Park | 0 | Local Park 2 | 4 | |
8022 | 8022 | 8021 | {"type": "Polygon", "coordinates": [[[-121.76021, 36.92854], [-121.75889, 36.92892], [-121.75862, 36.92828], [-121.75968, 36.92797], [-121.75973, 36.92797], [-121.75976, 36.92799], [-121.75992, 36.92823], [-121.76013, 36.92843], [-121.76021, 36.92854]]]} | Open Access 1 | 11355 | Crestview Park | 17813 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 2.145 | Crestview Park | 0 | Local Park 2 | 4 | |
4215 | 4215 | 4214 | {"type": "Polygon", "coordinates": [[[-121.7549, 36.91849], [-121.7545, 36.91871], [-121.75429, 36.91848], [-121.75388, 36.91869], [-121.75349, 36.91824], [-121.75322, 36.91838], [-121.75291, 36.91799], [-121.75268, 36.91773], [-121.75158, 36.91849], [-121.75102, 36.91787], [-121.7528, 36.91657], [-121.75302, 36.91683], [-121.75341, 36.91661], [-121.7542, 36.91753], [-121.7549, 36.91849]]]} | Restricted Access 2 | 44966 | E.A. Hall School Park | 32705 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 9.82 | E.A. Hall School Park | 0 | Local Park 2 | 4 | |
9341 | 9341 | 9340 | {"type": "Polygon", "coordinates": [[[-121.75749, 36.9143], [-121.75695, 36.9146], [-121.75683, 36.91447], [-121.75737, 36.91417], [-121.75749, 36.9143]]]} | Open Access 1 | 15609 | Emmett Courts Park | 18632 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.262 | Emmett Courts Park | 0 | Local Park 2 | 4 | |
5185 | 5185 | 5184 | {"type": "MultiPolygon", "coordinates": [[[[-121.75815, 36.92276], [-121.75776, 36.92297], [-121.75768, 36.92257], [-121.75788, 36.92246], [-121.75815, 36.92276]]], [[[-121.75848, 36.92319], [-121.75834, 36.92327], [-121.75787, 36.92353], [-121.75779, 36.92313], [-121.75822, 36.92289], [-121.75848, 36.92319]]]]} | Open Access 1 | 15866 | Flodberg Park | 18951 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 0.89 | Flodberg Park | 0 | Local Park 2 | 4 | |
9517 | 9517 | 9516 | {"type": "Polygon", "coordinates": [[[-121.74449, 36.92636], [-121.74449, 36.9264], [-121.74408, 36.92774], [-121.74406, 36.92788], [-121.74408, 36.92802], [-121.74191, 36.92759], [-121.74172, 36.92765], [-121.74168, 36.9276], [-121.74157, 36.92751], [-121.74143, 36.92745], [-121.74077, 36.92731], [-121.74115, 36.92581], [-121.74106, 36.92571], [-121.7411, 36.92569], [-121.74444, 36.92634], [-121.74449, 36.92636]]]} | Open Access 1 | 15972 | Franich Park | 19047 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 14.039 | Franich Park | 0 | Local Park 2 | 4 | |
9692 | 9692 | 9691 | {"type": "Polygon", "coordinates": [[[-121.82747, 36.9152], [-121.82607, 36.9168], [-121.82571, 36.91674], [-121.82537, 36.91664], [-121.82532, 36.91668], [-121.82468, 36.91634], [-121.82421, 36.91602], [-121.82368, 36.91571], [-121.82311, 36.91547], [-121.82248, 36.91531], [-121.82184, 36.91523], [-121.82145, 36.91524], [-121.82079, 36.91532], [-121.81964, 36.91555], [-121.81917, 36.91559], [-121.81862, 36.91557], [-121.81814, 36.91548], [-121.81777, 36.91537], [-121.81739, 36.91521], [-121.81705, 36.91502], [-121.81678, 36.91482], [-121.81457, 36.91299], [-121.8141, 36.91247], [-121.81373, 36.91189], [-121.81598, 36.91026], [-121.81956, 36.9132], [-121.82148, 36.91203], [-121.82242, 36.91172], [-121.82319, 36.91255], [-121.82441, 36.91278], [-121.82529, 36.91254], [-121.82747, 36.9152]]]} | Restricted Access 2 | 16377 | Gallighan Slough | 28151 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | http://cityofwatsonville.org/parks-community-services | City 2 | 1373 | Watsonville, City of 13 | City 2 | City Agency 2 | Santa Cruz 5 | 98.834 | Gallighan Slough | 0 | Local Conservation Area 4 | 2 |
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]);