trees
2,180 rows where qSpecies_id = 57 sorted by Fire Prevention Districts descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | ||||
| 77605 | 207813 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 410 Hearst Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5998661.39505 | 2094413.54813 | 37.7307837594656 | -122.446952376359 | (37.7307837594656, -122.446952376359) | 9 | 7 | 4 | 59 | 40 | |||
| 77857 | 207969 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 195 Los Palmos Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998222.89517 | 2096278.92785 | 37.735880587118 | -122.448602629628 | (37.735880587118, -122.448602629628) | 9 | 7 | 4 | 59 | 40 | |||
| 78388 | 177061 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5999007.90612 | 2090532.0864 | 37.7201459577571 | -122.44547544316 | (37.7201459577571, -122.44547544316) | 9 | 7 | 6 | 28861 | 25 | |||
| 78639 | 177046 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 317 Otsego Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6000299.83904 | 2091602.15468 | 37.7231577908794 | -122.441086408025 | (37.7231577908794, -122.441086408025) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 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 | |||
| 80257 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 80623 | 177063 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 5999015.35979 | 2090528.72065 | 37.7201371416945 | -122.445449436536 | (37.7201371416945, -122.445449436536) | 9 | 7 | 6 | 28861 | 25 | |||
| 80889 | 1130 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2554 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 5998598.10038 | 2088668.31183 | 37.7150050570134 | -122.446757963627 | (37.7150050570134, -122.446757963627) | 9 | 7 | 6 | 28861 | 25 | |||
| 81473 | 207835 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1209 Capitol Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5995030.31814 | 2091918.85126 | 37.7237258071947 | -122.459324908222 | (37.7237258071947, -122.459324908222) | 9 | 8 | 4 | 28861 | 24 | |||
| 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 | |||
| 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 | |||
| 82396 | 207854 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 258 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5992483.5365 | 2089596.1759 | 37.7172015521901 | -122.467959759631 | (37.7172015521901, -122.467959759631) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | ||
| 82670 | 207406 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 225 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5992144.25287 | 2095230.06817 | 37.7326512322553 | -122.469542382075 | (37.7326512322553, -122.469542382075) | 9 | 8 | 4 | 59 | 40 | |||
| 82930 | 30910 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 500 Faxon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/13/1995 12:00:00 AM | 11 | Permit Number 34732 | 5994801.3845 | 2091947.29043 | 37.723790729247 | -122.460118346809 | (37.723790729247, -122.460118346809) | 9 | 8 | 4 | 28861 | 24 | ||
| 85313 | 25293 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 144 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6000659.82425 | 2091738.03378 | 37.7235513818789 | -122.43985175037 | (37.7235513818789, -122.43985175037) | 9 | 7 | 6 | 28861 | 25 | |||
| 85430 | 177051 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998951.86154 | 2090168.3011 | 37.7191438872553 | -122.445643022832 | (37.7191438872553, -122.445643022832) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 85895 | 207998 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999486.80728 | 2094946.96177 | 37.7322955108311 | -122.444137119754 | (37.7322955108311, -122.444137119754) | 9 | 7 | 4 | 63 | 40 | |||
| 86241 | 68860 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 388 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/28/1993 12:00:00 AM | Permit Number 32823 | 5998853.5547129 | 2094405.18527642 | 37.7307717735093 | -122.446287451153 | (37.7307717735093, -122.446287451153) | 9 | 7 | 4 | 59 | 40 | ||
| 86744 | 207834 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 112 Marston Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5998700.55085 | 2093216.8077 | 37.7275000279916 | -122.446730933593 | (37.7275000279916, -122.446730933593) | 9 | 7 | 4 | 28861 | 40 | |||
| 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 | |||
| 86839 | 62794 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23151 | 6000307.76766309 | 2093181.82122993 | 37.727495644326 | -122.441172281845 | (37.727495644326, -122.441172281845) | 9 | 7 | 6 | 28861 | 25 | ||
| 88097 | 31105 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 Edna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 3 | Permit Number 34835 | 5998736.13021 | 2093248.30764 | 37.7275885518652 | -122.446610201415 | (37.7275885518652, -122.446610201415) | 9 | 7 | 4 | 28861 | 40 | |
| 88222 | 62786 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 154 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23142 | 6000618.91780925 | 2091744.38237049 | 37.723566485054 | -122.439993611308 | (37.723566485054, -122.439993611308) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 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 | ||
| 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 | ||
| 91996 | 207413 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 916 Rockdale Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 5996523.58257 | 2098185.78837 | 37.741019048902 | -122.454615507597 | (37.741019048902, -122.454615507597) | 9 | 7 | 4 | 59 | 40 | |||
| 92548 | 122410 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 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 | ||||
| 93095 | 177141 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 355 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6003671.36983 | 2091507.33706 | 37.7230889064227 | -122.429424930532 | (37.7230889064227, -122.429424930532) | 9 | 7 | 6 | 28861 | 5 | |||
| 93440 | 177117 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 226 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6004541.32921 | 2091944.569 | 37.7243386654761 | -122.426448769894 | (37.7243386654761, -122.426448769894) | 9 | 7 | 6 | 28861 | 5 | ||||
| 94055 | 177048 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2134 San Jose Ave | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998741.12463 | 2090893.49817 | 37.7211230774582 | -122.446423600184 | (37.7211230774582, -122.446423600184) | 9 | 7 | 6 | 28861 | 25 | |||
| 96139 | 207837 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 506 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 1ft | 5994801.27267 | 2091957.06598 | 37.7238175641248 | -122.460119441258 | (37.7238175641248, -122.460119441258) | 9 | 8 | 4 | 28861 | 24 | |||
| 96212 | 177050 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2134 San Jose Ave | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5998727.35732 | 2090872.12433 | 37.7210636034854 | -122.446469652679 | (37.7210636034854, -122.446469652679) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 97197 | 52416 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 734 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/21/2005 12:00:00 AM | Permit Number 48535 | 6001832.35713287 | 2089688.63788093 | 37.717990874718 | -122.435651969168 | (37.717990874718, -122.435651969168) | 9 | 7 | 6 | 28861 | 5 | ||
| 97403 | 207924 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 Monterey Blvd | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993576.36868 | 2095065.49282 | 37.7322820128957 | -122.464579299802 | (37.7322820128957, -122.464579299802) | 9 | 8 | 4 | 59 | 40 | |||
| 100014 | 25292 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000743.11246 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | ||
| 100754 | 177057 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998963.19339 | 2090191.18353 | 37.7192073641203 | -122.445605497718 | (37.7192073641203, -122.445605497718) | 9 | 7 | 6 | 28861 | 25 | |||
| 100886 | 177120 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 163 Vienna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 2ft | 6004577.78198 | 2092457.96973 | 37.7257504113309 | -122.42635929454 | (37.7257504113309, -122.42635929454) | 9 | 7 | 6 | 28861 | 5 | |||
| 101089 | 207976 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 791 Myra Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5997064.21874 | 2098028.7436 | 37.7406188361825 | -122.45273486333 | (37.7406188361825, -122.45273486333) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | |||
| 101652 | 207842 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 193 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995618.10907 | 2091172.31825 | 37.7217097825699 | -122.457239048551 | (37.7217097825699, -122.457239048551) | 9 | 8 | 6 | 28861 | 24 | |||
| 102355 | 96885 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 10 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
| 102801 | 122418 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 499x Ocean Ave | 15 | Sidewalk: Curb side : Cutout | Tree | MTA 3 | 3x3 | 5998874 | 2091543 | 37.7229140478676 | -122.446010982458 | (37.7229140478676, -122.446010982458) | 9 | 7 | 6 | 28861 | 25 | ||||
| 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 |
| 104597 | 177060 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5999004.71102 | 2090533.49079 | 37.7201496314864 | -122.445486588437 | (37.7201496314864, -122.445486588437) | 9 | 7 | 6 | 28861 | 25 | |||
| 105160 | 177045 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 21 Wanda St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 2ft | 6000634.57339 | 2091639.69962 | 37.7232799412972 | -122.439931990591 | (37.7232799412972, -122.439931990591) | 9 | 7 | 6 | 28861 | 25 | |||
| 106232 | 62791 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23147 | 5999722.02733953 | 2091630.11110927 | 37.7232016241068 | -122.443085790223 | (37.7232016241068, -122.443085790223) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 107428 | 207918 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 Monterey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993549.31722 | 2095096.55206 | 37.7323657343817 | -122.464675076695 | (37.7323657343817, -122.464675076695) | 9 | 8 | 4 | 59 | 40 | |||
| 107472 | 177070 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 195 Allison St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6000082.94652 | 2087742.95013 | 37.7125489329732 | -122.441559353395 | (37.7125489329732, -122.441559353395) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 110031 | 177059 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999000.98419 | 2090535.17383 | 37.7201540399677 | -122.445499591747 | (37.7201540399677, -122.445499591747) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 |
| 110484 | 207859 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 88 Ralston St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 5992207.50569 | 2088392.37957 | 37.713880274943 | -122.468826309486 | (37.713880274943, -122.468826309486) | 9 | 8 | 6 | 64 | 24 | |||
| 110964 | 177062 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 550 Geneva Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999011.63296 | 2090530.40369 | 37.7201415501799 | -122.445462439842 | (37.7201415501799, -122.445462439842) | 9 | 7 | 6 | 28861 | 25 | |||
| 111106 | 31106 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 101 Edna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | 18 | Permit Number 34835 | 5998729.12577 | 2093250.24462 | 37.7275934702536 | -122.446634555042 | (37.7275934702536, -122.446634555042) | 9 | 7 | 4 | 28861 | 40 | |
| 111818 | 207843 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995613.80856 | 2091011.1988 | 37.7212671398548 | -122.457242264538 | (37.7212671398548, -122.457242264538) | 9 | 8 | 6 | 28861 | 24 | |||
| 113480 | 177144 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 224 Naylor St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6002612.15992 | 2086733.11082 | 37.7099199079537 | -122.43274552071 | (37.7099199079537, -122.43274552071) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||
| 114572 | 62790 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 199 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23146 | 6000313.64252899 | 2091641.02456839 | 37.7232653049393 | -122.441041479459 | (37.7232653049393, -122.441041479459) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 115045 | 207857 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993273.27728 | 2090450.48631 | 37.7195928567171 | -122.465292042207 | (37.7195928567171, -122.465292042207) | 9 | 8 | 6 | 64 | 24 | |||
| 115523 | 62784 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 137 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23140 | 6000712.17881294 | 2091681.24596218 | 37.7233984355119 | -122.439666701145 | (37.7233984355119, -122.439666701145) | 9 | 7 | 6 | 28861 | 25 | ||
| 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 | |||
| 116381 | 207407 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 235 San Fernando Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5992143.68881 | 2095203.27021 | 37.7325776191621 | -122.469542382078 | (37.7325776191621, -122.469542382078) | 9 | 8 | 4 | 59 | 40 | |||
| 116469 | 227247 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 203 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003955.64595 | 2095256.72933 | 37.7333999916083 | -122.428709395715 | (37.7333999916083, -122.428709395715) | 9 | 7 | 5 | 28861 | 25 | |||
| 118018 | 207989 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 843 Detroit St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 5999418.49849 | 2095586.86925 | 37.7340486492241 | -122.444419249659 | (37.7340486492241, -122.444419249659) | 9 | 7 | 4 | 59 | 40 | |||
| 118121 | 62788 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 190 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23144 | 6000370.84981794 | 2091713.58104778 | 37.7234677867045 | -122.440848927652 | (37.7234677867045, -122.440848927652) | 9 | 7 | 6 | 28861 | 25 | ||
| 118234 | 19325 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 212 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X4 | 5993418.38204 | 2089852.67557 | 37.717959779598 | -122.464747082736 | (37.717959779598, -122.464747082736) | 9 | 8 | 6 | 64 | 24 | |||
| 118950 | 207983 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 620 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999460.54725 | 2095077.27531 | 37.7326518231051 | -122.444237267358 | (37.7326518231051, -122.444237267358) | 9 | 7 | 4 | 63 | 40 | |||
| 119662 | 207980 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 341 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 6ft | 5999148.95483 | 2095220.44107 | 37.733027140778 | -122.445324804895 | (37.733027140778, -122.445324804895) | 9 | 7 | 4 | 59 | 40 | |||
| 119782 | 207860 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 88 Ralston St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 5992206.43527 | 2088409.02561 | 37.7139259191081 | -122.468831219804 | (37.7139259191081, -122.468831219804) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 119912 | 177100 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 377 Delano Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5999723.90595 | 2091657.94251 | 37.7232781498534 | -122.443081294068 | (37.7232781498534, -122.443081294068) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 |
| 121327 | 207994 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999470.93523 | 2094944.41877 | 37.7322876228558 | -122.444191810206 | (37.7322876228558, -122.444191810206) | 9 | 7 | 4 | 63 | 40 | |||
| 121893 | 177101 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 130 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6000792.03134 | 2091751.28395 | 37.7235952885821 | -122.439395684376 | (37.7235952885821, -122.439395684376) | 9 | 7 | 6 | 28861 | 25 | |||
| 122026 | 177089 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 545 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009804.5393 | 2089523.18108 | 37.7179861612047 | -122.408083826812 | (37.7179861612047, -122.408083826812) | 9 | 7 | 8 | 309 | 39 | |||
| 122227 | 67018 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 400 Grafton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/20/1992 12:00:00 AM | Permit Number 30374 | 5995620.26197767 | 2090586.55623665 | 37.7201015427641 | -122.457189254526 | (37.7201015427641, -122.457189254526) | 9 | 8 | 6 | 28861 | 24 | ||
| 122398 | 177054 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998957.42918 | 2090181.03368 | 37.71917916587 | -122.44562469283 | (37.71917916587, -122.44562469283) | 9 | 7 | 6 | 28861 | 25 | |||
| 123233 | 62782 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 131 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23138 | 6000753.3579224 | 2091686.36985433 | 37.7234148482869 | -122.439524720053 | (37.7234148482869, -122.439524720053) | 9 | 7 | 6 | 28861 | 25 | ||
| 123526 | 207938 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 168 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 3ft | 5994463.39444 | 2096391.82051 | 37.7359748783422 | -122.461608798622 | (37.7359748783422, -122.461608798622) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 126041 | 177102 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 130 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000764.64112 | 2091750.39808 | 37.7235912973767 | -122.439490303855 | (37.7235912973767, -122.439490303855) | 9 | 7 | 6 | 28861 | 25 | |||
| 127210 | 207923 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1475 Monterey Blvd | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993572.45221 | 2095069.9309 | 37.7322939729878 | -122.464593161969 | (37.7322939729878, -122.464593161969) | 9 | 8 | 4 | 59 | 40 | |||
| 127448 | 207836 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 100 De Montfort Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5995005.14377 | 2091917.04933 | 37.7237194121086 | -122.459411800719 | (37.7237194121086, -122.459411800719) | 9 | 8 | 4 | 28861 | 24 | |||
| 128627 | 177118 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 224 Avalon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 2ft | 6003359.98068 | 2092814.59927 | 37.726660722214 | -122.430594576183 | (37.726660722214, -122.430594576183) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||||
| 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 | |||
| 129312 | 77648 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.14742 | 2093142.98247 | 37.7277576387802 | -122.418666516263 | (37.7277576387802, -122.418666516263) | 9 | 3 | 7 | 309 | 5 |
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) );