856 rows where qSpecies_id = 5 sorted by TreeID descending

View and edit SQL

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)
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
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
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
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
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
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
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
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
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
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
153332 96855 Undocumented 4 Ceratonia siliqua :: Carob 5 600 Eugenia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007257 2097738 37.740399305054 -122.417471450766 (37.740399305054, -122.417471450766) 2 7 7 28859 2
99949 96852 Undocumented 4 Ceratonia siliqua :: Carob 5 1x Bennington St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6007194 2097789 37.7405357947447 -122.417692894396 (37.7405357947447, -122.417692894396) 2 7 7 28859 2
63725 96756 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1820X Palou Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6013661.38712 2096183.48051 37.736489188553 -122.395218577377 (37.736489188553, -122.395218577377) 10 3 8 58 1
17034 96473 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3 Permit Number 767637 6014754.27658 2116074.97331 37.7911676114441 -122.392831160352 (37.7911676114441, -122.392831160352) 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
52265 95955 Permitted Site 7 Ceratonia siliqua :: Carob 5 190X Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/18/2011 12:00:00 AM   3x3 Permit Number 767637 6014675 2116143.7 37.791351915434 -122.393110267966 (37.791351915434, -122.393110267966) 12 2 9 28855 6
82714 94895 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
84292 94894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 3 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
132285 94893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
167565 94892 DPW Maintained 1 Ceratonia siliqua :: Carob 5 43 Flora St 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53954 6014036.5 2094589.2 37.7321324754711 -122.393810082896 (37.7321324754711, -122.393810082896) 10 3 8 58 1
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
120815 93114 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 6 3x3 Permit Number 53024 6016526.70747 2098382.71109 37.7426867642747 -122.385465070679 (37.7426867642747, -122.385465070679) 10 3 8 58 1
65447 93113 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 9 3x3 Permit Number 53024 6016543.92232 2098378.49318 37.7426761351889 -122.385405252254 (37.7426761351889, -122.385405252254) 10 3 8 58 1
163591 93112 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 3 3x3 Permit Number 53024 6016561.73954 2098375.23066 37.7426681627043 -122.385343417566 (37.7426681627043, -122.385343417566) 10 3 8 58 1
141218 93111 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 7 3x3 Permit Number 53024 6016584.37921 2098370.12887 37.7426554067123 -122.385264779961 (37.7426554067123, -122.385264779961) 10 3 8 58 1
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
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
94151 87254 Permitted Site 7 Ceratonia siliqua :: Carob 5 32 McCarthy Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 50278 6007985.7 2086740.5 37.7102434920179 -122.414174016703 (37.7102434920179, -122.414174016703) 9 7 8 309 39
133859 87253 Permitted Site 7 Ceratonia siliqua :: Carob 5 2 McCarthy Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 50277 6008031.4 2086860.8 37.7105763778259 -122.414024572568 (37.7105763778259, -122.414024572568) 9 7 8 309 39
107461 85255 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     6   Permit Number 49553 6013503.0525 2116024.16318 37.7909585226636 -122.39715682295 (37.7909585226636, -122.39715682295) 12 2 9 28855 6
88181 85254 DPW Maintained 1 Ceratonia siliqua :: Carob 5 45 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     9   Permit Number 49553 6013520.55509 2116003.76772 37.7909034958536 -122.397094833572 (37.7909034958536, -122.397094833572) 12 2 9 28855 6
50010 85052 Permitted Site 7 Ceratonia siliqua :: Carob 5 355x Page St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   06/27/2007 12:00:00 AM     Permit Number 49332 6004826.8 2109751.4 37.7732482408903 -122.426729425627 (37.7732482408903, -122.426729425627) 7 9 11 28852 10
138479 85051 Permitted Site 7 Ceratonia siliqua :: Carob 5 355x Page St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5   06/27/2007 12:00:00 AM     Permit Number 49332 6004826.8 2109751.4 37.7732482408903 -122.426729425627 (37.7732482408903, -122.426729425627) 7 9 11 28852 10
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
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
150580 82143 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
6377 82142 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
146949 82141 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 3 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
37929 82121 Permitted Site 7 Ceratonia siliqua :: Carob 5 44 Molimo Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49840 5998809.17063994 2096527.78133102 37.7365973852663 -122.446593550118 (37.7365973852663, -122.446593550118) 9 7 4 59 40
115939 82092 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 4 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
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
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
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
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
137043 6850 DPW Maintained 1 Ceratonia siliqua :: Carob 5 595X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/1998 12:00:00 AM 12 3x3   6015895.1615953 2097662.6258274 37.7406745956723 -122.387598567026 (37.7406745956723, -122.387598567026) 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
73481 6848 Permitted Site 7 Ceratonia siliqua :: Carob 5 595X Newhall St 5 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
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
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
93446 67186 Permitted Site 7 Ceratonia siliqua :: Carob 5 281 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30634 5996869.12207945 2106987.0610707 37.7652049569046 -122.454056265196 (37.7652049569046, -122.454056265196) 15 5 11 29492 12
69587 67184 Permitted Site 7 Ceratonia siliqua :: Carob 5 912 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/06/1992 12:00:00 AM     Permit Number 30631 5998760.11857013 2106856.81248154 37.7649555743728 -122.447506412542 (37.7649555743728, -122.447506412542) 15 5 11 29492 9
76900 6652 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 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
114719 6650 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
164263 6649 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
140399 6648 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
141600 6647 Permitted Site 7 Ceratonia siliqua :: Carob 5 495X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/01/1990 12:00:00 AM 3 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
166537 6646 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1990 12:00:00 AM 18 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
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
6002 65883 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3100X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2013 12:00:00 AM 3   Permit Number 770126 6002440.42815 2118878.88214 37.7981747762893 -122.435637321312 (37.7981747762893, -122.435637321312) 13 9 1 57 17
119313 65609 DPW Maintained 1 Ceratonia siliqua :: Carob 5 259 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/1990 12:00:00 AM 12   Permit Number 28514 6005079.93888 2093817.02687 37.7295104552453 -122.424720013038 (37.7295104552453, -122.424720013038) 9 7 6 28861 5
71727 65411 Permitted Site 7 Ceratonia siliqua :: Carob 5 81 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/16/1989 12:00:00 AM     Permit Number 28262 6004263.16526256 2108931.19399052 37.7709642723528 -122.428620636268 (37.7709642723528, -122.428620636268) 7 9 11 29492 10
43480 65221 Permitted Site 7 Ceratonia siliqua :: Carob 5 411 Paris St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/1989 12:00:00 AM     Permit Number 28008 6002203.13463286 2091195.37244375 37.7221490848593 -122.434478026037 (37.7221490848593, -122.434478026037) 9 7 6 28861 5
60751 64436 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2445 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/16/1988 12:00:00 AM 12   Permit Number 25292 6006658.75135 2119650.10198 37.8005310432266 -122.421095439396 (37.8005310432266, -122.421095439396) 5 9 1 28858 32
89492 63739 Permitted Site 7 Ceratonia siliqua :: Carob 5 665 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/1988 12:00:00 AM     Permit Number 24410 6003393.73641512 2109629.91106527 37.7728335359212 -122.431677907074 (37.7728335359212, -122.431677907074) 15 9 11 29492 10
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
35579 63232 Permitted Site 7 Ceratonia siliqua :: Carob 5 53 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/13/1987 12:00:00 AM     Permit Number 23779 6007031.32644483 2099242.02691528 37.7445163265111 -122.418358357204 (37.7445163265111, -122.418358357204) 2 7 7 28859 2
37593 63223 Permitted Site 7 Ceratonia siliqua :: Carob 5 74 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/08/1986 12:00:00 AM     Permit Number 23767 6007024.24525419 2099097.21630379 37.7441183104389 -122.418372576893 (37.7441183104389, -122.418372576893) 2 7 7 28859 2
41267 63222 Permitted Site 7 Ceratonia siliqua :: Carob 5 76 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/06/1987 12:00:00 AM     Permit Number 23766 6007018.22684623 2099086.03719365 37.7440872763149 -122.418392594768 (37.7440872763149, -122.418392594768) 2 7 7 28859 2
47785 63130 Permitted Site 7 Ceratonia siliqua :: Carob 5 26 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/11/1986 12:00:00 AM     Permit Number 23644 6007187.15982152 2099399.82780325 37.7449583833589 -122.417830699083 (37.7449583833589, -122.417830699083) 2 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
161614 63122 Permitted Site 7 Ceratonia siliqua :: Carob 5 42 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1993 12:00:00 AM     Permit Number 32290 6007020.23858667 2099330.24637666 37.7447579331798 -122.418402950875 (37.7447579331798, -122.418402950875) 2 7 7 28859 2
163554 63121 Permitted Site 7 Ceratonia siliqua :: Carob 5 42 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/09/1986 12:00:00 AM     Permit Number 23632 6007120.53987433 2099276.08223849 37.7446148564174 -122.418052288309 (37.7446148564174, -122.418052288309) 2 7 7 28859 2
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
120856 63118 Permitted Site 7 Ceratonia siliqua :: Carob 5 70 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23625 6006935.01451866 2099174.11524824 37.7443244342333 -122.418686569992 (37.7443244342333, -122.418686569992) 2 7 7 28859 2
52185 63117 Permitted Site 7 Ceratonia siliqua :: Carob 5 72 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23624 6006928.92708318 2099162.96302102 37.7442934699851 -122.418706828381 (37.7442934699851, -122.418706828381) 2 7 7 28859 2
82514 63116 Permitted Site 7 Ceratonia siliqua :: Carob 5 115 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23622 6006844.85682717 2098899.69149034 37.7435658517454 -122.418978856767 (37.7435658517454, -122.418978856767) 2 7 7 28859 2
26541 62275 Permitted Site 7 Ceratonia siliqua :: Carob 5 141 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22411 6004215.98521889 2109270.59348358 37.771893510559 -122.428808033039 (37.771893510559, -122.428808033039) 7 9 11 29492 10
102569 62273 Permitted Site 7 Ceratonia siliqua :: Carob 5 123 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22409 6004226.44756002 2109195.3304156 37.7716874486567 -122.428766476737 (37.7716874486567, -122.428766476737) 7 9 11 29492 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
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
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
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
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
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
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
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
161147 60694 Permitted Site 7 Ceratonia siliqua :: Carob 5 2770 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20337 6009580.52702931 2103388.84293588 37.7560457337564 -122.409836363248 (37.7560457337564, -122.409836363248) 2 4 7 28859 19
33302 60693 Permitted Site 7 Ceratonia siliqua :: Carob 5 2762 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20336 6009623.17116786 2103391.2059206 37.7560546117591 -122.409689051741 (37.7560546117591, -122.409689051741) 2 4 7 28859 19
154349 60691 Permitted Site 7 Ceratonia siliqua :: Carob 5 2767 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20334 6009604.72609902 2103338.10407704 37.7559077723841 -122.409749093146 (37.7559077723841, -122.409749093146) 2 4 7 28859 19
136811 60690 Permitted Site 7 Ceratonia siliqua :: Carob 5 2773 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20333 6009572.74299755 2103336.33183864 37.7559011138434 -122.409859576548 (37.7559011138434, -122.409859576548) 2 4 7 28859 19
112219 60684 Permitted Site 7 Ceratonia siliqua :: Carob 5 2969 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20325 6009095.19054271 2102724.34950865 37.7541939732112 -122.411467881257 (37.7541939732112, -122.411467881257) 2 4 7 28859 19
131314 60288 Permitted Site 7 Ceratonia siliqua :: Carob 5 2932 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1982 12:00:00 AM     Permit Number 19852 6009284.44431761 2102786.94037008 37.754376447105 -122.410817812439 (37.754376447105, -122.410817812439) 2 4 7 28859 19
162327 60271 Permitted Site 7 Ceratonia siliqua :: Carob 5 2761 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/10/1982 12:00:00 AM 12 3x3 Permit Number 19827 6009603.81924648 2103922.02713572 37.7575110429284 -122.409793445145 (37.7575110429284, -122.409793445145) 2 4 7 28859 19
20598 60264 Permitted Site 7 Ceratonia siliqua :: Carob 5 2804 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19820 6009362.55423892 2103960.83669592 37.7576040815568 -122.410630580485 (37.7576040815568, -122.410630580485) 2 4 7 28859 19
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
143674 60260 Permitted Site 7 Ceratonia siliqua :: Carob 5 2844 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/15/1984 12:00:00 AM     Permit Number 19815 6009158.9675903 2103949.64001782 37.757561921733 -122.411333877594 (37.757561921733, -122.411333877594) 2 4 7 28859 19
119539 60259 Permitted Site 7 Ceratonia siliqua :: Carob 5 900 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1989 12:00:00 AM     Permit Number 28050 6009367.15001104 2103917.51160129 37.7574853782949 -122.410611626923 (37.7574853782949, -122.410611626923) 2 4 7 28859 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)
);