Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1101 | 1101 | 251439 | DPW Maintained 3 | Gleditsia triacanthos :: Honey Locust 67 | 49X Eddy St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6010285.0 | 2113564.0 | 37.78402382830029 | -122.408117626865 | (37.7840238283003, -122.408117626865) | |||||
| 5008 | 5008 | 253723 | DPW Maintained 3 | Calocedrus decurrens :: Incense Cedar 177 | 1X Glenview Dr | Median : Yard 3 | Tree 1 | DPW 2 | 3x3 | 5998487.0 | 2100314.0 | 37.746975021233204 | -122.447979947083 | (37.7469750212332, -122.447979947083) | |||||
| 18679 | 18679 | 86291 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 1339 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/05/2006 12:00:00 AM | 3 | 3x3 | 5988318.888394 | 2106196.850699 | 37.7625412799726 | -122.483571174333 | (37.7625412799726, -122.483571174333) | |||
| 20263 | 20263 | 91677 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 599 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007489.042117 | 2106191.6259580003 | 37.763624095672895 | -122.417268041752 | (37.7636240956729, -122.417268041752) | |||
| 20297 | 20297 | 87411 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 898X Ellis St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/22/2008 12:00:00 AM | 3 | 3x3 | 6006570.640875 | 2113589.260791 | 37.783884515657896 | -122.42096977598499 | (37.7838845156579, -122.420969775985) | |||
| 37397 | 37397 | 91640 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1427 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007757.588641 | 2101343.9238919998 | 37.7503285203588 | -122.415995902486 | (37.7503285203588, -122.415995902486) | |||
| 40857 | 40857 | 124637 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 124 Arguello Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 31 | Width 5ft | 5995537.16304 | 2115311.02189 | 37.787983889154205 | -122.459265995172 | (37.7879838891542, -122.459265995172) | ||||
| 58727 | 58727 | 110212 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2978 CESAR CHAVEZ ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x4 | 6009700.7 | 2100638.5 | 37.7485006383082 | -122.409226689451 | (37.7485006383082, -122.409226689451) | ||||
| 61152 | 61152 | 90191 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1860X Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989777.17693 | 2111298.4454200002 | 37.776633638000604 | -122.478900695137 | (37.7766336380006, -122.478900695137) | |||
| 69881 | 69881 | 91641 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1401X South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007749.533216001 | 2101489.31094 | 37.750727267460604 | -122.416034053567 | (37.7507272674606, -122.416034053567) | |||
| 72151 | 72151 | 91659 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1015 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007624.666917 | 2103742.941155 | 37.7569082017019 | -122.4166254819 | (37.7569082017019, -122.4166254819) | |||
| 77431 | 77431 | 91612 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1108 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007615.164408 | 2103191.40433 | 37.755393273338 | -122.41661927573799 | (37.755393273338, -122.416619275738) | |||
| 78616 | 78616 | 106550 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 81 MINERVA ST | Median : Cutout 11 | Tree 1 | DPW 2 | 5996079.6 | 2088963.3 | 37.7156708325413 | -122.455484227095 | (37.7156708325413, -122.455484227095) | ||||||
| 78890 | 78890 | 91625 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1434 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007720.12849 | 2101296.976541 | 37.7501975073399 | -122.41612211811501 | (37.7501975073399, -122.416122118115) | |||
| 79028 | 79028 | 91619 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1286 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007670.444381 | 2102173.036115 | 37.7526001749043 | -122.416355973027 | (37.7526001749043, -122.416355973027) | |||
| 80121 | 80121 | 91624 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1424 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007717.03025 | 2101352.89464 | 37.7503508716121 | -122.416136791792 | (37.7503508716121, -122.416136791792) | |||
| 81296 | 81296 | 91645 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1300X South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007675.941296 | 2102071.044433 | 37.7523204379956 | -122.41632974036501 | (37.7523204379956, -122.416329740365) | |||
| 82097 | 82097 | 91787 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 974 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011579.2012910005 | 2111277.19318 | 37.7778171686355 | -122.403479195946 | (37.7778171686355, -122.403479195946) | |||
| 82418 | 82418 | 91638 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1453 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007765.644065 | 2101198.5368439998 | 37.7499297732176 | -122.415957751819 | (37.7499297732176, -122.415957751819) | |||
| 82540 | 82540 | 91660 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 999 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007618.393891 | 2103856.158531 | 37.7572187178563 | -122.416655196612 | (37.7572187178563, -122.416655196612) | ||
| 82883 | 82883 | 92052 | DPW Maintained 3 | Betula nigra :: River Birch 266 | 2323 Cesar Chavez St | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 84040 | 84040 | 91682 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 425 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007432.064539 | 2107206.199481 | 37.766406671896 | -122.41753702057301 | (37.766406671896, -122.417537020573) | |||
| 84319 | 84319 | 91601 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 746 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007497.69689 | 2105311.9357669996 | 37.7612091575166 | -122.417175768763 | (37.7612091575166, -122.417175768763) | |||
| 84625 | 84625 | 91618 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1240 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007656.818859 | 2102429.616316 | 37.753303919629396 | -122.41642126514 | (37.7533039196294, -122.41642126514) | |||
| 84656 | 84656 | 92048 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2323 Cesar Chavez St | Front Yard : Yard 7 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 85554 | 85554 | 91631 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1500 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007741.508083 | 2100911.11035 | 37.7491392078361 | -122.41602086316601 | (37.7491392078361, -122.416020863166) | |||
| 85635 | 85635 | 91684 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 387 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007418.830408 | 2107437.729103 | 37.7670416532981 | -122.41759920657 | (37.7670416532981, -122.41759920657) | ||
| 87505 | 87505 | 91656 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1141 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007665.027497 | 2103014.499609 | 37.7549103375799 | -122.416434303552 | (37.7549103375799, -122.416434303552) | |||
| 89955 | 89955 | 91579 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 170 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2013 01:09:00 PM | 3 | 3x3 | 6007322.882921 | 2108766.7829919998 | 37.770685522642104 | -122.41802530365601 | (37.7706855226421, -122.418025303656) | |||
| 90023 | 90023 | 91687 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 373 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007414.352337999 | 2107516.0725080003 | 37.767256513925204 | -122.417620248867 | (37.7672565139252, -122.417620248867) | |||
| 90256 | 90256 | 91630 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1490x South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007737.478632 | 2100983.83524 | 37.7493386674544 | -122.41603994665 | (37.7493386674544, -122.41603994665) | |||
| 91587 | 91587 | 91627 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1468 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007730.662506 | 2101106.855019 | 37.7496760688109 | -122.41607222806499 | (37.7496760688109, -122.416072228065) | |||
| 91691 | 91691 | 91674 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 697 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007520.814164 | 2105617.901611 | 37.762050569328295 | -122.417117496488 | (37.7620505693283, -122.417117496488) | |||
| 91710 | 91710 | 113415 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 450 PORTOLA DR | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 5998094.0 | 2100018.0 | 37.746139805242294 | -122.449317577522 | (37.7461398052423, -122.449317577522) | ||||
| 92055 | 92055 | 91657 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1133 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007662.546411 | 2103059.279009 | 37.755033152070396 | -122.416446055556 | (37.7550331520704, -122.416446055556) | |||
| 92240 | 92240 | 28968 | DPW Maintained 3 | Tree(s) :: 17 | 2455 Hyde St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6006975.507678599 | 2120876.6023828997 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | ||||||
| 92340 | 92340 | 91615 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1176 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007636.253645 | 2102810.779435 | 37.754349350274 | -122.416519382003 | (37.754349350274, -122.416519382003) | |||
| 92666 | 92666 | 91654 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1169 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007673.711302 | 2102857.771696 | 37.7544804867979 | -122.416393171829 | (37.7544804867979, -122.416393171829) | |||
| 92853 | 92853 | 91675 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 637 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007502.174043 | 2105954.495988 | 37.7629737307137 | -122.41720581806999 | (37.7629737307137, -122.41720581807) | |||
| 93249 | 93249 | 91701 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 101x South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007269.02291 | 2109328.047293 | 37.7722235898389 | -122.41825140648001 | (37.7722235898389, -122.41825140648) | |||
| 94128 | 94128 | 91801 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 3071 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009060.650721 | 2100687.104692 | 37.7485982168729 | -122.4114434106 | (37.7485982168729, -122.4114434106) | |||
| 94992 | 94992 | 91623 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 1376 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/10/2014 12:00:00 AM | 3 | 3x3 | 6007700.506204 | 2101645.30329 | 37.751152830563996 | -122.416214640532 | (37.751152830564, -122.416214640532) | |||
| 95283 | 95283 | 91688 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 349 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007406.675646 | 2107650.375519 | 37.7676248464865 | -122.41765632166201 | (37.7676248464865, -122.417656321662) | |||
| 96142 | 96142 | 86366 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2585 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988608.756978 | 2097742.1542599997 | 37.7393438043798 | -122.48194926840401 | (37.7393438043798, -122.481949268404) | |||
| 98203 | 98203 | 91803 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2989 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009039.569733 | 2101067.5188080003 | 37.7496415669707 | -122.41154318187799 | (37.7496415669707, -122.411543181878) | |||
| 98888 | 98888 | 91655 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1155 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007669.369399 | 2102936.135663 | 37.7546954122234 | -122.416413737633 | (37.7546954122234, -122.416413737633) | |||
| 99090 | 99090 | 91802 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2997 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009042.060032 | 2101022.818937 | 37.7495189707644 | -122.411531412589 | (37.7495189707644, -122.411531412589) | |||
| 101275 | 101275 | 91587 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 362 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 4 | 3x3 | 6007371.2189 | 2107569.74946 | 37.7674014710001 | -122.417773246729 | (37.7674014710001, -122.417773246729) | |||
| 101594 | 101594 | 91632 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1540 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007748.949212001 | 2100776.810346 | 37.748770868614 | -122.415985622241 | (37.748770868614, -122.415985622241) | |||
| 101874 | 101874 | 91639 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1435 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007760.067233 | 2101299.189418 | 37.7502058289413 | -122.415984163776 | (37.7502058289413, -122.415984163776) | |||
| 102637 | 102637 | 107643 | DPW Maintained 3 | Tree(s) :: 17 | 455 ATHENS ST | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | FUF 1 | 4x4 | 6003769.0 | 2090659.8 | 37.720767283734105 | -122.429027043999 | (37.7207672837341, -122.429027043999) | ||||
| 102871 | 102871 | 91840 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 895x Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012119.593271 | 2111738.3156290003 | 37.7791134735728 | -122.401642199835 | (37.7791134735728, -122.401642199835) | |||
| 103678 | 103678 | 108035 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 945 Market St | unknown : Cutout 12 | Tree 1 | DPW 2 | 3x3 | Permit Number 774370 | 6010085.9126699995 | 2113154.0076 | 37.782886937251796 | -122.408777465126 | (37.7828869372518, -122.408777465126) | ||||
| 103688 | 103688 | 92051 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 103888 | 103888 | 91613 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1116 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007617.645494999 | 2103146.62493 | 37.7552704588724 | -122.416607523387 | (37.7552704588724, -122.416607523387) | |||
| 105455 | 105455 | 91689 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 335 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007402.197577 | 2107728.718925 | 37.7678397070843 | -122.417677364286 | (37.7678397070843, -122.417677364286) | |||
| 107166 | 107166 | 98714 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 500X Brotherhood Way | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5992573.4 | 2087955.0 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | ||||||
| 107265 | 107265 | 86364 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2523 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988594.8095889995 | 2098144.989885 | 37.740449074615896 | -122.48202699429599 | (37.7404490746159, -122.482026994296) | |||
| 107985 | 107985 | 92049 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2323 Cesar Chavez St | Front Yard : Yard 7 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 108111 | 108111 | 91658 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1073 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007642.630657 | 2103418.725072 | 37.7560189888407 | -122.41654039069401 | (37.7560189888407, -122.416540390694) | |||
| 108300 | 108300 | 91690 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 315 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007395.800334 | 2107840.638089 | 37.7681466508094 | -122.417707425394 | (37.7681466508094, -122.417707425394) | |||
| 109400 | 109400 | 91693 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 253 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007399.603267 | 2108201.969765 | 37.7691389965346 | -122.417719885805 | (37.7691389965346, -122.417719885805) | |||
| 110148 | 110148 | 92047 | DPW Maintained 3 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 2323 Cesar Chavez St | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 05/16/2009 12:00:00 AM | 6012395.8634440005 | 2100936.77011 | 37.749470250033795 | -122.399927744224 | (37.7494702500338, -122.399927744224) | |||||
| 110632 | 110632 | 91626 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1450 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007725.085674 | 2101207.5075919996 | 37.749952124517996 | -122.41609864035699 | (37.749952124518, -122.416098640357) | |||
| 111227 | 111227 | 91642 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1383 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007742.379122 | 2101613.996265 | 37.7510692229497 | -122.41606762223 | (37.7510692229497, -122.41606762223) | |||
| 112236 | 112236 | 29903 | DPW Maintained 3 | Tree(s) :: 17 | 750 San Jose Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6005639.13550214 | 2098758.44315121 | 37.7431100472957 | -122.423137910761 | (37.7431100472957, -122.423137910761) | ||||||
| 113030 | 113030 | 91608 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 918 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007553.688973 | 2104300.922411 | 37.758436297925 | -122.416910482813 | (37.758436297925, -122.416910482813) | |||
| 113049 | 113049 | 91692 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 263 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007399.273891999 | 2108147.255986 | 37.76898874685379 | -122.417717146452 | (37.7689887468538, -122.417717146452) | |||
| 113358 | 113358 | 91737 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 3050 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009013.94236 | 2100807.207547 | 37.7489253726566 | -122.411613412745 | (37.7489253726566, -122.411613412745) | |||
| 113695 | 113695 | 91586 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 356 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007369.299728 | 2107603.325202 | 37.767493554100206 | -122.417782265097 | (37.7674935541002, -122.417782265097) | |||
| 114360 | 114360 | 90462 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 776 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988213.55131 | 2110700.5515099997 | 37.774901067358996 | -122.484265806793 | (37.774901067359, -122.484265806793) | |||
| 114739 | 114739 | 91669 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 765 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007543.215311 | 2105213.3938740003 | 37.760941144922704 | -122.417011357225 | (37.7609411449227, -122.417011357225) | |||
| 114778 | 114778 | 29905 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 Fell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | ||||
| 116300 | 116300 | 91614 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1140 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007588.0 | 2102997.0 | 37.754857955647395 | -122.41669944734699 | (37.7548579556474, -122.416699447347) | |||
| 116389 | 116389 | 91807 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2859 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008997.743306 | 2101817.227115 | 37.7516977523567 | -122.41174078681401 | (37.7516977523567, -122.411740786814) | |||
| 116453 | 116453 | 90459 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 798X 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988218.0470900005 | 2110585.2902900004 | 37.774584853982894 | -122.484241800238 | (37.7745848539829, -122.484241800238) | |||
| 116506 | 116506 | 116066 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 40 MALTA DR | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | 5999623.0 | 2096071.0 | 37.7353896244756 | -122.44374699604401 | (37.7353896244756, -122.443746996044) | |||||
| 117494 | 117494 | 107817 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 501X BROTHERHOOD WAY | unknown : Yard 19 | Tree 1 | DPW 2 | 5991892.0 | 2087849.0 | 37.712370053151204 | -122.469877266524 | (37.7123700531512, -122.469877266524) | ||||||
| 118341 | 118341 | 91785 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1020 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011200.069593 | 2110914.857315 | 37.7768010945018 | -122.40476523573601 | (37.7768010945018, -122.404765235736) | |||
| 119782 | 119782 | 91620 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1290 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007671.629207 | 2102150.7248259997 | 37.752538979795105 | -122.41635029552 | (37.7525389797951, -122.41635029552) | |||
| 120900 | 120900 | 91611 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1086 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007607.027989 | 2103338.253155 | 37.755796029043395 | -122.416657816418 | (37.7557960290434, -122.416657816418) | |||
| 122298 | 122298 | 91018 | DPW Maintained 3 | Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 125 | 95 McCoppin St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/17/2008 12:00:00 AM | 3 | 3x3 | 6006069.437314 | 2109106.791352 | 37.771548477703 | -122.422385159744 | (37.771548477703, -122.422385159744) | |||
| 122357 | 122357 | 90461 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 780 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988213.85738 | 2110673.16421 | 37.774825887299 | -122.484262739051 | (37.774825887299, -122.484262739051) | |||
| 122667 | 122667 | 100169 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 180X Manchester St | Back Yard : Yard 13 | Tree 1 | DPW 2 | Adjacent to rear of property - DPW parcel | 6008242.0 | 2099158.0 | 37.7443536844995 | -122.414166136282 | (37.7443536844995, -122.414166136282) | |||||
| 122798 | 122798 | 91589 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 442 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007397.135958 | 2107116.333394 | 37.7661579552478 | -122.417651462281 | (37.7661579552478, -122.417651462281) | |||
| 123640 | 123640 | 91806 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 2945 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009025.873083999 | 2101313.36822 | 37.7503158463726 | -122.411607913685 | (37.7503158463726, -122.411607913685) | |||
| 123835 | 123835 | 90460 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 786 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988216.47669 | 2110650.29112 | 37.7747632366882 | -122.484252000581 | (37.7747632366882, -122.484252000581) | |||
| 123845 | 123845 | 29902 | DPW Maintained 3 | Tree(s) :: 17 | 1716 Divisadero St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6001149.68281092 | 2114264.52722613 | 37.785431561169794 | -122.439772670022 | (37.7854315611698, -122.439772670022) | ||||||
| 123948 | 123948 | 29904 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 580 Fell St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | ||||||
| 125111 | 125111 | 91686 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 377 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007415.631785 | 2107493.6887080004 | 37.767195125258105 | -122.417614236777 | (37.7671951252581, -122.417614236777) | |||
| 126115 | 126115 | 91596 | DPW Maintained 3 | Ligustrum ovalifolium :: California privet 284 | 644 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6007464.720587 | 2105907.4049810003 | 37.7628423226144 | -122.41733201971 | (37.7628423226144, -122.41733201971) | ||||
| 126859 | 126859 | 91741 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2844 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008953.436672 | 2101893.072239 | 37.7519035204675 | -122.411899364623 | (37.7519035204675, -122.411899364623) | |||
| 127204 | 127204 | 91588 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 400x South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007384.392817 | 2107339.273033 | 37.76676937816789 | -122.417711341871 | (37.7667693781679, -122.417711341871) | |||
| 128087 | 128087 | 91328 | DPW Maintained 3 | Tree(s) :: 17 | 5089 Mission St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/05/2007 12:00:00 AM | 3x3 | 6000514.1536 | 2089460.50315 | 37.7172895061936 | -122.44019206138701 | (37.7172895061936, -122.440192061387) | ||||
| 128796 | 128796 | 109911 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1062X Carolina St | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476001 | (37.7552131559276, -122.39986897476) | |||||
| 138527 | 138527 | 91786 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 966 Harrison St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/21/2010 12:00:00 AM | 3 | 3x3 | 6011627.6734110005 | 2111323.517939 | 37.777947073022105 | -122.403314772772 | (37.7779470730221, -122.403314772772) | |||
| 138704 | 138704 | 91592 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 590 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 5 | 3x3 | Permit Number 776895 | 6007446.6064019995 | 2106234.50211 | 37.7637394360724 | -122.41741785273899 | (37.7637394360724, -122.417417852739) | ||
| 139205 | 139205 | 90190 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 1844 Balboa St | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2008 12:00:00 AM | 3 | 3x3 | 5989791.50296 | 2111298.5559400003 | 37.7766347733354 | -122.47885114584801 | (37.7766347733354, -122.478851145848) | |||
| 139358 | 139358 | 91644 | DPW Maintained 3 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 1343 South Van Ness Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007729.450223001 | 2101838.0705560003 | 37.7516837533185 | -122.41612819935499 | (37.7516837533185, -122.416128199355) | |||
| 139726 | 139726 | 98721 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 700X Brotherhood Way | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5991178.9 | 2088065.4 | 37.7129229890255 | -122.47235769727399 | (37.7129229890255, -122.472357697274) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");