trees
264 rows where Police Districts = 2 and qSpecies_id = 53 sorted by Neighborhoods (old)
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );