trees

963 rows where qCaretaker_id = 2 and qSpecies_id = 53

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 863 ✖
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)
24912 32645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 7 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
25450 17122 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1931 Oak St 4 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   5997743.85041 2109170.01524 37.7712489089965 -122.451188245827 (37.7712489089965, -122.451188245827) 15 5 11 29492 9
25734 113701 Undocumented 4 Ficus nitida :: Laurel Fig 53 12 LUNDYS LN 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6007151 2099622 37.7455663833026 -122.417971480149 (37.7455663833026, -122.417971480149) 2 7 7 28859 2
25834 93215 Permitted Site 7 Ficus nitida :: Laurel Fig 53 499 Jackson St   Sidewalk: Curb side : Cutout Tree Private 2   02/25/2010 12:00:00 AM   3x3 Permit Number 53209 6011715 2118034 37.7963773511427 -122.403484907832 (37.7963773511427, -122.403484907832) 3 1 10 28860 4
25882 40606 Permitted Site 7 Ficus nitida :: Laurel Fig 53 744 Montgomery St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/18/2005 12:00:00 AM     Permit Number 48110 6011762.49765618 2117875.03517526 37.7959435248288 -122.403309366526 (37.7959435248288, -122.403309366526) 3 1 10 28860 4
26107 21817 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2683 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008202.62871 2121958.17011 37.8069553278433 -122.4159165161 (37.8069553278433, -122.4159165161) 5 1 10 308 23
26170 124732 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
26376 107654 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
26693 111116 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2085 Hayes St 4 Sidewalk: Curb side : Cutout Tree Private 2     12     5997903.58032533 2109906.22418863 37.7732794935428 -122.450688824407 (37.7732794935428, -122.450688824407) 15 5 11 29492 16
26933 120656 Undocumented 4 Ficus nitida :: Laurel Fig 53 160 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
27040 120661 Undocumented 4 Ficus nitida :: Laurel Fig 53 299X Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778623 6015082 2115536 37.7897059122539 -122.3916595384 (37.7897059122539, -122.3916595384) 6 2 9 28855 6
27436 107660 Undocumented 4 Ficus nitida :: Laurel Fig 53 1316 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 3x3   5999083.9 2105040.7 37.7599874810533 -122.446255886285 (37.7599874810533, -122.446255886285) 15 5 5 28862 3
27757 16589 Permitted Site 7 Ficus nitida :: Laurel Fig 53 17 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     0 4X4PL   6002850.124051 2108197.2585517 37.768868996076 -122.433455924251 (37.768868996076, -122.433455924251) 15 5 5 28862 3
27991 97561 Undocumented 4 Ficus nitida :: Laurel Fig 53 1251X 04th Ave 1 Sidewalk: Property side : Cutout Tree Private 2       3x3   5994791.4 2106981 37.7650689602603 -122.461242116604 (37.7650689602603, -122.461242116604) 15 5 11 56 12
28234 109001 Undocumented 4 Ficus nitida :: Laurel Fig 53 525x BURNETT AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       1x1   5999530 2102478 37.7529764040195 -122.444528861079 (37.7529764040195, -122.444528861079) 2 5 5 63 38
28305 121625 Undocumented 4 Ficus nitida :: Laurel Fig 53 101x Trenton St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010049 2117862 37.7958118850813 -122.409237502382 (37.7958118850813, -122.409237502382) 3 1 10 308 4
28579 116510 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500x Waller St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998488 2108327 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995) 15 5 11 29492 9
28626 100399 Undocumented 4 Ficus nitida :: Laurel Fig 53 900 Montgomery St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/17/2016 12:00:00 AM 3 4x4   6011664 2118384 37.7973355180624 -122.403686018548 (37.7973355180624, -122.403686018548) 3 1 10 308 23
28662 99265 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 2 Sidewalk: Curb side : Cutout Tree Private 2           6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
28710 102826 Undocumented 4 Ficus nitida :: Laurel Fig 53 2001X Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997438 2109144 37.7711599615563 -122.452244312179 (37.7711599615563, -122.452244312179) 15 5 11 29492 9
28833 21815 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2653 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6008264.14138 2121978.44796 37.8070144637358 -122.415705074993 (37.8070144637358, -122.415705074993) 5 1 10 308 23
29320 21640 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1645 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6004732.1765743 2114674.6857014 37.7867610187213 -122.427407534005 (37.7867610187213, -122.427407534005) 13 9 11 28858 13
29416 7261 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1727 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003024.60166 2114236.6744 37.7854616266825 -122.433284024643 (37.7854616266825, -122.433284024643) 13 9 11 29490 13
29615 120137 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
29680 65045 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1066 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2004 12:00:00 AM     Permit Number 45972 6007827.74406772 2119607.84984942 37.8004808586212 -122.417047244449 (37.8004808586212, -122.417047244449) 5 1 1 308 32
29776 44063 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
29857 57300 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3178 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/27/1976 12:00:00 AM 14 3x3 Permit Number 16122 6005671.4432239 2106688.52693537 37.7648860421109 -122.423589884437 (37.7648860421109, -122.423589884437) 8 4 5 28853 19
30376 94524 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3322 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 774668 5988381 2111924 37.7782700631784 -122.483776297443 (37.7782700631784, -122.483776297443) 11 6 2 55 26
31137 4747 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1199X Columbus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     22 3X4   6007816.30894 2121179.41413 37.8047953349468 -122.417198239329 (37.8047953349468, -122.417198239329) 5 1 1 308 32
31247 106090 Permitted Site 7 Ficus nitida :: Laurel Fig 53 615 Front St 2 Sidewalk: Curb side : Cutout Tree Private 2           6012797.6 2118350.4 37.7973065196251 -122.399761086072 (37.7973065196251, -122.399761086072) 3 1 10 28860 6
31383 110696 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
31660 7182 Permitted Site 7 Ficus nitida :: Laurel Fig 53 857 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6003432.47617 2111314.05853 37.7774599847744 -122.43166416476 (37.7774599847744, -122.43166416476) 15 9 11 29492 10
32305 173934 Permitted Site 7 Ficus nitida :: Laurel Fig 53 614 Alabama St 4 Sidewalk: Curb side : Cutout Tree Private 2       9x9   6008960.61704517 2105361.82717089 37.7614283394777 -122.412119658359 (37.7614283394777, -122.412119658359) 2 4 7 28859 19
32399 102602 Undocumented 4 Ficus nitida :: Laurel Fig 53 88 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6014255.3 2116583.4 37.7925359054466 -122.394593235194 (37.7925359054466, -122.394593235194) 12 2 9 28855 6
32408 54027 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/01/2016 12:00:00 AM 3 6x6 Permit Number 778679 6004696.3346429 2103995.33974478 37.7574361004301 -122.426770728763 (37.7574361004301, -122.426770728763) 2 4 5 28862 3
32689 108945 Permitted Site 7 Ficus nitida :: Laurel Fig 53 105 Richland Ave 4 Sidewalk: Curb side : Cutout Tree Private 2           6005294.9 2096235.5 37.7361631827636 -122.424148798432 (37.7361631827636, -122.424148798432) 2 7 7 28859 2
32698 58520 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1486 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/02/1979 12:00:00 AM   7x7 Permit Number 17697 5998599.14429808 2108320.44227206 37.7689651308865 -122.448168577388 (37.7689651308865, -122.448168577388) 15 5 11 29492 9
32727 16390 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 Myrtle St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006205.61528 2114051.709 37.7851337020107 -122.422265498437 (37.7851337020107, -122.422265498437) 13 9 11 28858 41
32730 5389 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330X Dolores St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6004827.24095 2106401.30238 37.7640497043733 -122.426489313449 (37.7640497043733, -122.426489313449) 8 4 5 28859 3
32743 22671 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1140X Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6003752.72615 2112639.82159 37.7811183481869 -122.430650941901 (37.7811183481869, -122.430650941901) 15 9 11 29490 41
32968 16997 Permitted Site 7 Ficus nitida :: Laurel Fig 53 903 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   6002604.56537 2109869.28932 37.7734460452794 -122.43442485558 (37.7734460452794, -122.43442485558) 15 5 11 29492 9
33092 92818 Permitted Site 7 Ficus nitida :: Laurel Fig 53 95 Burlwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   11/12/2009 12:00:00 AM   3x3 Permit Number 53027 5996883 2096019 37.7350901820695 -122.453216393363 (37.7350901820695, -122.453216393363) 9 7 4 59 40
33102 110710 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
34036 9687 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2001 12:00:00 AM 16 3x3   6006025.52151 2110969.11138 37.7766594822933 -122.422669431679 (37.7766594822933, -122.422669431679) 7 9 11 28852 10
34217 575 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3007 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6008864.65035 2102095.7164 37.7524549543286 -122.41222072227 (37.7524549543286, -122.41222072227) 2 4 7 28859 19
34305 102625 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1865X Grant Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 17346 6010349.4 2120908.5 37.804193651889 -122.408413053021 (37.804193651889, -122.408413053021) 3 1 10 308 23
34686 101290 Permitted Site 7 Ficus nitida :: Laurel Fig 53 830 Lisbon St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 769326 6001055.4 2088979.9 37.7160006775821 -122.438286819162 (37.7160006775821, -122.438286819162) 9 7 6 28861 5
34974 253521 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2626 Larkin St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   6006643 2120264 37.8022157634914 -122.42119356192 (37.8022157634914, -122.42119356192) 5 1 1 28858 32
35016 120999 Undocumented 4 Ficus nitida :: Laurel Fig 53 390 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6010815 2115725 37.7899870820688 -122.406436332672 (37.7899870820688, -122.406436332672) 5 1 10 28857 6
35050 115907 Undocumented 4 Ficus nitida :: Laurel Fig 53 500x WALLER ST 4 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2016 12:00:00 AM 3 4x4   6003255 2109006 37.7711125644946 -122.432113248928 (37.7711125644946, -122.432113248928) 15 5 11 29492 9
35179 95222 Undocumented 4 Ficus nitida :: Laurel Fig 53 299 on 16th St Dolores St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6004880 2106610 37.7646257206218 -122.426321695151 (37.7646257206218, -122.426321695151) 8 4 5 28859 19
35372 94058 Undocumented 4 Ficus nitida :: Laurel Fig 53 1401X 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5993648 2105942 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228) 1 8 11 56 12
35514 110994 Permitted Site 7 Ficus nitida :: Laurel Fig 53 245x North Point St 13 Sidewalk: Curb side : Cutout Tree Private 2           6009556.06624176 2121873.83782792 37.8067997698403 -122.41122668881 (37.8067997698403, -122.41122668881) 3 1 10 308 23
35952 120884 Undocumented 4 Ficus nitida :: Laurel Fig 53 2140x 18th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011295 2105636 37.7623118602886 -122.404065249735 (37.7623118602886, -122.404065249735) 8 3 8 28856 29
36005 111369 Undocumented 4 Ficus nitida :: Laurel Fig 53 724 IRVING ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993485 2106687 37.7641864431876 -122.465739233402 (37.7641864431876, -122.465739233402) 11 8 11 56 12
36076 111627 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
36280 110558 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection 6007165.9 2109609 37.7729892139286 -122.418628045346 (37.7729892139286, -122.418628045346) 8 2 9 28853 19
37186 112411 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
37194 4729 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1075 Columbus Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     30 3X3   6008196.257 2120907.29394 37.8040695291651 -122.41586410452 (37.8040695291651, -122.41586410452) 5 1 10 308 32
37406 18007 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700X Pine St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x4   6001006.5406952 2114902.0443839 37.7871738702805 -122.440313633737 (37.7871738702805, -122.440313633737) 13 6 1 29490 27
37838 102503 Permitted Site 7 Ficus nitida :: Laurel Fig 53 290X Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x9   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233) 7 9 11 29492 10
37914 110712 Undocumented 4 Ficus nitida :: Laurel Fig 53 2999X Turk St 18 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996638 2111487 37.7775473668867 -122.455180869531 (37.7775473668867, -122.455180869531) 15 6 2 54 16
38373 52226 Permitted Site 7 Ficus nitida :: Laurel Fig 53 423 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/18/2005 12:00:00 AM     Permit Number 48405 5997634.34727934 2115023.86499621 37.7873157808513 -122.451989424725 (37.7873157808513, -122.451989424725) 11 6 1 54 31
38468 111626 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
38641 102621 Permitted Site 7 Ficus nitida :: Laurel Fig 53 190X Pfeiffer St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 18461 6009953.9 2121114.8 37.8047379445266 -122.409796287705 (37.8047379445266, -122.409796287705) 3 1 10 308 23
38651 113775 Undocumented 4 Ficus nitida :: Laurel Fig 53 1712 BAKER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6000121 2114885 37.7870766118482 -122.443376178084 (37.7870766118482, -122.443376178084) 13 6 1 29490 27
38667 21584 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1499 Sutter St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005574.52113 2114792.70084 37.787132663766 -122.424501615425 (37.787132663766, -122.424501615425) 13 9 1 28858 41
38715 120144 Undocumented 4 Ficus nitida :: Laurel Fig 53 1X Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008026 2111839 37.7791606496002 -122.415810780563 (37.7791606496002, -122.415810780563) 7 10 9 28852 36
38742 113004 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
38782 101759 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
38859 115059 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
38950 93145 Undocumented 4 Ficus nitida :: Laurel Fig 53 1152 Clement St 3 Sidewalk: Curb side : Cutout Tree Private 2           5991985 2113459 37.7826938870859 -122.471420727494 (37.7826938870859, -122.471420727494) 11 6 2 54 11
39288 116011 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1448 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/09/2016 12:00:00 AM 3     6000920 2110390.8 37.7747822166773 -122.440289401956 (37.7747822166773, -122.440289401956) 15 5 11 29492 10
39309 61493 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3149 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/19/1984 12:00:00 AM     Permit Number 777095 5999649.96958977 2116015.59113069 37.7901540469754 -122.445087143888 (37.7901540469754, -122.445087143888) 13 6 1 29490 27
39348 97611 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
39370 107630 Undocumented 4 Ficus nitida :: Laurel Fig 53 2164 CHESTNUT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6001495 2119755 37.8005266206576 -122.438971595662 (37.8005266206576, -122.438971595662) 13 9 1 57 17
39669 95554 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1333@ Larkin Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007121 2115358 37.7887720478953 -122.419191239667 (37.7887720478953, -122.419191239667) 13 9 10 28858 21
40083 49240 Permitted Site 7 Ficus nitida :: Laurel Fig 53 500 Howard St 24 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2003 12:00:00 AM     Permit Number 46300 6013774.5913005 2115138.38416874 37.7885414925604 -122.396155198 (37.7885414925604, -122.396155198) 12 2 9 28855 6
40156 49286 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2X Spear St 14 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
40462 48697 Permitted Site 7 Ficus nitida :: Laurel Fig 53 405 Howard St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2002 12:00:00 AM     Permit Number 45976 6014070.00775547 2115349.03612356 37.7891363266664 -122.395147855931 (37.7891363266664, -122.395147855931) 6 2 9 28855 6
40868 173774 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2239 15th St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002625 2107043 37.7656869095489 -122.434152085943 (37.7656869095489, -122.434152085943) 15 5 5 28862 3
41004 99266 Undocumented 4 Ficus nitida :: Laurel Fig 53 1340 Leavenworth St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008042 2117018 37.7933818247157 -122.416122311937 (37.7933818247157, -122.416122311937) 5 1 10 28858 21
41221 96947 Undocumented 4 Ficus nitida :: Laurel Fig 53 900X Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 6x6   6007389 2101516 37.750780272338 -122.417282702809 (37.750780272338, -122.417282702809) 2 4 7 28859 19
41634 13254 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2408 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1993 12:00:00 AM 45 3X3   6000832.23006 2119380.36917 37.7994602521243 -122.441238147567 (37.7994602521243, -122.441238147567) 13 9 1 57 17
41773 120139 Undocumented 4 Ficus nitida :: Laurel Fig 53 10X Grove St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007842 2111812 37.7790761683861 -122.416445400738 (37.7790761683861, -122.416445400738) 7 10 9 28852 36
41963 21634 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1629 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004806.293908 2114684.9896753 37.786793502462 -122.427151839633 (37.786793502462, -122.427151839633) 13 9 11 28858 13
42506 121635 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 506 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/2017 12:00:00 AM 3 3x3   5992560 2111978 37.7786607112968 -122.469323657797 (37.7786607112968, -122.469323657797) 11 6 2 54 11
43224 117205 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401 18th St 2 Sidewalk: Curb side : Cutout Tree Private 2           6013468.70293325 2105662.80878203 37.762506682391 -122.396549051509 (37.762506682391, -122.396549051509) 10 3 8 28856 29
43227 110731 Undocumented 4 Ficus nitida :: Laurel Fig 53 3515 25TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006381 2101411 37.7504352040325 -122.420761009138 (37.7504352040325, -122.420761009138) 2 4 5 28859 19
43330 113005 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
43367 116602 Undocumented 4 Ficus nitida :: Laurel Fig 53 3260x 16TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 9x9   6005124 2106632 37.764699916645 -122.425479329399 (37.764699916645, -122.425479329399) 8 4 5 28859 19
43513 120964 Undocumented 4 Ficus nitida :: Laurel Fig 53 1145x Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6003243 2101623 37.7508399403415 -122.43162756863 (37.7508399403415, -122.43162756863) 2 4 5 28862 22
43596 112404 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
43639 111595 Undocumented 4 Ficus nitida :: Laurel Fig 53 398X BRYANT ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014483 2113360 37.7836978486164 -122.393579678281 (37.7836978486164, -122.393579678281) 6 2 9 28856 6
43665 94218 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 01st St 3 Sidewalk: Property side : Pot Tree Private 2   06/25/2010 12:00:00 AM   2x3 Permit Number 53568 6014001.8 2114912.7 37.7879344554838 -122.395353268636 (37.7879344554838, -122.395353268636) 6 2 9 28855 6
43818 24454 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1384 Valencia St 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006362.58284 2101545.07315 37.7508023001764 -122.420834214589 (37.7508023001764, -122.420834214589) 2 4 5 28859 19
43945 573 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2990 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3 Permit Number 776380 6009007.86528 2102243.77418 37.7528695228517 -122.411735919997 (37.7528695228517, -122.411735919997) 2 4 7 28859 19
43985 111817 Undocumented 4 Ficus nitida :: Laurel Fig 53 80 ORD ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6000817 2105938 37.7625500726099 -122.440326296311 (37.7625500726099, -122.440326296311) 15 5 5 28862 3
44100 115215 Undocumented 4 Ficus nitida :: Laurel Fig 53 3395x 21ST ST 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2016 12:00:00 AM 3 9x5 Permit Number 779049 6005778 2103691 37.7566615513452 -122.423008263345 (37.7566615513452, -122.423008263345) 2 4 5 28859 19
44231 57108 Permitted Site 7 Ficus nitida :: Laurel Fig 53 280 Chattanooga St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/23/1974 12:00:00 AM 24 6x6 Permit Number 14378 6004748.38429029 2102046.50032189 37.7520879863161 -122.426451960244 (37.7520879863161, -122.426451960244) 2 4 5 28862 22

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