units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 1994
This data as json, copyable, CSV (advanced)
MNG_AGENCY 3
DES_TP 2
- Local Park 4
- None 1
MNG_AG_TYP 1
- City Agency · 5 ✖
ACCESS_TYP 1
- Open Access · 5 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6581 | 6581 | 6580 | {"type": "Polygon", "coordinates": [[[-117.32673, 34.02481], [-117.32567, 34.02481], [-117.32567, 34.02308], [-117.32673, 34.02308], [-117.32673, 34.02481]]]} | Open Access 1 | 3921 | Pico Park | 23654 | 1123 | Grand Terrace, City of 165 | City 2 | City Agency 2 | http://www.cityofgrandterrace.org/index.aspx?nid=25 | City 2 | 1123 | Grand Terrace, City of 161 | City 2 | City Agency 2 | http://www.grandterrace-ca.gov/pico-park.html | San Bernardino 22 | 4.643 | Pico Park | 1994 | Local Park 2 | 4 |
6582 | 6582 | 6581 | {"type": "Polygon", "coordinates": [[[-117.31061, 34.03019], [-117.30828, 34.03018], [-117.30829, 34.02846], [-117.31057, 34.02846], [-117.31061, 34.03019]]]} | Open Access 1 | 3922 | Richard Rollins Park | 24324 | 1123 | Grand Terrace, City of 165 | City 2 | City Agency 2 | http://www.cityofgrandterrace.org/index.aspx?nid=25 | City 2 | 1123 | Grand Terrace, City of 161 | City 2 | City Agency 2 | http://www.grandterrace-ca.gov/richard-rollins-park.html | San Bernardino 22 | 10.069 | Richard Rollins Park | 1994 | Local Park 2 | 4 |
7822 | 7822 | 7821 | {"type": "Polygon", "coordinates": [[[-121.76143, 37.31313], [-121.76078, 37.31323], [-121.76083, 37.31318], [-121.7608, 37.31299], [-121.76085, 37.31282], [-121.76091, 37.31279], [-121.76098, 37.31279], [-121.76143, 37.31313]]]} | Open Access 1 | 9062 | Pocket Park No. 16 | 23825 | 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 | 0.382 | PP No. 16 | 1994 | Local Park 2 | 4 | |
8328 | 8328 | 8327 | {"type": "Polygon", "coordinates": [[[-122.04698, 37.55463], [-122.04598, 37.55528], [-122.04556, 37.55507], [-122.04627, 37.55424], [-122.04698, 37.55463]]]} | Open Access 1 | 12813 | Eucalyptus Grove Park (North) | 18736 | 1221 | Newark, City of 377 | City 2 | City Agency 2 | http://www.ci.newark.ca.us/departments/recreation-and-community-services/parks/ | City 2 | 1221 | Newark, City of 372 | City 2 | City Agency 2 | Alameda 17 | 1.657 | Eucalyptus Grove Park (North) | 1994 | None 693 | ||
16403 | 16403 | 16402 | {"type": "Polygon", "coordinates": [[[-121.7745, 37.32534], [-121.77408, 37.32537], [-121.77333, 37.32544], [-121.77339, 37.32537], [-121.77346, 37.32538], [-121.77353, 37.32535], [-121.77356, 37.32537], [-121.7743, 37.3253], [-121.77434, 37.32527], [-121.77441, 37.3253], [-121.77448, 37.32529], [-121.7745, 37.32534]]]} | Open Access 1 | 9115 | Pocket Park No. 21 | 23831 | 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 | 0.155 | PP No. 21 | 1994 | 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]);