856 rows where qSpecies_id = 5 sorted by PermitNotes

View and edit SQL

Suggested facets: SiteOrder, qCareAssistant, Fire Prevention Districts, Police Districts, Supervisor Districts

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)
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
372 189871 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 9 : Tree Private 2     7 Width 3ft   6016028.58203 2097927.48174 37.7414092251604 -122.387155715173 (37.7414092251604, -122.387155715173) 10 3 8 58 1
438 16548 Permitted Site 7 Ceratonia siliqua :: Carob 5 400X Newhall St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016043.45751 2097947.55726 37.7414651721818 -122.387105680372 (37.7414651721818, -122.387105680372) 10 3 8 58 1
640 222906 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6004761.72453 2109824.22026 37.7734445081828 -122.42695971791 (37.7734445081828, -122.42695971791) 7 9 11 28852 10
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
857 189910 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 11 Sidewalk: Curb side : Cutout Tree DPW 1     14 Width 3ft   6016250.22154 2098227.10108 37.7422441899167 -122.386410241063 (37.7422441899167, -122.386410241063) 10 3 8 58 1
1256 97187 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
1800 189943 DPW Maintained 1 Ceratonia siliqua :: Carob 5 160 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014663.90287 2116268.03372 37.7916926905231 -122.393157367813 (37.7916926905231, -122.393157367813) 12 2 9 28855 6
1856 16547 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Newhall St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016044.76119 2097949.4335 37.7414703961451 -122.387101303489 (37.7414703961451, -122.387101303489) 10 3 8 58 1
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
2472 6651 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
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
3688 189905 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 Width 3ft   6016340.3864 2098339.29531 37.7425572430226 -122.386106295385 (37.7425572430226, -122.386106295385) 10 3 8 58 1
4441 246422 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Duncan St 4 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6003829.35465 2099854.81871 37.7460181445246 -122.429473817668 (37.7460181445246, -122.429473817668) 2 7 5 63 22
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
5811 2517 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016481.64243 2098901.45238 37.7441086284068 -122.385657039951 (37.7441086284068, -122.385657039951) 10 3 8 58 1
6962 189948 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 1ft   6014781.22378 2116142.62721 37.7913548700732 -122.392742658052 (37.7913548700732, -122.392742658052) 12 2 9 28855 6
7794 78331 DPW Maintained 1 Ceratonia siliqua :: Carob 5 50 Pomona St 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014103.03356 2094377.1679 37.7315539757311 -122.393565225657 (37.7315539757311, -122.393565225657) 10 3 8 58 1
8003 21791 Permitted Site 7 Ceratonia siliqua :: Carob 5 2585 Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 4X4   6008347.28278 2121527.17705 37.8057800612465 -122.415385378175 (37.8057800612465, -122.415385378175) 5 1 10 308 23
8094 78325 DPW Maintained 1 Ceratonia siliqua :: Carob 5 50 Pomona St 22 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014082.07463 2094268.00581 37.7312530742586 -122.393630047885 (37.7312530742586, -122.393630047885) 10 3 8 58 1
8125 189865 DPW Maintained 1 Ceratonia siliqua :: Carob 5 501 Newhall St 2 : Tree Private 2     13 Width 4ft   6015985.7864 2097784.98338 37.7410155838051 -122.387293751216 (37.7410155838051, -122.387293751216) 10 3 8 58 1
8282 80561 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1820X Palou Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6013651.87309 2096197.81138 37.7365280090438 -122.395252475224 (37.7365280090438, -122.395252475224) 10 3 8 58 1
8477 224897 DPW Maintained 1 Ceratonia siliqua :: Carob 5 600 Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007276.43224 2097752.07019 37.7404390320343 -122.417405258456 (37.7404390320343, -122.417405258456) 2 7 7 28859 2
9018 126003 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 8 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6007892.37102 2121599.81603 37.8059539308952 -122.416964822665 (37.8059539308952, -122.416964822665) 5 1 10 308 23
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
10434 189892 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 6 : Tree Private 2     13 Width 4ft   6016806.72009 2098324.89991 37.7425435148768 -122.384492832481 (37.7425435148768, -122.384492832481) 10 3 8 58 1
10873 189885 DPW Maintained 1 Ceratonia siliqua :: Carob 5 201 Newhall St 6 : Tree Private 2     3 Width 3ft   6016834.26905 2098267.19561 37.7423865939792 -122.384393557236 (37.7423865939792, -122.384393557236) 10 3 8 58 1
11061 189851 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 15 : Tree Private 2     12 Width 3ft   6017359.84801 2098072.09609 37.7418799384027 -122.382562673322 (37.7418799384027, -122.382562673322) 10 3 8 58 1
11562 206018 DPW Maintained 1 Ceratonia siliqua :: Carob 5 99 Merced Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5994828.29695 2099714.01169 37.7451177882671 -122.460587859436 (37.7451177882671, -122.460587859436) 1 8 4 59 40
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
12701 3581 Permitted Site 7 Ceratonia siliqua :: Carob 5 100X Cargo Way 16 Sidewalk: Curb side : Cutout Tree Port 6   03/01/2006 12:00:00 AM 3 3X3   6018980.3390981 2097500.2540781 37.7403991596993 -122.376919818221 (37.7403991596993, -122.376919818221) 10 3 8 58 1
12712 19967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY41 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
12741 188474 DPW Maintained 1 Ceratonia siliqua :: Carob 5 255 12th St 9 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6007923.25888 2109012.80714 37.7713948192467 -122.415966013116 (37.7713948192467, -122.415966013116) 8 2 9 28853 19
13041 19762 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY16 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 30ST                      
13958 262096 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 3 Sidewalk: Curb side : Cutout Tree DPW 1       Width 3ft   6016433.67399 2098382.99048 37.7426823836985 -122.385786776164 (37.7426823836985, -122.385786776164) 10 3 8 58 1
14221 189868 DPW Maintained 1 Ceratonia siliqua :: Carob 5 401 Newhall St 3 : Tree Private 2     7 Width 3ft   6016117.80915 2097961.55377 37.7415077207098 -122.386849571549 (37.7415077207098, -122.386849571549) 10 3 8 58 1
14738 103343 Undocumented 4 Ceratonia siliqua :: Carob 5 590X 09th St 5 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6010323 2108639 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146) 8 2 9 28853 34
15049 16543 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Newhall St 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3x3   6016084.8488 2098009.98397 37.7416388751438 -122.38696691509 (37.7416388751438, -122.38696691509) 10 3 8 58 1
15607 189834 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1698 Galvez Ave 4 : Tree Private 2     14 Width 4ft   6015429.09406 2098017.0802 37.7416220281222 -122.389234809264 (37.7416220281222, -122.389234809264) 10 3 8 58 1
15625 27616 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005483.48508 2112000.60744 37.7794611228941 -122.424617889559 (37.7794611228941, -122.424617889559) 7 9 11 28852 41
16214 16506 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016450.0254075 2098336.1941649 37.7425547953869 -122.385726976255 (37.7425547953869, -122.385726976255) 10 3 8 58 1
16420 189843 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017155.58292 2098191.33075 37.742196046505 -122.383277260246 (37.742196046505, -122.383277260246) 10 3 8 58 1
16430 119738 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 4 Sidewalk: Curb side : Cutout Tree Private 2     7     6013480.63892 2116044.41356 37.7910128776808 -122.397235794198 (37.7910128776808, -122.397235794198) 12 2 9 28855 6
16559 222925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1025 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5998825.08997 2106348.09575 37.7635624787486 -122.447245077795 (37.7635624787486, -122.447245077795) 15 5 11 29492 9
17541 14919 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017351.5544479 2098138.8848753 37.7420628687633 -122.382595996286 (37.7420628687633, -122.382595996286) 10 3 8 58 1
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
18347 189903 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6016618 2098337 37.7425663014752 -122.385146220096 (37.7425663014752, -122.385146220096) 10 3 8 58 1
18852 222928 DPW Maintained 1 Ceratonia siliqua :: Carob 5 912 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5998758.16977 2106859.07637 37.7649616790718 -122.447513315894 (37.7649616790718, -122.447513315894) 15 5 11 29492 9
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
19053 153989 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6016386.30028 2098368.17483 37.7426390813321 -122.385949549827 (37.7426390813321, -122.385949549827) 10 3 8 58 1
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
19339 21778 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500X Taylor St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 5X5   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23
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
19610 14916 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6017173.30591 2098243.55942 37.7423404352704 -122.383219613607 (37.7423404352704, -122.383219613607) 10 3 8 58 1
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
20273 18860 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2212 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004055.90045 2116026.39415 37.7904341972353 -122.429843740294 (37.7904341972353, -122.429843740294) 13 9 1 29490 27
20489 225066 DPW Maintained 1 Ceratonia siliqua :: Carob 5 199 Franconia St 13 : Yard Tree Private 2     5 Width 3ft   6010116.17854 2099660.00965 37.7458371865343 -122.407720980957 (37.7458371865343, -122.407720980957) 2 7 7 28859 2
21283 225084 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3784 22nd St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003185.26448 2103031.00379 37.7547027131682 -122.431927750974 (37.7547027131682, -122.431927750974) 2 4 5 28862 22
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
21523 189852 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 Newhall St 2 : Tree Private 2     8 Width 3ft   6017365.88907 2098130.81013 37.7420414890213 -122.38254586949 (37.7420414890213, -122.38254586949) 10 3 8 58 1
21860 206006 DPW Maintained 1 Ceratonia siliqua :: Carob 5 600 Vicente St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5991049.3393 2097743.54574 37.7394892625221 -122.473511002145 (37.7394892625221, -122.473511002145) 1 8 4 29491 40
21954 189895 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 2 : Tree Private 2     9 Width 3ft   6016704.91422 2098345.41637 37.7425942186412 -122.384846279543 (37.7425942186412, -122.384846279543) 10 3 8 58 1
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
22361 125968 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2810 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6001336.41783 2115647.62359 37.7892398148051 -122.439225792541 (37.7892398148051, -122.439225792541) 13 6 1 29490 27
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
23100 125989 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6008326.45195 2121634.40634 37.8060733149832 -122.41546506288 (37.8060733149832, -122.41546506288) 5 1 10 308 23
23115 189845 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 7 : Tree Private 2     6 Width 3ft   6017192.34248 2098175.05438 37.7421533862633 -122.383149023221 (37.7421533862633, -122.383149023221) 10 3 8 58 1
23322 189937 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013275.69539 2116164.65668 37.7913316253015 -122.397953334494 (37.7913316253015, -122.397953334494) 12 2 9 28855 6
23738 4926 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
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
24686 20125 Permitted Site 7 Ceratonia siliqua :: Carob 5 924X Fell St 5 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6002999.41967 2110319.25168 37.7747039360019 -122.433091154251 (37.7747039360019, -122.433091154251) 15 5 11 29492 10
24753 140022 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 MCALLISTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6005467.685 2112000.1843 37.7794590687234 -122.424672518677 (37.7794590687234, -122.424672518677) 7 9 11 28852 41
24789 188485 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1525 Burke Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6016660.6215 2098754.7402 37.7437156885266 -122.385027944407 (37.7437156885266, -122.385027944407) 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
25251 14688 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1     26 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
25898 225060 DPW Maintained 1 Ceratonia siliqua :: Carob 5 243 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5997087.67897 2106671.87912 37.7643520771977 -122.453277577199 (37.7643520771977, -122.453277577199) 15 5 11 29492 12
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
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
26717 189875 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 15 : Tree Private 2     12 Width 3ft   6015903.72942 2097762.72481 37.7409499215909 -122.387575924289 (37.7409499215909, -122.387575924289) 10 3 8 58 1
26958 188469 DPW Maintained 1 Ceratonia siliqua :: Carob 5 255 12th St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6008084.26268 2108917.74209 37.771142843604 -122.415402360325 (37.771142843604, -122.415402360325) 8 2 9 28853 19
27880 438 DPW Maintained 1 Ceratonia siliqua :: Carob 5 792X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     80 6   6004975.0011312 2103729.1085203 37.7567208435744 -122.425788038834 (37.7567208435744, -122.425788038834) 2 4 5 28862 3
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
29270 103687 Undocumented 4 Ceratonia siliqua :: Carob 5 903 SHOTWELL ST 2 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6008052 2102672 37.7539916655216 -122.415071798268 (37.7539916655216, -122.415071798268) 2 4 7 28859 19
29463 189899 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6016506.94741 2098386.01279 37.7426947367801 -122.385533625971 (37.7426947367801, -122.385533625971) 10 3 8 58 1
29579 189876 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 8 : Tree Private 2     8 Width 3ft   6016406.62692 2098319.91707 37.7425077002596 -122.385875902556 (37.7425077002596, -122.385875902556) 10 3 8 58 1
29632 102874 Permitted Site 7 Ceratonia siliqua :: Carob 5 2761 21st St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6009574.6 2103896.5 37.7574393136514 -122.409892695521 (37.7574393136514, -122.409892695521) 2 4 7 28859 19
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
31579 225050 DPW Maintained 1 Ceratonia siliqua :: Carob 5 500x 27th St 24 Median : Cutout Tree DPW 1     11 Width 4ft   6002949.31338 2100070.05084 37.7465592558077 -122.432532251866 (37.7465592558077, -122.432532251866) 2 7 5 63 22
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
32244 111887 Undocumented 4 Ceratonia siliqua :: Carob 5 140 LUNDYS LN 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x12   6006709 2098750 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965) 2 7 7 28859 2
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
32402 115846 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Bay St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003504.2747 2120736.26354 37.8033350304463 -122.432088807873 (37.8033350304463, -122.432088807873) 13 9 1 57 17
32557 6849 Permitted Site 7 Ceratonia siliqua :: Carob 5 595X Newhall St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6015895.1615953 2097662.6258274 37.7406745956723 -122.387598567026 (37.7406745956723, -122.387598567026) 10 3 8 58 1
32911 248271 DPW Maintained 1 Ceratonia siliqua :: Carob 5 157 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6006700.68835 2098666.52237 37.7429175024299 -122.419460818167 (37.7429175024299, -122.419460818167) 2 7 7 28859 2
33168 14912 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017247.98036 2098210.14599 37.7422528150795 -122.38295908457 (37.7422528150795, -122.38295908457) 10 3 8 58 1
33787 2545 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1590X Burke Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/1990 12:00:00 AM 12 3X3   6016148.3291237 2099227.8294693 37.7449863439757 -122.386832330586 (37.7449863439757, -122.386832330586) 10 3 8 58 1

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