superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where PARK_URL = "http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/"
This data as json, copyable, CSV (advanced)
ACCESS_TYP 2
MNG_AG_TYP 1
MNG_AGENCY 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
633 | 633 | 632 | {"type": "Polygon", "coordinates": [[[-121.43015, 36.85485], [-121.43017, 36.85489], [-121.43016, 36.85538], [-121.43014, 36.85541], [-121.43009, 36.85544], [-121.42946, 36.85541], [-121.42948, 36.85482], [-121.4301, 36.85483], [-121.43015, 36.85485]]]} | Open Access 1 | Tony Aguirre Memorial Park | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | 32732 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 1.008 | Tony Aguirre Memorial Park | |
862 | 862 | 861 | {"type": "Polygon", "coordinates": [[[-121.43452, 36.84973], [-121.43399, 36.84982], [-121.4335, 36.84994], [-121.43301, 36.85009], [-121.43244, 36.8503], [-121.42986, 36.8487], [-121.42882, 36.84872], [-121.42658, 36.84745], [-121.42574, 36.84588], [-121.42638, 36.8461], [-121.42653, 36.84589], [-121.42678, 36.846], [-121.42721, 36.84604], [-121.4276, 36.84581], [-121.42814, 36.84572], [-121.42901, 36.84565], [-121.42945, 36.84574], [-121.42984, 36.84583], [-121.43051, 36.84603], [-121.43079, 36.84606], [-121.43113, 36.84615], [-121.43131, 36.84621], [-121.43143, 36.84635], [-121.432, 36.84651], [-121.43282, 36.84666], [-121.43309, 36.84668], [-121.43326, 36.84672], [-121.43329, 36.84688], [-121.43336, 36.847], [-121.43346, 36.84701], [-121.43255, 36.84866], [-121.43267, 36.84877], [-121.43283, 36.84886], [-121.43388, 36.84917], [-121.43406, 36.84924], [-121.43419, 36.84933], [-121.4343, 36.84944], [-121.43438, 36.84956], [-121.43443, 36.84969], [-121.43452, 36.84973]]]} | Open Access 1 | Brigantino Park | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | 32725 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 49.579 | Brigantino Park | |
863 | 863 | 862 | {"type": "Polygon", "coordinates": [[[-121.37701, 36.84324], [-121.37698, 36.84393], [-121.37692, 36.84397], [-121.37665, 36.84395], [-121.37653, 36.84382], [-121.3764, 36.84359], [-121.37633, 36.84341], [-121.37628, 36.84321], [-121.37701, 36.84324]]]} | Open Access 1 | Las Brisas Park | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | 32727 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 1.019 | Las Brisas Park | |
1251 | 1251 | 1250 | {"type": "Polygon", "coordinates": [[[-121.37344, 36.8283], [-121.37344, 36.82867], [-121.37339, 36.82911], [-121.37285, 36.82909], [-121.37285, 36.82903], [-121.37278, 36.82902], [-121.37208, 36.82902], [-121.37206, 36.82921], [-121.37191, 36.82923], [-121.3719, 36.82956], [-121.37204, 36.82957], [-121.37203, 36.82976], [-121.37222, 36.82978], [-121.3722, 36.82988], [-121.37102, 36.82984], [-121.37093, 36.82991], [-121.37094, 36.83008], [-121.37077, 36.83008], [-121.37086, 36.82825], [-121.3734, 36.82827], [-121.37344, 36.8283]]]} | Restricted Access 2 | Cerra Vista School Park | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | 32923 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 7.46 | Cerra Vista School Park | |
11843 | 11843 | 11842 | {"type": "Polygon", "coordinates": [[[-121.37134, 36.82419], [-121.37131, 36.82422], [-121.37125, 36.82423], [-121.37091, 36.82421], [-121.37012, 36.82409], [-121.37018, 36.82292], [-121.37086, 36.82294], [-121.37095, 36.82297], [-121.37094, 36.82336], [-121.37099, 36.82361], [-121.37103, 36.82372], [-121.37127, 36.82399], [-121.37134, 36.82414], [-121.37134, 36.82419]]]} | Open Access 1 | Valley View Park | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | 28493 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 2.738 | Valley View Park | |
14099 | 14099 | 14098 | {"type": "Polygon", "coordinates": [[[-121.38663, 36.85252], [-121.38651, 36.85489], [-121.38407, 36.85481], [-121.38414, 36.85323], [-121.38515, 36.85329], [-121.38551, 36.85316], [-121.38596, 36.8531], [-121.38603, 36.85232], [-121.3862, 36.85233], [-121.38623, 36.85252], [-121.38663, 36.85252]]]} | Restricted Access 2 | Marguerite Maze Sports Complex | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | 32728 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 10.922 | Marguerite Maze Sports Complex | |
14124 | 14124 | 14123 | {"type": "Polygon", "coordinates": [[[-121.40104, 36.88449], [-121.40101, 36.88543], [-121.40098, 36.88569], [-121.40033, 36.88569], [-121.40027, 36.88538], [-121.40035, 36.88428], [-121.40104, 36.88449]]]} | Open Access 1 | Jerry Gabe Memorial Park | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | 32729 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 2.264 | Jerry Gabe Memorial 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]);