856 rows where qSpecies_id = 5 sorted by Fire Prevention Districts

View and edit SQL

Fire Prevention 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)
12712 19967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY41 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
13041 19762 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY16 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 30ST                      
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
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
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
33818 206007 DPW Maintained 1 Ceratonia siliqua :: Carob 5 600 Vicente St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991032.21326 2097741.26802 37.7394820166929 -122.473570049822 (37.7394820166929, -122.473570049822) 1 8 4 29491 40
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
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
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
51567 20965 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
55015 20969 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
75171 206004 DPW Maintained 1 Ceratonia siliqua :: Carob 5 10 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5991469.80126 2104851.05791 37.7590289864229 -122.472575296214 (37.7590289864229, -122.472575296214) 1 8 4 56 12
76986 205989 DPW Maintained 1 Ceratonia siliqua :: Carob 5 566 Dewey Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   5994108.82044 2099457.01961 37.744370734026 -122.463057021885 (37.744370734026, -122.463057021885) 1 8 4 29491 40
91647 205994 DPW Maintained 1 Ceratonia siliqua :: Carob 5 334 Pacheco St 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5994253.11993 2101023.44894 37.7486800649323 -122.462671676761 (37.7486800649323, -122.462671676761) 1 8 4 29491 40
110855 114592 Undocumented 4 Ceratonia siliqua :: Carob 5 70 LOMITA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5991433 2104626 37.7584089066312 -122.472686161822 (37.7584089066312, -122.472686161822) 1 8 4 56 12
111983 206019 DPW Maintained 1 Ceratonia siliqua :: Carob 5 99 Merced Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5994816.51833 2099704.78199 37.7450917681756 -122.460627918846 (37.7450917681756, -122.460627918846) 1 8 4 59 40
116296 182304 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2531 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5986925.2797 2105029.7497 37.7592555273516 -122.488305322992 (37.7592555273516, -122.488305322992) 1 8 3 56 35
120839 206020 DPW Maintained 1 Ceratonia siliqua :: Carob 5 146 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994480.54768 2101060.81011 37.7487957447457 -122.461887948175 (37.7487957447457, -122.461887948175) 1 8 4 29491 40
124717 20967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
129163 205988 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1469 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5993333.43827 2105504.18267 37.7609299931406 -122.466177475131 (37.7609299931406, -122.466177475131) 1 8 4 56 12
142864 32581 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1314 33rd Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1996 12:00:00 AM 4   Permit Number 37055 5985876.1437 2106257.7648 37.7625660493627 -122.492024105228 (37.7625660493627, -122.492024105228) 1 8 3 56 35
145696 206010 DPW Maintained 1 Ceratonia siliqua :: Carob 5 650 Vicente St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5990906.39798 2097737.17838 37.7394635005399 -122.474004761412 (37.7394635005399, -122.474004761412) 1 8 4 29491 40
149591 206002 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1593 15th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991725.37276 2104496.31776 37.7580697533422 -122.471665566332 (37.7580697533422, -122.471665566332) 1 8 4 56 12
159563 205993 DPW Maintained 1 Ceratonia siliqua :: Carob 5 334 Pacheco St 1 Sidewalk: Curb side : Yard Tree Private 2     10 Width 3ft   5994259.77922 2101011.29176 37.7486470679175 -122.462647767404 (37.7486470679175, -122.462647767404) 1 8 4 29491 40
161171 113383 Undocumented 4 Ceratonia siliqua :: Carob 5 146 CASTENADA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   5994461 2101055 37.7487786662853 -122.461955122224 (37.7487786662853, -122.461955122224) 1 8 4 29491 40
164683 112815 Undocumented 4 Ceratonia siliqua :: Carob 5 10 LOMITA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991472 2104830 37.7589712942358 -122.472566156736 (37.7589712942358, -122.472566156736) 1 8 4 56 12
164831 206009 DPW Maintained 1 Ceratonia siliqua :: Carob 5 650 Vicente St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990946.44352 2097737.21302 37.7394659152092 -122.47386630538 (37.7394659152092, -122.47386630538) 1 8 4 29491 40
170609 206008 DPW Maintained 1 Ceratonia siliqua :: Carob 5 600 Vicente St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5990990.06403 2097739.22497 37.7394739659536 -122.473715632987 (37.7394739659536, -122.473715632987) 1 8 4 29491 40
176911 206011 DPW Maintained 1 Ceratonia siliqua :: Carob 5 650 Vicente St 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5990881.65673 2097736.82059 37.7394610849722 -122.474090278863 (37.7394610849722, -122.474090278863) 1 8 4 29491 40
182568 206012 DPW Maintained 1 Ceratonia siliqua :: Carob 5 650 Vicente St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   5990870.16608 2097736.47672 37.7394594751618 -122.474129983014 (37.7394594751618, -122.474129983014) 1 8 4 29491 40
188809 218314 DPW Maintained 1 Ceratonia siliqua :: Carob 5 437 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 0ft   5993129.70143 2099920.62697 37.7455872325622 -122.466476271275 (37.7455872325622, -122.466476271275) 1 8 4 29491 40
191561 206003 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1593 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5991725.49788 2104502.2556 37.7580860643266 -122.471665566325 (37.7580860643266, -122.471665566325) 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
34404 4917 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1   01/26/2015 05:50:00 AM 3 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
34794 83038 Undocumented 4 Ceratonia siliqua :: Carob 5 100X Cargo Way 14 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/04/2006 12:00:00 AM       6018593.33009 2097780.6594 37.7411477742489 -122.378277419086 (37.7411477742489, -122.378277419086) 10 3 8 58 1
35125 4920 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   01/26/2015 05:54:00 AM 3 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
35835 2509 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1501 Burke Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016682.7889975 2098765.8378067 37.743747386446 -122.384952066789 (37.743747386446, -122.384952066789) 10 3 8 58 1
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
36755 14910 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017317.95316 2098168.33206 37.7421418684871 -122.38271422872 (37.7421418684871, -122.38271422872) 10 3 8 58 1
37237 16527 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016370.17243 2098292.39049 37.7424301004582 -122.386000034169 (37.7424301004582, -122.386000034169) 10 3 8 58 1
39064 6846 DPW Maintained 1 Ceratonia siliqua :: Carob 5 595X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6015951.07042 2097735.77472 37.7408785442151 -122.387410355501 (37.7408785442151, -122.387410355501) 10 3 8 58 1
39895 189881 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 6 : Tree Private 2     10 Width 3ft   6016559.49898 2098322.63372 37.7425236182725 -122.385347500499 (37.7425236182725, -122.385347500499) 10 3 8 58 1
40094 2518 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016498.61775 2098890.19219 37.7440786495081 -122.385597557904 (37.7440786495081, -122.385597557904) 10 3 8 58 1
40384 16481 Permitted Site 7 Ceratonia siliqua :: Carob 5 220 Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.384218928939 (37.7425024549748, -122.384218928939) 10 3 8 58 1
40554 189850 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 14 : Tree Private 2     9 Width 3ft   6017345.72519 2098082.05897 37.7419065142755 -122.382612199015 (37.7419065142755, -122.382612199015) 10 3 8 58 1
40972 16484 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 6 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
41334 2516 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016465.84234 2098914.75953 37.7441442928392 -122.38571260096 (37.7441442928392, -122.38571260096) 10 3 8 58 1
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
42308 3639 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 75 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6017551.66161 2098562.89956 37.743238180002 -122.381933568796 (37.743238180002, -122.381933568796) 10 3 8 58 1
42634 2501 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016709.08958 2098828.16093 37.7439199677279 -122.384865465686 (37.7439199677279, -122.384865465686) 10 3 8 58 1
43304 14908 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 2 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
43361 14928 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6016461.7664057 2098387.7906821 37.7426971185746 -122.385689974252 (37.7426971185746, -122.385689974252) 10 3 8 58 1
44548 189913 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 9 : Tree Private 2     6 Width 3ft   6013888.27035 2094422.90108 37.731667614051 -122.39431091023 (37.731667614051, -122.39431091023) 10 3 8 58 1
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

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