trees
548 rows where qCaretaker_id = 1 and qSpecies_id = 53 sorted by DBH
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 371 | 251215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 175X Otis St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3X3 | 6006718.5849914 | 2108715.6870946 | 37.7705111956623 | -122.420111956743 | (37.7705111956623, -122.420111956743) | 8 | 2 | 9 | 28853 | 19 | ||||
| 1142 | 260393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 3630 | 258965 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 5064 | 258966 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 6270 | 258961 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 7085 | 260395 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 9194 | 260391 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 9626 | 258963 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 9664 | 258964 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 10154 | 258967 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 10644 | 260392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 11514 | 258968 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 13855 | 260394 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 550 Octavia St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6005467 | 2111269 | 37.7774513766157 | -122.424622861078 | (37.7774513766157, -122.424622861078) | 7 | 9 | 11 | 28852 | 10 | ||||
| 14920 | 255508 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | ||||
| 17682 | 258962 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 18544 | 258969 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 398x Bryant St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014405 | 2113268 | 37.7834409032593 | -122.393843088876 | (37.7834409032593, -122.393843088876) | 6 | 2 | 9 | 28856 | 6 | ||||
| 20262 | 253597 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 269 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010453 | 2107072 | 37.7662077096315 | -122.407078650031 | (37.7662077096315, -122.407078650031) | 8 | 4 | 8 | 28853 | 19 | ||||
| 35407 | 94294 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
| 35445 | 253642 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010361.39347 | 2118971.94152 | 37.7988770104459 | -122.408234880635 | (37.7988770104459, -122.408234880635) | 3 | 1 | 10 | 308 | 4 | ||||
| 41708 | 251371 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
| 50094 | 253202 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800 Oak St | 4 | Sidewalk: Property side : Cutout | Tree | DPW 1 | Private | 6x6 | 6003064 | 2109976 | 37.77376511482 | -122.432843231253 | (37.77376511482, -122.432843231253) | 15 | 5 | 11 | 29492 | 10 | |||
| 65259 | 105658 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
| 66280 | 94296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
| 86887 | 94302 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
| 99392 | 94300 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6x6 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | |||
| 121115 | 94298 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
| 134290 | 94304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1150X Fillmore St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Rec/Park | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | 15 | 9 | 11 | 29490 | 41 | ||||
| 151939 | 257912 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
| 161897 | 253634 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830 Oak St | 1 | Sidewalk: Property side : Cutout | tree | DPW 1 | 6003018.63904 | 2109969.70237 | 37.7737452502421 | -122.432999691851 | (37.7737452502421, -122.432999691851) | 15 | 5 | 11 | 29492 | 10 | |||||
| 177482 | 255340 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1881 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6003626.50122 | 2114526.01983 | 37.7862902235864 | -122.431222292272 | (37.7862902235864, -122.431222292272) | 13 | 9 | 11 | 29490 | 13 | |||||
| 179087 | 105657 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 901X Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6007813.03508 | 2120272.88823 | 37.8023060594642 | -122.417145293832 | (37.8023060594642, -122.417145293832) | 5 | 1 | 1 | 308 | 32 | ||||
| 184329 | 173906 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2510 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6005854.79213 | 2118988.36383 | 37.7986687249765 | -122.423830387644 | (37.7986687249765, -122.423830387644) | 13 | 9 | 1 | 28858 | 32 | |||||
| 186181 | 251369 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390 06th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Private | 3x3 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
| 193319 | 257913 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 690X Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6010415 | 2118850 | 37.7985451903817 | -122.408040779349 | (37.7985451903817, -122.408040779349) | 3 | 1 | 10 | 308 | 4 | ||||
| 193625 | 255507 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | ||||
| 145725 | 112106 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
| 7742 | 21626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004833.69671 | 2114745.44523 | 37.7869610478907 | -122.427061339905 | (37.7869610478907, -122.427061339905) | 13 | 9 | 11 | 28858 | 27 | |||
| 11809 | 7237 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1065 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003359.4574 | 2111944.18191 | 37.7791860077197 | -122.431961766737 | (37.7791860077197, -122.431961766737) | 15 | 9 | 11 | 29490 | 41 | |||
| 19799 | 661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3290X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007123.820387 | 2102082.126741 | 37.7523198047665 | -122.418239853186 | (37.7523198047665, -122.418239853186) | 2 | 4 | 7 | 28859 | 19 | |||
| 20638 | 21644 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1657 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004676.7022509 | 2114666.9735246 | 37.7867367053745 | -122.427598912468 | (37.7867367053745, -122.427598912468) | 13 | 9 | 11 | 28858 | 13 | |||
| 24683 | 16945 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 602 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004026.09211 | 2110141.24132 | 37.7742733469863 | -122.429526989132 | (37.7742733469863, -122.429526989132) | 7 | 9 | 11 | 29492 | 10 | |||
| 25241 | 8179 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1205X Fulton St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002000.37874 | 2111170.93633 | 37.7769857283744 | -122.436608008152 | (37.7769857283744, -122.436608008152) | 15 | 5 | 11 | 29492 | 10 | |||
| 26003 | 20242 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
| 27252 | 17296 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 5X Otis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6007104.29527 | 2109558.64203 | 37.7728474744005 | -122.418837572 | (37.7728474744005, -122.418837572) | 8 | 2 | 9 | 28853 | 19 | |||
| 28409 | 23540 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2750 Van Ness Ave | 15 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6005743.06666 | 2119831.60651 | 37.8009777467475 | -122.424276999326 | (37.8009777467475, -122.424276999326) | 13 | 9 | 1 | 28858 | 32 | |||
| 35689 | 7151 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
| 37162 | 18698 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 5 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
| 39117 | 14994 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1459X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016235.7427248 | 2097702.9858463 | 37.7408042749191 | -122.38642376985 | (37.7408042749191, -122.38642376985) | 10 | 3 | 8 | 58 | 1 | |||
| 40345 | 17320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
| 40407 | 668 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | |||
| 40606 | 18940 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2770 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001564.88968 | 2115697.48907 | 37.7893897308811 | -122.438438883241 | (37.7893897308811, -122.438438883241) | 13 | 6 | 1 | 29490 | 27 | |||
| 41806 | 6719 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 43589 | 15250 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007716.15968 | 2110227.06056 | 37.7747172257492 | -122.416768419302 | (37.7747172257492, -122.416768419302) | 8 | 2 | 9 | 28853 | 34 | |||
| 43740 | 9577 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6003415.08005 | 2112113.96459 | 37.7796553418115 | -122.431781470984 | (37.7796553418115, -122.431781470984) | 15 | 9 | 11 | 29490 | 41 | |||
| 43983 | 10710 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 17X Hollis St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003901.15311 | 2113362.61867 | 37.7831113762968 | -122.430189039187 | (37.7831113762968, -122.430189039187) | 7 | 9 | 11 | 29490 | 41 | |||
| 44695 | 525 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009855.90033 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | 2 | 4 | 7 | 28859 | 19 | |||
| 46932 | 17830 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1961 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004561.39396 | 2115345.0767756 | 37.7885920838825 | -122.428046192771 | (37.7885920838825, -122.428046192771) | 13 | 9 | 11 | 28858 | 27 | |||
| 48721 | 9675 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 235 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/19/1981 12:00:00 AM | 12 | 3X3 | 6005972.11971 | 2110519.21136 | 37.7754211527567 | -122.422822183014 | (37.7754211527567, -122.422822183014) | 7 | 9 | 11 | 28852 | 10 | ||
| 49286 | 21956 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2475 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x9 | 6015841.22266 | 2104083.69236 | 37.7583025169931 | -122.388233087559 | (37.7583025169931, -122.388233087559) | 10 | 3 | 8 | 28856 | 29 | |||
| 49311 | 8762 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
| 50280 | 7218 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
| 50755 | 7185 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 865 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003457.39592 | 2111275.80383 | 37.7773563593355 | -122.431575227386 | (37.7773563593355, -122.431575227386) | 15 | 9 | 11 | 29492 | 10 | |||
| 51471 | 20141 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1001 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002903.1358 | 2111776.1473 | 37.7786987467479 | -122.433528357436 | (37.7786987467479, -122.433528357436) | 15 | 9 | 11 | 29490 | 41 | |||
| 51840 | 15324 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1698X Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | 8 | 4 | 9 | 28853 | 19 | |||
| 51940 | 665 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3297X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6007079.62061 | 2102029.84762 | 37.7521737701718 | -122.418388996947 | (37.7521737701718, -122.418388996947) | 2 | 4 | 7 | 28859 | 19 | |||
| 53228 | 7198 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 949 Fillmore St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003395.68163 | 2111577.87165 | 37.7781822644093 | -122.431810290332 | (37.7781822644093, -122.431810290332) | 15 | 9 | 11 | 29492 | 41 | |||
| 54854 | 18511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 626 Powell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6010143.9604039 | 2115933.8512359 | 37.7905229751065 | -122.408772822924 | (37.7905229751065, -122.408772822924) | 5 | 1 | 10 | 28857 | 21 | |||
| 55801 | 15251 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1450X Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007694.41094 | 2110207.30516 | 37.7746617588291 | -122.416842252889 | (37.7746617588291, -122.416842252889) | 8 | 2 | 9 | 28853 | 34 | |||
| 57513 | 12263 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 640 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004991.72568 | 2111198.95935 | 37.7772322091826 | -122.426262005109 | (37.7772322091826, -122.426262005109) | 7 | 9 | 11 | 28852 | 10 | |||
| 57729 | 16813 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2097X O'Farrell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5999009.37837 | 2112716.355 | 37.7810586242256 | -122.447066002739 | (37.7810586242256, -122.447066002739) | 15 | 5 | 1 | 54 | 16 | |||
| 57759 | 4493 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1616 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004570.9658455 | 2099475.4807252 | 37.7450185306318 | -122.426882412261 | (37.7450185306318, -122.426882412261) | 2 | 7 | 5 | 63 | 22 | |||
| 57812 | 13193 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2095 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002451.4681 | 2119463.3271 | 37.7997801365268 | -122.435640954547 | (37.7997801365268, -122.435640954547) | 13 | 9 | 1 | 57 | 17 | |||
| 60447 | 20241 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
| 61417 | 7288 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1860 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6003020.21181 | 2114689.03027 | 37.7867034322579 | -122.433331547756 | (37.7867034322579, -122.433331547756) | 13 | 9 | 11 | 29490 | 27 | |||
| 62418 | 2714 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2185X Bush St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003185.15216 | 2114858.41892 | 37.7871778864418 | -122.432772999031 | (37.7871778864418, -122.432772999031) | 13 | 9 | 11 | 29490 | 27 | |||
| 62512 | 21625 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1610 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6004858.21198 | 2114748.18478 | 37.7869699562504 | -122.426976717781 | (37.7869699562504, -122.426976717781) | 13 | 9 | 11 | 28858 | 27 | |||
| 63433 | 4418 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1128 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004420.05713 | 2102283.99445 | 37.752721523998 | -122.427604283815 | (37.752721523998, -122.427604283815) | 2 | 4 | 5 | 28862 | 22 | |||
| 64595 | 20258 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 495X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 8x8 | 6009991.46116 | 2120547.45752 | 37.8031822677113 | -122.409626234652 | (37.8031822677113, -122.409626234652) | 3 | 1 | 10 | 308 | 23 | |||
| 64713 | 7152 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 708 Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003574.54383 | 2110759.08622 | 37.775944219835 | -122.431133084506 | (37.775944219835, -122.431133084506) | 7 | 9 | 11 | 29492 | 10 | |||
| 64749 | 17324 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
| 65399 | 7150 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003528.61787 | 2110726.18593 | 37.7758512811844 | -122.431289605258 | (37.7758512811844, -122.431289605258) | 15 | 9 | 11 | 29492 | 10 | |||
| 66362 | 6799 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1375 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x9 | 6016685.6205969 | 2097367.3215875 | 37.7399075017412 | -122.384844867735 | (37.7399075017412, -122.384844867735) | 10 | 3 | 8 | 58 | 1 | |||
| 69533 | 8763 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3360 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5996663.11405 | 2112992.0555 | 37.7816812935668 | -122.455202782638 | (37.7816812935668, -122.455202782638) | 11 | 6 | 1 | 54 | 31 | |||
| 72154 | 17321 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 99X Otis St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6006684.07559 | 2109163.06169 | 37.7717376353271 | -122.420263082185 | (37.7717376353271, -122.420263082185) | 8 | 2 | 9 | 28853 | 19 | |||
| 74073 | 7223 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1234X McAllister St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003286.8961 | 2111743.0712 | 37.7786296939692 | -122.432198419662 | (37.7786296939692, -122.432198419662) | 15 | 9 | 11 | 29490 | 41 | |||
| 74408 | 6773 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1355 Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016787.8631263 | 2097291.0360599 | 37.7397036915046 | -122.384486040227 | (37.7397036915046, -122.384486040227) | 10 | 3 | 8 | 58 | 1 | |||
| 77697 | 26275 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1770 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 1X1 | 6000824.4471487 | 2093863.5491185 | 37.7293969298827 | -122.439434969516 | (37.7293969298827, -122.439434969516) | 9 | 7 | 6 | 28861 | 25 | |||
| 78348 | 6705 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Fairfax Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | 10 | 3 | 8 | 58 | 1 | |||
| 79190 | 7215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
| 79373 | 29910 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 791x Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6008575.10006 | 2120353.42874 | 37.8025700449008 | -122.414513871045 | (37.8025700449008, -122.414513871045) | 3 | 1 | 10 | 308 | 32 | ||||
| 79861 | 649 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
| 81673 | 21749 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1840X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002560.9316389 | 2114541.9034523 | 37.786273393243 | -122.434910019678 | (37.786273393243, -122.434910019678) | 13 | 9 | 11 | 29490 | 27 | |||
| 81976 | 7711 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 43 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006508.0978555 | 2110273.8315465 | 37.7747776257034 | -122.420950679235 | (37.7747776257034, -122.420950679235) | 7 | 9 | 11 | 28852 | 10 | |||
| 82543 | 7221 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1000X Fillmore St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.431717632161 | (37.778666518442, -122.431717632161) | 15 | 9 | 11 | 29490 | 41 | |||
| 83228 | 28249 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3340 San Bruno Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X3 | 6011954.9354871 | 2090169.2153285 | 37.7198802090971 | -122.400696159958 | (37.7198802090971, -122.400696159958) | 10 | 7 | 8 | 309 | 28 | |||
| 83236 | 7211 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1225X McAllister St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003292.0475526 | 2111699.258462 | 37.7785096871743 | -122.432177469127 | (37.7785096871743, -122.432177469127) | 15 | 9 | 11 | 29492 | 41 | |||
| 83502 | 112109 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 699x COLUMBUS AVE | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009471 | 2119722 | 37.8008865881446 | -122.411368963081 | (37.8008865881446, -122.411368963081) | 3 | 1 | 10 | 308 | 4 | |||
| 83755 | 7286 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1848 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003026.38997 | 2114635.62779 | 37.7865571530845 | -122.433306355459 | (37.7865571530845, -122.433306355459) | 13 | 9 | 11 | 29490 | 27 | |||
| 85621 | 21994 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2585 03rd St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x6 | 6015909.89309 | 2103367.89889 | 37.7563409047326 | -122.387945645479 | (37.7563409047326, -122.387945645479) | 10 | 3 | 8 | 28856 | 29 | |||
| 87320 | 9574 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1290X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6x5 | 6003478.20667 | 2112124.62637 | 37.7796881945834 | -122.431563850171 | (37.7796881945834, -122.431563850171) | 15 | 9 | 11 | 29490 | 41 |
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) );