units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, DES_TP = 2, MNG_AG_TYP = 2 and YR_EST = 1985
This data as json, copyable, CSV (advanced)
These facets timed out: DES_TP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453 | 453 | 452 | {"type": "Polygon", "coordinates": [[[-122.12673, 37.40193], [-122.12661, 37.40184], [-122.12648, 37.40197], [-122.12604, 37.40189], [-122.12565, 37.40208], [-122.12556, 37.40226], [-122.12552, 37.40242], [-122.1254, 37.40246], [-122.12533, 37.40254], [-122.12512, 37.40323], [-122.12444, 37.40294], [-122.1239, 37.40228], [-122.12396, 37.40223], [-122.12422, 37.40168], [-122.12432, 37.40153], [-122.12442, 37.40133], [-122.12661, 37.40112], [-122.12673, 37.40193]]]} | Open Access 1 | 1453 | Terman Park | 26250 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | Santa Clara 19 | 7.663 | Terman Park | 1985 | Local Park 2 | 4 | |
1999 | 1999 | 1998 | {"type": "Polygon", "coordinates": [[[-121.82582, 37.2727], [-121.82555, 37.27295], [-121.82555, 37.27309], [-121.82505, 37.2734], [-121.82524, 37.2741], [-121.82307, 37.27331], [-121.82274, 37.2722], [-121.82283, 37.27213], [-121.82287, 37.27199], [-121.82297, 37.27176], [-121.823, 37.27172], [-121.82304, 37.27172], [-121.82351, 37.27185], [-121.82582, 37.2727]]]} | Open Access 1 | 15311 | Danna Rock Park | 17921 | 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 | 9.56 | Danna Rock Park | 1985 | Local Park 2 | 4 | |
8538 | 8538 | 8537 | {"type": "Polygon", "coordinates": [[[-122.02209, 37.39289], [-122.02121, 37.39553], [-122.02121, 37.39564], [-122.02125, 37.39572], [-122.02114, 37.39605], [-122.01914, 37.39562], [-122.01932, 37.3955], [-122.01936, 37.39536], [-122.0193, 37.39526], [-122.01933, 37.39512], [-122.01922, 37.39508], [-122.01936, 37.39468], [-122.02007, 37.39483], [-122.02037, 37.39391], [-122.02043, 37.3939], [-122.02074, 37.39298], [-122.02073, 37.39296], [-122.02023, 37.39286], [-122.02009, 37.39284], [-122.02004, 37.39286], [-122.01987, 37.39279], [-122.01983, 37.39272], [-122.01984, 37.39261], [-122.01991, 37.39243], [-122.02209, 37.39289]]]} | Open Access 1 | 13433 | Columbia Park | 17546 | 1345 | Sunnyvale, City of 419 | City 2 | City Agency 2 | http://sunnyvale.ca.gov/Departments/CommunityServices/Parks.aspx | City 2 | 1345 | Sunnyvale, City of 413 | City 2 | City Agency 2 | Santa Clara 19 | 12.727 | Columbia Park | 1985 | Local Park 2 | 4 | |
8549 | 8549 | 8548 | {"type": "Polygon", "coordinates": [[[-122.29224, 37.5137], [-122.29177, 37.51383], [-122.29167, 37.5136], [-122.29124, 37.51373], [-122.29101, 37.51321], [-122.29192, 37.51294], [-122.29224, 37.5137]]]} | Open Access 1 | 13485 | Barrett Park | 15832 | 1025 | Belmont, City of 198 | City 2 | City Agency 2 | http://www.belmont.gov/city-hall/park-and-recreation | City 2 | 1025 | Belmont, City of 194 | City 2 | City Agency 2 | San Mateo 15 | 1.589 | Barrett Park | 1985 | Local Park 2 | 4 | |
8553 | 8553 | 8552 | {"type": "Polygon", "coordinates": [[[-122.34875, 37.57389], [-122.34862, 37.57404], [-122.34775, 37.5738], [-122.34734, 37.57365], [-122.34762, 37.57306], [-122.34768, 37.57305], [-122.34773, 37.57307], [-122.34875, 37.57389]]]} | Open Access 1 | 13514 | Pershing Park | 23617 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 1.525 | Pershing Park | 1985 | Local Park 2 | 4 | |
9664 | 9664 | 9663 | {"type": "Polygon", "coordinates": [[[-121.96605, 37.3077], [-121.96589, 37.30789], [-121.96586, 37.30806], [-121.96586, 37.3084], [-121.96581, 37.30846], [-121.96575, 37.30848], [-121.96447, 37.30856], [-121.96429, 37.30857], [-121.96425, 37.30855], [-121.96423, 37.30853], [-121.96423, 37.3085], [-121.96434, 37.30655], [-121.96605, 37.30654], [-121.96605, 37.3077]]]} | Open Access 1 | 16294 | Starbird Park | 25802 | 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 | 8.149 | Starbird Park | 1985 | Local Park 2 | 4 | |
10641 | 10641 | 10640 | {"type": "Polygon", "coordinates": [[[-121.81329, 37.2961], [-121.81329, 37.29614], [-121.81326, 37.29617], [-121.813, 37.29628], [-121.8123, 37.29672], [-121.81215, 37.29673], [-121.81209, 37.29676], [-121.81183, 37.29657], [-121.8116, 37.29678], [-121.81166, 37.29689], [-121.81147, 37.29697], [-121.8112, 37.29654], [-121.81095, 37.296], [-121.81176, 37.29608], [-121.81177, 37.29603], [-121.81215, 37.29608], [-121.81219, 37.29596], [-121.81212, 37.29593], [-121.81214, 37.2958], [-121.81162, 37.29575], [-121.81164, 37.29567], [-121.81144, 37.29564], [-121.81136, 37.29534], [-121.8115, 37.29542], [-121.81162, 37.29542], [-121.81168, 37.29539], [-121.81192, 37.2952], [-121.81204, 37.29513], [-121.81297, 37.29488], [-121.81301, 37.29489], [-121.81304, 37.29493], [-121.81321, 37.29533], [-121.81324, 37.29546], [-121.81325, 37.29588], [-121.81329, 37.2961]]]} | Open Access 1 | 18969 | Ramblewood Park | 24107 | 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 | 6.423 | Ramblewood Park | 1985 | 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]);