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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1121 | 77643 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006923.44086 | 2093174.37286 | 37.7278498138936 | -122.418301281799 | (37.7278498138936, -122.418301281799) | 9 | 3 | 7 | 309 | 5 | ||
| 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 | |
| 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 | |
| 3789 | 77644 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | 9 | 3 | 7 | 309 | 5 | ||
| 7775 | 77645 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 10 | 4x4 | 6006883.85072 | 2093162.97754 | 37.7278162961767 | -122.418437338432 | (37.7278162961767, -122.418437338432) | 9 | 3 | 7 | 309 | 5 | ||
| 8136 | 208000 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 5999487.48138 | 2094942.52217 | 37.7322833591869 | -122.444134470345 | (37.7322833591869, -122.444134470345) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | |||
| 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 | ||
| 9319 | 77642 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 12 | 4x4 | 6006942.10409 | 2093179.93326 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | 9 | 3 | 7 | 309 | 5 | ||
| 9829 | 207861 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 70 Ralston St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 5992207.07547 | 2088343.8619 | 37.7137470322778 | -122.468824268047 | (37.7137470322778, -122.468824268047) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |
| 14950 | 177116 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 280 Vienna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6004076.34637 | 2091739.89789 | 37.7237503874544 | -122.428041571781 | (37.7237503874544, -122.428041571781) | 9 | 7 | 6 | 28861 | 5 | |||
| 14971 | 26336 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2564 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5997739.39873 | 2089429.54745 | 37.7170461430363 | -122.449780813452 | (37.7170461430363, -122.449780813452) | 9 | 8 | 6 | 28861 | 24 | |||
| 15507 | 207853 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 258 Vernon St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5992483.11623 | 2089580.88214 | 37.7171595349616 | -122.467960100499 | (37.7171595349616, -122.467960100499) | 9 | 8 | 6 | 64 | 24 | |||
| 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 | |||
| 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 | |
| 17218 | 77646 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1300X Silliman St | 7 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 5 | 3x3 | 6006863.07514 | 2093156.65739 | 37.7277977728371 | -122.418508712231 | (37.7277977728371, -122.418508712231) | 9 | 3 | 7 | 309 | 5 | ||
| 18528 | 66992 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 173 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/12/1992 12:00:00 AM | Permit Number 30345 | 5995611.62082258 | 2091036.47990525 | 37.7213364301148 | -122.457251654811 | (37.7213364301148, -122.457251654811) | 9 | 8 | 6 | 28861 | 24 | ||
| 18794 | 177112 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 5998995.97899 | 2091518.17463 | 37.7228528478523 | -122.445587543638 | (37.7228528478523, -122.445587543638) | 9 | 7 | 6 | 28861 | 25 | |||
| 19806 | 117422 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 50 VERNON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5992487 | 2088224 | 37.7134340885283 | -122.467848042178 | (37.7134340885283, -122.467848042178) | 9 | 8 | 6 | 64 | 24 | ||||
| 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 | ||
| 21095 | 207966 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 735 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998008.19389 | 2095778.93089 | 37.7344954360226 | -122.449308921174 | (37.7344954360226, -122.449308921174) | 9 | 7 | 4 | 59 | 40 | |||
| 21215 | 208004 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 551 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998446.15319 | 2094958.35436 | 37.7322673692323 | -122.447735703852 | (37.7322673692323, -122.447735703852) | 9 | 7 | 4 | 59 | 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 | ||||
| 21412 | 207412 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 916 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5996538.53232 | 2098198.85248 | 37.7410557771982 | -122.454564760665 | (37.7410557771982, -122.454564760665) | 9 | 7 | 4 | 59 | 40 | |||
| 21748 | 207991 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 378 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5999591.13062 | 2094983.54982 | 37.7324019240113 | -122.443779078947 | (37.7324019240113, -122.443779078947) | 9 | 7 | 4 | 63 | 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 | |||
| 28511 | 207965 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 735 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998007.7209 | 2095786.05635 | 37.7345149737803 | -122.449311069653 | (37.7345149737803, -122.449311069653) | 9 | 7 | 4 | 59 | 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 | |||
| 31714 | 67465 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 937 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/01/1992 12:00:00 AM | 9 | Permit Number 30978 | 6008961.1272 | 2090382.77007 | 37.7202991536555 | -122.41105982826 | (37.7202991536555, -122.41105982826) | 9 | 3 | 7 | 309 | 28 | ||
| 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 | |
| 32430 | 207985 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 394 Mangels Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5998813.60918 | 2095274.4257 | 37.733156221377 | -122.446488060895 | (37.733156221377, -122.446488060895) | 9 | 7 | 4 | 59 | 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 | |||
| 33376 | 67278 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 58 Ina Ct | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1992 12:00:00 AM | 3 | Permit Number 30752 | 6004928.68664 | 2091573.73243 | 37.7233423191649 | -122.42508335531 | (37.7233423191649, -122.42508335531) | 9 | 7 | 6 | 28861 | 5 | |
| 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 | |||
| 36519 | 177044 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 87 Seneca Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 6000253.62595 | 2089858.96532 | 37.7183687570946 | -122.44112115244 | (37.7183687570946, -122.44112115244) | 9 | 7 | 6 | 28861 | 25 | |||
| 36628 | 177109 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 16 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998958.08532 | 2091518.52367 | 37.7228516427597 | -122.445718558684 | (37.7228516427597, -122.445718558684) | 9 | 7 | 6 | 28861 | 25 | |||
| 37244 | 177142 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 417 Rolph St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 6ft | 6002087.33741 | 2087757.61933 | 37.7127032044557 | -122.434632613123 | (37.7127032044557, -122.434632613123) | 9 | 7 | 6 | 28861 | 5 | |||
| 38760 | 207973 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 1 Cresta Vista Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995100.87909 | 2096206.06428 | 37.7355015111722 | -122.459391325848 | (37.7355015111722, -122.459391325848) | 9 | 7 | 4 | 59 | 40 | |||
| 38774 | 208003 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 5999487.18878 | 2094935.81354 | 37.7322649221692 | -122.444135000042 | (37.7322649221692, -122.444135000042) | 9 | 7 | 4 | 63 | 40 | |||
| 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 | |||
| 40533 | 177043 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 87 Seneca Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6000241.05575 | 2089872.3479 | 37.7184047866172 | -122.441165561868 | (37.7184047866172, -122.441165561868) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | ||||
| 41356 | 207975 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 538 Teresita Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5998933.25341 | 2097323.81684 | 37.7387901961225 | -122.44622178873 | (37.7387901961225, -122.44622178873) | 9 | 7 | 4 | 59 | 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 | ||
| 43775 | 177066 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 573 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6002664.89947 | 2090416.35383 | 37.7200362746301 | -122.432826194382 | (37.7200362746301, -122.432826194382) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | ||
| 44319 | 96882 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
| 44660 | 177090 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 36 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 5993074.95832 | 2086622.9468 | 37.7090719120225 | -122.46569961766 | (37.7090719120225, -122.46569961766) | 9 | 8 | 6 | 28861 | 25 | |||
| 46501 | 207936 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 145 Ridgewood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 3ft | 5996773.84945 | 2094603.00797 | 37.731195952028 | -122.453491559201 | (37.731195952028, -122.453491559201) | 9 | 7 | 4 | 28861 | 40 | |||
| 46904 | 208006 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 551 Joost Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998446.5912 | 2094951.62857 | 37.7322489268386 | -122.447733705547 | (37.7322489268386, -122.447733705547) | 9 | 7 | 4 | 59 | 40 | |||
| 47041 | 177110 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 17 | Sidewalk: Property side : Yard | Tree | MTA 3 | 6 | Width 5ft | 5998978.57855 | 2091518.53644 | 37.722852847868 | -122.445647719081 | (37.722852847868, -122.445647719081) | 9 | 7 | 6 | 28861 | 25 | |||
| 48518 | 96883 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 8 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
| 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 | |||
| 48667 | 207846 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 160 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5995656.91883 | 2090949.83096 | 37.7211011142092 | -122.457088808724 | (37.7211011142092, -122.457088808724) | 9 | 8 | 6 | 28861 | 24 | |||
| 49213 | 207982 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 620 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999457.28605 | 2095077.61427 | 37.7326525677521 | -122.444248566437 | (37.7326525677521, -122.444248566437) | 9 | 7 | 4 | 63 | 40 | |||
| 49633 | 177105 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 12 | Sidewalk: Property side : Yard | Tree | MTA 3 | 4 | Width 5ft | 5998924.5969 | 2091518.78116 | 37.7228504376811 | -122.445834339179 | (37.7228504376811, -122.445834339179) | 9 | 7 | 6 | 28861 | 25 | |||
| 49882 | 62789 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 196 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/24/1986 12:00:00 AM | Permit Number 23145 | 6000321.17614419 | 2091703.51030925 | 37.7234373055999 | -122.441019917909 | (37.7234373055999, -122.441019917909) | 9 | 7 | 6 | 28861 | 25 | ||
| 50331 | 177143 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 224 Naylor St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | Width 3ft | 6002598.76646 | 2086748.83961 | 37.7099623361716 | -122.432792933869 | (37.7099623361716, -122.432792933869) | 9 | 7 | 6 | 28861 | 5 | |||
| 50578 | 177099 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 377 Delano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5999714.66231 | 2091641.03543 | 37.7232311998395 | -122.443112033811 | (37.7232311998395, -122.443112033811) | 9 | 7 | 6 | 28861 | 25 | |||
| 50603 | 25289 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6000745.99488 | 2091748.78566 | 37.7235858088167 | -122.439554644937 | (37.7235858088167, -122.439554644937) | 9 | 7 | 6 | 28861 | 25 | |||
| 50736 | 25291 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 136 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000743.11246 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | 9 | 7 | 6 | 28861 | 25 | |||
| 50969 | 177047 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2134 San Jose Ave | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998747.58389 | 2090903.38197 | 37.721150585016 | -122.446401983167 | (37.721150585016, -122.446401983167) | 9 | 7 | 6 | 28861 | 25 | |||
| 51222 | 207848 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 833 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5995895.43899 | 2089793.88094 | 37.7179408434817 | -122.456180784842 | (37.7179408434817, -122.456180784842) | 9 | 8 | 6 | 28861 | 24 | |||
| 51228 | 177056 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 765 Delano Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998961.55007 | 2090188.45269 | 37.71919977204 | -122.445610981758 | (37.71919977204, -122.445610981758) | 9 | 7 | 6 | 28861 | 25 | |||
| 51438 | 207963 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 41 Stanford Heights Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 3ft | 5997821.41118 | 2095826.65809 | 37.7346157976753 | -122.449958126471 | (37.7346157976753, -122.449958126471) | 9 | 7 | 4 | 59 | 40 | |||
| 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 | ||
| 52506 | 207862 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 Vernon St | 2 | : | Tree | Private 2 | 13 | Width 3ft | 5992461.4298 | 2088225.86047 | 37.7134377203567 | -122.467936556254 | (37.7134377203567, -122.467936556254) | 9 | 8 | 6 | 64 | 24 | |||
| 53967 | 207811 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 454 Lansdale Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5996252.99114 | 2096374.29594 | 37.7360296092868 | -122.455420217376 | (37.7360296092868, -122.455420217376) | 9 | 7 | 4 | 59 | 40 | |||
| 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 |
| 57313 | 44826 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 129 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/20/2001 12:00:00 AM | Permit Number 43918 | 6010308.29040288 | 2087358.77915196 | 37.7120713475932 | -122.406190163796 | (37.7120713475932, -122.406190163796) | 9 | 7 | 8 | 309 | 39 | |||
| 57339 | 177108 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 15 | Sidewalk: Property side : Yard | Tree | MTA 3 | 5 | Width 5ft | 5998950.80755 | 2091518.23612 | 37.7228504376851 | -122.44574369564 | (37.7228504376851, -122.44574369564) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |
| 57591 | 207856 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 494 Victoria St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993273.29613 | 2090436.09778 | 37.7195533503791 | -122.465290932448 | (37.7195533503791, -122.465290932448) | 9 | 8 | 6 | 64 | 24 | |||
| 59332 | 177098 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 16 Paulding St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000285.11463 | 2093206.10275 | 37.727561025398 | -122.441252334748 | (37.727561025398, -122.441252334748) | 9 | 7 | 6 | 28861 | 25 | |||
| 59760 | 207984 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 394 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5998812.93096 | 2095267.10672 | 37.7331360864487 | -122.446489879305 | (37.7331360864487, -122.446489879305) | 9 | 7 | 4 | 59 | 40 | |||
| 61147 | 177040 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 50 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5999261.05656 | 2089438.38497 | 37.7171573523208 | -122.444521826318 | (37.7171573523208, -122.444521826318) | 9 | 7 | 6 | 28861 | 25 | |||
| 61804 | 177049 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2134 San Jose Ave | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998733.2334 | 2090880.12484 | 37.7210859066631 | -122.446449916153 | (37.7210859066631, -122.446449916153) | 9 | 7 | 6 | 28861 | 25 | |||
| 62230 | 25304 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 292 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x9 | 5999755.51283 | 2091622.1717 | 37.7231817335313 | -122.442969467865 | (37.7231817335313, -122.442969467865) | 9 | 7 | 6 | 28861 | 25 | |||
| 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 | |||
| 63232 | 207993 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5999470.98074 | 2094940.54969 | 37.7322770018656 | -122.444191374942 | (37.7322770018656, -122.444191374942) | 9 | 7 | 4 | 63 | 40 | |||
| 63630 | 208002 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 395 Joost Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999487.23949 | 2094938.25423 | 37.7322716266247 | -122.444135000043 | (37.7322716266247, -122.444135000043) | 9 | 7 | 4 | 63 | 40 | |||
| 63651 | 177111 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 401 Ocean Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 5998987.39789 | 2091518.79195 | 37.7228540529596 | -122.445617250956 | (37.7228540529596, -122.445617250956) | 9 | 7 | 6 | 28861 | 25 | |||
| 63976 | 208005 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 551 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5998445.88865 | 2094954.90573 | 37.7322578849907 | -122.447736370247 | (37.7322578849907, -122.447736370247) | 9 | 7 | 4 | 59 | 40 | |||
| 64201 | 207967 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 735 Foerster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5998008.97089 | 2095771.4899 | 37.7344750492842 | -122.449305698913 | (37.7344750492842, -122.449305698913) | 9 | 7 | 4 | 59 | 40 | |||
| 66691 | 1139 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 2627 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | 5998352.02606 | 2088442.52333 | 37.7143710331717 | -122.447592253902 | (37.7143710331717, -122.447592253902) | 9 | 7 | 6 | 28861 | 25 | |||
| 67498 | 207978 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 155 Burnside Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 6001108.30575 | 2095400.37488 | 37.7336328494621 | -122.438563716151 | (37.7336328494621, -122.438563716151) | 9 | 7 | 5 | 63 | 40 | |||
| 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 | |
| 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 | |||
| 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 | |||
| 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 | ||
| 71630 | 207971 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 204 Cresta Vista Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5996300.11007 | 2096185.08811 | 37.7355127940891 | -122.455243639995 | (37.7355127940891, -122.455243639995) | 9 | 7 | 4 | 59 | 40 | |||
| 72943 | 96884 | Permitted Site 7 | Ligustrum lucidum :: Glossy Privet 57 | 2200X San Jose Ave | 9 | Sidewalk: Property side : Cutout | Tree | Private 2 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | 9 | 7 | 6 | 28861 | 25 | |||||
| 74029 | 177088 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 300x Winding Way | 5 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6001504.62112 | 2086478.58914 | 37.7091581713864 | -122.436555171203 | (37.7091581713864, -122.436555171203) | 9 | 7 | 6 | 28861 | 5 | |||
| 76280 | 177065 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 626 Madrid St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002192.98275 | 2090253.20784 | 37.7195615351173 | -122.434445788846 | (37.7195615351173, -122.434445788846) | 9 | 7 | 6 | 28861 | 5 | |||
| 76695 | 207840 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 314 Faxon Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5994777.11096 | 2090681.20811 | 37.7203129744533 | -122.460110575752 | (37.7203129744533, -122.460110575752) | 9 | 8 | 6 | 28861 | 24 | |||
| 76842 | 177125 | DPW Maintained 1 | Ligustrum lucidum :: Glossy Privet 57 | 418 Amherst St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007739.52277 | 2091837.25861 | 37.724224288797 | -122.41538544049 | (37.724224288797, -122.41538544049) | 9 | 3 | 7 | 309 | 28 |
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) );