Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 577 | 577 | 15499 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2704 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006991.0 | 2102555.0 | 37.7536107294676 | -122.41873270043001 | (37.7536107294676, -122.41873270043) | |||
| 578 | 578 | 239543 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007186.362369999 | 2097372.9446900003 | 37.7393929694044 | -122.41768982014798 | (37.7393929694044, -122.417689820148) | |
| 579 | 579 | 2702 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2121 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003192.7078 | 2114808.0993 | 37.7870401500361 | -122.432743262211 | (37.7870401500361, -122.432743262211) | |||
| 580 | 580 | 48268 | Permitted Site 1 | Tree(s) :: 17 | 132 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 581 | 581 | 240741 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007184.54991 | 2097351.72127 | 37.739334592605 | -122.41769458294901 | (37.739334592605, -122.417694582949) | |
| 583 | 583 | 7548 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 2882 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 5x5 | 6008321.80095 | 2101666.80438 | 37.751246783135 | -122.414067651319 | (37.751246783135, -122.414067651319) | |||
| 585 | 585 | 236679 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 682 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/2000 12:00:00 AM | 2 | Width 3ft | Permit Number 42634 | 6000886.69016 | 2100906.56017 | 37.7487389273654 | -122.43972452598301 | (37.7487389273654, -122.439724525983) | |
| 589 | 589 | 26916 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901 Geary Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 3X3 | 6002555.1851 | 2113680.9302 | 37.783909052953 | -122.43486830704398 | (37.783909052953, -122.434868307044) | |||
| 591 | 591 | 139532 | Permitted Site 1 | Magnolia spp :: Magnolia 89 | 2103 O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779818 | 6001200.3588 | 2113145.5057 | 37.7823618989571 | -122.439517100245 | (37.7823618989571, -122.439517100245) | |
| 597 | 597 | 251329 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 598 | 598 | 22577 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006373.00538 | 2112825.1930299997 | 37.7817754301315 | -122.421599237822 | (37.7817754301315, -122.421599237822) | |||
| 601 | 601 | 225172 | Permitted Site 1 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 248 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/02/2002 12:00:00 AM | 9 | Width 3ft | Permit Number 46150 | 6006535.621280001 | 2098220.1400900004 | 37.7416825381227 | -122.419999905071 | (37.7416825381227, -122.419999905071) | |
| 602 | 602 | 15498 | Permitted Site 1 | Washingtonia robusta :: Mexican Fan Palm 75 | 2704 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6007015.1629 | 2102569.9783 | 37.7536532168709 | -122.41865020170799 | (37.7536532168709, -122.418650201708) | |||
| 603 | 603 | 239542 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Bennington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 2.5x4 | Permit Number 779298 | 6007187.05082 | 2097389.73315 | 37.739439105535105 | -122.41768862942101 | (37.7394391055351, -122.417688629421) | |
| 604 | 604 | 171523 | Permitted Site 1 | Tree(s) :: 17 | 281 Harvard St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779632 | 6006304.03409 | 2092571.58308 | 37.7261597980302 | -122.420399821019 | (37.7261597980302, -122.420399821019) | |
| 607 | 607 | 65964 | Permitted Site 1 | Tree(s) :: 17 | 2655 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779612 | 5989236.70778952 | 2097278.67232438 | 37.738107703581704 | -122.479744212489 | (37.7381077035817, -122.479744212489) | |
| 609 | 609 | 13247 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2372X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 40 | 4x4 | 6001031.9779 | 2119351.2951 | 37.7993917986357 | -122.44054486433201 | (37.7993917986357, -122.440544864332) | ||
| 610 | 610 | 251327 | Permitted Site 1 | Tree(s) :: 17 | 95x Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2017 12:00:00 AM | 3x3 | Permit Number 779511 | 6007651.0 | 2096616.0 | 37.7373407014575 | -122.416029712695 | (37.7373407014575, -122.416029712695) | ||
| 612 | 612 | 23503 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2550 Van Ness Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6005820.29029 | 2119236.56275 | 37.7993482683535 | -122.42396743424999 | (37.7993482683535, -122.42396743425) | |||
| 615 | 615 | 2703 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 2123 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/06/1987 12:00:00 AM | 12 | 3X3 | 6003147.2203 | 2114799.0941 | 37.7870128441602 | -122.432899995096 | (37.7870128441602, -122.432899995096) | ||
| 617 | 617 | 57850 | Permitted Site 1 | Tree(s) :: 17 | 1700 S. Amaylett Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | Permit Number 16791 | ||||||||
| 621 | 621 | 251339 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 05/28/2012 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | ||
| 630 | 630 | 20157 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1100X Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 4X4 | 6002895.0285 | 2112125.5503 | 37.7796576600117 | -122.433581380876 | (37.7796576600117, -122.433581380876) | |||
| 632 | 632 | 44905 | Permitted Site 1 | Tree(s) :: 17 | 139 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 633 | 633 | 48204 | Permitted Site 1 | Tree(s) :: 17 | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 634 | 634 | 251340 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 638 | 638 | 251341 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 2275 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/14/1996 12:00:00 AM | 3x3 | Permit Number 37503 | 5992527.0 | 2093770.0 | 37.7286643609316 | -122.46811297163299 | (37.7286643609316, -122.468112971633) | ||
| 641 | 641 | 5315 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1820 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/1990 12:00:00 AM | 3 | 3X3 | 6001085.4403 | 2114655.5077 | 37.7865014360219 | -122.440022974412 | (37.7865014360219, -122.440022974412) | ||
| 649 | 649 | 96374 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1315 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/2011 12:00:00 AM | 8 | 3x3 | Permit Number 768288 | 6008916.2106800005 | 2117429.1962900003 | 37.7945599836999 | -122.41312655846599 | (37.7945599836999, -122.413126558466) | |
| 650 | 650 | 11111 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 2015 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2012 12:00:00 AM | 5 | 3x3 | 6007199.704059999 | 2119289.07559 | 37.7995702354477 | -122.419197895967 | (37.7995702354477, -122.419197895967) | ||
| 670 | 670 | 13108 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 1557 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3x3 | 6004929.5061 | 2119810.12 | 37.80087277869679 | -122.427090735634 | (37.8008727786968, -122.427090735634) | |||
| 671 | 671 | 225029 | Permitted Site 1 | Ficus nitida :: Laurel Fig 43 | 4543 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 17041 | 6000793.7951 | 2105198.47261 | 37.7605181908718 | -122.44035351451099 | (37.7605181908718, -122.440353514511) | |
| 672 | 672 | 23002 | Permitted Site 1 | Platanus racemosa :: California Sycamore 81 | 742 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/23/1994 12:00:00 AM | 20 | 3X3 | 6006210.140269999 | 2105247.24413 | 37.7609590106658 | -122.421624291141 | (37.7609590106658, -122.421624291141) | ||
| 673 | 673 | 210967 | Permitted Site 1 | Photinia fraseri :: Photinia: Chinese photinia 104 | 375 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1993 12:00:00 AM | 4 | Width 3ft | Permit Number 32251 | 5992728.19812 | 2094135.00675 | 37.7296781967805 | -122.467443955276 | (37.7296781967805, -122.467443955276) | |
| 675 | 675 | 47038 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 716 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2002 12:00:00 AM | Permit Number 45030 | ||||||||
| 676 | 676 | 214191 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 14 | Width 3ft | Permit Number 10790 | 5992756.72765 | 2094187.53129 | 37.7298240632085 | -122.467349144256 | (37.7298240632085, -122.467349144256) | |
| 677 | 677 | 107511 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2141 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2014 12:00:00 AM | 3 | 3x3 | 6001625.68296 | 2119729.38155 | 37.8004637136911 | -122.43851754404601 | (37.8004637136911, -122.438517544046) | ||
| 680 | 680 | 214193 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 19 | Width 3ft | Permit Number 9508 | 5992820.4639099995 | 2094345.69157 | 37.7302620114641 | -122.467140297392 | (37.7302620114641, -122.467140297392) | |
| 681 | 681 | 204889 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 351 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | 8 | Width 3ft | Permit Number 46076 | 5992804.92706 | 2094302.99556 | 37.7301438819374 | -122.467190906752 | (37.7301438819374, -122.467190906752) | |
| 683 | 683 | 204884 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 374 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2002 12:00:00 AM | 5 | Width 3ft | Permit Number 45127 | 5992717.9561 | 2094174.3336900002 | 37.7297855875163 | -122.467482221425 | (37.7297855875163, -122.467482221425) | |
| 684 | 684 | 24323 | Permitted Site 1 | Eucalyptus globulus :: Blue Gum 103 | 600X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6006332.380890001 | 2112512.31586 | 37.7809140549901 | -122.42171754994101 | (37.7809140549901, -122.421717549941) | |||
| 685 | 685 | 214192 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 359 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 16 | Width 3ft | Permit Number 9509 | 5992777.37887 | 2094232.46292 | 37.7299486265111 | -122.46728101702 | (37.7299486265111, -122.46728101702) | |
| 687 | 687 | 13252 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001005.1632 | 2119265.163 | 37.7991537757264 | -122.440631471061 | (37.7991537757264, -122.440631471061) | |||
| 688 | 688 | 214188 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1972 12:00:00 AM | 21 | Width 3ft | Permit Number 9461 | 5992780.99407 | 2094319.4986599998 | 37.7301878137975 | -122.467274844971 | (37.7301878137975, -122.467274844971) | |
| 689 | 689 | 48269 | Permitted Site 1 | Tree(s) :: 17 | 120 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 693 | 693 | 214190 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 393 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2009 12:00:00 AM | 17 | Width 3ft | Permit Number 53039 | 5992606.38416 | 2093945.5647200001 | 37.7291510025005 | -122.46785130231501 | (37.7291510025005, -122.467851302315) | |
| 695 | 695 | 212430 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 377 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41586 | 5992705.098540001 | 2094089.26949 | 37.7295512799622 | -122.467520487584 | (37.7295512799622, -122.467520487584) | |
| 702 | 702 | 212428 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 384 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41587 | 5992676.41369 | 2094100.5394 | 37.7295805681871 | -122.467620472428 | (37.7295805681871, -122.467620472428) | |
| 703 | 703 | 204887 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 381 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2002 12:00:00 AM | 7 | Width 3ft | Permit Number 9510 | 5992671.12766 | 2094035.9384 | 37.729402884631 | -122.46763405038601 | (37.729402884631, -122.467634050386) | |
| 705 | 705 | 105051 | Permitted Site 1 | Tree(s) :: 17 | 1244 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/17/2017 12:00:00 AM | 3 | Permit Number 779926 | 5999515.4 | 2108544.9 | 37.769633771891606 | -122.445015457708 | (37.7696337718916, -122.445015457708) | ||
| 706 | 706 | 2833 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1200 California St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6008452.59238 | 2116301.4374700002 | 37.7914373972624 | -122.41465089583099 | (37.7914373972624, -122.414650895831) | |||
| 707 | 707 | 214065 | Permitted Site 1 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 388 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41588 | 5992652.79455 | 2094064.0577 | 37.729479034728605 | -122.46769947335 | (37.7294790347286, -122.46769947335) | |
| 708 | 708 | 204885 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 396 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/08/2002 12:00:00 AM | 10 | Width 3ft | Permit Number 45128 | 5992604.93972 | 2093995.7294599998 | 37.7292886590466 | -122.46785994299101 | (37.7292886590466, -122.467859942991) | |
| 711 | 711 | 212429 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 384 San Benito Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1999 12:00:00 AM | 4 | Width 3ft | Permit Number 41587 | 5992663.86781 | 2094081.2472599999 | 37.7295268723689 | -122.467662441966 | (37.7295268723689, -122.467662441966) | |
| 714 | 714 | 206262 | Permitted Site 1 | Eucalyptus pulverulenta :: Silver Mountain Gum Tree 107 | 389 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2005 12:00:00 AM | 17 | Width 3ft | Permit Number 48035 | 5992637.65541 | 2093989.35221 | 37.729273037804 | -122.46774637929501 | (37.729273037804, -122.467746379295) | |
| 718 | 718 | 99173 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2100 Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | Permit Number 25928 | 6003311.25259 | 2116120.54401 | 37.790650512059 | -122.432426898975 | (37.790650512059, -122.432426898975) | ||
| 719 | 719 | 246969 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299 Noe St | 1 | : 4 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 9 | Width 4ft | Permit Number 778955 | 6002937.11929 | 2106633.84457 | 37.7645811776972 | -122.433043298823 | (37.7645811776972, -122.433043298823) | |
| 724 | 724 | 25734 | Permitted Site 1 | Phoenix canariensis :: Canary Island Date Palm 100 | 500X The Embarcadero | 4 | Median : Cutout 11 | Tree 1 | Port 9 | 08/15/1996 12:00:00 AM | 16 | 10 | 6013899.49111 | 2118360.1858599996 | 37.7973947538281 | -122.395948920127 | (37.7973947538281, -122.395948920127) | ||
| 726 | 726 | 44958 | Permitted Site 1 | Tree(s) :: 17 | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 728 | 728 | 2813 | Permitted Site 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1075 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6009225.04881 | 2116342.3210299998 | 37.7915930222591 | -122.41198109107599 | (37.7915930222591, -122.411981091076) | |||
| 729 | 729 | 48266 | Permitted Site 1 | Tree(s) :: 17 | 130 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 730 | 730 | 195047 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 360 06th St | 2 | : 4 | Tree 1 | DPW 2 | 03/26/2005 12:00:00 AM | 3 | Width 3ft | Permit Number 42039 | 6011214.59355 | 2111232.18316 | 37.777673209496605 | -122.404737337955 | (37.7776732094966, -122.404737337955) | |
| 734 | 734 | 173936 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |
| 736 | 736 | 231004 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 7 | Width 3ft | Permit Number 46247 | 6008974.97232 | 2105068.82517 | 37.7606246283465 | -122.412049301945 | (37.7606246283465, -122.412049301945) | |
| 739 | 739 | 13244 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2012 12:00:00 AM | 3 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.44006524578501 | (37.7992300540772, -122.440065245785) | ||
| 741 | 741 | 9506 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 935 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/10/2002 12:00:00 AM | 3 | 3X3 | 6005056.2117 | 2112292.3227 | 37.7802379614696 | -122.426116783326 | (37.7802379614696, -122.426116783326) | ||
| 742 | 742 | 35926 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2660 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/24/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773492 | 6001423.81293 | 2116968.31873 | 37.7928710739952 | -122.43901810580799 | (37.7928710739952, -122.439018105808) | |
| 743 | 743 | 224663 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008964.71968 | 2105285.1997599998 | 37.761218168313704 | -122.412100053373 | (37.7612181683137, -122.412100053373) | |
| 744 | 744 | 231007 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 7 | Width 3ft | Permit Number 46247 | 6008969.23961 | 2105134.95103 | 37.7608058732193 | -122.412073802181 | (37.7608058732193, -122.412073802181) | |
| 751 | 751 | 224664 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008962.07625 | 2105304.40117 | 37.761270742678704 | -122.412110552966 | (37.7612707426787, -122.412110552966) | |
| 755 | 755 | 224665 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008961.65131 | 2105333.13094 | 37.7613496042185 | -122.412114053139 | (37.7613496042185, -122.412114053139) | |
| 756 | 756 | 231006 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 9 | Width 3ft | Permit Number 46247 | 6008972.79201 | 2105110.692 | 37.760739462776606 | -122.41205980151199 | (37.7607394627766, -122.412059801512) | |
| 758 | 758 | 231035 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 3050 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 7 | Width 3ft | Permit Number 46247 | 6008913.51781 | 2104995.63577 | 37.7604202187369 | -122.41225667301799 | (37.7604202187369, -122.412256673018) | |
| 765 | 765 | 231003 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 9 | Width 3ft | Permit Number 46247 | 6008977.98805 | 2105043.06556 | 37.760554067537704 | -122.412037051387 | (37.7605540675377, -122.412037051387) | |
| 768 | 768 | 13057 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 566 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/04/2014 12:00:00 AM | 3 | 2x2 | 6009630.8999 | 2120542.6321 | 37.8031488074681 | -122.410873631329 | (37.8031488074681, -122.410873631329) | ||
| 771 | 771 | 224662 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008966.3106 | 2105264.00424 | 37.7611600595223 | -122.412093053058 | (37.7611600595223, -122.412093053058) | |
| 774 | 774 | 231034 | Permitted Site 1 | Tree(s) :: 17 | 3050 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008943.01244 | 2104996.16235 | 37.760423319597294 | -122.412154701577 | (37.7604233195973, -122.412154701577) | |
| 775 | 775 | 231005 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 660 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 8 | Width 3ft | Permit Number 46247 | 6008971.29667 | 2105087.04019 | 37.7606744364044 | -122.41206330170401 | (37.7606744364044, -122.412063301704) | |
| 776 | 776 | 196857 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 487 Tehama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010733.79239 | 2111871.68352 | 37.7794022433647 | -122.406445673949 | (37.7794022433647, -122.406445673949) | |||
| 788 | 788 | 173935 | Permitted Site 1 | Tree(s) :: 17 | 614 Alabama St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2017 12:00:00 AM | 3 | 5x5 | Permit Number 779497 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.41211965835899 | (37.7614283394777, -122.412119658359) | |
| 793 | 793 | 65876 | Permitted Site 1 | Tree(s) :: 17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1990 12:00:00 AM | Permit Number 28874 | |||||||||
| 802 | 802 | 64866 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/02/1989 12:00:00 AM | 13 | Permit Number 25884 | 5997401.9097 | 2109840.7512 | 37.773070992957 | -122.45241943675501 | (37.773070992957, -122.452419436755) | |
| 809 | 809 | 46145 | Permitted Site 1 | Tree(s) :: 17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2001 12:00:00 AM | Permit Number 44490 | |||||||||
| 814 | 814 | 44650 | Permitted Site 1 | Tree(s) :: 17 | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 823 | 823 | 13156 | Permitted Site 1 | Tristania conferta :: 79 | 1875 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6003411.9498 | 2119598.2407 | 37.800205081624604 | -122.432326975222 | (37.8002050816246, -122.432326975222) | |||
| 830 | 830 | 12894 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 255X Larch St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1990 12:00:00 AM | 3 | 3X3 | 6006443.29256 | 2113021.2667 | 37.7823177635948 | -122.421370005133 | (37.7823177635948, -122.421370005133) | ||
| 833 | 833 | 251388 | Permitted Site 1 | Brahea edulis :: Guadalupe Palm 115 | 1658 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2017 12:00:00 AM | 3 | 6014992.0461800005 | 2094842.7959900002 | 37.732881854221894 | -122.39052423440701 | (37.7328818542219, -122.390524234407) | |||
| 847 | 847 | 107475 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1099x Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5999355.4 | 2109104.7 | 37.77116170781979 | -122.445609151717 | (37.7711617078198, -122.445609151717) | |||
| 849 | 849 | 93578 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 401X Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/2010 12:00:00 AM | 1 | 3x3 | Permit Number 53401 | 6009309.6837 | 2121148.6264 | 37.8047947000965 | -122.41202806393 | (37.8047947000965, -122.41202806393) | |
| 850 | 850 | 14550 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 834 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/1993 12:00:00 AM | 12 | 3X3 | 5999292.7589 | 2109954.5102 | 37.7734914941004 | -122.445886958088 | (37.7734914941004, -122.445886958088) | ||
| 862 | 862 | 141567 | Permitted Site 1 | Tree(s) :: 17 | 501X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779825 | 6000588.8239 | 2110706.7362 | 37.7756308363396 | -122.44145768074499 | (37.7756308363396, -122.441457680745) | |
| 864 | 864 | 37366 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 125 Street | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/1998 12:00:00 AM | Permit Number 39871 | ||||||||
| 872 | 872 | 5299 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1635 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6001101.8528 | 2114070.3216 | 37.7848955998057 | -122.43992421757 | (37.7848955998057, -122.43992421757) | |||
| 876 | 876 | 192614 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 1500 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2016 12:00:00 AM | 4 | Width 3ft | 6007548.67256 | 2110072.64933 | 37.774283827466896 | -122.417336847918 | (37.7742838274669, -122.417336847918) | ||
| 878 | 878 | 108700 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 3024 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772805 | 6001479.41501 | 2118822.32035 | 37.7979648412708 | -122.438958648025 | (37.7979648412708, -122.438958648025) |
| 884 | 884 | 20233 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1724 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002600.0088 | 2114219.702 | 37.785390928556396 | -122.43475177403499 | (37.7853909285564, -122.434751774035) | |||
| 888 | 888 | 14525 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 638 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999197.0779 | 2110617.9064 | 37.7753075467631 | -122.44626566212901 | (37.7753075467631, -122.446265662129) | |||
| 897 | 897 | 22581 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 799X Turk St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6006522.42636 | 2112846.04587 | 37.7818411112169 | -122.42108379139799 | (37.7818411112169, -122.421083791398) | |||
| 899 | 899 | 23949 | Permitted Site 1 | Acer buergeranum :: Trident Maple 120 | 2400X Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/15/2014 12:00:00 AM | 3 | 4x4 | Permit Number 773408 | 6003202.444680001 | 2115904.93175 | 37.7900523252984 | -122.43278795880501 | (37.7900523252984, -122.432787958805) | |
| 906 | 906 | 238924 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 1362 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 1 | Width 3ft | Permit Number 777634 | 6007680.96975 | 2101719.66165 | 37.751355903252 | -122.41628746589 | (37.751355903252, -122.41628746589) |
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");