trees
334 rows where qSpecies_id = 59 sorted by Longitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1959 | 19904 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY34 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | |||||||||||||
| 6805 | 19781 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY19 | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 50ST | |||||||||||||
| 12447 | 19841 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY25 | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
| 13169 | 20051 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY52 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
| 15701 | 254211 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300X Esmeralda Ave | 3 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
| 18074 | 19903 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY34 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6X6 | |||||||||||||
| 185083 | 195981 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6018524.13374 | 2099557.33259 | 37.7460223488573 | -122.378640013128 | (37.7460223488573, -122.378640013128) | 10 | 3 | 8 | 58 | 1 | ||||
| 64096 | 195982 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6018502.10258 | 2099556.87815 | 37.7460198865213 | -122.378716163238 | (37.7460198865213, -122.378716163238) | 10 | 3 | 8 | 58 | 1 | ||||
| 47866 | 195983 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6018491.3513 | 2099573.26629 | 37.7460642923356 | -122.378754477939 | (37.7460642923356, -122.378754477939) | 10 | 3 | 8 | 58 | 1 | ||||
| 82059 | 195984 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6018485.16554 | 2099556.70792 | 37.7460184853642 | -122.378774718093 | (37.7460184853642, -122.378774718093) | 10 | 3 | 8 | 58 | 1 | ||||
| 120240 | 195985 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6018474.35913 | 2099556.32192 | 37.7460168297129 | -122.378812058831 | (37.7460168297129, -122.378812058831) | 10 | 3 | 8 | 58 | 1 | ||||
| 28533 | 195986 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6018468.61509 | 2099561.76349 | 37.7460314544851 | -122.378832298987 | (37.7460314544851, -122.378832298987) | 10 | 3 | 8 | 58 | 1 | ||||
| 176786 | 195987 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6018466.53487 | 2099573.76457 | 37.7460642923433 | -122.378840325441 | (37.7460642923433, -122.378840325441) | 10 | 3 | 8 | 58 | 1 | ||||
| 55799 | 195988 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6018362.60368 | 2099564.59582 | 37.7460333862374 | -122.379199073078 | (37.7460333862374, -122.379199073078) | 10 | 3 | 8 | 58 | 1 | ||||
| 99139 | 195989 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6018358.23149 | 2099573.02507 | 37.7460562901585 | -122.379214777067 | (37.7460562901585, -122.379214777067) | 10 | 3 | 8 | 58 | 1 | ||||
| 135590 | 195990 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6018348.89198 | 2099575.3229 | 37.7460620845153 | -122.379247231793 | (37.7460620845153, -122.379247231793) | 10 | 3 | 8 | 58 | 1 | ||||
| 127782 | 195991 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6018339.20952 | 2099575.6179 | 37.7460623605839 | -122.379280733321 | (37.7460623605839, -122.379280733321) | 10 | 3 | 8 | 58 | 1 | ||||
| 62379 | 195992 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6018320.61791 | 2099573.80473 | 37.7460563567193 | -122.379344895446 | (37.7460563567193, -122.379344895446) | 10 | 3 | 8 | 58 | 1 | ||||
| 164057 | 196049 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 35 | Width 10ft | 6017090.91062 | 2097040.61449 | 37.7390328376916 | -122.383420792935 | (37.7390328376916, -122.383420792935) | 10 | 3 | 8 | 58 | 1 | |||
| 112062 | 196048 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 10ft | 6017086.86394 | 2097032.16257 | 37.7390094067689 | -122.383434196434 | (37.7390094067689, -122.383434196434) | 10 | 3 | 8 | 58 | 1 | |||
| 159019 | 196047 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 10ft | 6017083.09876 | 2097027.5652 | 37.7389965752218 | -122.383446894874 | (37.7389965752218, -122.383446894874) | 10 | 3 | 8 | 58 | 1 | |||
| 37731 | 196046 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017076.84536 | 2097020.98628 | 37.7389781652152 | -122.383468058608 | (37.7389781652152, -122.383468058608) | 10 | 3 | 8 | 58 | 1 | |||
| 66956 | 196045 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6017076.58838 | 2097018.35028 | 37.7389709130863 | -122.383468763681 | (37.7389709130863, -122.383468763681) | 10 | 3 | 8 | 58 | 1 | |||
| 148904 | 196044 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6017074.4672 | 2097014.32935 | 37.7389597551859 | -122.383475817977 | (37.7389597551859, -122.383475817977) | 10 | 3 | 8 | 58 | 1 | |||
| 21224 | 196043 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 6017069.89025 | 2097009.95172 | 37.7389474821301 | -122.383491338448 | (37.7389474821301, -122.383491338448) | 10 | 3 | 8 | 58 | 1 | |||
| 144912 | 196042 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6017068.02223 | 2097008.36414 | 37.7389430197102 | -122.383497686772 | (37.7389430197102, -122.383497686772) | 10 | 3 | 8 | 58 | 1 | |||
| 158208 | 196041 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017065.52556 | 2097005.97628 | 37.7389363251367 | -122.383506153 | (37.7389363251367, -122.383506153) | 10 | 3 | 8 | 58 | 1 | |||
| 110153 | 196040 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 6017061.14337 | 2096999.06361 | 37.7389171021312 | -122.383520823632 | (37.7389171021312, -122.383520823632) | 10 | 3 | 8 | 58 | 1 | |||
| 52670 | 196039 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6017058.78761 | 2096996.23306 | 37.7389091998064 | -122.38352877184 | (37.7389091998064, -122.38352877184) | 10 | 3 | 8 | 58 | 1 | |||
| 35055 | 196038 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017052.09274 | 2096987.35134 | 37.7388844423585 | -122.38355130167 | (37.7388844423585, -122.38355130167) | 10 | 3 | 8 | 58 | 1 | |||
| 98268 | 196037 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 10ft | 6017049.14343 | 2096982.73756 | 37.7388716108342 | -122.383561177999 | (37.7388716108342, -122.383561177999) | 10 | 3 | 8 | 58 | 1 | |||
| 153530 | 196036 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6017046.41048 | 2096978.72928 | 37.738860453849 | -122.383570348389 | (37.738860453849, -122.383570348389) | 10 | 3 | 8 | 58 | 1 | |||
| 104734 | 196035 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 10ft | 6017042.43736 | 2096973.93304 | 37.7388470647366 | -122.383583751905 | (37.7388470647366, -122.383583751905) | 10 | 3 | 8 | 58 | 1 | |||
| 79693 | 196025 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6017042.18161 | 2097072.11853 | 37.7391166482065 | -122.383591469892 | (37.7391166482065, -122.383591469892) | 10 | 3 | 8 | 58 | 1 | |||
| 91426 | 196034 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 10ft | 6017038.23562 | 2096967.92235 | 37.7388303283508 | -122.38359786136 | (37.7388303283508, -122.38359786136) | 10 | 3 | 8 | 58 | 1 | |||
| 136935 | 196026 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6017039.21913 | 2097067.45785 | 37.7391036871735 | -122.383601388517 | (37.7391036871735, -122.383601388517) | 10 | 3 | 8 | 58 | 1 | |||
| 124042 | 196027 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017034.20589 | 2097061.66689 | 37.7390875092666 | -122.383618319135 | (37.7390875092666, -122.383618319135) | 10 | 3 | 8 | 58 | 1 | |||
| 72063 | 196028 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 10ft | 6017030.63637 | 2097056.65947 | 37.7390735625998 | -122.383630312507 | (37.7390735625998, -122.383630312507) | 10 | 3 | 8 | 58 | 1 | |||
| 169477 | 255308 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Mendell St | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | 6017061 | 2098665 | 37.7434914187463 | -122.383637271506 | (37.7434914187463, -122.383637271506) | 10 | 3 | 8 | 58 | 1 | ||
| 178720 | 196029 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017027.27121 | 2097051.6476 | 37.7390596150087 | -122.383641598974 | (37.7390596150087, -122.383641598974) | 10 | 3 | 8 | 58 | 1 | |||
| 38227 | 196030 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6017023.70578 | 2097046.84349 | 37.739046226814 | -122.383653592346 | (37.739046226814, -122.383653592346) | 10 | 3 | 8 | 58 | 1 | |||
| 152914 | 196031 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 6017021.60504 | 2097043.83814 | 37.7390378586108 | -122.383660646635 | (37.7390378586108, -122.383660646635) | 10 | 3 | 8 | 58 | 1 | |||
| 72670 | 196032 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 10ft | 6017018.89253 | 2097040.84511 | 37.7390294904202 | -122.383669817022 | (37.7390294904202, -122.383669817022) | 10 | 3 | 8 | 58 | 1 | |||
| 102343 | 196033 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 6017016.3348 | 2097035.41086 | 37.7390144276853 | -122.383678282325 | (37.7390144276853, -122.383678282325) | 10 | 3 | 8 | 58 | 1 | |||
| 151245 | 255455 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 31x Garlington Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6016454 | 2094669 | 37.7324856396877 | -122.385457730704 | (37.7324856396877, -122.385457730704) | 10 | 3 | 8 | 58 | 1 | ||||
| 175828 | 195997 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6016094.12732 | 2110713.51522 | 37.776520582607 | -122.387821017432 | (37.776520582607, -122.387821017432) | 14 | 3 | 9 | 310 | 20 | ||||
| 100061 | 195998 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6016075.49067 | 2110714.30849 | 37.7765217283366 | -122.387885542896 | (37.7765217283366, -122.387885542896) | 14 | 3 | 9 | 310 | 20 | ||||
| 10408 | 195999 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6016051.5903 | 2110711.60548 | 37.7765129824099 | -122.387968033214 | (37.7765129824099, -122.387968033214) | 14 | 3 | 9 | 310 | 20 | ||||
| 32582 | 196000 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6016029.90141 | 2110710.35403 | 37.7765083446095 | -122.38804297462 | (37.7765083446095, -122.38804297462) | 14 | 3 | 9 | 310 | 20 | ||||
| 137112 | 196001 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6016008.12939 | 2110708.52586 | 37.7765021186104 | -122.388118163334 | (37.7765021186104, -122.388118163334) | 14 | 3 | 9 | 310 | 20 | ||||
| 185058 | 196002 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6015985.51722 | 2110706.09628 | 37.7764941946745 | -122.388196216398 | (37.7764941946745, -122.388196216398) | 14 | 3 | 9 | 310 | 20 | ||||
| 121735 | 196003 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015962.95079 | 2110705.93329 | 37.7764924967751 | -122.388274269443 | (37.7764924967751, -122.388274269443) | 14 | 3 | 9 | 310 | 20 | ||||
| 191532 | 196004 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015940.35109 | 2110704.12187 | 37.7764862707572 | -122.388352322497 | (37.7764862707572, -122.388352322497) | 14 | 3 | 9 | 310 | 20 | ||||
| 87935 | 196005 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015919.22066 | 2110703.31156 | 37.7764828749315 | -122.38842536276 | (37.7764828749315, -122.38842536276) | 14 | 3 | 9 | 310 | 20 | ||||
| 161562 | 195955 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 6015700.85592 | 2100342.37267 | 37.7480218628289 | -122.388457404684 | (37.7480218628289, -122.388457404684) | 10 | 3 | 8 | 58 | 1 | ||||
| 80958 | 196006 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6015895.59891 | 2110702.13918 | 37.7764783468376 | -122.388506996001 | (37.7764783468376, -122.388506996001) | 14 | 3 | 9 | 310 | 20 | ||||
| 42007 | 195956 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 2 | Back Yard : Yard | Tree | Private 2 | 9 | 6015682.42479 | 2100340.57249 | 37.7480158985316 | -122.388521013727 | (37.7480158985316, -122.388521013727) | 10 | 3 | 8 | 58 | 1 | ||||
| 173532 | 195957 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 3 | Back Yard : Yard | Tree | Private 2 | 12 | 6015667.37966 | 2100340.53223 | 37.7480149542209 | -122.388573036834 | (37.7480149542209, -122.388573036834) | 10 | 3 | 8 | 58 | 1 | ||||
| 81978 | 196007 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015874.48096 | 2110701.94702 | 37.7764766489106 | -122.388580036236 | (37.7764766489106, -122.388580036236) | 14 | 3 | 9 | 310 | 20 | ||||
| 176690 | 195958 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 4 | Back Yard : Yard | Tree | Private 2 | 10 | 6015649.24062 | 2100340.89834 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | 10 | 3 | 8 | 58 | 1 | ||||
| 145197 | 196008 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015854.16157 | 2110700.296 | 37.7764709894889 | -122.388650212137 | (37.7764709894889, -122.388650212137) | 14 | 3 | 9 | 310 | 20 | ||||
| 126204 | 196009 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015830.73834 | 2110698.70731 | 37.776465329147 | -122.388731129538 | (37.776465329147, -122.388731129538) | 14 | 3 | 9 | 310 | 20 | ||||
| 61534 | 195959 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 5 | Back Yard : Yard | Tree | Private 2 | 10 | 6015616.60441 | 2100338.74984 | 37.7480072461368 | -122.388748492749 | (37.7480072461368, -122.388748492749) | 10 | 3 | 8 | 58 | 1 | ||||
| 37957 | 196010 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015807.5178 | 2110696.90854 | 37.7764591031505 | -122.38881133109 | (37.7764591031505, -122.38881133109) | 14 | 3 | 9 | 310 | 20 | ||||
| 192137 | 195960 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 6 | Back Yard : Yard | Tree | Private 2 | 8 | 6015597.7328 | 2100337.72732 | 37.7480033925609 | -122.388813679213 | (37.7480033925609, -122.388813679213) | 10 | 3 | 8 | 58 | 1 | ||||
| 137920 | 195961 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 7 | Back Yard : Yard | Tree | Private 2 | 10 | 6015577.60391 | 2100335.50195 | 37.7479961664858 | -122.388883129368 | (37.7479961664858, -122.388883129368) | 10 | 3 | 8 | 58 | 1 | ||||
| 84576 | 196011 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015786.39152 | 2110696.30426 | 37.7764562729832 | -122.388884371337 | (37.7764562729832, -122.388884371337) | 14 | 3 | 9 | 310 | 20 | ||||
| 90159 | 195962 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 8 | Back Yard : Yard | Tree | Private 2 | 9 | 6015556.60842 | 2100333.99599 | 37.7479908676843 | -122.388955626422 | (37.7479908676843, -122.388955626422) | 10 | 3 | 8 | 58 | 1 | ||||
| 23490 | 196012 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015764.41678 | 2110694.68671 | 37.7764506135265 | -122.388960275907 | (37.7764506135265, -122.388960275907) | 14 | 3 | 9 | 310 | 20 | ||||
| 167404 | 195963 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 9 | Back Yard : Yard | Tree | Private 2 | 8 | 6015537.22246 | 2100333.68578 | 37.7479889413373 | -122.389022641203 | (37.7479889413373, -122.389022641203) | 10 | 3 | 8 | 58 | 1 | ||||
| 49343 | 196013 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015743.28218 | 2110693.67028 | 37.7764466511333 | -122.389033316139 | (37.7764466511333, -122.389033316139) | 14 | 3 | 9 | 310 | 20 | ||||
| 155557 | 195964 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 10 | Back Yard : Yard | Tree | Private 2 | 8 | 6015516.57214 | 2100331.82177 | 37.7479826784534 | -122.38909391965 | (37.7479826784534, -122.38909391965) | 10 | 3 | 8 | 58 | 1 | ||||
| 30255 | 196014 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015720.48392 | 2110692.27541 | 37.7764415573597 | -122.389112085054 | (37.7764415573597, -122.389112085054) | 14 | 3 | 9 | 310 | 20 | ||||
| 63271 | 195965 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 11 | Back Yard : Yard | Tree | Private 2 | 8 | 6015497.16873 | 2100330.63483 | 37.7479783437428 | -122.389160933554 | (37.7479783437428, -122.389160933554) | 10 | 3 | 8 | 58 | 1 | ||||
| 184380 | 196015 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015698.09519 | 2110690.66596 | 37.7764358970472 | -122.389189422279 | (37.7764358970472, -122.389189422279) | 14 | 3 | 9 | 310 | 20 | ||||
| 103959 | 195966 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 12 | Back Yard : Yard | Tree | Private 2 | 6 | 6015475.98989 | 2100328.78152 | 37.7479720808553 | -122.389234040342 | (37.7479720808553, -122.389234040342) | 3 | 8 | 58 | 1 | |||||
| 169789 | 196016 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015678.42156 | 2110690.23877 | 37.7764336334278 | -122.389257449686 | (37.7764336334278, -122.389257449686) | 14 | 3 | 9 | 310 | 20 | ||||
| 138530 | 195967 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 13 | Back Yard : Yard | Tree | Private 2 | 5 | 6015456.78398 | 2100328.64296 | 37.747970635647 | -122.389300444473 | (37.747970635647, -122.389300444473) | 3 | 8 | 58 | 1 | |||||
| 155750 | 196017 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015653.37625 | 2110690.3321 | 37.776432501193 | -122.389344095768 | (37.776432501193, -122.389344095768) | 14 | 3 | 9 | 310 | 20 | ||||
| 79032 | 195968 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 14 | Back Yard : Yard | Tree | Private 2 | 7 | 6015437.03514 | 2100327.81381 | 37.7479672640843 | -122.389368677829 | (37.7479672640843, -122.389368677829) | 3 | 8 | 58 | 1 | |||||
| 52665 | 254470 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1601 Evans Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
| 6092 | 196018 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015632.04702 | 2110689.93838 | 37.7764302375944 | -122.389417852744 | (37.7764302375944, -122.389417852744) | 14 | 3 | 9 | 310 | 20 | ||||
| 64076 | 195969 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 15 | Back Yard : Yard | Tree | Private 2 | 8 | 6015417.97335 | 2100326.09336 | 37.7479614832509 | -122.389434473133 | (37.7479614832509, -122.389434473133) | 3 | 8 | 58 | 1 | |||||
| 138177 | 196019 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015611.09455 | 2110687.68162 | 37.7764228793455 | -122.389490176245 | (37.7764228793455, -122.389490176245) | 14 | 3 | 9 | 310 | 20 | ||||
| 29793 | 195970 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 16 | Back Yard : Yard | Tree | Private 2 | 8 | 6015399.1088 | 2100325.42161 | 37.7479585928282 | -122.389499659601 | (37.7479585928282, -122.389499659601) | 3 | 8 | 58 | 1 | |||||
| 158107 | 196020 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6015589.15281 | 2110687.71234 | 37.7764217471115 | -122.38956608172 | (37.7764217471115, -122.38956608172) | 14 | 3 | 9 | 310 | 20 | ||||
| 144333 | 195971 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 17 | Back Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6015377.86647 | 2100320.41197 | 37.7479436595871 | -122.389572765484 | (37.7479436595871, -122.389572765484) | 3 | 8 | 58 | 1 | ||||
| 39747 | 196021 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6015567.39764 | 2110686.7089 | 37.7764177856004 | -122.389641269543 | (37.7764177856004, -122.389641269543) | 14 | 3 | 9 | 310 | 20 | ||||
| 127355 | 195972 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 18 | Back Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6015355.8319 | 2100319.80426 | 37.7479407691514 | -122.389648918288 | (37.7479407691514, -122.389648918288) | 3 | 8 | 58 | 1 | ||||
| 68586 | 196022 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | 6015549.75144 | 2110684.1794 | 37.7764098616684 | -122.389702136539 | (37.7764098616684, -122.389702136539) | 14 | 3 | 9 | 310 | 20 | ||||
| 98771 | 195973 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 19 | Back Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6015335.01264 | 2100318.29491 | 37.7479354703429 | -122.389720805596 | (37.7479354703429, -122.389720805596) | 3 | 8 | 58 | 1 | ||||
| 41514 | 195974 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 20 | Back Yard : Yard | Tree | Private 2 | 12 | Width 4ft | 6015315.44713 | 2100317.81293 | 37.7479330619596 | -122.389788429193 | (37.7479330619596, -122.389788429193) | 3 | 8 | 58 | 1 | ||||
| 81240 | 195975 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 21 | Back Yard : Yard | Tree | Private 2 | 9 | Width 4ft | 6015294.9834 | 2100316.47199 | 37.747928245201 | -122.389859098828 | (37.747928245201, -122.389859098828) | 3 | 8 | 58 | 1 | ||||
| 185019 | 195976 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 22 | Back Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6015275.57642 | 2100315.10939 | 37.7479234275315 | -122.389926112714 | (37.7479234275315, -122.389926112714) | 3 | 8 | 58 | 1 | ||||
| 145025 | 195977 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 23 | Back Yard : Yard | Tree | Private 2 | 5 | Width 4ft | 6015256.87723 | 2100313.90806 | 37.7479190918917 | -122.389990690329 | (37.7479190918917, -122.389990690329) | 3 | 8 | 58 | 1 | ||||
| 53808 | 195978 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 24 | Back Yard : Yard | Tree | Private 2 | 9 | Width 4ft | 6015236.23042 | 2100312.22008 | 37.7479133119586 | -122.390061968785 | (37.7479133119586, -122.390061968785) | 3 | 8 | 58 | 1 | ||||
| 183244 | 195979 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Phelps St | 1 | Side Yard : Yard | Tree | Private 2 | 30 | Width 9ft | 6014704.25324 | 2097268.53042 | 37.7395264548697 | -122.39168875964 | (37.7395264548697, -122.39168875964) | 10 | 3 | 8 | 58 | 1 | |||
| 74182 | 195980 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Phelps St | 2 | Side Yard : Yard | Tree | Private 2 | 24 | 6014694.29284 | 2097256.88186 | 37.7394939174204 | -122.391722384404 | (37.7394939174204, -122.391722384404) | 10 | 3 | 8 | 58 | 1 | ||||
| 73440 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
| 80147 | 116095 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 |
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) );