units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where COUNTY = 38, MNG_AG_TYP = 2 and PARK_URL = "http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/"
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_WEB, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6226 | 6226 | 6225 | {"type": "Polygon", "coordinates": [[[-121.37339, 36.82911], [-121.37285, 36.82909], [-121.37285, 36.82903], [-121.37278, 36.82902], [-121.37207, 36.82902], [-121.37206, 36.82921], [-121.37191, 36.82922], [-121.3719, 36.82957], [-121.37204, 36.82957], [-121.37203, 36.82976], [-121.37222, 36.82978], [-121.3722, 36.82988], [-121.37101, 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], [-121.37345, 36.82833], [-121.37344, 36.82867], [-121.37339, 36.82911]]]} | Restricted Access 2 | 48357 | Cerra Vista School Park | 32923 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | San Benito 38 | 7.458 | Cerra Vista School Park | 0 | Local Park 2 | 4 |
11474 | 11474 | 11473 | {"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 | 48192 | Jerry Gabe Memorial Park | 32729 | 1138 | Hollister, City of 200 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | San Benito 38 | 2.265 | Jerry Gabe Memorial Park | 0 | Local Park 2 | 4 |
11501 | 11501 | 11500 | {"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.84869], [-121.42882, 36.84872], [-121.42658, 36.84745], [-121.42574, 36.84588], [-121.42639, 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.84701], [-121.43346, 36.84701], [-121.43255, 36.84865], [-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 | 48189 | Brigantino Park | 32725 | 1138 | Hollister, City of 200 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | San Benito 38 | 49.565 | Brigantino Park | 0 | Local Park 2 | 4 |
11502 | 11502 | 11501 | {"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 | 48190 | Las Brisas Park | 32727 | 1138 | Hollister, City of 200 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | San Benito 38 | 1.019 | Las Brisas Park | 0 | Local Park 2 | 4 |
11503 | 11503 | 11502 | {"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 | 48191 | Marguerite Maze Sports Complex | 32728 | 2425 | Hollister School District 561 | Special District 4 | School District 14 | https://www.hesd.org/ | Special District 4 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | San Benito 38 | 10.915 | Marguerite Maze Sports Complex | 0 | Local Recreation Area 3 | 4 |
11504 | 11504 | 11503 | {"type": "Polygon", "coordinates": [[[-121.42948, 36.85482], [-121.4301, 36.85483], [-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]]]} | Open Access 1 | 48195 | Tony Aguirre Memorial Park | 32732 | 1138 | Hollister, City of 200 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | San Benito 38 | 1.008 | Tony Aguirre Memorial Park | 0 | Local Park 2 | 4 |
15028 | 15028 | 15027 | {"type": "Polygon", "coordinates": [[[-121.37134, 36.82419], [-121.37131, 36.82422], [-121.37126, 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.82371], [-121.37127, 36.82399], [-121.37134, 36.82414], [-121.37134, 36.82419]]]} | Open Access 1 | 45679 | Valley View Park | 28493 | 1138 | Hollister, City of 200 | City 2 | City Agency 2 | http://www.hollister.ca.gov/Site/html/gov/office/recreation/parkfac.asp | City 2 | 1138 | Hollister, City of 196 | City 2 | City Agency 2 | http://hollister.ca.gov/government/city-departments/recreation/parks-facilities/ | San Benito 38 | 2.738 | Valley View 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]);