superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1, MNG_AG_TYP = 2 and YR_EST = 2003
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
487 | 487 | 486 | {"type": "Polygon", "coordinates": [[[-122.36754, 37.72678], [-122.36734, 37.727], [-122.36723, 37.72694], [-122.36712, 37.72698], [-122.36703, 37.72705], [-122.36698, 37.72714], [-122.36697, 37.72723], [-122.36708, 37.7273], [-122.36688, 37.72752], [-122.36589, 37.72698], [-122.36647, 37.72634], [-122.36666, 37.72629], [-122.36754, 37.72678]]]} | Open Access 1 | Hillpoint Park | https://www.cmgsite.com/project/hunters-point-parks-hillside-central-park-hillpoint-park-and-innes-court-park/ | 33507 | 2290 | San Francisco, City and County of, Redevelopment Agency 788 | City 2 | City Agency 2 | http://www.sfredevelopment.org/index.aspx?page=104 | City 2 | 2.471 | Hillpoint Park | 2003 |
4658 | 4658 | 4657 | {"type": "Polygon", "coordinates": [[[-121.90425, 37.27304], [-121.90248, 37.27381], [-121.90212, 37.2733], [-121.90195, 37.27299], [-121.9018, 37.27278], [-121.90185, 37.27276], [-121.90187, 37.27272], [-121.90189, 37.27269], [-121.90188, 37.27264], [-121.90273, 37.27242], [-121.90265, 37.27222], [-121.90297, 37.27213], [-121.90314, 37.27251], [-121.90375, 37.27236], [-121.90425, 37.27304]]]} | Open Access 1 | Kirk Park | 20677 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 5.329 | Kirk Park | 2003 | |
5300 | 5300 | 5299 | {"type": "Polygon", "coordinates": [[[-121.89793, 37.31439], [-121.89792, 37.31475], [-121.89747, 37.31474], [-121.89748, 37.31438], [-121.89793, 37.31439]]]} | Open Access 1 | Hummingbird Park | 20150 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.388 | Hummingbird Park | 2003 | |
7534 | 7534 | 7533 | {"type": "MultiPolygon", "coordinates": [[[[-121.91295, 37.32069], [-121.91197, 37.32074], [-121.91197, 37.32068], [-121.91209, 37.32069], [-121.91213, 37.3206], [-121.91223, 37.3205], [-121.91235, 37.32046], [-121.91247, 37.32044], [-121.9126, 37.32046], [-121.91268, 37.3205], [-121.91275, 37.32056], [-121.91282, 37.32065], [-121.91294, 37.32064], [-121.91295, 37.32069]]], [[[-121.9129, 37.32142], [-121.91239, 37.32141], [-121.91205, 37.32142], [-121.91202, 37.32096], [-121.9129, 37.32092], [-121.9129, 37.32142]]]]} | Open Access 1 | O'Connor Park | 22945 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1.412 | O'Connor Park | 2003 | |
10511 | 10511 | 10510 | {"type": "Polygon", "coordinates": [[[-121.8406, 37.32362], [-121.84058, 37.32366], [-121.84013, 37.32397], [-121.83978, 37.32364], [-121.83981, 37.32356], [-121.83978, 37.32348], [-121.84018, 37.32321], [-121.84058, 37.32358], [-121.8406, 37.32362]]]} | Open Access 1 | Turtle Rock Park | 26596 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 0.851 | Turtle Rock Park | 2003 | |
11061 | 11061 | 11060 | {"type": "Polygon", "coordinates": [[[-121.85647, 37.27809], [-121.85645, 37.2782], [-121.85641, 37.2783], [-121.85628, 37.27849], [-121.8561, 37.27863], [-121.85589, 37.27872], [-121.85573, 37.27876], [-121.85558, 37.27877], [-121.8545, 37.27877], [-121.85445, 37.27874], [-121.85445, 37.27809], [-121.85647, 37.27809]]]} | Open Access 1 | Waterford Park | 27300 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 2.996 | Waterford Park | 2003 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);