units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
29 rows where DES_TP = 2 and MNG_AGENCY = 13 sorted by rowid descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
- City Agency 29
MNG_AGENCY 1
- Watsonville, City of · 29 ✖
DES_TP 1
- Local Park · 29 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10611 | 10611 | 10610 | {"type": "Polygon", "coordinates": [[[-121.77365, 36.91398], [-121.77242, 36.91642], [-121.76903, 36.91583], [-121.76892, 36.91543], [-121.76966, 36.91462], [-121.77036, 36.91276], [-121.77032, 36.91306], [-121.77047, 36.91326], [-121.77144, 36.91337], [-121.77244, 36.91308], [-121.77266, 36.91309], [-121.77299, 36.9133], [-121.77325, 36.9138], [-121.77365, 36.91398]]]} | Open Access 1 | 18897 | Ramsay Park | 24123 | 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 | 25.557 | Ramsay Park | 0 | Local Park 2 | 4 | |
10475 | 10475 | 10474 | {"type": "Polygon", "coordinates": [[[-121.77403, 36.95659], [-121.77176, 36.95734], [-121.77175, 36.95749], [-121.76987, 36.95751], [-121.76989, 36.95712], [-121.76961, 36.95662], [-121.76959, 36.95623], [-121.76944, 36.95607], [-121.76909, 36.95585], [-121.76908, 36.95569], [-121.76894, 36.95555], [-121.76847, 36.95528], [-121.7682, 36.95464], [-121.76779, 36.95408], [-121.76767, 36.95372], [-121.7675, 36.95332], [-121.76742, 36.95264], [-121.76762, 36.95201], [-121.76704, 36.95116], [-121.76711, 36.95067], [-121.76667, 36.95038], [-121.7655, 36.95014], [-121.76501, 36.95002], [-121.76493, 36.94947], [-121.76513, 36.9489], [-121.76538, 36.94842], [-121.76565, 36.94792], [-121.76555, 36.94824], [-121.76629, 36.94896], [-121.7682, 36.95031], [-121.76813, 36.95042], [-121.7683, 36.95043], [-121.76828, 36.95058], [-121.76997, 36.95054], [-121.76997, 36.9508], [-121.77029, 36.95115], [-121.77059, 36.95144], [-121.77067, 36.95161], [-121.77072, 36.95166], [-121.77089, 36.95169], [-121.77096, 36.95187], [-121.77079, 36.95199], [-121.77065, 36.95222], [-121.77094, 36.95245], [-121.77108, 36.9523], [-121.77161, 36.95261], [-121.77246, 36.95333], [-121.77202, 36.95367], [-121.77193, 36.95391], [-121.77205, 36.95406], [-121.77243, 36.95419], [-121.77266, 36.9543], [-121.77287, 36.95467], [-121.77323, 36.95491], [-121.77388, 36.95516], [-121.77403, 36.95536], [-121.77403, 36.95659]]]} | Open Access 1 | 18559 | Pinto Lake Park | 23707 | 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 | 77.698 | Pinto Lake Park | 0 | Local Park 2 | 4 | |
10268 | 10268 | 10267 | {"type": "Polygon", "coordinates": [[[-121.75376, 36.90563], [-121.75326, 36.90599], [-121.75273, 36.90552], [-121.75312, 36.90514], [-121.75316, 36.90512], [-121.75321, 36.90512], [-121.75376, 36.90563]]]} | Open Access 1 | 18057 | Muzzio Pocket Park | 22618 | 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.117 | Muzzio PP | 0 | Local Park 2 | 4 | |
10144 | 10144 | 10143 | {"type": "Polygon", "coordinates": [[[-121.75842, 36.90801], [-121.75787, 36.9084], [-121.7574, 36.90798], [-121.75794, 36.90759], [-121.75842, 36.90801]]]} | Open Access 1 | 17665 | Marinovich Park | 21860 | 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.007 | Marinovich Park | 0 | Local Park 2 | 4 | |
9929 | 9929 | 9928 | {"type": "Polygon", "coordinates": [[[-121.74128, 36.92456], [-121.7412, 36.92483], [-121.7392, 36.9245], [-121.73918, 36.92428], [-121.7392, 36.92424], [-121.73925, 36.92422], [-121.74038, 36.92433], [-121.74123, 36.9245], [-121.74128, 36.92452], [-121.74128, 36.92456]]]} | Open Access 1 | 17073 | Joyce-McKenzie Park | 20510 | 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.692 | Joyce-McKenzie Park | 0 | Local Park 2 | 4 | |
9919 | 9919 | 9918 | {"type": "Polygon", "coordinates": [[[-121.76249, 36.91094], [-121.76233, 36.91109], [-121.76189, 36.91079], [-121.76204, 36.91065], [-121.76249, 36.91094]]]} | Open Access 1 | 17095 | Kearney Street Park | 20565 | 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.277 | Kearney Street Park | 0 | Local Park 2 | 4 | |
9872 | 9872 | 9871 | {"type": "Polygon", "coordinates": [[[-121.77715, 36.92485], [-121.77709, 36.92503], [-121.77673, 36.92544], [-121.77662, 36.92564], [-121.77656, 36.9258], [-121.77655, 36.92595], [-121.77641, 36.92595], [-121.77613, 36.92561], [-121.77667, 36.92362], [-121.7769, 36.92468], [-121.77715, 36.92485]]]} | Open Access 1 | 16934 | Hope Drive Park | 20085 | 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.456 | Hope Drive 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 | |
9790 | 9790 | 9789 | {"type": "Polygon", "coordinates": [[[-121.78496, 36.92154], [-121.78481, 36.92163], [-121.78443, 36.92135], [-121.78433, 36.92058], [-121.7848, 36.92034], [-121.78469, 36.92071], [-121.78496, 36.92154]]]} | Open Access 1 | 16806 | Hazelwood Park | 19765 | 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.074 | Hazelwood 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
5813 | 5813 | 5812 | {"type": "Polygon", "coordinates": [[[-121.75218, 36.90885], [-121.75199, 36.90899], [-121.75154, 36.90859], [-121.75172, 36.90846], [-121.75218, 36.90885]]]} | Open Access 1 | 86 | Riverside Mini Park | 24452 | 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.338 | Riverside MP | 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 | |
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 |
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]);