units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, AGNCY_TYP = 2, MNG_AGENCY = 32 and YR_EST = 2000
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1811 | 1811 | 1810 | {"type": "Polygon", "coordinates": [[[-121.87893, 37.28067], [-121.87888, 37.28071], [-121.87872, 37.28064], [-121.87863, 37.28065], [-121.87791, 37.28092], [-121.87784, 37.28092], [-121.87762, 37.28056], [-121.87756, 37.28043], [-121.87735, 37.28009], [-121.87731, 37.27998], [-121.87714, 37.27971], [-121.87707, 37.27964], [-121.87688, 37.27961], [-121.87685, 37.27954], [-121.87753, 37.27925], [-121.87773, 37.27952], [-121.87841, 37.28024], [-121.87893, 37.28067]]]} | Open Access 1 | 13741 | Rubino Park | 24723 | 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 | 3.22 | Rubino Park | 2000 | Local Park 2 | 4 | |
2304 | 2304 | 2303 | {"type": "Polygon", "coordinates": [[[-121.81025, 37.29897], [-121.80953, 37.29949], [-121.80862, 37.29863], [-121.80923, 37.29804], [-121.81025, 37.29897]]]} | Open Access 1 | 16998 | Dovehill Park | 18251 | 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 | 2.74 | Dovehill Park | 2000 | Local Park 2 | 4 | |
8609 | 8609 | 8608 | {"type": "Polygon", "coordinates": [[[-121.80696, 37.24034], [-121.80916, 37.24033], [-121.8093, 37.24037], [-121.80943, 37.24045], [-121.8095, 37.24056], [-121.80952, 37.24062], [-121.80952, 37.24073], [-121.80948, 37.24083], [-121.80941, 37.24091], [-121.80932, 37.24097], [-121.80915, 37.24101], [-121.80714, 37.24103], [-121.8071, 37.24101], [-121.80708, 37.24098], [-121.80705, 37.24075], [-121.8069, 37.24041], [-121.80691, 37.24037], [-121.80696, 37.24034]]]} | Open Access 1 | 13710 | Palmia Park | 23355 | 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 | 4.026 | Palmia Park | 2000 | Local Park 2 | 4 | |
8615 | 8615 | 8614 | {"type": "Polygon", "coordinates": [[[-121.79774, 37.31556], [-121.79746, 37.31561], [-121.79725, 37.31561], [-121.79714, 37.31564], [-121.79702, 37.31563], [-121.7968, 37.31557], [-121.79672, 37.31551], [-121.7966, 37.31539], [-121.79659, 37.31526], [-121.7967, 37.31504], [-121.79674, 37.315], [-121.79682, 37.31496], [-121.79681, 37.31491], [-121.79679, 37.31489], [-121.79665, 37.31485], [-121.79646, 37.31485], [-121.79638, 37.31484], [-121.79623, 37.31479], [-121.79599, 37.31458], [-121.79592, 37.31449], [-121.79585, 37.31445], [-121.79573, 37.31442], [-121.79558, 37.31434], [-121.7955, 37.31427], [-121.79544, 37.31418], [-121.79539, 37.31414], [-121.79533, 37.31412], [-121.79512, 37.3141], [-121.79508, 37.31409], [-121.79505, 37.31404], [-121.79506, 37.31394], [-121.79502, 37.31388], [-121.79496, 37.31382], [-121.7948, 37.31374], [-121.79475, 37.31367], [-121.79543, 37.31358], [-121.79546, 37.31378], [-121.79614, 37.31418], [-121.79694, 37.31401], [-121.79722, 37.31397], [-121.79711, 37.31413], [-121.79706, 37.31424], [-121.79703, 37.31441], [-121.79705, 37.31456], [-121.79709, 37.31464], [-121.79742, 37.31517], [-121.79763, 37.31546], [-121.79774, 37.31556]]]} | Open Access 1 | 13754 | Aborn Park | 15237 | 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 | 4.601 | Aborn Park | 2000 | 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]);