units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
8 rows where ACCESS_TYP = 1, DES_TP = 2 and YR_EST = 2002
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7694 | 7694 | 7693 | {"type": "Polygon", "coordinates": [[[-121.75463, 37.93253], [-121.75397, 37.93253], [-121.75318, 37.93094], [-121.75369, 37.93096], [-121.75381, 37.93109], [-121.75385, 37.93149], [-121.75395, 37.93166], [-121.7541, 37.93184], [-121.75449, 37.93215], [-121.75463, 37.93253]]]} | Open Access 1 | 11438 | Rolling Hills Park | 24577 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 2.083 | Rolling Hills Park | 2002 | Local Park 2 | 4 | |
7695 | 7695 | 7694 | {"type": "Polygon", "coordinates": [[[-121.75553, 37.92537], [-121.75553, 37.92537], [-121.75551, 37.92742], [-121.75396, 37.92632], [-121.75395, 37.92535], [-121.75553, 37.92537]]]} | Open Access 1 | 11449 | Balfour Guthrie Park | 15783 | 1034 | Brentwood, City of 351 | City 2 | City Agency 2 | http://www.brentwoodca.gov/gov/parks/default.asp | City 2 | 1034 | Brentwood, City of 348 | City 2 | City Agency 2 | Contra Costa 12 | 5.691 | Balfour Guthrie Park | 2002 | Local Park 2 | 4 | |
8748 | 8748 | 8747 | {"type": "Polygon", "coordinates": [[[-122.23545, 38.1614], [-122.23492, 38.16177], [-122.23451, 38.16159], [-122.23496, 38.16096], [-122.23508, 38.1609], [-122.23525, 38.16116], [-122.23545, 38.1614]]]} | Open Access 1 | 14211 | Via Bellagio Park | 27064 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 0.994 | Via Bellagio Park | 2002 | Local Park 2 | 4 | |
8749 | 8749 | 8748 | {"type": "Polygon", "coordinates": [[[-122.23961, 38.16213], [-122.23949, 38.16217], [-122.23924, 38.16215], [-122.23903, 38.161], [-122.23897, 38.16087], [-122.23885, 38.16084], [-122.2387, 38.1609], [-122.23836, 38.16091], [-122.23805, 38.16085], [-122.23818, 38.16039], [-122.23853, 38.16034], [-122.23912, 38.15992], [-122.23936, 38.16091], [-122.23961, 38.16213]]]} | Open Access 1 | 14213 | Montecarlo Park | 22408 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 2.979 | Montecarlo Park | 2002 | Local Park 2 | 4 | |
8795 | 8795 | 8794 | {"type": "Polygon", "coordinates": [[[-122.38728, 37.60488], [-122.3869, 37.60509], [-122.38641, 37.60455], [-122.38679, 37.60433], [-122.38728, 37.60488]]]} | Open Access 1 | 14307 | Bayside Manor Park | 15895 | 1205 | Millbrae, City of 404 | City 2 | City Agency 2 | http://www.ci.millbrae.ca.us/ | City 2 | 1205 | Millbrae, City of 398 | City 2 | City Agency 2 | San Mateo 15 | 0.76 | Bayside Manor Park | 2002 | Local Park 2 | 4 | |
9293 | 9293 | 9292 | {"type": "Polygon", "coordinates": [[[-122.33272, 37.80548], [-122.33211, 37.80596], [-122.33226, 37.80633], [-122.33185, 37.80641], [-122.33188, 37.80651], [-122.33128, 37.80669], [-122.33018, 37.80715], [-122.32968, 37.8073], [-122.32911, 37.80741], [-122.32832, 37.80746], [-122.32745, 37.80745], [-122.32667, 37.8074], [-122.3259, 37.8073], [-122.32262, 37.80667], [-122.32252, 37.80661], [-122.3225, 37.80656], [-122.32252, 37.80613], [-122.32248, 37.80579], [-122.32237, 37.80541], [-122.32221, 37.80509], [-122.32267, 37.8052], [-122.32518, 37.79906], [-122.32546, 37.79913], [-122.32636, 37.79902], [-122.32644, 37.79904], [-122.32645, 37.79907], [-122.32628, 37.79949], [-122.32631, 37.79952], [-122.32664, 37.79961], [-122.32677, 37.79957], [-122.32693, 37.79919], [-122.32697, 37.79918], [-122.33, 37.79996], [-122.33008, 37.80006], [-122.33021, 37.80017], [-122.33009, 37.80036], [-122.32992, 37.80033], [-122.32948, 37.80032], [-122.32946, 37.80037], [-122.32976, 37.80065], [-122.32963, 37.80074], [-122.32919, 37.80054], [-122.32896, 37.80052], [-122.32854, 37.80054], [-122.32832, 37.8005], [-122.32818, 37.80045], [-122.32772, 37.80021], [-122.32734, 37.80005], [-122.32673, 37.80033], [-122.32556, 37.80009], [-122.32521, 37.80008], [-122.32516, 37.80009], [-122.32511, 37.80012], [-122.32506, 37.80029], [-122.325, 37.80041], [-122.3248, 37.80067], [-122.32458, 37.80125], [-122.32513, 37.80139], [-122.3251, 37.80146], [-122.32462, 37.80136], [-122.32456, 37.80152], [-122.32456, 37.80169], [-122.32449, 37.80192], [-122.32441, 37.80235], [-122.32443, 37.80279], [-122.32452, 37.80305], [-122.325, 37.80315], [-122.32498, 37.80323], [-122.32462, 37.80316], [-122.32455, 37.80323], [-122.32451, 37.80332], [-122.32449, 37.80342], [-122.3245, 37.8035], [-122.32462, 37.80375], [-122.32496, 37.80462], [-122.32512, 37.80509], [-122.32523, 37.80511], [-122.32525, 37.8051], [-122.32588, 37.80523], [-122.32591, 37.80516], [-122.32639, 37.80526], [-122.32649, 37.80535], [-122.32648, 37.80545], [-122.32494, 37.80666], [-122.32494, 37.80667], [-122.32508, 37.80676], [-122.32539, 37.80685], [-122.32628, 37.80702], [-122.32662, 37.80695], [-122.32665, 37.80696], [-122.32668, 37.807], [-122.32667, 37.80709], [-122.32669, 37.80713], [-122.32672, 37.80716], [-122.32677, 37.80718], [-122.32685, 37.80716], [-122.32692, 37.8071], [-122.32701, 37.80706], [-122.32735, 37.80717], [-122.3277, 37.80724], [-122.32806, 37.80728], [-122.32842, 37.80729], [-122.32873, 37.80726], [-122.32925, 37.80717], [-122.32985, 37.8071], [-122.33004, 37.80705], [-122.33049, 37.80684], [-122.33078, 37.80673], [-122.33098, 37.80662], [-122.33119, 37.80646], [-122.33129, 37.80642], [-122.3314, 37.8064], [-122.33161, 37.80624], [-122.33156, 37.80618], [-122.3326, 37.80538], [-122.33272, 37.80548]]]} | Open Access 1 | 15481 | Middle Harbor Shoreline Park | 22208 | 2286 | Port of Oakland 907 | Special District 4 | Port/Harbor District 15 | http://www.portofoakland.com/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Alameda 17 | 41.418 | Middle Harbor Shoreline Park | 2002 | Local Park 2 | 4 | |
9636 | 9636 | 9635 | {"type": "MultiPolygon", "coordinates": [[[[-122.46304, 37.49846], [-122.46257, 37.4993], [-122.46263, 37.50003], [-122.45814, 37.50031], [-122.45789, 37.50012], [-122.46102, 37.49766], [-122.46304, 37.49846]]], [[[-122.46299, 37.49613], [-122.46315, 37.49627], [-122.46327, 37.49635], [-122.46384, 37.49663], [-122.46402, 37.49673], [-122.46465, 37.49723], [-122.46594, 37.49809], [-122.46709, 37.4987], [-122.46721, 37.49881], [-122.46731, 37.49897], [-122.46741, 37.4993], [-122.4674, 37.49937], [-122.46738, 37.49941], [-122.46732, 37.49945], [-122.46726, 37.49948], [-122.46719, 37.49948], [-122.46712, 37.49947], [-122.4615, 37.49729], [-122.46299, 37.49613]]], [[[-122.46738, 37.49855], [-122.46727, 37.49867], [-122.46709, 37.49855], [-122.46607, 37.49801], [-122.46476, 37.49713], [-122.46412, 37.49663], [-122.46395, 37.49653], [-122.46336, 37.49625], [-122.46321, 37.49615], [-122.4631, 37.49605], [-122.46335, 37.49585], [-122.46362, 37.49607], [-122.46376, 37.4962], [-122.46398, 37.49639], [-122.46424, 37.49655], [-122.46439, 37.49669], [-122.46455, 37.49681], [-122.46482, 37.49695], [-122.46537, 37.49727], [-122.46576, 37.49758], [-122.4661, 37.49781], [-122.46644, 37.49802], [-122.46701, 37.4983], [-122.46738, 37.49855]]]]} | Open Access 1 | 16263 | Mirada Surf Park | 22282 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | San Mateo 15 | 36.504 | Mirada Surf Park | 2002 | Local Park 2 | 4 | |
11391 | 11391 | 11390 | {"type": "Polygon", "coordinates": [[[-117.7296, 33.61084], [-117.72904, 33.61171], [-117.72886, 33.61162], [-117.7291, 33.61125], [-117.72915, 33.61116], [-117.72917, 33.61105], [-117.72915, 33.6109], [-117.7296, 33.61084]]]} | Open Access 1 | 48087 | City Centre Park | 32589 | 1694 | Laguna Woods, City of 974 | City 2 | City Agency 2 | http://www.lagunawoodscity.org/ | City 2 | 1694 | Laguna Woods, City of 939 | City 2 | City Agency 2 | Orange 3 | 0.545 | City Centre Park | 2002 | 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]);