units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where UNIT_NAME = "Hillview Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, DES_TP
MNG_AG_TYP 2
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2312 | 2312 | 2311 | {"type": "Polygon", "coordinates": [[[-122.04197, 38.27757], [-122.0416, 38.27758], [-122.04147, 38.27761], [-122.04132, 38.27769], [-122.04097, 38.27776], [-122.04013, 38.27786], [-122.04013, 38.27648], [-122.04191, 38.27649], [-122.04197, 38.27653], [-122.04197, 38.27757]]]} | Open Access 1 | 16959 | Hillview Park | 19993 | 1105 | Fairfield, City of 208 | City 2 | City Agency 2 | http://www.fairfield.ca.gov/gov/depts/pw/parks/default.asp | City 2 | 1105 | Fairfield, City of 204 | City 2 | City Agency 2 | Solano 26 | 5.466 | Hillview Park | 0 | Local Park 2 | 4 | |
9893 | 9893 | 9892 | {"type": "Polygon", "coordinates": [[[-121.82711, 37.33885], [-121.82645, 37.33931], [-121.82597, 37.33976], [-121.82509, 37.34035], [-121.82503, 37.34034], [-121.82348, 37.33884], [-121.8235, 37.33878], [-121.82558, 37.33734], [-121.82566, 37.33737], [-121.82711, 37.33885]]]} | Open Access 1 | 16962 | Hillview Park | 19994 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 13.613 | Hillview Park | 1978 | Local Park 2 | 4 | |
11426 | 11426 | 11425 | {"type": "Polygon", "coordinates": [[[-117.72332, 33.5635], [-117.72297, 33.56336], [-117.72223, 33.56295], [-117.72187, 33.56267], [-117.72153, 33.56236], [-117.72132, 33.5621], [-117.72113, 33.56181], [-117.72104, 33.56147], [-117.72087, 33.56092], [-117.7207, 33.56059], [-117.7207, 33.56051], [-117.7206, 33.56017], [-117.72038, 33.55978], [-117.72018, 33.55956], [-117.71985, 33.5593], [-117.71958, 33.55916], [-117.71884, 33.55882], [-117.71903, 33.55868], [-117.7184, 33.55712], [-117.71842, 33.55691], [-117.71838, 33.55634], [-117.71839, 33.55617], [-117.71845, 33.55603], [-117.71842, 33.55601], [-117.71858, 33.55577], [-117.71876, 33.55579], [-117.71875, 33.55589], [-117.71927, 33.55597], [-117.7193, 33.55588], [-117.71994, 33.55599], [-117.71998, 33.55618], [-117.71981, 33.55721], [-117.71994, 33.55777], [-117.72054, 33.55825], [-117.7218, 33.56002], [-117.72219, 33.56026], [-117.72224, 33.56043], [-117.72228, 33.56042], [-117.72238, 33.56071], [-117.72252, 33.56116], [-117.72209, 33.56196], [-117.72211, 33.5622], [-117.72214, 33.56232], [-117.72234, 33.56265], [-117.72257, 33.5629], [-117.72257, 33.56293], [-117.72332, 33.5635]]]} | Open Access 1 | 22280 | Hillview Park | 19992 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 312 | Orange, County of 138 | County 3 | County Agency 3 | Orange 3 | 24.716 | Hillview Park | 0 | Local Park 2 | 4 | |
14050 | 14050 | 14049 | {"type": "Polygon", "coordinates": [[[-122.55648, 38.01214], [-122.55599, 38.01179], [-122.55595, 38.01168], [-122.55606, 38.01156], [-122.55608, 38.0116], [-122.5563, 38.01176], [-122.55648, 38.01214]]]} | Open Access 1 | 38051 | Hillview Park | 19995 | 1312 | San Rafael, City of 352 | City 2 | City Agency 2 | http://www.cityofsanrafael.org/comsvcs-home/ | City 2 | 1312 | San Rafael, City of 349 | City 2 | City Agency 2 | Marin 23 | 0.256 | Hillview 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]);