trees
27,746 rows where qCaretaker_id = 1 sorted by SiteOrder
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18098 | 259796 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 567 Somerset St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | 6010266.31037 | 2091928.95171 | 37.7246177539405 | -122.406657122403 | (37.7246177539405, -122.406657122403) | 10 | 3 | 7 | 309 | 28 | |||
| 18423 | 258374 | DPW Maintained 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 103 | 1009 Silliman St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 4x5 | 6007871.84523 | 2093420.07444 | 37.7285777984137 | -122.415040000813 | (37.7285777984137, -122.415040000813) | 9 | 3 | 7 | 309 | 5 | ||||
| 18448 | 260600 | DPW Maintained 1 | Tree(s) :: 17 | 1122 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014231.13861 | 2090181.46138 | 37.7200405252834 | -122.392828913667 | (37.7200405252834, -122.392828913667) | 10 | 3 | 8 | 58 | 1 | |||
| 18563 | 259805 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1249 Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | 6011760.82557 | 2089103.97372 | 37.71694444304 | -122.401292315923 | (37.71694444304, -122.401292315923) | 10 | 7 | 8 | 309 | 39 | |||
| 18737 | 258112 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 28 06th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5993962.87947 | 2115311.61201 | 37.7878948748238 | -122.464712734046 | (37.7878948748238, -122.464712734046) | 11 | 6 | 1 | 54 | 11 | ||||||
| 18741 | 260851 | DPW Maintained 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 625 33rd Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5985649.08401 | 2111623.73701 | 37.7772862197699 | -122.493204739608 | (37.7772862197699, -122.493204739608) | 11 | 6 | 2 | 55 | 26 | |||
| 18837 | 260887 | DPW Maintained 1 | Acer buergeranum :: Trident Maple 110 | 811 41st Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/18/2019 12:00:00 AM | 3 | 5983217.77071 | 2110265.58898 | 37.7734146368587 | -122.501514803752 | (37.7734146368587, -122.501514803752) | 11 | 6 | 2 | 55 | 26 | |||
| 18906 | 258110 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 639 Woolsey St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 4x5 | 6009897.96561 | 2091634.59657 | 37.723788900764 | -122.407909701204 | (37.723788900764, -122.407909701204) | 10 | 3 | 7 | 309 | 28 | ||||
| 19014 | 260601 | DPW Maintained 1 | Tree(s) :: 17 | 1142 Hollister Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6014128.86091 | 2090257.70792 | 37.7202442017659 | -122.393187787982 | (37.7202442017659, -122.393187787982) | 10 | 3 | 8 | 58 | 1 | |||
| 19114 | 259651 | DPW Maintained 1 | :: 45 | 598x Rutland St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
| 22150 | 91686 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 377 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007415.631785 | 2107493.688708 | 37.7671951252581 | -122.417614236777 | (37.7671951252581, -122.417614236777) | 8 | 4 | 7 | 28853 | 19 | |||
| 23171 | 109911 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1062X Carolina St | Median : Cutout | Tree | DPW 1 | 3x3 | 6012455.3 | 2103027.1 | 37.7552131559276 | -122.39986897476 | (37.7552131559276, -122.39986897476) | 10 | 3 | 8 | 28856 | 29 | |||||
| 23858 | 85447 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y13 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 24076 | 91328 | DPW Maintained 1 | Tree(s) :: 17 | 5089 Mission St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/05/2007 12:00:00 AM | 3x3 | 6000514.1536 | 2089460.50315 | 37.7172895061936 | -122.440192061387 | (37.7172895061936, -122.440192061387) | 9 | 7 | 6 | 28861 | 5 | ||||
| 29419 | 91588 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 400x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007384.392817 | 2107339.273033 | 37.7667693781679 | -122.417711341871 | (37.7667693781679, -122.417711341871) | 8 | 4 | 7 | 28853 | 19 | |||
| 34806 | 91741 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 2844 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008953.436672 | 2101893.072239 | 37.7519035204675 | -122.411899364623 | (37.7519035204675, -122.411899364623) | 2 | 4 | 7 | 28859 | 19 | |||
| 35939 | 91612 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1108 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007615.164408 | 2103191.40433 | 37.755393273338 | -122.416619275738 | (37.755393273338, -122.416619275738) | 2 | 4 | 7 | 28859 | 19 | |||
| 36068 | 91596 | DPW Maintained 1 | Ligustrum ovalifolium :: California privet 382 | 644 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6007464.720587 | 2105907.404981 | 37.7628423226144 | -122.41733201971 | (37.7628423226144, -122.41733201971) | 8 | 4 | 7 | 28859 | 19 | ||||
| 38921 | 91625 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1434 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007720.12849 | 2101296.976541 | 37.7501975073399 | -122.416122118115 | (37.7501975073399, -122.416122118115) | 2 | 4 | 7 | 28859 | 19 | |||
| 39867 | 91624 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1424 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007717.03025 | 2101352.89464 | 37.7503508716121 | -122.416136791792 | (37.7503508716121, -122.416136791792) | 2 | 4 | 7 | 28859 | 19 | |||
| 41289 | 124637 | DPW Maintained 1 | Ulmus pumila :: Siberian Elm 99 | 124 Arguello Blvd | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 31 | Width 5ft | 5995537.16304 | 2115311.02189 | 37.7879838891542 | -122.459265995172 | (37.7879838891542, -122.459265995172) | 11 | 6 | 1 | 54 | 31 | ||||
| 42600 | 91638 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1453 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007765.644065 | 2101198.536844 | 37.7499297732176 | -122.415957751819 | (37.7499297732176, -122.415957751819) | 2 | 4 | 7 | 28859 | 19 | |||
| 42885 | 92052 | DPW Maintained 1 | Betula nigra :: River Birch 361 | 2323 Cesar Chavez St | Sidewalk: Property side : Cutout | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
| 44768 | 85446 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y12 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 45380 | 91682 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 425 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007432.064539 | 2107206.199481 | 37.766406671896 | -122.417537020573 | (37.766406671896, -122.417537020573) | 8 | 4 | 7 | 28853 | 19 | |||
| 49387 | 91787 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 974 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6011579.201291 | 2111277.19318 | 37.7778171686355 | -122.403479195946 | (37.7778171686355, -122.403479195946) | 14 | 2 | 9 | 28856 | 34 | |||
| 50197 | 91660 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 999 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007618.393891 | 2103856.158531 | 37.7572187178563 | -122.416655196612 | (37.7572187178563, -122.416655196612) | 2 | 4 | 7 | 28859 | 19 | ||
| 53423 | 91645 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1300X South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007675.941296 | 2102071.044433 | 37.7523204379956 | -122.416329740365 | (37.7523204379956, -122.416329740365) | 2 | 4 | 7 | 28859 | 19 | |||
| 56651 | 91619 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1286 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007670.444381 | 2102173.036115 | 37.7526001749043 | -122.416355973027 | (37.7526001749043, -122.416355973027) | 2 | 4 | 7 | 28859 | 19 | |||
| 57032 | 91601 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 746 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007497.69689 | 2105311.935767 | 37.7612091575166 | -122.417175768763 | (37.7612091575166, -122.417175768763) | 2 | 4 | 7 | 28859 | 19 | |||
| 57396 | 106550 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 81 MINERVA ST | Median : Cutout | Tree | DPW 1 | 5996079.6 | 2088963.3 | 37.7156708325413 | -122.455484227095 | (37.7156708325413, -122.455484227095) | 9 | 8 | 6 | 28861 | 24 | ||||||
| 59684 | 91684 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 387 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007418.830408 | 2107437.729103 | 37.7670416532981 | -122.41759920657 | (37.7670416532981, -122.41759920657) | 8 | 4 | 7 | 28853 | 19 | ||
| 59988 | 91630 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1490x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007737.478632 | 2100983.83524 | 37.7493386674544 | -122.41603994665 | (37.7493386674544, -122.41603994665) | 2 | 4 | 7 | 28859 | 19 | |||
| 60318 | 91631 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1500 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007741.508083 | 2100911.11035 | 37.7491392078361 | -122.416020863166 | (37.7491392078361, -122.416020863166) | 2 | 4 | 7 | 28859 | 19 | |||
| 60767 | 91618 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1240 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007656.818859 | 2102429.616316 | 37.7533039196294 | -122.41642126514 | (37.7533039196294, -122.41642126514) | 2 | 4 | 7 | 28859 | 19 | |||
| 67006 | 91687 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 373 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007414.352338 | 2107516.072508 | 37.7672565139252 | -122.417620248867 | (37.7672565139252, -122.417620248867) | 8 | 4 | 7 | 28853 | 19 | |||
| 67599 | 91656 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1141 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007665.027497 | 2103014.499609 | 37.7549103375799 | -122.416434303552 | (37.7549103375799, -122.416434303552) | 2 | 4 | 7 | 28859 | 19 | |||
| 72089 | 92048 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2323 Cesar Chavez St | Front Yard : Yard | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
| 72192 | 85433 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y1 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 74482 | 91579 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 170 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/19/2013 01:09:00 PM | 3 | 3x3 | 6007322.882921 | 2108766.782992 | 37.7706855226421 | -122.418025303656 | (37.7706855226421, -122.418025303656) | 8 | 2 | 9 | 28853 | 19 | |||
| 76312 | 91803 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2989 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009039.569733 | 2101067.518808 | 37.7496415669707 | -122.411543181878 | (37.7496415669707, -122.411543181878) | 2 | 4 | 7 | 28859 | 19 | |||
| 76766 | 85437 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y4 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 77309 | 91657 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1133 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007662.546411 | 2103059.279009 | 37.7550331520704 | -122.416446055556 | (37.7550331520704, -122.416446055556) | 2 | 4 | 7 | 28859 | 19 | |||
| 79095 | 85444 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y10 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 81154 | 91654 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1169 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007673.711302 | 2102857.771696 | 37.7544804867979 | -122.416393171829 | (37.7544804867979, -122.416393171829) | 2 | 4 | 7 | 28859 | 19 | |||
| 82941 | 86366 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2585 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988608.756978 | 2097742.15426 | 37.7393438043798 | -122.481949268404 | (37.7393438043798, -122.481949268404) | 1 | 8 | 3 | 29491 | 35 | |||
| 84099 | 91688 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 349 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007406.675646 | 2107650.375519 | 37.7676248464865 | -122.417656321662 | (37.7676248464865, -122.417656321662) | 8 | 4 | 7 | 28853 | 19 | |||
| 84687 | 91615 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1176 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007636.253645 | 2102810.779435 | 37.754349350274 | -122.416519382003 | (37.754349350274, -122.416519382003) | 2 | 4 | 7 | 28859 | 19 | |||
| 84872 | 91623 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 1376 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/10/2014 12:00:00 AM | 3 | 3x3 | 6007700.506204 | 2101645.30329 | 37.751152830564 | -122.416214640532 | (37.751152830564, -122.416214640532) | 2 | 4 | 7 | 28859 | 19 | |||
| 87205 | 91675 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 637 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007502.174043 | 2105954.495988 | 37.7629737307137 | -122.41720581807 | (37.7629737307137, -122.41720581807) | 8 | 4 | 7 | 28859 | 19 | |||
| 88350 | 91701 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 101x South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007269.02291 | 2109328.047293 | 37.7722235898389 | -122.41825140648 | (37.7722235898389, -122.41825140648) | 8 | 2 | 9 | 28853 | 19 | |||
| 90022 | 91674 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 697 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007520.814164 | 2105617.901611 | 37.7620505693283 | -122.417117496488 | (37.7620505693283, -122.417117496488) | 8 | 4 | 7 | 28859 | 19 | |||
| 90765 | 113415 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 450 PORTOLA DR | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 5998094 | 2100018 | 37.7461398052423 | -122.449317577522 | (37.7461398052423, -122.449317577522) | 2 | 7 | 5 | 63 | 7 | ||||
| 91070 | 91801 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3071 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009060.650721 | 2100687.104692 | 37.7485982168729 | -122.4114434106 | (37.7485982168729, -122.4114434106) | 2 | 4 | 7 | 28859 | 19 | |||
| 92648 | 28968 | DPW Maintained 1 | Tree(s) :: 17 | 2455 Hyde St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6006975.5076786 | 2120876.6023829 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | 5 | 1 | 1 | 28858 | 32 | ||||||
| 94031 | 85448 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y14 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 94776 | 91627 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1468 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007730.662506 | 2101106.855019 | 37.7496760688109 | -122.416072228065 | (37.7496760688109, -122.416072228065) | 2 | 4 | 7 | 28859 | 19 | |||
| 96062 | 108035 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 945 Market St | unknown : Cutout | Tree | DPW 1 | 3x3 | Permit Number 774370 | 6010085.91267 | 2113154.0076 | 37.7828869372518 | -122.408777465126 | (37.7828869372518, -122.408777465126) | 14 | 2 | 9 | 28853 | 34 | ||||
| 96199 | 91639 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1435 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007760.067233 | 2101299.189418 | 37.7502058289413 | -122.415984163776 | (37.7502058289413, -122.415984163776) | 2 | 4 | 7 | 28859 | 19 | |||
| 96550 | 91587 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 362 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 4 | 3x3 | 6007371.2189 | 2107569.74946 | 37.7674014710001 | -122.417773246729 | (37.7674014710001, -122.417773246729) | 8 | 4 | 7 | 28853 | 19 | |||
| 96901 | 85439 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y5 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 100115 | 91632 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1540 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007748.949212 | 2100776.810346 | 37.748770868614 | -122.415985622241 | (37.748770868614, -122.415985622241) | 2 | 4 | 7 | 28859 | 19 | |||
| 107166 | 91802 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2997 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009042.060032 | 2101022.818937 | 37.7495189707644 | -122.411531412589 | (37.7495189707644, -122.411531412589) | 2 | 4 | 7 | 28859 | 19 | |||
| 107246 | 91840 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 895x Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6012119.593271 | 2111738.315629 | 37.7791134735728 | -122.401642199835 | (37.7791134735728, -122.401642199835) | 6 | 2 | 9 | 28856 | 34 | |||
| 108205 | 91655 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1155 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007669.369399 | 2102936.135663 | 37.7546954122234 | -122.416413737633 | (37.7546954122234, -122.416413737633) | 2 | 4 | 7 | 28859 | 19 | |||
| 108600 | 92051 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2323 Cesar Chavez St | Front Yard : Cutout | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
| 109129 | 85445 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y11 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 111192 | 85440 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y6 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/22/2007 12:00:00 AM | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 111765 | 91613 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1116 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 10 | 3x3 | 6007617.645495 | 2103146.62493 | 37.7552704588724 | -122.416607523387 | (37.7552704588724, -122.416607523387) | 2 | 4 | 7 | 28859 | 19 | |||
| 113755 | 85435 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y3 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 08/07/2006 12:00:00 AM | 3 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | ||
| 116463 | 85443 | - 12 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 360Y9 Valencia St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 6 | 4x4 | 6005797.96455 | 2107491.19806 | 37.7670971272034 | -122.423209339646 | (37.7670971272034, -122.423209339646) | 8 | 4 | 5 | 28853 | 19 | |||
| 117185 | 98714 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 500X Brotherhood Way | Front Yard : Yard | Tree | DPW 1 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | ||||||
| 120273 | 86364 | DPW Maintained 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2523 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/2006 12:00:00 AM | 3 | 3x3 | 5988594.809589 | 2098144.989885 | 37.7404490746159 | -122.482026994296 | (37.7404490746159, -122.482026994296) | 1 | 8 | 3 | 29491 | 35 | |||
| 125863 | 92049 | DPW Maintained 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 18 | 2323 Cesar Chavez St | Front Yard : Yard | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
| 127070 | 254844 | Undocumented 4 | Callistemon viminalis :: Weeping Bottlebrush 60 | 475 Arkansas St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/29/2018 12:00:00 AM | 3 | 3x3 | 6013011 | 2104854 | 37.7602603887437 | -122.398075345371 | (37.7602603887437, -122.398075345371) | 10 | 3 | 8 | 28856 | 29 | ||
| 127698 | 257930 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1000X Hudson Ave | Unaccepted Street : Cutout | Tree | DPW 1 | 3x3 | 6018755 | 2095128 | 37.7338730033489 | -122.377534379141 | (37.7338730033489, -122.377534379141) | 10 | 3 | 8 | 58 | 1 | |||||
| 128361 | 91689 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 335 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007402.197577 | 2107728.718925 | 37.7678397070843 | -122.417677364286 | (37.7678397070843, -122.417677364286) | 8 | 4 | 7 | 28853 | 19 | |||
| 128961 | 91690 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 315 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007395.800334 | 2107840.638089 | 37.7681466508094 | -122.417707425394 | (37.7681466508094, -122.417707425394) | 8 | 4 | 7 | 28853 | 19 | |||
| 129945 | 91693 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 253 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007399.603267 | 2108201.969765 | 37.7691389965346 | -122.417719885805 | (37.7691389965346, -122.417719885805) | 8 | 4 | 7 | 28853 | 19 | |||
| 132267 | 91658 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1073 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007642.630657 | 2103418.725072 | 37.7560189888407 | -122.416540390694 | (37.7560189888407, -122.416540390694) | 2 | 4 | 7 | 28859 | 19 | |||
| 133771 | 91586 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 356 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007369.299728 | 2107603.325202 | 37.7674935541002 | -122.417782265097 | (37.7674935541002, -122.417782265097) | 8 | 4 | 7 | 28853 | 19 | |||
| 135561 | 91626 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1450 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007725.085674 | 2101207.507592 | 37.749952124518 | -122.416098640357 | (37.749952124518, -122.416098640357) | 2 | 4 | 7 | 28859 | 19 | |||
| 139468 | 91692 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 263 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007399.273892 | 2108147.255986 | 37.7689887468538 | -122.417717146452 | (37.7689887468538, -122.417717146452) | 8 | 4 | 7 | 28853 | 19 | |||
| 139882 | 91608 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 918 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 7 | 3x3 | 6007553.688973 | 2104300.922411 | 37.758436297925 | -122.416910482813 | (37.758436297925, -122.416910482813) | 2 | 4 | 7 | 28859 | 19 | |||
| 140083 | 29905 | DPW Maintained 1 | Acacia melanoxylon :: Blackwood Acacia 70 | 580 Fell St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004657.19551 | 2110576.88809 | 37.7755052392808 | -122.427374927138 | (37.7755052392808, -122.427374927138) | 7 | 9 | 11 | 28852 | 10 | ||||
| 141211 | 90459 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 798X 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988218.04709 | 2110585.29029 | 37.7745848539829 | -122.484241800238 | (37.7745848539829, -122.484241800238) | 11 | 6 | 2 | 55 | 26 | |||
| 142131 | 91614 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1140 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 3 | 3x3 | 6007588 | 2102997 | 37.7548579556474 | -122.416699447347 | (37.7548579556474, -122.416699447347) | 2 | 4 | 7 | 28859 | 19 | |||
| 143544 | 29903 | DPW Maintained 1 | Tree(s) :: 17 | 750 San Jose Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6005639.13550214 | 2098758.44315121 | 37.7431100472957 | -122.423137910761 | (37.7431100472957, -122.423137910761) | 2 | 7 | 5 | 28859 | 22 | ||||||
| 143745 | 91737 | DPW Maintained 1 | Pistacia chinensis :: Chinese Pistache 32 | 3050 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009013.94236 | 2100807.207547 | 37.7489253726566 | -122.411613412745 | (37.7489253726566, -122.411613412745) | 2 | 4 | 7 | 28859 | 19 | |||
| 145660 | 91669 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 765 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 6 | 3x3 | 6007543.215311 | 2105213.393874 | 37.7609411449227 | -122.417011357225 | (37.7609411449227, -122.417011357225) | 2 | 4 | 7 | 28859 | 19 | |||
| 145883 | 251439 | DPW Maintained 1 | Gleditsia triacanthos :: Honey Locust 182 | 49X Eddy St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010285 | 2113564 | 37.7840238283003 | -122.408117626865 | (37.7840238283003, -122.408117626865) | 14 | 2 | 9 | 28852 | 36 | |||||
| 146054 | 92047 | DPW Maintained 1 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2323 Cesar Chavez St | Sidewalk: Property side : Yard | Tree | DPW 1 | 05/16/2009 12:00:00 AM | 6012395.863444 | 2100936.77011 | 37.7494702500338 | -122.399927744224 | (37.7494702500338, -122.399927744224) | 10 | 3 | 8 | 58 | 1 | |||||
| 146289 | 90462 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 776 25th Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2008 12:00:00 AM | 3 | 3x3 | 5988213.55131 | 2110700.55151 | 37.774901067359 | -122.484265806793 | (37.774901067359, -122.484265806793) | 11 | 6 | 2 | 55 | 26 | |||
| 146709 | 254547 | Permitted Site 7 | Lagunaria patersonii :: Primrose Tree 6 | 2908 Bush St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 02/26/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781446 | 5999588.42992 | 2114352.40043 | 37.7855838475934 | -122.445180440387 | (37.7855838475934, -122.445180440387) | 15 | 6 | 1 | 29490 | 31 | |
| 149994 | 91642 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1383 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 5 | 3x3 | 6007742.379122 | 2101613.996265 | 37.7510692229497 | -122.41606762223 | (37.7510692229497, -122.41606762223) | 2 | 4 | 7 | 28859 | 19 | |||
| 150760 | 116066 | DPW Maintained 1 | Fraxinus spp :: Ash Spp 121 | 40 MALTA DR | Median : Cutout | Tree | DPW 1 | 10 | 5999623 | 2096071 | 37.7353896244756 | -122.443746996044 | (37.7353896244756, -122.443746996044) | 9 | 7 | 4 | 63 | 40 | |||||
| 152782 | 104960 | Permitted Site 7 | :: 45 | 2895 San Bruno Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6011715.1 | 2091289.8 | 37.7229437265236 | -122.401603910944 | (37.7229437265236, -122.401603910944) | 10 | 3 | 7 | 309 | 28 | ||||||
| 153570 | 91807 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2859 Harrison St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008997.743306 | 2101817.227115 | 37.7516977523567 | -122.411740786814 | (37.7516977523567, -122.411740786814) | 2 | 4 | 7 | 28859 | 19 | |||
| 155550 | 91589 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 442 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 8 | 3x3 | 6007397.135958 | 2107116.333394 | 37.7661579552478 | -122.417651462281 | (37.7661579552478, -122.417651462281) | 8 | 4 | 7 | 28853 | 19 | |||
| 158272 | 91620 | DPW Maintained 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 | 1290 South Van Ness Ave | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/01/2007 12:00:00 AM | 9 | 3x3 | 6007671.629207 | 2102150.724826 | 37.7525389797951 | -122.41635029552 | (37.7525389797951, -122.41635029552) | 2 | 4 | 7 | 28859 | 19 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );