trees
2,180 rows where qSpecies_id = 57 sorted by Latitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10546 | 77641 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006964.98892 | 2093186.85252 | 37.7278864190206 | -122.418158533295 | (37.7278864190206, -122.418158533295) | 9 | 3 | 7 | 309 | 5 | ||
| 9059 | 77640 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 13 | 0 | 6006980.92428 | 2093193.11147 | 37.7279045016753 | -122.418103887786 | (37.7279045016753, -122.418103887786) | 9 | 3 | 7 | 309 | 5 | ||
| 194115 | 208012 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 126 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998765.71342 | 2093368.99771 | 37.7279216283624 | -122.446516611665 | (37.7279216283624, -122.446516611665) | 9 | 7 | 4 | 28861 | 40 | |||
| 122469 | 40057 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1311 Shafter Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | Permit Number 41291 | 6016435.57889801 | 2093012.13201176 | 37.7279351895138 | -122.385405998165 | (37.7279351895138, -122.385405998165) | 10 | 3 | 8 | 58 | 1 | ||
| 115622 | 177140 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 822 Felton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008497.82437 | 2093174.81281 | 37.727939519481 | -122.412858615334 | (37.727939519481, -122.412858615334) | 9 | 3 | 7 | 309 | 28 | |||
| 178739 | 40056 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1311 Shafter Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/19/1999 12:00:00 AM | 9 | Permit Number 41291 | 6016422.4594 | 2093017.6709 | 37.727949672355 | -122.385451738871 | (37.727949672355, -122.385451738871) | 10 | 3 | 8 | 58 | 1 | |
| 183551 | 208011 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 126 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998765.6075 | 2093383.38931 | 37.7279611382792 | -122.446518012793 | (37.7279611382792, -122.446518012793) | 9 | 7 | 4 | 28861 | 40 | |||
| 79711 | 208010 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 126 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998766.05843 | 2093398.57604 | 37.7280028632432 | -122.446517546066 | (37.7280028632432, -122.446517546066) | 9 | 7 | 4 | 28861 | 40 | |||
| 166356 | 208009 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 126 Edna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998765.79191 | 2093418.21539 | 37.7280567730798 | -122.446519879783 | (37.7280567730798, -122.446519879783) | 9 | 7 | 4 | 28861 | 40 | |||
| 43850 | 35726 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Dartmouth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 | ||
| 96498 | 35728 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Dartmouth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 | ||
| 100174 | 35727 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Dartmouth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.412628258541 | (37.7280780839519, -122.412628258541) | 9 | 3 | 7 | 309 | 28 | ||
| 101453 | 177134 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6006986.52486 | 2093261.74193 | 37.7280932612704 | -122.418089389836 | (37.7280932612704, -122.418089389836) | 9 | 3 | 7 | 309 | 5 | |||
| 181255 | 177133 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6006981.25379 | 2093279.99997 | 37.7281430972085 | -122.418108906001 | (37.7281430972085, -122.418108906001) | 9 | 3 | 7 | 309 | 5 | |||
| 149433 | 177115 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Vienna St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 6005069.55264 | 2093328.89911 | 37.7281695777432 | -122.424721208244 | (37.7281695777432, -122.424721208244) | 9 | 7 | 6 | 28861 | 5 | |||
| 81544 | 177114 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 3ft | 6005072.9536 | 2093334.35555 | 37.7281847520053 | -122.424709838991 | (37.7281847520053, -122.424709838991) | 9 | 7 | 6 | 28861 | 5 | |||
| 139834 | 177113 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Vienna St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 6005075.07966 | 2093337.79149 | 37.728194306415 | -122.42470273344 | (37.728194306415, -122.42470273344) | 9 | 7 | 6 | 28861 | 5 | |||
| 77144 | 177132 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6006974.89341 | 2093300.20785 | 37.728198225668 | -122.418132326164 | (37.728198225668, -122.418132326164) | 9 | 3 | 7 | 309 | 5 | |||
| 41145 | 207832 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 147 Judson Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999123.91286 | 2093462.37431 | 37.7281984720769 | -122.44528502248 | (37.7281984720769, -122.44528502248) | 9 | 7 | 4 | 28861 | 40 | ||||
| 148591 | 68862 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 147 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32825 | 5999105.31511453 | 2093467.13996107 | 37.7282104958197 | -122.445349657876 | (37.7282104958197, -122.445349657876) | 9 | 7 | 4 | 28861 | 40 | ||
| 32604 | 207831 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 147 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5999093.71355 | 2093470.19209 | 37.7282182139785 | -122.445389984154 | (37.7282182139785, -122.445389984154) | 9 | 7 | 4 | 28861 | 40 | |||
| 96997 | 177131 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006969.3427 | 2093320.55961 | 37.7282537947592 | -122.418152957489 | (37.7282537947592, -122.418152957489) | 9 | 3 | 7 | 309 | 5 | |||
| 185273 | 177130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6006962.96943 | 2093340.12514 | 37.7283071587297 | -122.41817637676 | (37.7283071587297, -122.41817637676) | 9 | 3 | 7 | 309 | 5 | |||
| 22254 | 199896 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1231 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6017188.7375 | 2093143.079 | 37.728336384515 | -122.382811392019 | (37.728336384515, -122.382811392019) | 10 | 3 | 8 | 58 | 1 | |||
| 78851 | 177135 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 567 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008900.11894 | 2093318.49374 | 37.7283566097612 | -122.411478013912 | (37.7283566097612, -122.411478013912) | 9 | 3 | 7 | 309 | 28 | |||
| 89858 | 177129 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006955.53979 | 2093363.24603 | 37.7283702254814 | -122.418203699955 | (37.7283702254814, -122.418203699955) | 9 | 3 | 7 | 309 | 5 | |||
| 82041 | 177136 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 567 Bowdoin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008890.39934 | 2093346.80434 | 37.7284337994566 | -122.411513614482 | (37.7284337994566, -122.411513614482) | 9 | 3 | 7 | 309 | 28 | |||
| 109873 | 177128 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006947.17025 | 2093387.19061 | 37.7284355009944 | -122.418234330861 | (37.7284355009944, -122.418234330861) | 9 | 3 | 7 | 309 | 5 | |||
| 85866 | 177137 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 567 Bowdoin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008885.05575 | 2093363.35639 | 37.728478948128 | -122.411533256552 | (37.728478948128, -122.411533256552) | 9 | 3 | 7 | 309 | 28 | |||
| 139598 | 177127 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6006940.52586 | 2093410.55841 | 37.728499289894 | -122.418258956995 | (37.728499289894, -122.418258956995) | 9 | 3 | 7 | 309 | 5 | |||
| 125609 | 177138 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 567 Bowdoin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008881.29174 | 2093378.99217 | 37.7285216695165 | -122.411547373223 | (37.7285216695165, -122.411547373223) | 9 | 3 | 7 | 309 | 28 | |||
| 39322 | 177139 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 567 Bowdoin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6008876.27782 | 2093394.29976 | 37.7285634196519 | -122.411565787757 | (37.7285634196519, -122.411565787757) | 9 | 3 | 7 | 309 | 28 | |||
| 131590 | 47214 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 570 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 12 | 6x4 | Permit Number 45165 | 6008824.68232 | 2093406.49274 | 37.7285940046859 | -122.411745018113 | (37.7285940046859, -122.411745018113) | 9 | 3 | 7 | 309 | 28 |
| 8214 | 73718 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 73 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6001058.66667 | 2093583.83186 | 37.7286422173636 | -122.438605218052 | (37.7286422173636, -122.438605218052) | 9 | 7 | 6 | 28861 | 25 | |||
| 15927 | 72147 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 73 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10 | 6001070.59946 | 2093593.78195 | 37.7286702168354 | -122.43856467842 | (37.7286702168354, -122.43856467842) | 9 | 7 | 6 | 28861 | 25 | |||
| 102592 | 17145 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
| 193717 | 17143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/1999 12:00:00 AM | 3 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.379831166827 | (37.7286870123052, -122.379831166827) | 10 | 3 | 8 | 58 | 1 | ||
| 70145 | 62207 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 55 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/1985 12:00:00 AM | Permit Number 22329 | 6001115.41413851 | 2093618.10384038 | 37.728739548363 | -122.438411493533 | (37.728739548363, -122.438411493533) | 9 | 7 | 6 | 28861 | 25 | ||
| 86795 | 177126 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6006914.16107 | 2093507.15679 | 37.7287630439686 | -122.418356948033 | (37.7287630439686, -122.418356948033) | 9 | 3 | 7 | 309 | 5 | |||
| 135876 | 17142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/31/1992 12:00:00 AM | 3 | 3X3 | 6017965.0245 | 2093314.70496 | 37.7288504949441 | -122.380139626367 | (37.7288504949441, -122.380139626367) | 10 | 3 | 8 | 58 | 1 | ||
| 1826 | 62206 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 13 | Permit Number 22328 | 6001109.87298 | 2093671.7514 | 37.7288865370674 | -122.438434491679 | (37.7288865370674, -122.438434491679) | 9 | 7 | 6 | 28861 | 25 | |
| 16674 | 62213 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 37 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 13 | Permit Number 22336 | 6001177.27304 | 2093672.32892 | 37.7288919563899 | -122.438201526774 | (37.7288919563899, -122.438201526774) | 9 | 7 | 6 | 28861 | 25 | |
| 76196 | 17144 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1030 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/1997 12:00:00 AM | 3 | 3X3 | 6017899.57967 | 2093362.52409 | 37.728978186084 | -122.380369198091 | (37.728978186084, -122.380369198091) | 10 | 3 | 8 | 58 | 1 | ||
| 32373 | 77649 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
| 54545 | 42985 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 12 | 9x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
| 67880 | 77637 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
| 103561 | 42990 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 8 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
| 110301 | 42989 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
| 120765 | 42988 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/16/2000 12:00:00 AM | 10 | 4x5 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 |
| 133673 | 77636 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
| 135683 | 77635 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
| 141010 | 77633 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 8 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
| 180726 | 77634 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2X Yale St | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10/26/1984 12:00:00 AM | 14 | 4x4 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.419224083243 | (37.7290063985797, -122.419224083243) | 9 | 3 | 7 | 309 | 5 | |
| 92937 | 208008 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 247 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998434.03995 | 2093773.36689 | 37.7290129808422 | -122.447692307953 | (37.7290129808422, -122.447692307953) | 9 | 7 | 4 | 28861 | 40 | ||||
| 131561 | 58390 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 100 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/08/1994 12:00:00 AM | Permit Number 17524 | 5998126.0559233 | 2093810.47392433 | 37.7290972609549 | -122.448759699122 | (37.7290972609549, -122.448759699122) | 9 | 7 | 4 | 28861 | 40 | ||
| 139672 | 207824 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Staples Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998157.01661 | 2093811.48705 | 37.7291018131794 | -122.448652738959 | (37.7291018131794, -122.448652738959) | 9 | 7 | 4 | 28861 | 40 | |||
| 179043 | 207823 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Staples Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998174.84145 | 2093811.63794 | 37.7291032467189 | -122.448591128189 | (37.7291032467189, -122.448591128189) | 9 | 7 | 4 | 28861 | 40 | |||
| 114846 | 207822 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5998191.35411 | 2093811.83744 | 37.7291047386702 | -122.448534057207 | (37.7291047386702, -122.448534057207) | 9 | 7 | 4 | 28861 | 40 | |||
| 119905 | 207821 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Staples Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998204.93693 | 2093811.96794 | 37.7291058736189 | -122.448487109905 | (37.7291058736189, -122.448487109905) | 9 | 7 | 4 | 28861 | 40 | |||
| 68595 | 207820 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 298 Staples Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998217.89747 | 2093812.45957 | 37.7291079645478 | -122.448442339861 | (37.7291079645478, -122.448442339861) | 9 | 7 | 4 | 28861 | 40 | |||
| 41391 | 68819 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 201 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32767 | 5999394.1666158 | 2093791.36471631 | 37.729117226145 | -122.444374381277 | (37.729117226145, -122.444374381277) | 9 | 7 | 4 | 28861 | 40 | ||
| 96553 | 207830 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5999312.24137 | 2093797.37115 | 37.7291290437632 | -122.444658034037 | (37.7291290437632, -122.444658034037) | 9 | 7 | 4 | 28861 | 40 | |||
| 63173 | 207829 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5999329.28012 | 2093797.53913 | 37.7291304772829 | -122.444599141963 | (37.7291304772829, -122.444599141963) | 9 | 7 | 4 | 28861 | 40 | |||
| 192433 | 207827 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5999363.86559 | 2093797.08144 | 37.7291311940404 | -122.444479544704 | (37.7291311940404, -122.444479544704) | 9 | 7 | 4 | 28861 | 40 | |||
| 29772 | 207828 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 1ft | 5999348.94408 | 2093797.91328 | 37.7291326266637 | -122.444531189165 | (37.7291326266637, -122.444531189165) | 9 | 7 | 4 | 28861 | 40 | |||
| 13631 | 207826 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 5999382.74348 | 2093797.47195 | 37.7291333434223 | -122.444414310576 | (37.7291333434223, -122.444414310576) | 9 | 7 | 4 | 28861 | 40 | |||
| 3257 | 62475 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 14 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/08/1986 12:00:00 AM | 14 | Permit Number 22646 | 6001230.17424 | 2093762.35137 | 37.729142145995 | -122.438025089712 | (37.729142145995, -122.438025089712) | 9 | 7 | 6 | 28861 | 25 | |
| 52021 | 67901 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31603 | 5997414.60785489 | 2093843.94609455 | 37.729148458175 | -122.45122163283 | (37.729148458175, -122.45122163283) | 9 | 7 | 4 | 28861 | 40 | ||
| 90755 | 61047 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 104 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32830 | 5999375.36037511 | 2093808.9050602 | 37.7291643148165 | -122.444440655825 | (37.7291643148165, -122.444440655825) | 9 | 7 | 4 | 28861 | 40 | ||
| 14672 | 62212 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 San Gabriel Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 11 | Permit Number 22335 | 6001303.33369 | 2093769.88226 | 37.7291669843608 | -122.437772711138 | (37.7291669843608, -122.437772711138) | 9 | 7 | 6 | 28861 | 25 | |
| 140336 | 67902 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 115 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31604 | 5997414.89563577 | 2093860.91507447 | 37.7291950674434 | -122.451221861234 | (37.7291950674434, -122.451221861234) | 9 | 7 | 4 | 28861 | 40 | ||
| 128931 | 121622 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 298X Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998141 | 2093851 | 37.7292093905587 | -122.448710954214 | (37.7292093905587, -122.448710954214) | 9 | 7 | 4 | 28861 | 40 | ||||
| 191692 | 121621 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 298X Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5998141 | 2093851 | 37.7292093905587 | -122.448710954214 | (37.7292093905587, -122.448710954214) | 9 | 7 | 4 | 28861 | 40 | ||||
| 82436 | 68881 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 318 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/29/1993 12:00:00 AM | Permit Number 32853 | 5998787.73896502 | 2093851.41161762 | 37.7292474820186 | -122.446475160796 | (37.7292474820186, -122.446475160796) | 9 | 7 | 4 | 28861 | 40 | ||
| 141044 | 207819 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 106 Foerster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5998117.86344 | 2093869.45755 | 37.7292587475919 | -122.448792267857 | (37.7292587475919, -122.448792267857) | 9 | 7 | 4 | 28861 | 40 | |||
| 106777 | 207817 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 109 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997420.91181 | 2093893.18113 | 37.7292840068365 | -122.451203388929 | (37.7292840068365, -122.451203388929) | 9 | 7 | 4 | 28861 | 40 | |||
| 192483 | 207818 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 115 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5997421.24463 | 2093919.55877 | 37.7293564526293 | -122.451204139877 | (37.7293564526293, -122.451204139877) | 9 | 7 | 4 | 28861 | 40 | |||
| 48548 | 207825 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 318 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 5998773.91713 | 2093910.347 | 37.7294085152774 | -122.446527182289 | (37.7294085152774, -122.446527182289) | 9 | 7 | 4 | 28861 | 40 | |||
| 76187 | 191503 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 15 Baldwin Ct | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6017915.59707 | 2093553.456 | 37.7295033317063 | -122.380327088241 | (37.7295033317063, -122.380327088241) | 10 | 3 | 8 | 58 | 1 | |||
| 177429 | 1702 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 47 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017785.2431167 | 2093593.9655411 | 37.7296073696477 | -122.380780554369 | (37.7296073696477, -122.380780554369) | 10 | 3 | 8 | 58 | 1 | |||
| 34603 | 207928 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 240 Upland Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993706.55269 | 2094092.03353 | 37.7296166372822 | -122.464058586949 | (37.7296166372822, -122.464058586949) | 9 | 8 | 4 | 59 | 40 | |||
| 159405 | 1691 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 23 Baldwin Ct | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017695.7876646 | 2093605.1145142 | 37.7296330451049 | -122.381090589205 | (37.7296330451049, -122.381090589205) | 10 | 3 | 8 | 58 | 1 | |||
| 18778 | 1705 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017900.5576644 | 2093604.0676713 | 37.729641471652 | -122.380382597634 | (37.729641471652, -122.380382597634) | 10 | 3 | 8 | 58 | 1 | |||
| 163286 | 1687 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 15 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/11/2006 12:00:00 AM | 3 | 3X3 | 6017775.00772 | 2093610.25153 | 37.729651522897 | -122.380817071263 | (37.729651522897, -122.380817071263) | 10 | 3 | 8 | 58 | 1 | ||
| 133841 | 191504 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2 Baldwin Ct | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6017862.18303 | 2093613.8535 | 37.7296662241092 | -122.38051594408 | (37.7296662241092, -122.38051594408) | 10 | 3 | 8 | 58 | 1 | |||
| 70646 | 1696 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 34 Baldwin Ct | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017739.6025757 | 2093657.002741 | 37.7297779384797 | -122.380942720777 | (37.7297779384797, -122.380942720777) | 10 | 3 | 8 | 58 | 1 | |||
| 20975 | 68850 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32813 | 5999189.08755836 | 2094052.99169606 | 37.7298238896011 | -122.445102154978 | (37.7298238896011, -122.445102154978) | 9 | 7 | 4 | 28861 | 40 | ||
| 193216 | 68829 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 33 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/30/1993 12:00:00 AM | Permit Number 32780 | 6000341.33765445 | 2094036.785475 | 37.729845090832 | -122.441117543772 | (37.729845090832, -122.441117543772) | 9 | 7 | 4 | 63 | 40 | ||
| 69728 | 207814 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 235 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 1ft | 5999174.29168 | 2094063.56835 | 37.7298520861014 | -122.445154065929 | (37.7298520861014, -122.445154065929) | 9 | 7 | 4 | 28861 | 40 | |||
| 129502 | 208007 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 33 Flood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6000194.86676 | 2094049.10178 | 37.7298705644518 | -122.441624792557 | (37.7298705644518, -122.441624792557) | 9 | 7 | 4 | 63 | 40 | |||
| 113820 | 65617 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 127 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/07/1990 12:00:00 AM | Permit Number 28524 | 6004220.92651357 | 2094058.36358609 | 37.7301245583022 | -122.42770689303 | (37.7301245583022, -122.42770689303) | 9 | 7 | 6 | 28861 | 5 | ||
| 57376 | 31133 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 212 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 12 | Permit Number 34848 | 5997464.63581 | 2094208.87257 | 37.7301533239181 | -122.451074988218 | (37.7301533239181, -122.451074988218) | 9 | 7 | 4 | 28861 | 40 | |
| 22866 | 207815 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 225 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 5997426.46465 | 2094243.22962 | 37.7302454747445 | -122.451209426987 | (37.7302454747445, -122.451209426987) | 9 | 7 | 4 | 28861 | 40 | |||
| 10026 | 207816 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 236 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5997465.81636 | 2094312.11288 | 37.7304368648498 | -122.451078348996 | (37.7304368648498, -122.451078348996) | 9 | 7 | 4 | 28861 | 40 | |||
| 21324 | 173925 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997414 | 2094357 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | 9 | 7 | 4 | 28861 | 40 | ||||
| 77227 | 173926 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5997414 | 2094357 | 37.7305571474498 | -122.451260720639 | (37.7305571474498, -122.451260720639) | 9 | 7 | 4 | 28861 | 40 | ||||
| 129294 | 207812 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 635 Hearst Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5997216.39115 | 2094387.61086 | 37.7306298809467 | -122.451946087746 | (37.7306298809467, -122.451946087746) | 9 | 7 | 4 | 28861 | 40 | |||
| 34022 | 200058 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 0ft | 6014865.9446 | 2094065.6668 | 37.7307410182438 | -122.390905909596 | (37.7307410182438, -122.390905909596) | 10 | 3 | 8 | 58 | 1 | |||
| 189764 | 200059 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1801 Lane St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6014873.6392 | 2094076.1095 | 37.7307701187384 | -122.390880037484 | (37.7307701187384, -122.390880037484) | 10 | 3 | 8 | 58 | 1 | |||
| 89908 | 67501 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 394 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/18/1993 12:00:00 AM | Permit Number 31030 | 5998815.69417134 | 2094405.78441062 | 37.7307712562319 | -122.446418383601 | (37.7307712562319, -122.446418383601) | 9 | 7 | 4 | 59 | 40 |
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) );