856 rows where qSpecies_id = 5 sorted by SiteOrder

View and edit SQL

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)
117938 105930 Undocumented 4 Ceratonia siliqua :: Carob 5 971 Florida St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009455 2103552.4 37.7564877890416 -122.410282026926 (37.7564877890416, -122.410282026926) 2 4 7 28859 19
7 188479 Prune Opt Out 3 Ceratonia siliqua :: Carob 5 2208 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft Permit Number 787847 6010817.79084 2106032.71885 37.7633744862602 -122.405743691032 (37.7633744862602, -122.405743691032) 8 4 8 28859 19
239 205987 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1639 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5990866.8027 2104246.93654 37.7573353075836 -122.474616638541 (37.7573353075836, -122.474616638541) 1 8 4 56 12
846 115842 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6003573.21553 2120746.37029 37.8033666892713 -122.431850957862 (37.8033666892713, -122.431850957862) 13 9 1 57 17
2297 16623 DPW Maintained 1 Ceratonia siliqua :: Carob 5 136 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285) 15 5 5 28862 3
3395 17446 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1966 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6012949.46477 2096727.20845 37.7379425338291 -122.397718137505 (37.7379425338291, -122.397718137505) 10 3 8 58 1
4137 61685 DPW Maintained 1 Ceratonia siliqua :: Carob 5 34 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/1984 12:00:00 AM 11   Permit Number 21682 6013864.09066 2093969.56082 37.7304214900476 -122.394362775032 (37.7304214900476, -122.394362775032) 10 3 8 58 1
6002 65883 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3100X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2013 12:00:00 AM 3   Permit Number 770126 6002440.42815 2118878.88214 37.7981747762893 -122.435637321312 (37.7981747762893, -122.435637321312) 13 9 1 57 17
9140 48531 Permitted Site 7 Ceratonia siliqua :: Carob 5 500(REVISED) Capp St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45857 6007225.9541014 2104383.62172477 37.7586449307205 -122.41804980128 (37.7586449307205, -122.41804980128) 2 4 7 28859 19
9688 52724 DPW Maintained 1 Ceratonia siliqua :: Carob 5 160@ HOWARD Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/18/2006 12:00:00 AM 7   Permit Number 48777 6014638.31432 2116297.63809 37.791772555711 -122.393247977227 (37.791772555711, -122.393247977227) 12 2 9 28855 6
9983 248199 DPW Maintained 1 Ceratonia siliqua :: Carob 5 55 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006933.20129 2099091.48631 37.7440974516285 -122.41868698122 (37.7440974516285, -122.41868698122) 2 7 7 28859 2
12569 111886 Undocumented 4 Ceratonia siliqua :: Carob 5 140 LUNDYS LN 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x12   6006709 2098750 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965) 2 7 7 28859 2
13041 19762 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY16 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 30ST                      
14153 61726 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/14/1984 12:00:00 AM 9   Permit Number 21728 6013869.02725 2093995.24936 37.7304922999628 -122.39434750634 (37.7304922999628, -122.39434750634) 10 3 8 58 1
16205 222929 DPW Maintained 1 Ceratonia siliqua :: Carob 5 979 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1979 12:00:00 AM 10 Width 4ft Permit Number 17592 5999199.8898 2106672.6396 37.7644750037296 -122.445972112616 (37.7644750037296, -122.445972112616) 15 5 11 29492 9
17663 101489 Undocumented 4 Ceratonia siliqua :: Carob 5 59X Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/2012 12:00:00 AM 1 3x3 Permit Number 769087 6005416.7 2109221 37.7718252244657 -122.424651142233 (37.7718252244657, -122.424651142233) 7 9 5 28852 10
18217 222886 DPW Maintained 1 Ceratonia siliqua :: Carob 5 139 Webster St 1 : Tree Private 2     15 Width 3ft   6004216.91806 2109283.17336 37.7719281046318 -122.428805703247 (37.7719281046318, -122.428805703247) 7 9 11 29492 10
18873 61724 DPW Maintained 1 Ceratonia siliqua :: Carob 5 18 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1984 12:00:00 AM 8   Permit Number 21726 6013883.84127 2094072.5147 37.7307052783181 -122.394301699376 (37.7307052783181, -122.394301699376) 10 3 8 58 1
18931 16634 DPW Maintained 1 Ceratonia siliqua :: Carob 5 158 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.433406271499 (37.7664480128774, -122.433406271499) 15 5 5 28862 3
19336 247504 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1398 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5999483.6766 2108789.6708 37.7703040400286 -122.445142787454 (37.7703040400286, -122.445142787454) 15 5 11 29492 9
19461 138737 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2945 BUSH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5999415.669 2114277.6236 37.7853686673978 -122.445772761062 (37.7853686673978, -122.445772761062) 15 6 1 29490 31
20031 17400 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1740 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6014126.91093 2095851.18558 37.7356026534403 -122.393585802156 (37.7356026534403, -122.393585802156) 10 3 8 58 1
20304 49779 Permitted Site 7 Ceratonia siliqua :: Carob 5 241@ BLANKEN Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/09/2003 12:00:00 AM     Permit Number 46565 6012711.25696991 2087289.78103258 37.7120160109599 -122.397879925295 (37.7120160109599, -122.397879925295) 10 3 8 309 1
20598 60264 Permitted Site 7 Ceratonia siliqua :: Carob 5 2804 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19820 6009362.55423892 2103960.83669592 37.7576040815568 -122.410630580485 (37.7576040815568, -122.410630580485) 2 4 7 28859 19
21471 139360 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2807 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6000073 2114379 37.7856845299005 -122.443505885647 (37.7856845299005, -122.443505885647) 15 6 1 29490 31
22352 16479 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.384218928939 (37.7425024549748, -122.384218928939) 10 3 8 58 1
22540 225094 DPW Maintained 1 Ceratonia siliqua :: Carob 5 621 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/09/2017 12:00:00 AM 3 Width 3ft Permit Number 780775 6002723.2165 2108842.98565 37.7706348030957 -122.433941050651 (37.7706348030957, -122.433941050651) 15 5 5 29492 9
22673 248195 DPW Maintained 1 Ceratonia siliqua :: Carob 5 99 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006895.3062 2099022.51404 37.7439059356157 -122.418813123741 (37.7439059356157, -122.418813123741) 2 7 7 28859 2
24361 206014 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 San Benito Way 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5992843.12782 2095854.05613 37.7344049138512 -122.467171573123 (37.7344049138512, -122.467171573123) 9 8 4 59 40
24468 57556 Permitted Site 7 Ceratonia siliqua :: Carob 5 57 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23627 6007019.50965831 2099220.3784742 37.7444562195491 -122.418397682663 (37.7444562195491, -122.418397682663) 2 7 7 28859 2
24626 93109 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 9 3x3 Permit Number 53024 6016621.35417 2098362.60938 37.7426368051604 -122.385136406214 (37.7426368051604, -122.385136406214) 10 3 8 58 1
24818 97179 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013408 2116114 37.7911999015077 -122.397492006217 (37.7911999015077, -122.397492006217) 12 2 9 28855 6
24938 188478 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 San Bruno Ave 1 Sidewalk: Curb side : Yard Tree Private 2     13 Width 3ft   6010892.5271 2106015.01328 37.7633300498768 -122.405483954234 (37.7633300498768, -122.405483954234) 8 4 8 28856 19
25806 47316 Permitted Site 7 Ceratonia siliqua :: Carob 5 2524 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/10/2002 12:00:00 AM     Permit Number 45245 6010338.92838604 2105074.55283943 37.7607167883884 -122.407332377331 (37.7607167883884, -122.407332377331) 10 4 8 28859 19
25903 125969 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2672 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6002023.76351 2115741.9503 37.7895379005066 -122.43685441882 (37.7895379005066, -122.43685441882) 13 6 1 29490 27
26053 16540 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     5 0   6016126.25571 2098060.8881 37.7417809401523 -122.386827291768 (37.7417809401523, -122.386827291768) 10 3 8 58 1
26541 62275 Permitted Site 7 Ceratonia siliqua :: Carob 5 141 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22411 6004215.98521889 2109270.59348358 37.771893510559 -122.428808033039 (37.771893510559, -122.428808033039) 7 9 11 29492 10
26621 222916 DPW Maintained 1 Ceratonia siliqua :: Carob 5 92 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6004301.92294 2109033.13825 37.7712463798496 -122.428493839936 (37.7712463798496, -122.428493839936) 7 9 11 28852 10
28248 248203 DPW Maintained 1 Ceratonia siliqua :: Carob 5 47 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6006976.18023 2099171.17204 37.7443186704674 -122.418544018687 (37.7443186704674, -122.418544018687) 2 7 7 28859 2
29498 225099 DPW Maintained 1 Ceratonia siliqua :: Carob 5 109 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM 14 Width 3ft Permit Number 37779 6003663.75485 2108815.27117 37.7706120358534 -122.430685739554 (37.7706120358534, -122.430685739554) 15 9 11 29492 10
30088 5432 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 Dolores St 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3X3   6004968.15127 2105494.35348 37.7615674029223 -122.425937381218 (37.7615674029223, -122.425937381218) 8 4 5 28859 19
30477 222899 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3737 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 6ft   6005393.47694 2104277.70893 37.7582508111316 -122.424379813902 (37.7582508111316, -122.424379813902) 2 4 5 28859 19
32130 5658 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1349-1349 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   6005239.88286 2100530.07402 37.7479520016853 -122.42464442051 (37.7479520016853, -122.42464442051) 2 4 5 28859 19
32220 17420 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1844 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6013467.77602 2096339.40457 37.7369065543995 -122.395898900707 (37.7369065543995, -122.395898900707) 10 3 8 58 1
32299 222920 DPW Maintained 1 Ceratonia siliqua :: Carob 5 957 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5998076.5165 2106905.97838 37.765051481758 -122.449874352843 (37.765051481758, -122.449874352843) 15 5 11 29492 9
33302 60693 Permitted Site 7 Ceratonia siliqua :: Carob 5 2762 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20336 6009623.17116786 2103391.2059206 37.7560546117591 -122.409689051741 (37.7560546117591, -122.409689051741) 2 4 7 28859 19
34635 225051 DPW Maintained 1 Ceratonia siliqua :: Carob 5 4331 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6000881.81518 2102275.99981 37.7524988021808 -122.439839555559 (37.7524988021808, -122.439839555559) 2 4 5 28862 22
35126 15121 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 2X2   6013826.37134 2116069.93693 37.7911022004845 -122.396041353962 (37.7911022004845, -122.396041353962) 12 2 9 28855 6
35310 47061 Permitted Site 7 Ceratonia siliqua :: Carob 5 114 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM   3x3 Permit Number 45048 6004275.94265243 2109216.94695979 37.7717496035942 -122.428596811267 (37.7717496035942, -122.428596811267) 7 9 11 28852 10
35427 35826 Permitted Site 7 Ceratonia siliqua :: Carob 5 658 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/30/2003 12:00:00 AM     Permit Number 47147 6002331.25520589 2089974.9119099 37.7188052443929 -122.433947949751 (37.7188052443929, -122.433947949751) 9 7 6 28861 5
35456 225068 DPW Maintained 1 Ceratonia siliqua :: Carob 5 900 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6009114.1902 2103856.87983 37.7573047117606 -122.411482183163 (37.7573047117606, -122.411482183163) 2 4 7 28859 19
35579 63232 Permitted Site 7 Ceratonia siliqua :: Carob 5 53 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1987 12:00:00 AM     Permit Number 23779 6007031.32644483 2099242.02691528 37.7445163265111 -122.418358357204 (37.7445163265111, -122.418358357204) 2 7 7 28859 2
35885 189864 DPW Maintained 1 Ceratonia siliqua :: Carob 5 501 Newhall St 1 : Tree Private 2     16 Width 3ft   6015974.53489 2097767.48194 37.7409669053009 -122.387331434622 (37.7409669053009, -122.387331434622) 10 3 8 58 1
35932 222922 DPW Maintained 1 Ceratonia siliqua :: Carob 5 848 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5998725.13711 2107078.63003 37.7655626303238 -122.44764337315 (37.7655626303238, -122.44764337315) 15 5 11 29492 9
36033 37053 Permitted Site 7 Ceratonia siliqua :: Carob 5 231 Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/2015 12:00:00 AM 3 6x9 Permit Number 775674 6005030.06979159 2099868.96006137 37.7461248828886 -122.425322907066 (37.7461248828886, -122.425322907066) 2 7 5 63 22
36090 58566 Permitted Site 7 Ceratonia siliqua :: Carob 5 119 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1979 12:00:00 AM   3x3 Permit Number 17756 5997901.33257876 2107130.89979942 37.7656590338964 -122.450496484092 (37.7656590338964, -122.450496484092) 15 5 11 29492 9
36850 21792 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
37593 63223 Permitted Site 7 Ceratonia siliqua :: Carob 5 74 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/08/1986 12:00:00 AM     Permit Number 23767 6007024.24525419 2099097.21630379 37.7441183104389 -122.418372576893 (37.7441183104389, -122.418372576893) 2 7 7 28859 2
37802 119741 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
37929 82121 Permitted Site 7 Ceratonia siliqua :: Carob 5 44 Molimo Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49840 5998809.17063994 2096527.78133102 37.7365973852663 -122.446593550118 (37.7365973852663, -122.446593550118) 9 7 4 59 40
38377 189958 DPW Maintained 1 Ceratonia siliqua :: Carob 5 562 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6010386.69691 2108550.07878 37.7702624648584 -122.407412194212 (37.7702624648584, -122.407412194212) 8 2 9 28853 34
40377 103339 Undocumented 4 Ceratonia siliqua :: Carob 5 590X 09th St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6010323 2108639 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146) 8 2 9 28853 34
41267 63222 Permitted Site 7 Ceratonia siliqua :: Carob 5 76 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1987 12:00:00 AM     Permit Number 23766 6007018.22684623 2099086.03719365 37.7440872763149 -122.418392594768 (37.7440872763149, -122.418392594768) 2 7 7 28859 2
41358 115360 Undocumented 4 Ceratonia siliqua :: Carob 5 205 ARKANSAS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6012944 2106057 37.7635598294353 -122.398391479388 (37.7635598294353, -122.398391479388) 14 3 8 28856 29
41601 222917 DPW Maintained 1 Ceratonia siliqua :: Carob 5 88 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6004303.69708 2109018.65394 37.7712067098536 -122.428486670528 (37.7712067098536, -122.428486670528) 7 9 11 28852 10
41676 175842 DPW Maintained 1 Ceratonia siliqua :: Carob 5 234 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004274.97667 2092050.61974 37.724614796925 -122.427377064513 (37.724614796925, -122.427377064513) 9 7 6 28861 5
42288 199691 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1343 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6016071.0177 2092930.0859 37.7276897308085 -122.38666058841 (37.7276897308085, -122.38666058841) 10 3 8 58 1
42305 182440 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1530 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5985926.0511 2104791.6519 37.7585434265078 -122.49174356194 (37.7585434265078, -122.49174356194) 1 8 3 56 35
43480 65221 Permitted Site 7 Ceratonia siliqua :: Carob 5 411 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1989 12:00:00 AM     Permit Number 28008 6002203.13463286 2091195.37244375 37.7221490848593 -122.434478026037 (37.7221490848593, -122.434478026037) 9 7 6 28861 5
44357 248229 DPW Maintained 1 Ceratonia siliqua :: Carob 5 72 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006943.33301 2099166.51729 37.7443040402894 -122.418657267644 (37.7443040402894, -122.418657267644) 2 7 7 28859 2
46212 61684 Permitted Site 7 Ceratonia siliqua :: Carob 5 49 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/12/1985 12:00:00 AM     Permit Number 21681 6013901.59422939 2093898.15648128 37.7302275129585 -122.394228121663 (37.7302275129585, -122.394228121663) 10 3 8 58 1
47329 16647 DPW Maintained 1 Ceratonia siliqua :: Carob 5 178 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/04/2015 12:00:00 AM 14 4x4   6002850.60519 2107244.6681 37.7662534427777 -122.433386179722 (37.7662534427777, -122.433386179722) 15 5 5 28862 3
47785 63130 Permitted Site 7 Ceratonia siliqua :: Carob 5 26 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23644 6007187.15982152 2099399.82780325 37.7449583833589 -122.417830699083 (37.7449583833589, -122.417830699083) 2 7 7 28859 2
47941 218315 DPW Maintained 1 Ceratonia siliqua :: Carob 5 437 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 0ft   5993144.55141 2099923.03964 37.7455947140337 -122.466425098064 (37.7455947140337, -122.466425098064) 1 8 4 29491 40
48301 225091 DPW Maintained 1 Ceratonia siliqua :: Carob 5 169 Lower Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6000007.70524 2106202.33536 37.7632297601708 -122.443144329371 (37.7632297601708, -122.443144329371) 15 5 5 28862 3
48763 225089 DPW Maintained 1 Ceratonia siliqua :: Carob 5 838 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004316.16009 2104019.9015 37.7574820391842 -122.428087274435 (37.7574820391842, -122.428087274435) 2 4 5 28862 3
49432 222887 DPW Maintained 1 Ceratonia siliqua :: Carob 5 123 Webster St 1 : Tree Private 2     13 Width 5ft   6004226.51196 2109212.81898 37.77173547164 -122.428767500918 (37.77173547164, -122.428767500918) 7 9 11 29492 10
50058 103976 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2440 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6000022.661 2113372.9775 37.7829193814773 -122.44360774817 (37.7829193814773, -122.44360774817) 15 5 1 29490 31
50124 206005 DPW Maintained 1 Ceratonia siliqua :: Carob 5 600 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991064.94409 2097743.51009 37.7394900683054 -122.47345704553 (37.7394900683054, -122.47345704553) 1 8 4 29491 40
50667 2542 Permitted Site 7 Ceratonia siliqua :: Carob 5 1580 Burke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016211.040056 2099180.9466222 37.7448610852571 -122.386612216975 (37.7448610852571, -122.386612216975) 10 3 8 58 1
50898 49041 Permitted Site 7 Ceratonia siliqua :: Carob 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/07/2003 12:00:00 AM     Permit Number 46216 6004132.32350443 2101573.22879489 37.7507536483556 -122.428548658976 (37.7507536483556, -122.428548658976) 2 4 5 28862 22
51291 225053 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6001218.80684 2096592.16387 37.7369115105593 -122.438267032523 (37.7369115105593, -122.438267032523) 2 7 5 63 7
52185 63117 Permitted Site 7 Ceratonia siliqua :: Carob 5 72 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23624 6006928.92708318 2099162.96302102 37.7442934699851 -122.418706828381 (37.7442934699851, -122.418706828381) 2 7 7 28859 2
53125 248260 DPW Maintained 1 Ceratonia siliqua :: Carob 5 132 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006738.11061 2098784.48151 37.7432434994904 -122.419339788302 (37.7432434994904, -122.419339788302) 2 7 7 28859 2
53638 138239 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5999639.177 2114119.037 37.784945988756 -122.444988088871 (37.784945988756, -122.444988088871) 15 6 1 29490 31
53679 56848 Permitted Site 7 Ceratonia siliqua :: Carob 5 1025 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1974 12:00:00 AM   6x5 Permit Number 14082 5998817.86133668 2106377.94605096 37.7636440271414 -122.447272227776 (37.7636440271414, -122.447272227776) 15 5 11 29492 9
53701 51842 Permitted Site 7 Ceratonia siliqua :: Carob 5 34 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 48069 6007044.58832094 2099374.8552715 37.7448817898933 -122.418321916232 (37.7448817898933, -122.418321916232) 2 7 7 28859 2
54510 225090 DPW Maintained 1 Ceratonia siliqua :: Carob 5 188 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002851.63466 2107200.77986 37.7661329947706 -122.433379482476 (37.7661329947706, -122.433379482476) 15 5 5 28862 3
55304 14686 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 4X4   6005447.7824 2111997.5051 37.7794505882327 -122.424741179621 (37.7794505882327, -122.424741179621) 7 9 11 28852 41
56161 18866 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2241 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6004050.55009 2115976.04283 37.7902956422834 -122.429858659173 (37.7902956422834, -122.429858659173) 13 9 1 29490 27
56324 225070 DPW Maintained 1 Ceratonia siliqua :: Carob 5 890 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 3ft   6009108.93583 2103990.98377 37.757672636103 -122.411509829221 (37.757672636103, -122.411509829221) 2 4 7 28859 19
56492 21779 Permitted Site 7 Ceratonia siliqua :: Carob 5 2535 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 4x4   6008355.3148 2121474.21304 37.8056350868765 -122.415353830252 (37.8056350868765, -122.415353830252) 5 1 10 308 23
56518 237914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1001 Stanyan St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 Width 4ft   5997227 2107052 37.7654037766697 -122.452823145368 (37.7654037766697, -122.452823145368) 15 5 11 29492 12
56519 44334 Permitted Site 7 Ceratonia siliqua :: Carob 5 57 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/06/2001 12:00:00 AM     Permit Number 43719 6004283.91720992 2108781.91004669 37.770555549309 -122.428538212023 (37.770555549309, -122.428538212023) 7 9 11 29492 10
56818 139055 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2693 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   5999732.7035 2113978.0164 37.7845641202108 -122.444654378813 (37.7845641202108, -122.444654378813) 15 6 11 29490 31
57765 225058 DPW Maintained 1 Ceratonia siliqua :: Carob 5 283 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5996870.76469 2106986.93981 37.76520471814 -122.454050575073 (37.76520471814, -122.454050575073) 15 5 11 29492 12
58282 115847 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3501 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6003582.67693 2120834.73516 37.8036098524612 -122.431824529496 (37.8036098524612, -122.431824529496) 13 9 1 57 17
60751 64436 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2445 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1988 12:00:00 AM 12   Permit Number 25292 6006658.75135 2119650.10198 37.8005310432266 -122.421095439396 (37.8005310432266, -122.421095439396) 5 9 1 28858 32
61480 246510 DPW Maintained 1 Ceratonia siliqua :: Carob 5 231 Duncan St 1 : Tree Private 2     1 Width 5ft   6004993.26159 2099869.66747 37.7461247456624 -122.425450235552 (37.7461247456624, -122.425450235552) 2 7 5 63 22
61840 222914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 108 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6004276.58953 2109191.75922 37.7716804808011 -122.428592777936 (37.7716804808011, -122.428592777936) 7 9 11 28852 10

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