264 rows where Police Districts = 2 and qSpecies_id = 53 sorted by Neighborhoods (old)

View and edit SQL

Police Districts

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old) ▼
347 108327 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
371 251215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
16987 17305 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
19705 95415 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Created record for this tree on 2/28/2011 although tree is approxmiately 20 years old. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
27252 17296 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 5X Otis St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6007104.29527 2109558.64203 37.7728474744005 -122.418837572 (37.7728474744005, -122.418837572) 8 2 9 28853 19
34758 15261 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007445.07805 2110006.65891 37.7740968045009 -122.417690522857 (37.7740968045009, -122.417690522857) 8 2 9 28853 19
36076 111627 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
36280 110558 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1X Otis St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Tree is at very corner of Otis and Mission; at 12 St and S Van Ness Intersection 6007165.9 2109609 37.7729892139286 -122.418628045346 (37.7729892139286, -122.418628045346) 8 2 9 28853 19
38468 111626 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
40345 17320 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
51241 15259 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6007494.54134 2110025.11497 37.7741502637452 -122.417520728591 (37.7741502637452, -122.417520728591) 8 2 9 28853 19
52966 66275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1065 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/01/1990 12:00:00 AM   3x3 Permit Number 768678 6007678.31560988 2109516.6646006 37.7727645184447 -122.416848989215 (37.7727645184447, -122.416848989215) 8 2 9 28853 19
54802 17309 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 70 Otis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006766.44916 2109389.93705 37.7723652222089 -122.419994248937 (37.7723652222089, -122.419994248937) 8 2 9 28853 19
64749 17324 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
66600 17310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 70 Otis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006766.44916 2109389.93705 37.7723652222089 -122.419994248937 (37.7723652222089, -122.419994248937) 8 2 9 28853 19
72154 17321 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
72411 15256 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 7 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6007417.64852 2109947.83449 37.7739337430824 -122.417781236147 (37.7739337430824, -122.417781236147) 8 2 9 28853 19
77006 108328 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
93090 108326 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
108637 27712 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
109251 17295 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 5X Otis St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007087.86369 2109540.24307 37.7727960300261 -122.418893105705 (37.7727960300261, -122.418893105705) 8 2 9 28853 19
109824 17315 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
113415 17294 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 5X Otis St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6007138.45925 2109591.54151 37.7729397321212 -122.418721728138 (37.7729397321212, -122.418721728138) 8 2 9 28853 19
122653 17306 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
131297 17307 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006961.49044 2109420.44821 37.772459985288 -122.419321746309 (37.772459985288, -122.419321746309) 8 2 9 28853 19
138208 95414 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Creating record for 3 ficus trees at this address on 2/28/2011. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
138240 108324 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
140527 15263 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 8 Sidewalk: Curb side : Cutout Tree DPW 1   09/30/2008 12:00:00 AM 12 3x3 Permit Number 51766 6007587.5132074 2110099.4827033 37.7743596907053 -122.417204392502 (37.7743596907053, -122.417204392502) 8 2 9 28853 19
148003 95416 Undocumented 4 Ficus nitida :: Laurel Fig 53 49X South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Created recoard for tree on 2/28/2011. Tree approx. 20 years old. 6007102.30356 2110018.85993 37.7741110108752 -122.418877107651 (37.7741110108752, -122.418877107651) 8 2 9 28853 19
155474 17322 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
157267 17313 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
162113 108325 Permitted Site 7 Ficus nitida :: Laurel Fig 53 86 11TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007396 2110315 37.7749406737789 -122.417882154347 (37.7749406737789, -122.417882154347) 8 2 9 28853 19
167163 17304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 51X Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006870.5020453 2109341.6908091 37.7722386113234 -122.419630895813 (37.7722386113234, -122.419630895813) 8 2 9 28853 19
173445 15262 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 6 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6007448.14843 2109975.86864 37.774012434525 -122.417677719037 (37.774012434525, -122.417677719037) 8 2 9 28853 19
173835 17323 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 99X Otis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6006684.07559 2109163.06169 37.7717376353271 -122.420263082185 (37.7717376353271, -122.420263082185) 8 2 9 28853 19
175687 17314 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
177897 100470 Undocumented 4 Ficus nitida :: Laurel Fig 53 5X Pearl St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6005567.3 2108720.4 37.7704592014806 -122.424094599295 (37.7704592014806, -122.424094599295) 8 2 5 28853 19
177980 27711 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
181935 17311 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 77 Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006769.4589066 2109244.8738273 37.7719670827617 -122.419973541884 (37.7719670827617, -122.419973541884) 8 2 9 28853 19
183049 111628 Undocumented 4 Ficus nitida :: Laurel Fig 53 11X SOUTH VAN NESS AVE 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007074 2110234 37.7747001403616 -122.418990277193 (37.7747001403616, -122.418990277193) 8 2 9 28853 19
185238 15310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1650 Mission St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6006887.5781181 2109042.9003069 37.7714191656036 -122.41955062575 (37.7714191656036, -122.41955062575) 8 2 9 28853 19
186566 15267 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1531 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6007476.41024 2109891.28194 37.7737817698767 -122.417573960108 (37.7737817698767, -122.417573960108) 8 2 9 28853 19
187371 89021 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500 Mission St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 51766 6007445.1 2110006.7 37.7740969185595 -122.417690449841 (37.7740969185595, -122.417690449841) 8 2 9 28853 19
187641 17308 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 70 Otis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006766.44916 2109389.93705 37.7723652222089 -122.419994248937 (37.7723652222089, -122.419994248937) 8 2 9 28853 19
189650 15279 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1551 MISSION ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6007345 2109715.7 37.7732922684508 -122.418016080506 (37.7732922684508, -122.418016080506) 8 2 9 28853 19
190135 15260 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1500 Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6007445.07805 2110006.65891 37.7740968045009 -122.417690522857 (37.7740968045009, -122.417690522857) 8 2 9 28853 19
190383 17316 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 86 OTIS ST 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006711 2109331 37.7722002709716 -122.420181869556 (37.7722002709716, -122.420181869556) 8 2 9 28853 19
37186 112411 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
43596 112404 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
55250 112408 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
120051 112410 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
130193 112406 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
145639 112403 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
153176 112405 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
166186 112407 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
168880 112409 Undocumented 4 Ficus nitida :: Laurel Fig 53 300x 15TH ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6011264 2107649 37.7678373720049 -122.404314158491 (37.7678373720049, -122.404314158491) 8 2 8 28853 20
770 111807 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
1212 40354 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 12 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
2027 32641 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
5722 255886 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
6188 111792 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
8874 15149 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 3 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
9438 115058 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
15941 85313 Significant Tree 6 Ficus nitida :: Laurel Fig 53 610 Brannan St 1 unknown : Cutout Tree Private 2         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
18772 115057 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
19070 15154 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 8 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
20034 255882 Undocumented 4 Ficus nitida :: Laurel Fig 53 50 Columbia Square St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
20552 15171 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 941 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6010472.08374 2112774.72891 37.7818671496492 -122.407414720255 (37.7818671496492, -122.407414720255) 14 2 9 28853 34
24140 32644 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
24565 10586 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1050X Harrison St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5     75 3X3   6011036.2882597 2110765.2479161 37.7763811461579 -122.405321269139 (37.7763811461579, -122.405321269139) 14 2 9 28853 34
24912 32645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/17/1999 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
26170 124732 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 198X Division St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010680 2108566 37.7703225929477 -122.406398777104 (37.7703225929477, -122.406398777104) 14 2 9 28853 34
26375 111795 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 12 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
27832 15155 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 9 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
28163 10573 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000X Harrison St 2 Sidewalk: Curb side : Cutout Tree DPW 1     65 4x4   6011301.87316 2111047.97507 37.7771722946398 -122.404422436991 (37.7771722946398, -122.404422436991) 14 2 9 28853 34
31550 15160 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 14 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
32017 116771 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 590X NATOMA ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6009883 2111689 37.7788530052944 -122.409376039999 (37.7788530052944, -122.409376039999) 14 2 9 28853 34
32372 111797 Undocumented 4 Ficus nitida :: Laurel Fig 53 55X SHERMAN ST 14 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
34792 15148 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 2 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
38782 101759 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
38859 115059 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
39348 97611 Permitted Site 7 Ficus nitida :: Laurel Fig 53 349 10th St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009106.7 2109348.6 37.7723832922197 -122.411896150488 (37.7723832922197, -122.411896150488) 8 2 9 28853 34
39622 15164 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 18 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
40269 25702 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 06th St 4 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6012081.78675 2110335.7627 37.7752602760543 -122.401674380603 (37.7752602760543, -122.401674380603) 14 2 9 28853 34
41708 251371 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390 06th St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Private     3x3   6011351 2111108 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486) 14 2 9 28853 34
42234 25701 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 06th St 3 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6012066.85402 2110350.08491 37.7752987682674 -122.40172704355 (37.7752987682674, -122.40172704355) 14 2 9 28853 34
43589 15250 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007716.15968 2110227.06056 37.7747172257492 -122.416768419302 (37.7747172257492, -122.416768419302) 8 2 9 28853 34
45235 15147 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 1 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
47908 101764 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 7 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
51739 19375 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 390X 06th St 6 Sidewalk: Curb side : Cutout Tree DPW 1     35 3X3   6011348.29286 2111104.97037 37.7773313845055 -122.404265868127 (37.7773313845055, -122.404265868127) 14 2 9 28853 34
54470 101758 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
55646 111811 Undocumented 4 Ficus nitida :: Laurel Fig 53 50X COLUMBIA SQUARE ST 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6010857 2110997 37.7770074580074 -122.405957810357 (37.7770074580074, -122.405957810357) 14 2 9 28853 34
55801 15251 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1450X Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6007694.41094 2110207.30516 37.7746617588291 -122.416842252889 (37.7746617588291, -122.416842252889) 8 2 9 28853 34
55811 115056 Undocumented 4 Ficus nitida :: Laurel Fig 53 499X BRANNAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6013762 2111312 37.7780344196247 -122.395930522096 (37.7780344196247, -122.395930522096) 6 2 9 28856 34
57879 101766 Undocumented 4 Ficus nitida :: Laurel Fig 53 45X 11th St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6007389.6 2110351.2 37.7750397101602 -122.417906860029 (37.7750397101602, -122.417906860029) 8 2 9 28853 34
58538 15152 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 6 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     18 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34
58892 40350 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 Tehama St 11 Sidewalk: Curb side : Cutout Tree Private 2   05/17/1999 12:00:00 AM 8   Permit Number 41479 6011468.97735143 2112560.39183232 37.7813343766323 -122.403950824176 (37.7813343766323, -122.403950824176) 6 2 9 28853 34
60538 32649 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/28/2005 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
66641 32646 Permitted Site 7 Ficus nitida :: Laurel Fig 53 379 TEHAMA ST 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/23/1996 12:00:00 AM 8   Permit Number 37086 6011447 2112547 37.7812963779039 -122.404025912764 (37.7812963779039, -122.404025912764) 6 2 9 28853 34
67792 15158 Permitted Site 7 Ficus nitida :: Laurel Fig 53 895X Mission St 12 Sidewalk: Curb side : Cutout Tree Dept of Real Estate 7     12 4x4   6010810.7123748 2113108.5528643 37.7828026992214 -122.406266743907 (37.7828026992214, -122.406266743907) 12 2 9 28853 34

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