trees
548 rows where qCaretaker_id = 1 and qSpecies_id = 53 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 280 | 8072 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 661 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6005345.6576 | 2111619.4154 | 37.7784066780298 | -122.425067563729 | (37.7784066780298, -122.425067563729) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||||
| 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 | ||||
| 14128 | 16935 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 542 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6004164.66828 | 2110140.85762 | 37.7742801386068 | -122.429047601533 | (37.7742801386068, -122.429047601533) | 7 | 9 | 11 | 28852 | 10 | |||
| 18087 | 4603 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 270 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6010933.33158 | 2118545.7793 | 37.7977388815556 | -122.406225735505 | (37.7977388815556, -122.406225735505) | 3 | 1 | 10 | 308 | 23 | |||
| 19494 | 20113 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 800X OAK ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002934 | 2109937 | 37.7736506563952 | -122.433290134136 | (37.7736506563952, -122.433290134136) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 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 | ||||
| 20364 | 516 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2800 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010023.971 | 2102231.13329 | 37.7528917628192 | -122.408221130018 | (37.7528917628192, -122.408221130018) | 2 | 4 | 7 | 28859 | 19 | |||
| 20388 | 6375 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 309X Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006152.1987649 | 2112618.7866796 | 37.7811962356475 | -122.422348456516 | (37.7811962356475, -122.422348456516) | 7 | 9 | 11 | 28852 | 41 | |||
| 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 | |||
| 20699 | 17025 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1109 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001571.2304 | 2109724.9634 | 37.7729910525637 | -122.43798896281 | (37.7729910525637, -122.43798896281) | 15 | 5 | 11 | 29492 | 9 | |||
| 21080 | 11033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1503 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007448.9758793 | 2117473.8836265 | 37.7946002066648 | -122.418206559463 | (37.7946002066648, -122.418206559463) | 5 | 1 | 10 | 28858 | 32 | |||
| 23488 | 1442 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 144 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 5995540.31731 | 2115189.6989 | 37.7876509503315 | -122.459246293031 | (37.7876509503315, -122.459246293031) | 11 | 6 | 1 | 54 | 31 | |||
| 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 | |||
| 26891 | 601 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3085 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6008510.8606794 | 2102109.8045166 | 37.7524737788751 | -122.413445186335 | (37.7524737788751, -122.413445186335) | 2 | 4 | 7 | 28859 | 19 | ||||
| 27435 | 11036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1521 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3x3 | 6007446.95336 | 2117561.22726 | 37.79483991673 | -122.41821975317 | (37.79483991673, -122.41821975317) | 5 | 1 | 10 | 28858 | 32 | |||
| 28315 | 6990 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 855 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003337.33996 | 2110322.66362 | 37.7747324668328 | -122.431922464006 | (37.7747324668328, -122.431922464006) | 15 | 9 | 11 | 29492 | 10 | |||
| 28577 | 18320 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 206 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010262.2750436 | 2107350.6845554 | 37.7669622387245 | -122.40775798639 | (37.7669622387245, -122.40775798639) | 8 | 4 | 8 | 28853 | 19 | |||
| 28739 | 11129 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2140 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 2X2 | 6007198.4118085 | 2119638.2581616 | 37.8005289300711 | -122.419227150729 | (37.8005289300711, -122.419227150729) | 5 | 1 | 1 | 28858 | 32 | |||
| 29407 | 16958 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 705 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x5 | 6003566.56897 | 2110004.67754 | 37.7738723476787 | -122.431106813505 | (37.7738723476787, -122.431106813505) | 15 | 9 | 11 | 29492 | 10 | |||
| 30808 | 21696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1890 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/09/1990 12:00:00 AM | 16 | 4x4 | 6003576.7245218 | 2114564.5327129 | 37.7863931493079 | -122.431397256992 | (37.7863931493079, -122.431397256992) | 13 | 9 | 11 | 29490 | 27 | ||
| 32017 | 116771 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 590X NATOMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3x3 | 6009883 | 2111689 | 37.7788530052944 | -122.409376039999 | (37.7788530052944, -122.409376039999) | 14 | 2 | 9 | 28853 | 34 | |||
| 33185 | 18322 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 226 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010268.7839855 | 2107259.8540962 | 37.7667132034185 | -122.407729067657 | (37.7667132034185, -122.407729067657) | 8 | 4 | 8 | 28853 | 19 | |||
| 33912 | 484 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.406700537042 | (37.7532507356841, -122.406700537042) | 10 | 4 | 7 | 28859 | 19 | |||
| 34775 | 14651 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 655X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6006015.9359491 | 2112078.013352 | 37.7797037167615 | -122.422781416289 | (37.7797037167615, -122.422781416289) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||||
| 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 | |||
| 36315 | 4701 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 841 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6008961.46783 | 2120321.2947 | 37.8025035109944 | -122.41317456692 | (37.8025035109944, -122.41317456692) | 3 | 1 | 10 | 308 | 23 | |||
| 37710 | 4753 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1250 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6007719.65165 | 2121534.55679 | 37.8057650284682 | -122.417557918763 | (37.8057650284682, -122.417557918763) | 5 | 1 | 10 | 308 | 23 | |||
| 38445 | 4501 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1748 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004612.9512322 | 2098708.9638206 | 37.74291622476 | -122.4266826598 | (37.74291622476, -122.4266826598) | 2 | 7 | 5 | 63 | 22 | |||
| 38510 | 19240 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 701 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 8x6 | 6002037.68577 | 2110909.98609 | 37.7762713444054 | -122.436460270394 | (37.7762713444054, -122.436460270394) | 15 | 5 | 11 | 29492 | 10 | |||
| 39760 | 21735 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1980 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x4 | 6003153.81629 | 2114507.53827 | 37.7862126798287 | -122.432856338004 | (37.7862126798287, -122.432856338004) | 13 | 9 | 11 | 29490 | 27 | |||
| 39764 | 11100 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1960 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007273.5320198 | 2119093.4977666 | 37.7990373853425 | -122.418928545127 | (37.7990373853425, -122.418928545127) | 5 | 1 | 10 | 28858 | 32 | |||
| 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 | |||
| 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 | |||
| 43860 | 8182 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1218 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6001778.22585 | 2111194.36963 | 37.7770374434445 | -122.437378180533 | (37.7770374434445, -122.437378180533) | 15 | 5 | 11 | 29492 | 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 | |||
| 45836 | 9661 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 112 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006079.13931 | 2110176.88384 | 37.7744872417771 | -122.422427647286 | (37.7744872417771, -122.422427647286) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 47161 | 18304 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 100 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6010232.4387225 | 2107842.1672579 | 37.7683100673499 | -122.407895847634 | (37.7683100673499, -122.407895847634) | 8 | 4 | 8 | 28853 | 19 | |||
| 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 | |||
| 50489 | 18364 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 598 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010361.2141646 | 2105516.7578044 | 37.7619322307219 | -122.407286474232 | (37.7619322307219, -122.407286474232) | 8 | 4 | 8 | 28859 | 19 | |||
| 50702 | 11103 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1995X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007217.8875 | 2119096.40041 | 37.7990422218557 | -122.419121300277 | (37.7990422218557, -122.419121300277) | 5 | 1 | 10 | 28858 | 32 | |||
| 50734 | 21952 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2455 03RD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 4x9 | 6015836.2 | 2104173 | 37.7585474584562 | -122.388256691115 | (37.7585474584562, -122.388256691115) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | |||
| 52416 | 6378 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 310 Elm St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006136.3622128 | 2112667.0618885 | 37.7813278942368 | -122.422406674363 | (37.7813278942368, -122.422406674363) | 7 | 9 | 11 | 28852 | 41 | |||
| 52589 | 11046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1560 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007462.42749 | 2117742.73439 | 37.7953391611566 | -122.418179084924 | (37.7953391611566, -122.418179084924) | 5 | 1 | 10 | 28858 | 32 | |||
| 52658 | 4626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 419 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010254.83162 | 2118999.33253 | 37.7989462519709 | -122.408605554576 | (37.7989462519709, -122.408605554576) | 3 | 1 | 10 | 308 | 4 | |||
| 53550 | 18383 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | 10 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 55261 | 11108 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2022 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 3X3 | 6007226.47271 | 2119353.11491 | 37.799747578786 | -122.419109811467 | (37.799747578786, -122.419109811467) | 5 | 1 | 1 | 28858 | 32 | |||
| 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 | |||
| 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 | |||
| 61171 | 16895 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 371 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005249.75731 | 2110166.87775 | 37.7744129459718 | -122.425295929281 | (37.7744129459718, -122.425295929281) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 61483 | 17037 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001158.18128 | 2109720.4277 | 37.7729551007398 | -122.439417421896 | (37.7729551007398, -122.439417421896) | 15 | 5 | 11 | 29492 | 10 | |||
| 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 | |||
| 63549 | 18006 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2700X Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001006.5406952 | 2114902.0443839 | 37.7871738702805 | -122.440313633737 | (37.7871738702805, -122.440313633737) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | |||
| 66172 | 18444 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.406744963711 | (37.7558091798762, -122.406744963711) | 10 | 4 | 7 | 28859 | 19 | |||
| 66815 | 23796 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1133 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 6003746.01833 | 2112690.85168 | 37.7812580840725 | -122.430677790145 | (37.7812580840725, -122.430677790145) | 15 | 9 | 11 | 29490 | 41 | |||
| 70605 | 7148 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 670X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6003788.041 | 2110084.01472 | 37.7741027355458 | -122.430346367315 | (37.7741027355458, -122.430346367315) | 7 | 9 | 11 | 29492 | 10 | |||
| 71188 | 4619 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 358 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6010602.31813 | 2118839.00805 | 37.7985254951528 | -122.407391821594 | (37.7985254951528, -122.407391821594) | 3 | 1 | 10 | 308 | 23 | |||
| 72584 | 16863 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 215 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6005958.79101 | 2110336.37823 | 37.774918385113 | -122.422855293382 | (37.774918385113, -122.422855293382) | 7 | 9 | 11 | 28852 | 10 | |||
| 73677 | 18366 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 601 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6010418.5901612 | 2105518.9759028 | 37.7619415321313 | -122.407088188566 | (37.7619415321313, -122.407088188566) | 8 | 4 | 8 | 28859 | 19 | |||
| 77397 | 16979 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 830X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6003018.00984 | 2109974.66323 | 37.7737588358485 | -122.43300222285 | (37.7737588358485, -122.43300222285) | 15 | 5 | 11 | 29492 | 10 | |||
| 77688 | 1668 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2679X LOMBARD ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 5999625 | 2119128 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 78906 | 7228 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1040 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 6003407.87597 | 2111884.23201 | 37.7790241450036 | -122.431789985507 | (37.7790241450036, -122.431789985507) | 15 | 9 | 11 | 29490 | 41 | |||
| 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 | ||||
| 79887 | 16728 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1519 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.7811155269813 | -122.446627836224 | (37.7811155269813, -122.446627836224) | 15 | 5 | 1 | 54 | 16 | |||
| 80355 | 588 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3044 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6008688.10488 | 2102161.42262 | 37.7526254609089 | -122.412835893087 | (37.7526254609089, -122.412835893087) | 2 | 4 | 7 | 28859 | 19 | |||
| 81527 | 26942 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 6x5 | 6002862.4862 | 2114464.90765 | 37.7860790992099 | -122.433861214618 | (37.7860790992099, -122.433861214618) | 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 | |||
| 82016 | 16948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 617 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6004030.19479 | 2110006.18975 | 37.7739027607756 | -122.429503163951 | (37.7739027607756, -122.429503163951) | 7 | 9 | 11 | 29492 | 10 | |||
| 83704 | 10626 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 414 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6005955 | 2111106 | 37.7770313662769 | -122.422923117926 | (37.7770313662769, -122.422923117926) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 83917 | 7189 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 896 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5X5 | 6003518.08132 | 2111313.80886 | 37.7774641511736 | -122.43136801056 | (37.7774641511736, -122.43136801056) | 7 | 9 | 11 | 29492 | 10 | |||
| 85308 | 631 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3195 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6007841.79281 | 2102038.51474 | 37.7522404437102 | -122.415753894425 | (37.7522404437102, -122.415753894425) | 2 | 4 | 7 | 28859 | 19 | |||
| 86183 | 645 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3244X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007408.30918 | 2102098.45375 | 37.7523806444342 | -122.417257199664 | (37.7523806444342, -122.417257199664) | 2 | 4 | 7 | 28859 | 19 | |||
| 87434 | 7222 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1005 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003381.12091 | 2111775.83058 | 37.7787249849862 | -122.431874799698 | (37.7787249849862, -122.431874799698) | 15 | 9 | 11 | 29490 | 41 | |||
| 88644 | 4629 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 427 Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 22 | 3x3 | 6010259.97829 | 2119047.3818 | 37.7990784717377 | -122.408591136664 | (37.7990784717377, -122.408591136664) | 3 | 1 | 10 | 308 | 4 | |||
| 89072 | 18459 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1137 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010601.42584 | 2102531.48836 | 37.7537487889396 | -122.406245333375 | (37.7537487889396, -122.406245333375) | 10 | 4 | 8 | 28859 | 19 | |||
| 90207 | 6932 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 500 Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | Permit Number 780762 | 6004980.8762 | 2110598.20876 | 37.7755820815859 | -122.426256755638 | (37.7755820815859, -122.426256755638) | 7 | 9 | 11 | 28852 | 10 | ||
| 90532 | 490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2734 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
| 90745 | 18351 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 469 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010382.7073264 | 2106125.7302845 | 37.7636055342277 | -122.407255067708 | (37.7636055342277, -122.407255067708) | 8 | 4 | 8 | 28859 | 19 | |||
| 91776 | 18465 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | 10 | 4 | 7 | 28859 | 19 | ||
| 91800 | 19370 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 390X 06TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6011351 | 2111108 | 37.7773398544385 | -122.404256716486 | (37.7773398544385, -122.404256716486) | 14 | 2 | 9 | 28853 | 34 | |||
| 93569 | 7144 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 685X Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003730.75372 | 2110025.58578 | 37.7739390589029 | -122.430540363958 | (37.7739390589029, -122.430540363958) | 7 | 9 | 11 | 29492 | 10 | |||
| 93831 | 7281 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1820X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6003034.84406 | 2114579.8244 | 37.7864044107242 | -122.433273117504 | (37.7864044107242, -122.433273117504) | 13 | 9 | 11 | 29490 | 27 | |||
| 94426 | 23139 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406X Columbus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 6x3 | 6010454.05392 | 2118948.49862 | 37.798817830036 | -122.407912589535 | (37.798817830036, -122.407912589535) | 3 | 1 | 10 | 308 | 23 | |||
| 95502 | 16899 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 406 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6005035.08833 | 2110252.02045 | 37.7746345969303 | -122.426044572686 | (37.7746345969303, -122.426044572686) | 7 | 9 | 11 | 28852 | 10 | |||
| 95868 | 19217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1103X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002080.8485 | 2110141.50629 | 37.7741637433971 | -122.436255949697 | (37.7741637433971, -122.436255949697) | 15 | 5 | 11 | 29492 | 10 |
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) );