661 rows where qCaretaker_id = 2 and qSpecies_id = 5 sorted by rowid descending

View and edit SQL

qCaretaker_id

  • Private · 661
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)
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
194245 106032 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Main St 1 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
194211 189883 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 9 : Tree Private 2     8 Width 3ft   6016619.88237 2098309.8227 37.7424917822737 -122.385137818162 (37.7424917822737, -122.385137818162) 10 3 8 58 1
193801 248275 DPW Maintained 1 Ceratonia siliqua :: Carob 5 137 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006752.53211 2098758.77008 37.743173713897 -122.419288098893 (37.743173713897, -122.419288098893) 2 7 7 28859 2
193471 225085 DPW Maintained 1 Ceratonia siliqua :: Carob 5 406 Vicksburg St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 5ft   6004142.31119 2101495.14459 37.7505398125629 -122.428508555547 (37.7505398125629, -122.428508555547) 2 4 5 28862 22
193340 16552 Permitted Site 7 Ceratonia siliqua :: Carob 5 500X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
192924 125980 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008387.31056 2121533.89692 37.8058007619722 -122.415247331605 (37.8058007619722, -122.415247331605) 5 1 10 308 23
192846 175841 DPW Maintained 1 Ceratonia siliqua :: Carob 5 407 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 2ft   6002201.57312 2091201.22242 37.7221650589433 -122.434483841864 (37.7221650589433, -122.434483841864) 9 7 6 28861 5
192717 222909 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004826.79581 2109830.90843 37.7734665514719 -122.426735103265 (37.7734665514719, -122.426735103265) 7 9 11 28852 10
192516 60263 Permitted Site 7 Ceratonia siliqua :: Carob 5 2781 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19819 6009497.44754454 2103916.17692673 37.7574890178355 -122.410160909746 (37.7574890178355, -122.410160909746) 2 4 7 28859 19
192269 189944 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6014676.15778 2116259.76194 37.7916706589171 -122.393114386531 (37.7916706589171, -122.393114386531) 12 2 9 28855 6
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
191608 248257 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006778.60351 2098856.6294 37.7434438819296 -122.419204890889 (37.7434438819296, -122.419204890889) 2 7 7 28859 2
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
191495 225054 DPW Maintained 1 Ceratonia siliqua :: Carob 5 342 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 2ft   6001139.36381 2096693.29596 37.7371846769336 -122.438548945674 (37.7371846769336, -122.438548945674) 2 7 5 63 7
191380 123914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 389 09th Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5993078.53663 2112857.80843 37.7811063777719 -122.467593853963 (37.7811063777719, -122.467593853963) 11 6 2 54 11
191172 16486 Permitted Site 7 Ceratonia siliqua :: Carob 5 220 Newhall St 8 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
190873 2530 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016273.7509883 2099134.0637751 37.7447358261247 -122.386392104106 (37.7447358261247, -122.386392104106) 10 3 8 58 1
190680 63270 Permitted Site 7 Ceratonia siliqua :: Carob 5 15 Winfield St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/26/1987 12:00:00 AM     Permit Number 23827 6007494.42657363 2099465.13084364 37.7451549781049 -122.41677284932 (37.7451549781049, -122.41677284932) 2 7 7 28859 2
190306 93110 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 6 3x3 Permit Number 53024 6016603.54888 2098366.45199 37.7426463712226 -122.385198240014 (37.7426463712226, -122.385198240014) 10 3 8 58 1
190273 222903 DPW Maintained 1 Ceratonia siliqua :: Carob 5 164 Peralta Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009951.59256 2100103.15651 37.7470447557132 -122.408321349458 (37.7470447557132, -122.408321349458) 2 7 7 28859 2
189953 189835 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1698 Galvez Ave 7 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   6015422.83464 2098030.46357 37.7416584290923 -122.389257386733 (37.7416584290923, -122.389257386733) 10 3 8 58 1
189381 189911 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 7 : Tree Private 2     5 Width 3ft   6013879.72064 2094387.80607 37.7315707750637 -122.394338012196 (37.7315707750637, -122.394338012196) 10 3 8 58 1
189250 189912 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 8 : Tree Private 2     4 Width 3ft   6013884.75868 2094408.47452 37.7316278064595 -122.394322041155 (37.7316278064595, -122.394322041155) 10 3 8 58 1
189232 248206 DPW Maintained 1 Ceratonia siliqua :: Carob 5 39 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007021.99675 2099262.74695 37.7445726938814 -122.41839208634 (37.7445726938814, -122.41839208634) 2 7 7 28859 2
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
188712 125990 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008335.58159 2121584.43449 37.8059366180507 -122.415429928145 (37.8059366180507, -122.415429928145) 5 1 10 308 23
188640 248208 DPW Maintained 1 Ceratonia siliqua :: Carob 5 37 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007034.71089 2099281.86096 37.7446258923754 -122.418349478271 (37.7446258923754, -122.418349478271) 2 7 7 28859 2
188633 4914 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
187721 125971 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6008148.4886 2112831.14919 37.7818917385495 -122.415457300812 (37.7818917385495, -122.415457300812) 7 10 9 28852 36
187611 189884 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 12 : Tree Private 2     8 Width 3ft   6016685.38219 2098298.11667 37.7424632629752 -122.384910521712 (37.7424632629752, -122.384910521712) 10 3 8 58 1
187600 56853 DPW Maintained 1 Ceratonia siliqua :: Carob 5 245 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/01/1974 12:00:00 AM 10   Permit Number 14088 6004257.88058 2091960.10063 37.7243652845164 -122.427429718013 (37.7243652845164, -122.427429718013) 9 7 6 28861 5
187401 119740 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     7     6013460.47758 2116066.81767 37.7910732716747 -122.397307123936 (37.7910732716747, -122.397307123936) 12 2 9 28855 6
187326 248200 DPW Maintained 1 Ceratonia siliqua :: Carob 5 53 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006940.78232 2099105.37762 37.7441360208722 -122.418661752548 (37.7441360208722, -122.418661752548) 2 7 7 28859 2
186270 119739 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 5 Sidewalk: Curb side : Cutout Tree Private 2     8     6013469.82728 2116055.87494 37.7910437460335 -122.397274006392 (37.7910437460335, -122.397274006392) 12 2 9 28855 6
186123 189857 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 7 : Tree Private 2     11 Width 4ft   6017207.28329 2098227.98563 37.7422995503725 -122.383101045278 (37.7422995503725, -122.383101045278) 10 3 8 58 1
185943 225083 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3782 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003229.02977 2103031.88331 37.7547076090931 -122.431776461616 (37.7547076090931, -122.431776461616) 2 4 5 28862 22
185043 48532 Permitted Site 7 Ceratonia siliqua :: Carob 5 500(REVISED) Capp St 2 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
184994 225046 DPW Maintained 1 Ceratonia siliqua :: Carob 5 901 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009412.50008 2103884.66728 37.7573977376442 -122.41045246843 (37.7573977376442, -122.41045246843) 2 4 7 28859 19
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
183488 63120 Permitted Site 7 Ceratonia siliqua :: Carob 5 46 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23631 6007008.06371762 2099307.94192573 37.7446960047915 -122.418443468102 (37.7446960047915, -122.418443468102) 2 7 7 28859 2
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
182570 189917 DPW Maintained 1 Ceratonia siliqua :: Carob 5 338 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6013829.87851 2116068.4816 37.7910983996161 -122.396029117153 (37.7910983996161, -122.396029117153) 12 2 9 28855 6
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
182447 224898 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1X Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6007216.8564 2097735.11711 37.7403891304638 -122.417610047575 (37.7403891304638, -122.417610047575) 2 7 7 28859 2
182345 222884 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Valencia St 1 : Tree Private 2     18 Width 5ft   6006058.17228 2109199.11331 37.7718013362 -122.422430687153 (37.7718013362, -122.422430687153) 8 2 9 28853 19
181866 68375 Permitted Site 7 Ceratonia siliqua :: Carob 5 175 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/09/1993 12:00:00 AM     Permit Number 32198 5997884.42699251 2106160.35589629 37.7629931985038 -122.45048498279 (37.7629931985038, -122.45048498279) 15 5 11 29492 9
181416 225043 DPW Maintained 1 Ceratonia siliqua :: Carob 5 463 Nevada St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 2ft   6008911.67409 2096164.66425 37.7361722309519 -122.411639081583 (37.7361722309519, -122.411639081583) 10 7 7 28859 2
180926 63125 Permitted Site 7 Ceratonia siliqua :: Carob 5 80 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23639 6007006.19001516 2099063.67894521 37.744025207978 -122.418432630519 (37.744025207978, -122.418432630519) 2 7 7 28859 2
180800 248209 DPW Maintained 1 Ceratonia siliqua :: Carob 5 37 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6007043.43628 2099296.21325 37.7446657917085 -122.418320324941 (37.7446657917085, -122.418320324941) 2 7 7 28859 2
179562 2526 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3X3   6016552.46567 2098935.10176 37.744204941317 -122.385414490998 (37.744204941317, -122.385414490998) 10 3 8 58 1
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
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
179136 189964 DPW Maintained 1 Ceratonia siliqua :: Carob 5 287 07th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6010268.27805 2111003.99646 37.7769937249279 -122.407994884783 (37.7769937249279, -122.407994884783) 14 2 9 28853 34
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
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
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
178019 248274 DPW Maintained 1 Ceratonia siliqua :: Carob 5 137 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006747.61558 2098750.15701 37.743149787441 -122.419304488116 (37.743149787441, -122.419304488116) 2 7 7 28859 2
177869 33711 Permitted Site 7 Ceratonia siliqua :: Carob 5 109 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM     Permit Number 37779 6003691.57039211 2108804.29883955 37.7705834843276 -122.430588742236 (37.7705834843276, -122.430588742236) 15 9 11 29492 10
177859 248254 DPW Maintained 1 Ceratonia siliqua :: Carob 5 112 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006798.65634 2098892.16282 37.7435425780247 -122.419138073069 (37.7435425780247, -122.419138073069) 2 7 7 28859 2
177221 61796 Permitted Site 7 Ceratonia siliqua :: Carob 5 60 Pierce St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/25/1985 12:00:00 AM     Permit Number 21819 6002883.06164476 2108748.24537279 37.7703837393735 -122.433381373664 (37.7703837393735, -122.433381373664) 15 5 5 29492 9
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
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
176339 244469 DPW Maintained 1 Ceratonia siliqua :: Carob 5 665 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003415.8306 2109638.093 37.7728572538387 -122.431602065027 (37.7728572538387, -122.431602065027) 15 9 11 29492 10
176007 189894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 8 : Tree Private 2     10 Width 3ft   6016764.20599 2098333.7275 37.7425654025768 -122.384640449909 (37.7425654025768, -122.384640449909) 10 3 8 58 1
175649 189897 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6016662.64586 2098353.63161 37.7426144381027 -122.384993004817 (37.7426144381027, -122.384993004817) 10 3 8 58 1
175418 125967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3440 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 6ft   5998347.68841 2115559.33393 37.7888268704136 -122.449560024485 (37.7888268704136, -122.449560024485) 13 6 1 54 31
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
174571 225065 DPW Maintained 1 Ceratonia siliqua :: Carob 5 219 Bonview St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6006960.17815 2097772.45281 37.7404771992577 -122.418500188445 (37.7404771992577, -122.418500188445) 2 7 7 28859 2
174476 189889 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 3 : Tree Private 2     7 Width 3ft   6016866.9099 2098314.50918 37.7425183122785 -122.384283988325 (37.7425183122785, -122.384283988325) 10 3 8 58 1
174284 189893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 7 : Tree Private 2     10 Width 3ft   6016784.24817 2098329.21731 37.7425541268854 -122.384570835175 (37.7425541268854, -122.384570835175) 10 3 8 58 1
174101 113692 Undocumented 4 Ceratonia siliqua :: Carob 5 112 LUNDYS LN 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6006814 2098928 37.7436418429474 -122.419087559811 (37.7436418429474, -122.419087559811) 2 7 7 28859 2
173944 189837 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1698 Galvez Ave 11 Sidewalk: Property side : Yard Tree Private 2     16 Width 8ft   6015387.45837 2098059.88528 37.7417372537812 -122.389381761177 (37.7417372537812, -122.389381761177) 10 3 8 58 1
173505 119746 Undocumented 4 Ceratonia siliqua :: Carob 5 15X Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013411 2116073 37.7910874921548 -122.39747874957 (37.7910874921548, -122.39747874957) 12 2 9 28855 6
172971 96123 Permitted Site 7 Ceratonia siliqua :: Carob 5 181 College Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/2011 12:00:00 AM   3x3 Permit Number 767774 6004920.8 2095965.5 37.7354006937902 -122.425423007406 (37.7354006937902, -122.425423007406) 2 7 5 28861 2
172953 34010 Permitted Site 7 Ceratonia siliqua :: Carob 5 123 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/28/1997 12:00:00 AM     Permit Number 37945 6002886.66979468 2107551.69377695 37.7670985064042 -122.433283380019 (37.7670985064042, -122.433283380019) 15 5 5 28862 3
172941 225057 DPW Maintained 1 Ceratonia siliqua :: Carob 5 360 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6001062.01743 2096696.77883 37.7371898399477 -122.438816616317 (37.7371898399477, -122.438816616317) 2 7 5 63 7
172639 56842 Permitted Site 7 Ceratonia siliqua :: Carob 5 910 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1992 12:00:00 AM 3   Permit Number 30536 5998759.08975741 2106864.1829233 37.7649757529568 -122.447510501506 (37.7649757529568, -122.447510501506) 15 5 11 29492 9
172553 225079 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2804 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009325.52412 2103958.77383 37.7575963412133 -122.410758500511 (37.7575963412133, -122.410758500511) 2 4 7 28859 19
172314 225082 DPW Maintained 1 Ceratonia siliqua :: Carob 5 543 Hill St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 3ft   6002779.31526 2103257.03916 37.7553003306644 -122.433347783174 (37.7553003306644, -122.433347783174) 2 4 5 28862 22
172152 189849 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 12 : Tree Private 2     10 Width 4ft   6017283.17469 2098125.85242 37.7420233065307 -122.38283152746 (37.7420233065307, -122.38283152746) 10 3 8 58 1
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
170988 225052 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6000953.83658 2096674.21341 37.7371217252913 -122.439189029173 (37.7371217252913, -122.439189029173) 2 7 5 63 7
170663 225064 DPW Maintained 1 Ceratonia siliqua :: Carob 5 253 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5998981.07779 2106664.05961 37.7644389481338 -122.446728303069 (37.7644389481338, -122.446728303069) 15 5 11 29492 9
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
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
169891 205990 DPW Maintained 1 Ceratonia siliqua :: Carob 5 452 Kenwood Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5993405.09676 2093676.51676 37.7284583518695 -122.46507057606 (37.7284583518695, -122.46507057606) 9 8 4 59 40
169680 225063 DPW Maintained 1 Ceratonia siliqua :: Carob 5 247 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   5998979.47876 2106681.18548 37.7644858801306 -122.44673506599 (37.7644858801306, -122.44673506599) 15 5 11 29492 9
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
168987 222912 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 9 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6004886.98291 2109837.99569 37.7734894140273 -122.42652741201 (37.7734894140273, -122.42652741201) 7 9 11 28852 10
168339 2544 Permitted Site 7 Ceratonia siliqua :: Carob 5 1580 BURKE AVE 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6016440 2099034 37.7444702727306 -122.385810268433 (37.7444702727306, -122.385810268433) 10 3 8 58 1
167516 51302 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300X Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2004 12:00:00 AM 12   Permit Number 47670 6008052.8861 2112760.32075 37.7816918867218 -122.415783025366 (37.7816918867218, -122.415783025366) 7 10 9 28852 36
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
166428 65950 Permitted Site 7 Ceratonia siliqua :: Carob 5 120 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM     Permit Number 28971 6008148.07854497 2112823.994523 37.7818720705068 -122.415458212735 (37.7818720705068, -122.415458212735) 7 10 9 28852 36
166358 189847 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 9 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017231.39271 2098158.22234 37.7421093266962 -122.383012827183 (37.7421093266962, -122.383012827183) 10 3 8 58 1
166336 188472 DPW Maintained 1 Ceratonia siliqua :: Carob 5 255 12th St 7 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 5ft   6007955.34249 2108999.99523 37.7713614445082 -122.415854126661 (37.7713614445082, -122.415854126661) 8 2 9 28853 19
166205 175843 DPW Maintained 1 Ceratonia siliqua :: Carob 5 154 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6004555.98826 2092507.33419 37.7258847232758 -122.426438147115 (37.7258847232758, -122.426438147115) 9 7 6 28861 5
166057 225074 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3354 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   6007335.7626 2101504.20622 37.7507448939762 -122.417465967185 (37.7507448939762, -122.417465967185) 2 4 7 28859 19
166050 222891 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2759 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6009566.16928 2103923.02169 37.7575116637409 -122.409923724614 (37.7575116637409, -122.409923724614) 2 4 7 28859 19
165805 188470 DPW Maintained 1 Ceratonia siliqua :: Carob 5 255 12th St 4 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 5ft   6008074.61393 2108923.40936 37.7711578622784 -122.415436137088 (37.7711578622784, -122.415436137088) 8 2 9 28853 19

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