units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where DES_TP = 2, MNG_AG_TYP = 2 and YR_EST = 2003
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1813 | 1813 | 1812 | {"type": "Polygon", "coordinates": [[[-121.85647, 37.27809], [-121.85646, 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 | 13748 | Waterford Park | 27300 | 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.997 | Waterford Park | 2003 | Local Park 2 | 4 | |
5253 | 5253 | 5252 | {"type": "Polygon", "coordinates": [[[-121.84018, 37.32321], [-121.84058, 37.32359], [-121.8406, 37.32362], [-121.84058, 37.32366], [-121.84013, 37.32397], [-121.83978, 37.32364], [-121.83982, 37.32356], [-121.83978, 37.32348], [-121.84018, 37.32321]]]} | Open Access 1 | 1720 | Turtle Rock Park | 26596 | 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.851 | Turtle Rock Park | 2003 | Local Park 2 | 4 | |
5575 | 5575 | 5574 | {"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 | 48781 | Hillpoint Park | 33507 | 2290 | San Francisco, City and County of, Redevelopment Agency 809 | City 2 | City Agency 2 | http://www.sfredevelopment.org/index.aspx?page=104 | City 2 | 2290 | San Francisco, City and County of, Redevelopment Agency 788 | City 2 | City Agency 2 | https://www.cmgsite.com/project/hunters-point-parks-hillside-central-park-hillpoint-park-and-innes-court-park/ | San Francisco 13 | 2.47 | Hillpoint Park | 2003 | Local Park 2 | 4 |
8597 | 8597 | 8596 | {"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 | 13675 | Hummingbird Park | 20150 | 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.388 | Hummingbird Park | 2003 | Local Park 2 | 4 | |
8599 | 8599 | 8598 | {"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.90274, 37.27241], [-121.90265, 37.27222], [-121.90297, 37.27213], [-121.90313, 37.27252], [-121.90375, 37.27236], [-121.90425, 37.27304]]]} | Open Access 1 | 13681 | Kirk Park | 20677 | 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 | 5.323 | Kirk Park | 2003 | Local Park 2 | 4 | |
8608 | 8608 | 8607 | {"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.91281, 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 | 13701 | O'Connor Park | 22945 | 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 | 1.412 | O'Connor Park | 2003 | 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]);