home / trees

Street_Tree_List

Data source: data.sfgov.org

3,192 rows where qSpecies = 49

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts, Zip Codes

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
215 100211 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 701 Rhode Island St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/23/2012 12:00:00 AM 1   Permit Number 769013 6011855.60136 2105068.89592 37.7607860251716 -122.40208645763799 (37.7607860251716, -122.402086457638) 10 3 8 28856 29
216 100212 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 701 Rhode Island St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1   Permit Number 769013 6011854.68115 2105077.88991 37.760810669307496 -122.40209027256901 (37.7608106693075, -122.402090272569) 10 3 8 28856 29
698 100780 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 450 Hayes St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/10/2012 12:00:00 AM     Permit Number 768934 6005678.7 2111113.4 37.7770360905223 -122.423879452899 (37.7770360905223, -122.423879452899) 7 9 11 28852 10
801 10090 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 707 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/09/2016 12:00:00 AM 3 2X2 Permit Number 777732 6005659.80497 2104809.7574 37.7597267272239 -122.423496559112 (37.7597267272239, -122.423496559112) 2 4 5 28859 19
824 100962 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 55 Hawthorne St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 Private 1 04/03/2013 12:00:00 AM 18 3x3 Permit Number 768706 6013015.61085 2114021.6260599997 37.7854328757839 -122.39870276924 (37.7854328757839, -122.39870276924) 6 2 9 28855 6
1069 101216 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 444 De Haro St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/03/2012 12:00:00 AM   3x3 Permit Number 769365 6011994.2 2106304.5 37.764186453503605 -122.401693953948 (37.7641864535036, -122.401693953948) 8 3 8 28856 29
1094 101250 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 737 Irving St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5993514.0 2106614.0 37.7639876770853 -122.465633627671 (37.7639876770853, -122.465633627671) 1 8 11 56 12
1306 101472 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 1X Melrose Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/05/2012 12:00:00 AM     Permit Number 768853 6000100.0 2095441.0 37.733686987275796 -122.442052627426 (37.7336869872758, -122.442052627426) 9 7 4 63 40
1490 101684 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 4054 20th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003246.0 2104197.0 37.757907704177704 -122.431800959125 (37.7579077041777, -122.431800959125) 2 4 5 28862 3
1507 101703 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 2700 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009810.4 2105505.4 37.7618702017999 -122.409190731152 (37.7618702017999, -122.409190731152) 8 4 8 28859 19
1508 101704 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 2700 18th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6009810.4 2105505.4 37.7618702017999 -122.409190731152 (37.7618702017999, -122.409190731152) 8 4 8 28859 19
1604 101840 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 654 Vermont St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/27/2012 12:00:00 AM 1 3x3 Permit Number 769499 6011223.03061 2105283.28605 37.761339365434395 -122.404289339783 (37.7613393654344, -122.404289339783) 10 3 8 28856 29
1855 102141 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 53 Wilder St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/24/2012 12:00:00 AM 3 2x3 Permit Number 769415 6002570.6 2095528.3 37.7340671770771 -122.433517283514 (37.7340671770771, -122.433517283514) 2 7 5 63 7
1856 102142 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 53 Wilder St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   12/24/2012 12:00:00 AM 5 2x3 Permit Number 769415 6002570.6 2095528.3 37.7340671770771 -122.433517283514 (37.7340671770771, -122.433517283514) 2 7 5 63 7
2080 102373 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 870 39th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3     1     5983890.730690001 2109977.48147 37.7726630776505 -122.499165683617 (37.7726630776505, -122.499165683617) 11 6 2 55 26
2081 102374 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 870 39th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3     2     5983888.78905 2110020.99125 37.7727824290992 -122.499175615397 (37.7727824290992, -122.499175615397) 11 6 2 55 26
2082 102375 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 870 39th Ave 5 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3     1     5983887.37527 2110050.4929400003 37.7728633493226 -122.499182686047 (37.7728633493226, -122.499182686047) 11 6 2 55 26
2222 102516 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1401X Steiner St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Rec/Park 3   01/28/2013 12:00:00 AM   4x4 Permit Number 768629 6002724.9 2113044.1 37.782170112299795 -122.434235614198 (37.7821701122998, -122.434235614198) 15 9 11 29490 41
2342 102649 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1845X Oakdale Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6013718.9 2096447.3 37.73721678059611 -122.39503820233601 (37.7372167805961, -122.395038202336) 10 3 8 58 1
2344 102650 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1845X Oakdale Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6013718.9 2096447.3 37.73721678059611 -122.39503820233601 (37.7372167805961, -122.395038202336) 10 3 8 58 1
3664 104096 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3666 104098 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3667 104099 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3670 104100 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3671 104101 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3672 104102 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3673 104103 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3674 104104 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3675 104105 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3676 104106 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3677 104107 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3678 104108 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 55X Clarence Pl 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.779581080700396 -122.39259103594802 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
3728 104178 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 801 JARBOE AVE 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 3x9   6008973.0 2096925.0 37.7382633878874 -122.411480752917 (37.7382633878874, -122.411480752917) 10 7 7 28859 2
3886 104377 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 868 Douglass St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6001252.8 2101329.2 37.7499202272654 -122.43848880009399 (37.7499202272654, -122.438488800094) 2 4 5 28862 22
3917 104418 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 1125 Cabrillo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2013 12:00:00 AM     Permit Number 770463 5992112.0 2110623.1 37.7749146251824 -122.47077473048 (37.7749146251824, -122.47077473048) 11 6 2 54 11
4236 104764 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 1855 08TH AVE   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10 2x4 Permit Number 770861 5993717.5 2102872.4 37.7537259496496 -122.46465807345601 (37.7537259496496, -122.464658073456) 1 8 4 56 12
4498 105049 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2835 Steiner St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/26/2014 12:00:00 AM 3 3x3 Permit Number 771766 6002046.080580001 2117916.60345 37.795510203784204 -122.436932952092 (37.7955102037842, -122.436932952092) 13 9 1 57 27
4569 105159 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 740 Noe St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13 3x3   6003006.6 2103935.0 37.7571747411483 -122.432610189818 (37.7571747411483, -122.432610189818) 2 4 5 28862 3
4586 105179 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1845X Oakdale Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     3 3x3   6013865.3937099995 2096317.18633 37.73686766051579 -122.394522594469 (37.7368676605158, -122.394522594469) 10 3 8 58 1
4728 105352 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2055 Union St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/16/2014 12:00:00 AM 1 3x3 Permit Number 768583 6003162.6 2118532.6 37.7972649672191 -122.433113640832 (37.7972649672191, -122.433113640832) 13 9 1 57 17
5009 105663 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 263 17th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x2   5990541.506469999 2113621.53342 37.783056548593 -122.476426424914 (37.783056548593, -122.476426424914) 11 6 2 55 26
5225 10597 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 385X 07th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     10 3X3   6010728.50062 2110559.72736 37.7757996213793 -122.40637151367399 (37.7757996213793, -122.406371513674) 14 2 9 28853 34
5236 10598 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 385X 07th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     9 3X3   6010728.50062 2110559.72736 37.7757996213793 -122.40637151367399 (37.7757996213793, -122.406371513674) 14 2 9 28853 34
5265 10601 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2749 Harrison St 2 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   06/01/1992 12:00:00 AM 6 3x3   6008971.05874 2102435.54315 37.7533940125469 -122.411876754419 (37.7533940125469, -122.411876754419) 2 4 7 28859 19
5274 106020 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 181 Buena Vista Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 771765 6001436.7 2108377.5 37.7692836023561 -122.438357764726 (37.7692836023561, -122.438357764726) 15 5 5 29492 9
5275 106021 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 181 Buena Vista Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2         Permit Number 771765 6001436.7 2108377.5 37.7692836023561 -122.438357764726 (37.7692836023561, -122.438357764726) 15 5 5 29492 9
5355 106117 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 405 Lisbon St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/24/2014 12:00:00 AM   3x3 Permit Number 772749 6002458.5 2091056.7 37.721782813937395 -122.433585385445 (37.7217828139374, -122.433585385445) 9 7 6 28861 5
5621 106426 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2919 Laguna St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   04/28/2014 12:00:00 AM 2 3x3 Permit Number 770060 6003851.7386 2118879.7612099997 37.798257249522 -122.430753834436 (37.798257249522, -122.430753834436) 13 9 1 57 17
5626 106446 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 900 Oak St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/02/2014 12:00:00 AM     Permit Number 771655 6002688.0 2109928.0 37.7736119859455 -122.434140441388 (37.7736119859455, -122.434140441388) 15 5 11 29492 10
5627 106447 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 900 Oak St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/02/2014 12:00:00 AM     Permit Number 771655 6002688.0 2109928.0 37.7736119859455 -122.434140441388 (37.7736119859455, -122.434140441388) 15 5 11 29492 10
5651 106472 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 101 Leland Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/01/2014 12:00:00 AM 3   Permit Number 772868 6010429.7 2087279.3 37.711859904289206 -122.405764940253 (37.7118599042892, -122.405764940253) 9 7 8 309 39
5792 106655 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 899X BRODERICK ST 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5 3x3   6000958.0 2111726.0 37.778450501705606 -122.440253723857 (37.7784505017056, -122.440253723857) 15 5 11 29490 41
5821 106691 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 12 CHATTANOOGA ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   6004659.5 2103503.6 37.7560838161182 -122.426863097691 (37.7560838161182, -122.426863097691) 2 4 5 28862 22
5887 10679 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1125 Hayes St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12 3X3   6002427.1981 2110540.5146 37.775278993428394 -122.43508641032301 (37.7752789934284, -122.435086410323) 15 5 11 29492 10
5896 10680 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1133 Hayes St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     6 3X3   6002410.4328 2110539.1175 37.7752742053449 -122.435144305311 (37.7752742053449, -122.435144305311) 15 5 11 29492 10
5906 10681 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1145 Hayes St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3X3   6002358.7398 2110530.7348 37.7752482530433 -122.435322523233 (37.7752482530433, -122.435322523233) 15 5 11 29492 10
5924 10684 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1161 Hayes St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   05/04/2010 12:00:00 AM 3 3X3   6002309.8411 2110524.4478 37.775228213443704 -122.435491224879 (37.7752282134437, -122.435491224879) 15 5 11 29492 10
5925 106842 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 230 02nd Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/11/2014 12:00:00 AM 1 3x3 Permit Number 770882 5995254.51721 2113999.80828 37.784367396402295 -122.460148860326 (37.7843673964023, -122.460148860326) 11 6 2 54 11
6043 106963 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2728 Union St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 Port 9   14     5999920.02374 2118149.14648 37.7960276377095 -122.444306168018 (37.7960276377095, -122.444306168018) 13 9 1 57 17
6080 107002 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 320 DUNCAN ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6004300.3 2099890.4 37.746142495461896 -122.427847885707 (37.7461424954619, -122.427847885707) 2 7 5 63 22
6123 107065 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1912 Lyon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   5999488.74187 2115560.69721 37.788895824140795 -122.44561225161301 (37.7888958241408, -122.445612251613) 13 6 1 29490 27
6157 107119 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 41 Elsie St   Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/31/2014 12:00:00 AM   3x3 Permit Number 773430 6007557.36556 2099188.16218 37.7443980238935 -122.41653560079901 (37.7443980238935, -122.416535600799) 2 7 7 28859 2
6296 10729 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 99 Ardath Ct 7 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   03/11/2006 12:00:00 AM 3 3X4   6017489.511071401 2095183.8764266002 37.73395662609639 -122.38191348672399 (37.7339566260964, -122.381913486724) 10 3 8 58 1
6450 107475 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 1099x Masonic Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   5999355.4 2109104.7 37.77116170781979 -122.445609151717 (37.7711617078198, -122.445609151717) 15 5 11 29492 9
6542 107579 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 100 Panama St 1 Sidewalk: Curb side : Yard 7 Tree 1 Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992416.91174 2086830.03613 37.7096025506984 -122.467988957943 (37.7096025506984, -122.467988957943) 9 8 4 64 24
6544 107580 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 100 Panama St 2 Sidewalk: Curb side : Yard 7 Tree 1 Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992406.39157 2086830.73395 37.709603859212706 -122.468025367885 (37.7096038592127, -122.468025367885) 9 8 4 64 24
6545 107581 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 100 Panama St 3 Sidewalk: Curb side : Yard 7 Tree 1 Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992393.946819999 2086830.9956900002 37.7096038591978 -122.46806839775299 (37.7096038591978, -122.468068397753) 9 8 4 64 24
6546 107582 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 100 Panama St 4 Sidewalk: Curb side : Yard 7 Tree 1 Private 2   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992337.55751 2086836.4734200002 37.7096156430274 -122.46826368552 (37.7096156430274, -122.46826368552) 9 8 4 64 24
6703 107778 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 3155 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/24/2014 12:00:00 AM 3 3x3 Permit Number 770908 6000890.09266 2119225.96368 37.7990395913723 -122.441026839613 (37.7990395913723, -122.441026839613) 13 9 1 57 17
6704 107779 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 3155 Scott St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/24/2014 12:00:00 AM 3 3x3 Permit Number 770908 6000890.66944 2119210.84486 37.798998111943604 -122.44102375853599 (37.7989981119436, -122.441023758536) 13 9 1 57 17
6706 107780 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 3155 Scott St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/24/2014 12:00:00 AM 3 3x3 Permit Number 770908 6000893.56163 2119195.20013 37.7989553203824 -122.441012627647 (37.7989553203824, -122.441012627647) 13 9 1 57 17
6707 107781 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 3155 Scott St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/24/2014 12:00:00 AM 3 3x3 Permit Number 770908 6000894.3565 2119181.32338 37.7989172637699 -122.441008881075 (37.7989172637699, -122.441008881075) 13 9 1 57 17
6788 107883 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4         6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6789 107884 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 2 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6790 107885 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 3 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6791 107886 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 4 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6792 107887 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 5 Sidewalk: Curb side : Cutout 2 Tree 1 SFUSD 4 DPW for City Agency 4 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6793 107888 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 941 Washington St 6 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1 SFUSD 8 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946771999 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
6935 108031 Undocumented 3 Ginkgo biloba :: Maidenhair Tree 49 330 DUNCAN ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       5x9   6004182.5 2099883.8 37.7461177086536 -122.42825475290199 (37.7461177086536, -122.428254752902) 2 7 5 63 22
6951 108047 Significant Tree 4 Ginkgo biloba :: Maidenhair Tree 49 1301 Evans Ave 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   06/12/2015 12:00:00 AM 3 3x3   6017036.144669999 2097442.01922 37.7401319873023 -122.383638088928 (37.7401319873023, -122.383638088928) 10 3 8 58 1
7039 108146 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 3322 Buchanan St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5     6003298.685 2119704.23273 37.800489685219 -122.432726491033 (37.800489685219, -122.432726491033) 13 9 1 57 17
7040 108147 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 3322 Buchanan St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   11/26/2014 12:00:00 AM 3   Permit Number 774253 6003296.86852 2119720.45859 37.800534134189 -122.43273393652399 (37.800534134189, -122.432733936524) 13 9 1 57 17
7041 108148 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 3322 Buchanan St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     5     6003294.68219 2119741.92969 37.8005929642463 -122.43274303675899 (37.8005929642463, -122.432743036759) 13 9 1 57 17
7063 108170 Private 7 Ginkgo biloba :: Maidenhair Tree 49 1645 ALABAMA ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   02/03/2015 12:00:00 AM 3 3x3 Permit Number 774689 6009348.4 2099893.7 37.7464358384441 -122.410392359276 (37.7464358384441, -122.410392359276) 2 7 7 28859 2
7082 108196 Significant Tree 4 Ginkgo biloba :: Maidenhair Tree 49 930 FLORIDA ST 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092) 2 4 7 28859 19
7264 108383 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 300X Franconia St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       2x3 Permit Number 773427 6010115.02759 2099226.1979 37.7446459697666 -122.4076943783 (37.7446459697666, -122.4076943783) 2 7 7 28859 2
7394 108516 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 695-699X 07th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773792 5993787.87218 2111075.28381 37.776252973902395 -122.46501042751899 (37.7762529739024, -122.465010427519) 11 6 2 54 11
7397 108519 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 1241 04th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/23/2014 12:00:00 AM 3 3x3 Permit Number 773665 5994833.54334 2107094.83383 37.7653839436153 -122.461104605949 (37.7653839436153, -122.461104605949) 15 5 11 56 12
7423 108542 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 225 Capistrano Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/24/2014 12:00:00 AM 3 3x3 Permit Number 773703 6001152.31796 2093187.75047 37.7275599956139 -122.43825309742901 (37.7275599956139, -122.438253097429) 9 7 6 28861 25
7472 108590 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 900x Newhall St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15 3x3   6015291.6077 2096931.09034 37.738632499980895 -122.38963436456001 (37.7386324999809, -122.38963436456) 10 3 8 58 1
7491 108607 Permitted Site 2 Ginkgo biloba :: Maidenhair Tree 49 1511 MASONIC AVE 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   03/06/2015 12:00:00 AM 3 3x3 Permit Number 774497 5999638.2 2107266.4 37.7661303401087 -122.44449879943998 (37.7661303401087, -122.44449879944) 15 5 5 29492 9
7506 108622 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 244 Scott St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 12/29/2014 12:00:00 AM 3   Permit Number 772819 6002313.92049 2109316.7536299997 37.7719124170473 -122.43539070428301 (37.7719124170473, -122.435390704283) 15 5 11 29492 9
7585 108698 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2922 Lyon St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 774622 5999117.98057 2118844.23155 37.7978903639015 -122.447131431372 (37.7978903639015, -122.447131431372) 13 9 1 57 17
7600 108710 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2000-2038X 17th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773095 6011387.70807 2106529.33414 37.764769934605205 -122.40380746863998 (37.7647699346052, -122.40380746864) 8 3 8 28853 20
7601 108711 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2000-2038X 17th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773095 6011373.53842 2106528.5170299998 37.7647668994048 -122.40385642054 (37.7647668994048, -122.40385642054) 8 3 8 28853 20
7602 108712 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 2000-2038X 17th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773095 6011359.92903 2106527.96496 37.7647646232249 -122.40390345328501 (37.7647646232249, -122.403903453285) 8 3 8 28853 20
7609 108719 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 479 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773098 6014398.610859999 2104906.56094 37.760481897828996 -122.393279892377 (37.760481897829, -122.393279892377) 10 3 8 28856 29
7610 108720 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 375 Rhode Island St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773094 6011766.25551 2106680.42507 37.765205936725295 -122.40250878917 (37.7652059367253, -122.40250878917) 8 3 8 28853 20
7611 108721 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 375 Rhode Island St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773094 6011766.2386 2106696.76782 37.76525080930121 -122.402509996945 (37.7652508093012, -122.402509996945) 8 3 8 28853 20
7612 108722 DPW Maintained 1 Ginkgo biloba :: Maidenhair Tree 49 375 Rhode Island St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2 FUF 2 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773094 6011765.777319999 2106711.15345 37.765290283256995 -122.402512604068 (37.765290283257, -122.402512604068) 8 3 8 28853 20

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 90.826ms · Data source: data.sfgov.org