trees

39,840 rows where qLegalStatus_id = 7 sorted by Supervisor Districts descending

✎ View and edit SQL

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)
75 74661 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 165-167 11th St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056) 8 2 9 28853 34
158 100607 Permitted Site 7 Tree(s) :: 17 270x 05th St 5 Sidewalk: Curb side : Cutout Tree Private 2           6011410.5 2112131.8 37.7801542961347 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
193 100595 Permitted Site 7 Tree(s) :: 17 401x Clementina St 10 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
195 101535 Permitted Site 7 Tree(s) :: 17 1X Main St 12 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
309 40920 Permitted Site 7 Tree(s) :: 17 720 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/23/1999 12:00:00 AM     Permit Number 41793 6012338.0511994 2113764.09224404 37.7846879743619 -122.401028836502 (37.7846879743619, -122.401028836502) 12 2 9 28853 6
347 108327 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
521 100638 Permitted Site 7 Tree(s) :: 17 401X Clementina St 8 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
630 106356 Permitted Site 7 Hymenosporum flavum :: Sweet Shade 125 74 Brady St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/21/2014 12:00:00 AM   3x3 Permit Number 771746 6006716.8 2109464.1 37.7725660586042 -122.420171254703 (37.7725660586042, -122.420171254703) 8 2 9 28853 19
777 84774 Permitted Site 7 Tree(s) :: 17 185 Berry St 20 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
852 108444 Permitted Site 7 Jacaranda mimosifolia :: Jacaranda 50 1 Sycamore St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/22/2014 12:00:00 AM 2 3x2.5   6014877 2117007 37.7937335561349 -122.392471758503 (37.7937335561349, -122.392471758503) 12 2 9 28855 6
920 91853 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 601x Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/07/2007 12:00:00 AM 3 3x3   6014039.760938 2113573.418065 37.7842592071543 -122.395128082808 (37.7842592071543, -122.395128082808) 6 2 9 28856 6
928 67058 Permitted Site 7 Tree(s) :: 17 180 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/08/1992 12:00:00 AM   3x3 Permit Number 30439 6009767.36044891 2111443.36861251 37.7781720795529 -122.409758741886 (37.7781720795529, -122.409758741886) 8 2 9 28853 34
949 38398 Permitted Site 7 Tree(s) :: 17 1000 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1998 12:00:00 AM     Permit Number 40450 6006538.75328643 2113902.05144478 37.7847415646224 -122.421102312622 (37.7847415646224, -122.421102312622) 7 9 9 28858 36
992 192119 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     22 Width 4ft   6010836.94593 2113119.25584 37.782833554469 -122.406176740686 (37.782833554469, -122.406176740686) 12 2 9 28853 34
1039 51110 Permitted Site 7 Koelreuteria paniculata :: Golden Rain Tree 131 420@ 6TH ST Berry St 21 Sidewalk: Curb side : Cutout Tree Private 2   07/27/2004 12:00:00 AM     Permit Number 47557 6013008.01748439 2109097.62504611 37.7719122726701 -122.398383421945 (37.7719122726701, -122.398383421945) 14 2 9 310 20
1114 32669 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
1212 40354 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 12 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
1237 35474 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 455 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/17/1998 12:00:00 AM     Permit Number 38887 6007396.82109854 2112616.81920427 37.7812609627381 -122.418042529741 (37.7812609627381, -122.418042529741) 7 9 9 28852 36
1381 84767 Permitted Site 7 Tree(s) :: 17 185 Berry St 13 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
1390 33763 Permitted Site 7 Ficus microcarpa :: Chinese Banyan 97 1580 Mission St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/23/1996 12:00:00 AM     Permit Number 37815 6007223.30298499 2109757.94023834 37.7734013999863 -122.418440043785 (37.7734013999863, -122.418440043785) 8 2 9 28853 19
1501 27903 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 280 The Embarcadero 33 Sidewalk: Curb side : Cutout Tree Port 6   01/31/2001 12:00:00 AM 12     6015937.152 2112771.705 37.7821632154212 -122.388507741674 (37.7821632154212, -122.388507741674) 6 2 9 28856 6
1649 92526 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 275 10th St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/07/2009 12:00:00 AM   3x3 Permit Number 52874 6008743 2109634 37.7731465224788 -122.413174412357 (37.7731465224788, -122.413174412357) 8 2 9 28853 34
2027 32641 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
2153 100644 Permitted Site 7 Tree(s) :: 17 401X Clementina St 14 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
2310 91800 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 530X Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/05/2017 12:00:00 AM 3 3x3 Permit Number 778971 6014458 2114030 37.785536126129 -122.39371308036 (37.785536126129, -122.39371308036) 6 2 9 28855 6
2327 108056 Permitted Site 7 Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 39 535X Mission St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2014 12:00:00 AM 3 3x3 Permit Number 773596 6013160.27922 2115313.8399 37.7889890532579 -122.398292953274 (37.7889890532579, -122.398292953274) 12 2 9 28855 6
2453 49617 Permitted Site 7 Pyrus kawakamii :: Evergreen Pear 83 1626 Folsom St 7 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM     Permit Number 46477 6008114.57908688 2108709.83276472 37.7705736773564 -122.415282774124 (37.7705736773564, -122.415282774124) 8 2 9 28853 19
2454 46118 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 2 Folsom St 11 Sidewalk: Curb side : Cutout Tree Private 2   12/27/2001 12:00:00 AM     Permit Number 44476 6015543.8 2115940.8 37.7908430231508 -122.390090033136 (37.7908430231508, -122.390090033136) 6 2 9 28855 6
2499 55575 Permitted Site 7 Tree(s) :: 17 622 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/06/1972 12:00:00 AM     Permit Number 11546 6010538.99497753 2108399.45644768 37.7698574135988 -122.40687477594 (37.7698574135988, -122.40687477594) 8 2 9 28853 19
2552 42536 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 95 Brady St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42642 6006853.97359683 2109407.99798814 37.7724197439799 -122.419692774816 (37.7724197439799, -122.419692774816) 8 2 9 28853 19
2803 39877 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 301 Bryant St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/21/1999 12:00:00 AM     Permit Number 41173 6015620.67363669 2114221.43610992 37.786126305998 -122.389703911477 (37.786126305998, -122.389703911477) 6 2 9 28855 6
2968 108902 Permitted Site 7 Ficus laurel :: 247 33 Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2     21 4x6   6006450.1 2109317.2 37.7721476754667 -122.421083366581 (37.7721476754667, -122.421083366581) 8 2 9 28853 19
3792 46228 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 55 02nd St 11 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2002 12:00:00 AM     Permit Number 44531 6012528.68122922 2115201.03212894 37.7886441073773 -122.400470285309 (37.7886441073773, -122.400470285309) 12 2 9 28855 6
3993 49288 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 19 Sidewalk: Curb side : Cutout Tree Private 2   02/07/2003 12:00:00 AM     Permit Number 46305 6014371 2116872 37.7933347653256 -122.394213120763 (37.7933347653256, -122.394213120763) 12 2 9 28855 6
4095 49027 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 199 01st St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/06/2003 12:00:00 AM     Permit Number 46205 6013823.58160426 2115158.37921296 37.7885991200294 -122.395987099577 (37.7885991200294, -122.395987099577) 6 2 9 28855 6
4128 109223 Permitted Site 7 Eucalyptus melliodora :: Yellow Box 188 1675 OWENS ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 4x4   6014234 2107598 37.7678628533553 -122.394037627847 (37.7678628533553, -122.394037627847) 14 3 9 310 20
4131 38411 Permitted Site 7 Tree(s) :: 17 1000 Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   06/30/1998 12:00:00 AM     Permit Number 40450 6006538.75328643 2113902.05144478 37.7847415646224 -122.421102312622 (37.7847415646224, -122.421102312622) 7 9 9 28858 36
4189 192124 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 6 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     25 Width 4ft   6011038.85416 2113311.43716 37.783372530757 -122.405491758548 (37.783372530757, -122.405491758548) 12 2 9 28853 34
4247 41540 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 775X 02nd St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/20/2000 12:00:00 AM 6 3x3 Permit Number 42068 6015692.30699351 2111981.66601878 37.7799803743496 -122.389299616981 (37.7799803743496, -122.389299616981) 6 2 9 28856 20
4727 51621 Permitted Site 7 Photinia fraseri :: Photinia Tree 225 465 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/04/2005 12:00:00 AM     Permit Number 47916 6010931.94121292 2112045.86318657 37.7798915829784 -122.40577246257 (37.7798915829784, -122.40577246257) 14 2 9 28853 34
4782 50976 Permitted Site 7 Tree(s) :: 17 683 REVISED Brannan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2004 12:00:00 AM     Permit Number 47463 6012417.01604771 2110263.6615562 37.775081003703 -122.40050967291 (37.775081003703, -122.40050967291) 14 2 9 28856 20
4861 40879 Permitted Site 7 Schinus molle :: California Pepper 91 38 Washburn St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1976 12:00:00 AM     Permit Number 41789 6008346.99191908 2110451.53839796 37.775369049965 -122.414602124139 (37.775369049965, -122.414602124139) 8 2 9 28853 34
5125 38779 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 534 04th St 10 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/20/1998 12:00:00 AM     Permit Number 40639 6013303.96708897 2111684.86517271 37.7790327294989 -122.397541189965 (37.7790327294989, -122.397541189965) 6 2 9 28856 34
5290 89193 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
5323 104579 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 201X Channel St 10 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6011985.48737 2113104.04931 37.7828559770513 -122.402202175758 (37.7828559770513, -122.402202175758) 6 2 9 28853 34
5351 108330 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 86 11TH ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
5579 50971 Permitted Site 7 Tree(s) :: 17 683 REVISED Brannan St 7 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2004 12:00:00 AM     Permit Number 47463 6012417.01604771 2110263.6615562 37.775081003703 -122.40050967291 (37.775081003703, -122.40050967291) 14 2 9 28856 20
5594 106035 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Main St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014366.74772 2116104.57878 37.7912273690908 -122.394174082061 (37.7912273690908, -122.394174082061) 12 2 9 28855 6
5638 89169 Permitted Site 7 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 370 03rd St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013271 2113050 37.7827792408585 -122.397751016594 (37.7827792408585, -122.397751016594) 6 2 9 28856 34
6134 44234 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 599 03rd St 6 Sidewalk: Curb side : Cutout Tree Private 2   01/29/2001 12:00:00 AM     Permit Number 43674 6014264.27015126 2112071.58281381 37.7801479924912 -122.394246170943 (37.7801479924912, -122.394246170943) 6 2 9 28856 6
6417 84770 Permitted Site 7 Tree(s) :: 17 185 Berry St 16 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
6443 45729 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 235 02nd St 17 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2001 12:00:00 AM     Permit Number 44392 6013350.5591251 2114341.46161867 37.7863297261158 -122.397566379799 (37.7863297261158, -122.397566379799) 6 2 9 28855 6
6869 51982 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 660 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/25/2005 12:00:00 AM     Permit Number 48204 6007266.85815782 2113345.5415055 37.7832545419232 -122.4185438282 (37.7832545419232, -122.4185438282) 7 9 9 28858 36
7053 93534 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 325 China Basin St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/08/2010 12:00:00 AM   3x3 Permit Number 53240 6016190.6 2109941.9 37.774407241214 -122.387433446454 (37.774407241214, -122.387433446454) 14 3 9 310 20
7228 65038 Permitted Site 7 Tree(s) :: 17 153 Steuart St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/18/1989 12:00:00 AM     Permit Number 26090 6014916.9048923 2116605.4476944 37.7926332027205 -122.392305584841 (37.7926332027205, -122.392305584841) 12 2 9 28855 6
7276 84766 Permitted Site 7 Tree(s) :: 17 185 Berry St 12 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
7295 100582 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 900 Folsom St 13 Sidewalk: Curb side : Cutout Tree Private 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
7326 98693 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 1400X Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 48713 6009268 2109041 37.7715477423488 -122.411316462549 (37.7715477423488, -122.411316462549) 8 2 9 28853 34
7408 53652 Permitted Site 7 Tree(s) :: 17 831 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/1969 12:00:00 AM     Permit Number 6588 6012089.84873388 2112576.989681 37.781414618516 -122.401804066947 (37.781414618516, -122.401804066947) 6 2 9 28856 34
7482 30852 Permitted Site 7 Acacia melanoxylon :: Blackwood Acacia 70 99 South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   02/16/1995 12:00:00 AM     Permit Number 34698 6007267.59353144 2109330.19931681 37.772229418327 -122.418256503442 (37.772229418327, -122.418256503442) 8 2 9 28853 19
7539 100598 Permitted Site 7 Tree(s) :: 17 401x Clementina St 13 Sidewalk: Curb side : Cutout Tree Private 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
7694 44088 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 500 Bryant St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/31/2000 12:00:00 AM 6 3x3 Permit Number 43605 6013788.61209882 2112522.22157888 37.7813588929752 -122.395923288248 (37.7813588929752, -122.395923288248) 6 2 9 28856 34
7885 57193 Permitted Site 7 Tree(s) :: 17 633 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/1974 12:00:00 AM     Permit Number 14473 6007510.46945444 2113541.05571027 37.7838050881462 -122.417714890881 (37.7838050881462, -122.417714890881) 7 9 9 28858 36
7888 84764 Permitted Site 7 Tree(s) :: 17 185 Berry St 10 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2007 12:00:00 AM     Permit No. 49299 6014606 2110554 37.7760000408576 -122.392957754299 (37.7760000408576, -122.392957754299) 6 2 9 28856 20
7907 91707 Permitted Site 7 Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 123 99 South Van Ness Ave 6 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2007 12:00:00 AM 3 3x3   6007261.828778 2109331.862933 37.7722336617279 -122.418276562246 (37.7722336617279, -122.418276562246) 8 2 9 28853 19
8181 192121 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     27 Width 4ft   6010922.27002 2113199.63335 37.783059024392 -122.405887217429 (37.783059024392, -122.405887217429) 12 2 9 28853 34
8184 82951 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 660X Clementina St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2005 12:00:00 AM 3 3x3 Permit Number 52432 6009636 2110586 37.7758105844997 -122.410152621086 (37.7758105844997, -122.410152621086) 8 2 9 28853 34
8599 262043 Permitted Site 7 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 245 11th St   : Cutout Tree Private 2 FUF 04/14/2020 12:00:00 AM 3   Permit Number 785251 6008265.74007 2109435.35593 37.7725742877847 -122.414811260337 (37.7725742877847, -122.414811260337) 8 2 9 28853 34
8706 50165 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 175 Russ St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/29/2003 12:00:00 AM 5 3x3 Permit Number 47119 6010544.92166501 2111364.78189969 37.7779998423871 -122.40706332103 (37.7779998423871, -122.40706332103) 14 2 9 28853 34
8714 65277 Permitted Site 7 Tree(s) :: 17 413 Tehama St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/14/1989 12:00:00 AM     Permit Number 28080 6011259.0467766 2112359.25955834 37.7807703835022 -122.404662921728 (37.7807703835022, -122.404662921728) 14 2 9 28853 34
8873 86678 Permitted Site 7 Acer rubrum 'Red Sunset' :: Red Swamp Maple 193 1099X Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/09/2007 12:00:00 AM 3 3x3   6010093.920773 2108925.272404 37.7712762686377 -122.408451379419 (37.7712762686377, -122.408451379419) 8 2 9 28853 34
8874 15149 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
9108 116642 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 270 Brannan St 4 Sidewalk: Property side : Cutout Tree Private 2     1 3x3   6015144.15756 2112956.70855 37.7826272167081 -122.391264104249 (37.7826272167081, -122.391264104249) 6 2 9 28856 6
9470 46514 Permitted Site 7 Ceratonia siliqua :: Carob 5 525or larger Golden Gate Ave In A 24 Box 3 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2002 12:00:00 AM     Permit Number 44680 6007056.20383649 2112568.41573989 37.7811088818185 -122.419217465788 (37.7811088818185, -122.419217465788) 7 9 9 28852 36
9492 104107 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 55X Clarence Pl 10 Sidewalk: Curb side : Cutout Tree Private 2       2x3 Permit Number 768392 6014738.33428 2111855.52316 37.7795810807004 -122.392591035948 (37.7795810807004, -122.392591035948) 6 2 9 28856 6
9584 45722 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 235 02nd St 23 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2001 12:00:00 AM     Permit Number 44392 6013350.5591251 2114341.46161867 37.7863297261158 -122.397566379799 (37.7863297261158, -122.397566379799) 6 2 9 28855 6
9586 191511 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 392 04th St 2 : Tree Private 2   09/27/2001 12:00:00 AM 5 Width 3ft Permit Number 44376 6012652.22642 2112454.21838 37.7811088850041 -122.399849876973 (37.7811088850041, -122.399849876973) 6 2 9 28856 34
9632 91051 Permitted Site 7 Tree(s) :: 17 750 Folsom St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/10/2008 12:00:00 AM   3x3 Permit Number 51965 6012124 2113544 37.7840717096161 -122.401753911211 (37.7840717096161, -122.401753911211) 12 2 9 28853 6
9670 85554 Permitted Site 7 Eriobotrya deflexa :: Bronze Loquat 8 360X 12th St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2007 12:00:00 AM 6     6008520.7969 2108615.740864 37.7703381448181 -122.413871001048 (37.7703381448181, -122.413871001048) 8 2 9 28853 19
9826 55790 Permitted Site 7 Tree(s) :: 17 81 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/13/1973 12:00:00 AM     Permit Number 11831 6013029.07044422 2114920.75129783 37.7879024142259 -122.39871932399 (37.7879024142259, -122.39871932399) 12 2 9 28855 6
10135 46240 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 160 King St 5 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM     Permit Number 44534 6015164.29463736 2111614.90461458 37.7789440431462 -122.39110062089 (37.7789440431462, -122.39110062089) 6 2 9 28856 20
10415 43967 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 627 Turk St 7 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2000 12:00:00 AM     Permit Number 43534 6006999.24602912 2112908.87547401 37.7820404937398 -122.419438672428 (37.7820404937398, -122.419438672428) 7 9 9 28852 36
10416 42198 Permitted Site 7 Crataegus phaenopyrum :: Washington Hawthorn 102 1108 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/2000 12:00:00 AM     Permit Number 42472 6010019.96061049 2108918.62513791 37.7712538746338 -122.408706742901 (37.7712538746338, -122.408706742901) 8 2 9 28853 34
10748 92022 Permitted Site 7 Magnolia grandiflora :: Southern Magnolia 19 230 04th St 3 Sidewalk: Curb side : Cutout Tree Private 2   06/04/2009 12:00:00 AM   3x3 Permit Number 770960 6011866.1 2113060.9 37.7827308344341 -122.402612173234 (37.7827308344341, -122.402612173234) 6 2 9 28853 34
10886 192122 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 4 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     23 Width 4ft   6010961.41826 2113239.46389 37.7831705790105 -122.405754586311 (37.7831705790105, -122.405754586311) 12 2 9 28853 34
11270 32664 Permitted Site 7 Liquidambar styraciflua :: American Sweet Gum 37 750 Brannan St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM     Permit Number 37093 6011928.74882851 2109868.72792778 37.773969364433 -122.402170934506 (37.773969364433, -122.402170934506) 14 2 9 28853 34
11309 44191 Permitted Site 7 Ginkgo biloba :: Maidenhair Tree 22 100 Harrison St 12 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2000 12:00:00 AM     Permit Number 43651 6015694.21185643 2115218.20458409 37.7888672826794 -122.389519124295 (37.7888672826794, -122.389519124295) 6 2 9 28855 6
11321 57873 Permitted Site 7 Tree(s) :: 17 230 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1977 12:00:00 AM     Permit Number 16819 6009047.83782132 2113329.34235578 37.7833101664213 -122.412381181992 (37.7833101664213, -122.412381181992) 14 10 9 28852 36
11358 105913 Permitted Site 7 Metrosideros excelsa :: New Zealand Xmas Tree 16 115 Steuart St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 771767 6014820.9 2116826.5 37.7932348296087 -122.392653238457 (37.7932348296087, -122.392653238457) 12 2 9 28855 6
11779 44518 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 100X TOWNSEND ST 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2001 12:00:00 AM 9 3x3 Permit Number 43820 6015218.7 2112179.2 37.7804964903429 -122.390951859139 (37.7804964903429, -122.390951859139) 6 2 9 28856 6
11798 66507 Permitted Site 7 Prunus serrulata :: Ornamental Cherry 84 64 Langton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/21/1991 12:00:00 AM     Permit Number 29671 6009973.94739461 2110908.31483893 37.7767145222423 -122.409006317188 (37.7767145222423, -122.409006317188) 8 2 9 28853 34
11880 42194 Permitted Site 7 Tristaniopsis laurina :: Swamp Myrtle 1 1016 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/21/2000 12:00:00 AM     Permit Number 42470 6010410.48288619 2109291.59089856 37.772299817533 -122.407382201369 (37.772299817533, -122.407382201369) 14 2 9 28853 34
11898 32704 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 890 Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/29/1996 12:00:00 AM     Permit Number 37106 6007466.88018988 2114411.93310855 37.7861938524183 -122.417927449032 (37.7861938524183, -122.417927449032) 13 1 9 28858 36
11961 115127 Permitted Site 7 Geijera parviflora :: Australian Willow 25 499X MAIN ST 5 Sidewalk: Curb side : Cutout Tree Private 2     6     6015842 2114626 37.7872494168956 -122.388966430338 (37.7872494168956, -122.388966430338) 6 2 9 28855 6
12274 56690 Permitted Site 7 Tree(s) :: 17 55 Hallam St 1 Sidewalk: Curb side : Cutout Tree Private 2           6010204.8585712 2110471.70826771 37.7755286348545 -122.408176723323 (37.7755286348545, -122.408176723323) 8 2 9 28853 34
12345 107864 Permitted Site 7 Tree(s) :: 17 362 BRANNAN ST   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014441.4 2112297.4 37.7807778793576 -122.393649202889 (37.7807778793576, -122.393649202889) 6 2 9 28856 6
12381 65434 Permitted Site 7 Callistemon citrinus :: Lemon Bottlebrush 67 555 O'Farrell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/23/1999 12:00:00 AM     Permit Number 33170 6008638.12512872 2114173.69680574 37.785605560242 -122.41385837708 (37.785605560242, -122.41385837708) 7 10 9 28852 36
12401 53714 Permitted Site 7 Tree(s) :: 17 455 08th St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1970 12:00:00 AM     Permit Number 6662 6010362.97418755 2109585.6917484 37.7731046912712 -122.407567278306 (37.7731046912712, -122.407567278306) 14 2 9 28853 34
12460 106116 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 615 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6008342 2114560 37.7866496204263 -122.414910238271 (37.7866496204263, -122.414910238271) 13 1 9 28858 36
12465 192125 Permitted Site 7 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 807 Mission St 7 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     23 Width 4ft   6011096.71819 2113372.25093 37.7835427463303 -122.405295854729 (37.7835427463303, -122.405295854729) 12 2 9 28853 34

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);