856 rows where qSpecies_id = 5 sorted by qAddress

View and edit SQL

qCaretaker_id

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)
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
56752 189914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 11 : Tree Private 2     5 Width 3ft   6013894.18582 2094452.33408 37.7317487598799 -122.394292519091 (37.7317487598799, -122.394292519091) 10 3 8 58 1
107432 189915 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 13 : Tree Private 2     5 Width 3ft   6013899.07383 2094479.41823 37.7318233991302 -122.394277515688 (37.7318233991302, -122.394277515688) 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
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
114865 201371 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Hare St 1 Sidewalk: Curb side : Yard Tree Private 2     12     6018297.03999 2095334.93444 37.7344159629251 -122.379132069983 (37.7344159629251, -122.379132069983) 10 3 8 58 1
52787 222885 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Valencia St 3 : Tree Private 2     18 Width 5ft   6006051.02822 2109339.24494 37.7721857010308 -122.422465357814 (37.7721857010308, -122.422465357814) 8 2 9 28853 19
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
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
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
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
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
13041 19762 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY16 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 30ST                      
12712 19967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY41 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
117059 222915 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6004287.81752 2109130.32918 37.7715124442731 -122.42854956012 (37.7715124442731, -122.42854956012) 7 9 11 28852 10
124477 189963 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1000 Brannan St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6010349.36768 2108372.96344 37.7697740574441 -122.40752882731 (37.7697740574441, -122.40752882731) 8 2 9 28853 34
155251 103345 Undocumented 4 Ceratonia siliqua :: Carob 5 1000 Brannan St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3 Permit Number 29899 6010491 2108479 37.7700731362443 -122.407046397751 (37.7700731362443, -122.407046397751) 8 2 9 28853 34
112435 47241 Permitted Site 7 Ceratonia siliqua :: Carob 5 1000X Jamestown Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 8 3x3 Permit Number 45190 6014093.2543098 2089771.82198012 37.718908077116 -122.393276886105 (37.718908077116, -122.393276886105) 10 3 8 58 1
56518 237914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1001 Stanyan St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 Width 4ft   5997227 2107052 37.7654037766697 -122.452823145368 (37.7654037766697, -122.452823145368) 15 5 11 29492 12
138537 47239 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1004X Jamestown Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 8 3x3 Permit Number 45190 6013984.3411 2089670.3406 37.7186233778889 -122.393646260173 (37.7186233778889, -122.393646260173) 10 3 8 58 1
154770 47240 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1006X Jamestown Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 8 3x3 Permit Number 45190 6013969.3769 2089681.5637 37.7186533627648 -122.393698770823 (37.7186533627648, -122.393698770823) 10 3 8 58 1
109482 200192 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1008 Jamestown Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6013935.7075 2089708.6863 37.718725965018 -122.393817050636 (37.718725965018, -122.393817050636) 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
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
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
46225 3611 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 47 Sidewalk: Curb side : Cutout Tree Port 6   05/31/1996 12:00:00 AM 3 3X3   6018038.29611 2098194.83807 37.7422544187983 -122.380225323637 (37.7422544187983, -122.380225323637) 10 3 8 58 1
100284 3652 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 88 Sidewalk: Curb side : Cutout Tree Port 6   03/07/2006 12:00:00 AM 3 3X3   6017348.88964 2098746.4497 37.7437309716031 -122.382647477613 (37.7437309716031, -122.382647477613) 10 3 8 58 1
101145 3593 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 29 Sidewalk: Curb side : Cutout Tree Port 6   04/06/2016 12:00:00 AM 7 3X3   6018341.35218 2097966.95491 37.7416454132021 -122.379161613636 (37.7416454132021, -122.379161613636) 10 3 8 58 1
163469 3627 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 63 Sidewalk: Curb side : Cutout Tree Port 6   04/06/2016 12:00:00 AM 3 3X3   6017747.14415 2098409.63099 37.7428281287262 -122.381246979566 (37.7428281287262, -122.381246979566) 10 3 8 58 1
169962 83036 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100X Cargo Way 16 Sidewalk: Curb side : Cutout Tree Port 6   03/18/2017 02:55:00 PM 3     6018559.56213 2097806.04485 37.7412156164156 -122.378395939846 (37.7412156164156, -122.378395939846) 10 3 8 58 1
120772 51301 Permitted Site 7 Ceratonia siliqua :: Carob 5 101 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/20/2004 12:00:00 AM     Permit Number 47670 6008105.70875607 2112751.56982087 37.7816708281319 -122.415599663608 (37.7816708281319, -122.415599663608) 7 10 9 28852 36
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
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
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
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
64200 189844 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017173.06513 2098183.08322 37.7421743665616 -122.383216237654 (37.7421743665616, -122.383216237654) 10 3 8 58 1
67259 189842 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 4 : Tree Private 2     7 Width 3ft   6017136.08616 2098201.14709 37.7422219227174 -122.383345357813 (37.7422219227174, -122.383345357813) 10 3 8 58 1
80577 189839 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 1 : Tree Private 2     1 Width 3ft   6017074.26086 2098217.41845 37.7422631836031 -122.383560265197 (37.7422631836031, -122.383560265197) 10 3 8 58 1
98742 189846 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 8 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017214.17115 2098166.7194 37.7421317063069 -122.383072965771 (37.7421317063069, -122.383072965771) 10 3 8 58 1
100985 189841 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 3 : Tree Private 2     1 Width 3ft   6017113.18863 2098207.21128 37.7422373082953 -122.383424953219 (37.7422373082953, -122.383424953219) 10 3 8 58 1
162252 189848 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 11 : Tree Private 2     8 Width 4ft   6017264.73109 2098137.17538 37.7420533780644 -122.38289608801 (37.7420533780644, -122.38289608801) 10 3 8 58 1
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
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
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
65626 189862 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 12 : Tree Private 2     7 Width 3ft   6017103.28687 2098264.26759 37.7423934261135 -122.383463161819 (37.7423934261135, -122.383463161819) 10 3 8 58 1
70275 189859 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 9 : Tree Private 2     7 Width 3ft   6017171.36242 2098242.65136 37.7423378345214 -122.38322627048 (37.7423378345214, -122.38322627048) 10 3 8 58 1
71679 189860 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 10 : Tree Private 2     7 Width 3ft   6017146.31011 2098252.64566 37.7423638923838 -122.383313590143 (37.7423638923838, -122.383313590143) 10 3 8 58 1
77795 189855 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 5 : Tree Private 2     9 Width 3ft   6017245.40272 2098209.38961 37.7422505957884 -122.382967944715 (37.7422505957884, -122.382967944715) 10 3 8 58 1
83224 189863 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 13 : Tree Private 2     9 Width 3ft   6017087.00267 2098268.01639 37.7424028195418 -122.383519729148 (37.7424028195418, -122.383519729148) 10 3 8 58 1
99211 189861 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 11 : Tree Private 2     8 Width 3ft   6017125.66493 2098258.40905 37.742378576526 -122.383385376738 (37.742378576526, -122.383385376738) 10 3 8 58 1
123006 189856 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 6 : Tree Private 2     6 Width 3ft   6017223.11391 2098220.28067 37.7422792688651 -122.383045771154 (37.7422792688651, -122.383045771154) 10 3 8 58 1
129552 189854 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 4 : Tree Private 2     10 Width 3ft   6017283.71117 2098187.47887 37.7421925499461 -122.382833960126 (37.7421925499461, -122.382833960126) 10 3 8 58 1
136362 189853 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 1 : Tree Private 2     8 Width 3ft   6017352.03209 2098141.27696 37.7420694633311 -122.382594511142 (37.7420694633311, -122.382594511142) 10 3 8 58 1
143777 189858 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 8 : Tree Private 2     10 Width 4ft   6017192.20681 2098235.03839 37.7423180827181 -122.383153666435 (37.7423180827181, -122.383153666435) 10 3 8 58 1
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
112903 62270 Permitted Site 7 Ceratonia siliqua :: Carob 5 102 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22404 6004290.78316217 2109110.18870614 37.7714573112605 -122.42853786595 (37.7714573112605, -122.42853786595) 7 9 11 28852 10
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
53679 56848 Permitted Site 7 Ceratonia siliqua :: Carob 5 1025 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1974 12:00:00 AM   6x5 Permit Number 14082 5998817.86133668 2106377.94605096 37.7636440271414 -122.447272227776 (37.7636440271414, -122.447272227776) 15 5 11 29492 9
85587 94581 Permitted Site 7 Ceratonia siliqua :: Carob 5 1025 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5998825 2106371 37.763625362932 -122.447247037522 (37.763625362932, -122.447247037522) 15 5 11 29492 9
110010 222924 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1025 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5998822.08068 2106365.67219 37.763610567293 -122.447256751019 (37.763610567293, -122.447256751019) 15 5 11 29492 9
61840 222914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 108 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 2ft   6004276.58953 2109191.75922 37.7716804808011 -122.428592777936 (37.7716804808011, -122.428592777936) 7 9 11 28852 10
62864 62271 Permitted Site 7 Ceratonia siliqua :: Carob 5 108 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22405 6004283.36290773 2109163.56782991 37.7716034574246 -122.428567338549 (37.7716034574246, -122.428567338549) 7 9 11 28852 10
29498 225099 DPW Maintained 1 Ceratonia siliqua :: Carob 5 109 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM 14 Width 3ft Permit Number 37779 6003663.75485 2108815.27117 37.7706120358534 -122.430685739554 (37.7706120358534, -122.430685739554) 15 9 11 29492 10
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
147007 222888 DPW Maintained 1 Ceratonia siliqua :: Carob 5 109 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6004218 2109157 37.7715817245566 -122.428792964354 (37.7715817245566, -122.428792964354) 7 9 11 29492 10
68954 7418 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1090 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6010342.8854 2110986.7114 37.7769504410171 -122.407735574616 (37.7769504410171, -122.407735574616) 14 2 9 28853 34
99086 7417 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1090 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2003 12:00:00 AM 6 3X3   6010360.059 2111002.9309 37.7769959373466 -122.407677309481 (37.7769959373466, -122.407677309481) 14 2 9 28853 34
175440 7419 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1090 Folsom St 3 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6010341.13591 2111005.37017 37.777001575706 -122.407742942642 (37.777001575706, -122.407742942642) 14 2 9 28853 34
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
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
42963 97180 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 2 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
103825 97186 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 8 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
110444 97188 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 10 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
124374 97181 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 3 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
127764 97182 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 4 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
128485 97184 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013138 2116168 37.791333135618 -122.398429995238 (37.791333135618, -122.398429995238) 12 2 9 28855 6
157690 97185 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 7 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
158873 97183 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 5 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
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
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
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
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
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
49574 14913 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017225.13937 2098220.80076 37.7422808088462 -122.383038803855 (37.7422808088462, -122.383038803855) 10 3 8 58 1
77909 14909 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017336.92539 2098155.67833 37.7421081720326 -122.382647747732 (37.7421081720326, -122.382647747732) 10 3 8 58 1
98289 14914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017206.58246 2098230.05631 37.7423051973143 -122.383103612647 (37.7423051973143, -122.383103612647) 10 3 8 58 1
108291 14920 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017135.89317 2098259.62578 37.7423824826909 -122.383350094901 (37.7423824826909, -122.383350094901) 10 3 8 58 1
149371 14911 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6017284.29114 2098190.72199 37.7422014869413 -122.38283218039 (37.7422014869413, -122.38283218039) 10 3 8 58 1
166582 14918 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 12 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
180338 14917 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017157.89779 2098250.45331 37.7423585130106 -122.383273370488 (37.7423585130106, -122.383273370488) 10 3 8 58 1
191303 14915 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017191.33538 2098236.4203 37.7423218290085 -122.383156775767 (37.7423218290085, -122.383156775767) 10 3 8 58 1
105802 248279 DPW Maintained 1 Ceratonia siliqua :: Carob 5 111 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6006822.34586 2098891.67697 37.743542578041 -122.419056125953 (37.743542578041, -122.419056125953) 2 7 7 28859 2
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
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
157121 248253 DPW Maintained 1 Ceratonia siliqua :: Carob 5 112 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6006804.33159 2098902.21261 37.7435704920937 -122.419119162122 (37.7435704920937, -122.419119162122) 2 7 7 28859 2
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
78514 222913 DPW Maintained 1 Ceratonia siliqua :: Carob 5 112 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004271.62218 2109232.31503 37.771791556066 -122.428612851729 (37.771791556066, -122.428612851729) 7 9 11 28852 10
131347 62272 Permitted Site 7 Ceratonia siliqua :: Carob 5 113 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22406 6004233.40404883 2109145.28748516 37.7715504366717 -122.428738845772 (37.7715504366717, -122.428738845772) 7 9 11 29492 10
35310 47061 Permitted Site 7 Ceratonia siliqua :: Carob 5 114 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM   3x3 Permit Number 45048 6004275.94265243 2109216.94695979 37.7717496035942 -122.428596811267 (37.7717496035942, -122.428596811267) 7 9 11 28852 10
74084 124322 DPW Maintained 1 Ceratonia siliqua :: Carob 5 115 Jordan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 3ft   5996192.87314 2113669.73604 37.7835150337529 -122.456878613619 (37.7835150337529, -122.456878613619) 11 6 1 54 31

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