136 rows where SiteOrder = 2 and qSpecies_id = 5 sorted by TreeID

View and edit SQL

Supervisor Districts

SiteOrder

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)
139674 101042 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47845 6006837 2121873 37.8066446021589 -122.420636512845 (37.8066446021589, -122.420636512845) 5 1 1 28858 32
127110 103340 Undocumented 4 Ceratonia siliqua :: Carob 5 590X 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 772809 6010323 2108639 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146) 8 2 9 28853 34
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
187922 10409 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1398 HAIGHT ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   5999436 2108778 37.7702692735678 -122.445306860847 (37.7702692735678, -122.445306860847) 15 5 11 29492 9
43272 105450 Undocumented 4 Ceratonia siliqua :: Carob 5 890 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2           6009082.7 2103985.1 37.7576550089679 -122.411600148106 (37.7576550089679, -122.411600148106) 2 4 7 28859 19
147008 106033 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Main St 2 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
61904 110184 Undocumented 4 Ceratonia siliqua :: Carob 5 1500x LYON ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999718 2114083 37.7848515388794 -122.444712796347 (37.7848515388794, -122.444712796347) 15 6 1 29490 31
140473 11180 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006892.18437 2121805.14198 37.806461391357 -122.420440716763 (37.806461391357, -122.420440716763) 5 1 1 28858 32
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
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
149041 113693 Undocumented 4 Ceratonia siliqua :: Carob 5 112 LUNDYS LN 2 Sidewalk: Curb side : Cutout Tree Private 2       3x5   6006814 2098928 37.7436418429474 -122.419087559811 (37.7436418429474, -122.419087559811) 2 7 7 28859 2
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
62148 115558 Undocumented 4 Ceratonia siliqua :: Carob 5 2500x 19TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010357 2105131 37.7608727909959 -122.407273854716 (37.7608727909959, -122.407273854716) 10 4 8 28859 19
191816 115841 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3501 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/19/2017 12:00:00 AM 3 3x3   6003584.99572 2120815.79777 37.8035579867804 -122.431815152253 (37.8035579867804, -122.431815152253) 13 9 1 57 17
179100 115843 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Bay St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6003556.38477 2120742.54729 37.8033552382023 -122.431908928161 (37.8033552382023, -122.431908928161) 13 9 1 57 17
89068 119742 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
194344 124321 DPW Maintained 1 Ceratonia siliqua :: Carob 5 115 Jordan Ave 2 Sidewalk: Curb side : Yard Tree Private 2   12/16/2020 12:00:00 AM 3 Width 3ft   5996193.40211 2113658.22839 37.7834834671867 -122.456875951009 (37.7834834671867, -122.456875951009) 11 6 1 54 31
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
167066 125973 DPW Maintained 1 Ceratonia siliqua :: Carob 5 633 Beach St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6006932.43872 2121860.17562 37.8066147680158 -122.420305317544 (37.8066147680158, -122.420305317544) 5 1 1 28858 32
154655 125978 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008392.85025 2121496.40648 37.8056981340166 -122.415225505068 (37.8056981340166, -122.415225505068) 5 1 10 308 23
107672 125981 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 6ft   6008384.91577 2121552.17509 37.8058508146246 -122.415256913874 (37.8058508146246, -122.415256913874) 5 1 10 308 23
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
178863 125997 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6007910.60432 2121475.90892 37.8056147389887 -122.416892938958 (37.8056147389887, -122.416892938958) 5 1 10 308 23
49549 13332 DPW Maintained 1 Ceratonia siliqua :: Carob 5 145 Mansell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6011384.17484 2090567.17856 37.7209410845847 -122.402697063866 (37.7209410845847, -122.402697063866) 10 7 8 309 28
97344 138240 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999643.6372 2114098.2225 37.7848890921049 -122.444971161243 (37.7848890921049, -122.444971161243) 15 6 1 29490 31
179176 139007 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5999691.7088 2114071.461 37.7848183554363 -122.444802925313 (37.7848183554363, -122.444802925313) 15 6 1 29490 31
111478 139056 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2693 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999748.2433 2113980.0087 37.7845704772917 -122.444600759792 (37.7845704772917, -122.444600759792) 15 6 11 29490 31
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
57482 140579 DPW Maintained 1 Ceratonia siliqua :: Carob 5 949 FILLMORE ST 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003399.7999 2111643.4846 37.7783626547096 -122.431800729752 (37.7783626547096, -122.431800729752) 15 9 11 29492 41
36977 14687 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
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
57622 14925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016461.7664057 2098387.7906821 37.7426971185746 -122.385689974252 (37.7426971185746, -122.385689974252) 10 3 8 58 1
95233 15122 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 2X2   6013811.40838 2116056.32171 37.7910639837629 -122.396092171091 (37.7910639837629, -122.396092171091) 12 2 9 28855 6
102749 16480 Permitted Site 7 Ceratonia siliqua :: Carob 5 220 Newhall St 2 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
109930 16491 DPW Maintained 1 Ceratonia siliqua :: Carob 5 305X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016683.07088 2098298.50072 37.7424641896573 -122.384918540359 (37.7424641896573, -122.384918540359) 10 3 8 58 1
100676 16500 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 2 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
48636 16511 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016438.27303 2098384.37308 37.7426864345304 -122.385770970205 (37.7426864345304, -122.385770970205) 10 3 8 58 1
113438 16522 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016298.51131 2098203.01239 37.7421807202532 -122.386241589372 (37.7421807202532, -122.386241589372) 10 3 8 58 1
168028 16541 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6016112.61616 2098044.40161 37.7417349164267 -122.386873303758 (37.7417349164267, -122.386873303758) 10 3 8 58 1
117426 17378 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1600 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6014792.92868 2095354.29337 37.7342752738796 -122.391248382303 (37.7342752738796, -122.391248382303) 10 3 8 58 1
183287 188468 DPW Maintained 1 Ceratonia siliqua :: Carob 5 255 12th St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6008096.35172 2108912.02487 37.7711278249234 -122.415360138963 (37.7711278249234, -122.415360138963) 8 2 9 28853 19
77410 188477 DPW Maintained 1 Ceratonia siliqua :: Carob 5 499 San Bruno Ave 2 Sidewalk: Curb side : Yard Tree Private 2     16 Width 3ft   6010894.54885 2106022.42438 37.7633505121307 -122.405477483603 (37.7633505121307, -122.405477483603) 8 4 8 28856 19
52442 188480 DPW Maintained 1 Ceratonia siliqua :: Carob 5 209 Arkansas St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6012920.54855 2106035.89651 37.7635005775036 -122.398471110175 (37.7635005775036, -122.398471110175) 14 3 8 28856 29
79345 18853 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2222 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3X3   6004009.33777 2116018.08762 37.7904087527096 -122.430004251319 (37.7904087527096, -122.430004251319) 13 9 1 29490 27
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
56233 18865 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2230 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003863.26827 2115999.97726 37.7903507527417 -122.430508349195 (37.7903507527417, -122.430508349195) 13 9 1 29490 27
71087 189833 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 2 : Tree DPW 1   02/12/2016 12:00:00 AM 14 Width 3ft   6016585.78665 2098909.19771 37.7441356575455 -122.385297468507 (37.7441356575455, -122.385297468507) 10 3 8 58 1
184901 189840 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 2 : Tree Private 2     3 Width 3ft   6017094.37686 2098212.93845 37.7422519942486 -122.383490397763 (37.7422519942486, -122.383490397763) 10 3 8 58 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
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
111910 189867 DPW Maintained 1 Ceratonia siliqua :: Carob 5 401 Newhall St 2 : Tree Private 2     16 Width 3ft   6016089.46635 2097928.70806 37.7414159637784 -122.38694528192 (37.7414159637784, -122.38694528192) 10 3 8 58 1
102361 189877 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 2 : Tree Private 2     7 Width 3ft   6016448.85629 2098333.07564 37.7425461678608 -122.385730801451 (37.7425461678608, -122.385730801451) 10 3 8 58 1
124439 189888 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 2 : Tree Private 2     6 Width 3ft   6016891.26784 2098307.49665 37.7425004040788 -122.384199276697 (37.7425004040788, -122.384199276697) 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
75654 189902 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 Width 3ft   6016433.67399 2098382.99048 37.7426823836985 -122.385786776164 (37.7426823836985, -122.385786776164) 10 3 8 58 1
88195 189918 DPW Maintained 1 Ceratonia siliqua :: Carob 5 338 Mission St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6013810.73123 2116050.81938 37.7910488379738 -122.396094128247 (37.7910488379738, -122.396094128247) 12 2 9 28855 6
141155 189927 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013321.30985 2116211.38819 37.7914624793694 -122.3977987878 (37.7914624793694, -122.3977987878) 12 2 9 28855 6
178073 189942 DPW Maintained 1 Ceratonia siliqua :: Carob 5 160 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014651.73587 2116280.65037 37.7917266570015 -122.393200349112 (37.7917266570015, -122.393200349112) 12 2 9 28855 6
159299 189945 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 1ft   6014694.61322 2116242.67208 37.7916247593304 -122.393049334066 (37.7916247593304, -122.393049334066) 12 2 9 28855 6
177137 189949 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6014767.16396 2116087.91405 37.791203859513 -122.392787475772 (37.791203859513, -122.392787475772) 12 2 9 28855 6
63341 189955 DPW Maintained 1 Ceratonia siliqua :: Carob 5 145 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6014561.09202 2115949.59191 37.790812611275 -122.393490799583 (37.790812611275, -122.393490799583) 12 2 9 28855 6
71893 189957 DPW Maintained 1 Ceratonia siliqua :: Carob 5 572 07th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6011483.58307 2109635.35024 37.7733037049339 -122.403694422077 (37.7733037049339, -122.403694422077) 14 2 9 28853 34
62803 189959 DPW Maintained 1 Ceratonia siliqua :: Carob 5 562 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6010397.61848 2108539.03358 37.7702327485634 -122.40737363759 (37.7702327485634, -122.40737363759) 8 2 9 28853 34
170432 199692 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1343 Thomas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6016085.8906 2092920.1706 37.7276633287451 -122.386608480998 (37.7276633287451, -122.386608480998) 10 3 8 58 1
100972 199697 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1331 Thomas Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6016182.8401 2092843.0517 37.7274569422187 -122.386267947878 (37.7274569422187, -122.386267947878) 10 3 8 58 1
149414 205991 DPW Maintained 1 Ceratonia siliqua :: Carob 5 452 Kenwood Way 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993388.91946 2093682.37508 37.7284735045328 -122.465126926677 (37.7284735045328, -122.465126926677) 9 8 4 59 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
174999 205996 DPW Maintained 1 Ceratonia siliqua :: Carob 5 30 Molimo Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   5998822.4881 2096514.65172 37.7365620951723 -122.446546561796 (37.7365620951723, -122.446546561796) 9 7 4 59 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
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
38322 206016 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5995893.6658 2094152.61505 37.7299087874515 -122.456501934539 (37.7299087874515, -122.456501934539) 9 7 4 28861 40
179167 206017 DPW Maintained 1 Ceratonia siliqua :: Carob 5 59 Hazelwood Ave 2 Sidewalk: Curb side : Yard Tree Private 2     9 Width 3ft   5996580.00391 2094034.75678 37.7296245567167 -122.454120687124 (37.7296245567167, -122.454120687124) 9 7 4 28861 40
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
64750 21777 Permitted Site 7 Ceratonia siliqua :: Carob 5 2500X Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/15/1992 12:00:00 AM 3 3x3   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23
67442 21780 Permitted Site 7 Ceratonia siliqua :: Carob 5 2535 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 4X4   6008357.89402 2121452.8869 37.805576675639 -122.41534339379 (37.805576675639, -122.41534339379) 5 1 10 308 23
150613 21782 Permitted Site 7 Ceratonia siliqua :: Carob 5 2550 TAYLOR ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 5x5   6008458.6 2121488.8 37.8056809434427 -122.414997429015 (37.8056809434427, -122.414997429015) 3 1 10 308 23
64093 21787 Permitted Site 7 Ceratonia siliqua :: Carob 5 2585 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 4X4   6008331.30284 2121636.25204 37.8060786554609 -122.415448406282 (37.8060786554609, -122.415448406282) 5 1 10 308 23
100104 21793 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 2 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
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
77058 222893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 301 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 Width 4ft   6004914.2278 2106488.73534 37.7642946914815 -122.426194676362 (37.7642946914815, -122.426194676362) 8 4 5 28859 19
169536 222895 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3080 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft Permit Number 27054 6006273.18784 2106724.09401 37.7650176483701 -122.421511125848 (37.7650176483701, -122.421511125848) 8 4 7 28853 19
101361 222898 Undocumented 4 Ceratonia siliqua :: Carob 5 2771 22nd St 2 Sidewalk: Curb side : Yard Tree Private 2     21 Width 6ft   6009527.7031 2103333.93064 37.7558919964247 -122.410015170384 (37.7558919964247, -122.410015170384) 2 4 7 28859 19
148016 222902 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6010304.7702 2105067.63235 37.760695874438 -122.407450027813 (37.760695874438, -122.407450027813) 10 4 8 28859 19
116588 222905 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6004739.78961 2109820.49268 37.7734330328342 -122.427035328438 (37.7734330328342, -122.427035328438) 7 9 11 28852 10
69905 222921 DPW Maintained 1 Ceratonia siliqua :: Carob 5 957 Cole St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   5998078.46928 2106885.24351 37.7649946607859 -122.449866104246 (37.7649946607859, -122.449866104246) 15 5 11 29492 9
145445 222923 DPW Maintained 1 Ceratonia siliqua :: Carob 5 88 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5998162.74598 2106870.63901 37.7649593821837 -122.449573561064 (37.7649593821837, -122.449573561064) 15 5 11 29492 9
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
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
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
171993 225042 DPW Maintained 1 Ceratonia siliqua :: Carob 5 979 Ashbury St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5999193.16537 2106656.55415 37.7644304531311 -122.445994213458 (37.7644304531311, -122.445994213458) 15 5 11 29492 9
64795 225045 DPW Maintained 1 Ceratonia siliqua :: Carob 5 881 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6009145.12233 2103987.25914 37.7576644387915 -122.411384417877 (37.7576644387915, -122.411384417877) 2 4 7 28859 19
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
115384 225080 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2823 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009082.12028 2103902.99509 37.7574295349581 -122.411596352099 (37.7574295349581, -122.411596352099) 2 4 7 28859 19
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
108228 225097 DPW Maintained 1 Ceratonia siliqua :: Carob 5 290 Waller St 2 Sidewalk: Curb side : Yard Tree Private 2     17 Width 3ft   6004333.63591 2109116.41234 37.7714768248196 -122.42839007974 (37.7714768248196, -122.42839007974) 7 9 11 28852 10
107019 225101 DPW Maintained 1 Ceratonia siliqua :: Carob 5 75 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 5ft   6006050.3801 2109334.27291 37.7721720124675 -122.422467246366 (37.7721720124675, -122.422467246366) 8 2 9 28853 19
98842 22886 DPW Maintained 1 Ceratonia siliqua :: Carob 5 95X Valencia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6006042.93395 2109155.55847 37.7716808854236 -122.422480302267 (37.7716808854236, -122.422480302267) 8 2 9 28853 19
122812 23566 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2958 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2005 12:00:00 AM 6     6005632.06356 2120580.68582 37.8030282582004 -122.424714436346 (37.8030282582004, -122.424714436346) 5 9 1 28858 32
60894 246420 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Duncan St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6003851.19686 2099854.61267 37.7460188154337 -122.429398275524 (37.7460188154337, -122.429398275524) 2 7 5 63 22
83815 248196 DPW Maintained 1 Ceratonia siliqua :: Carob 5 99 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006902.26536 2099037.70953 37.7439480508589 -122.418790137961 (37.7439480508589, -122.418790137961) 2 7 7 28859 2

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