trees
3,709 rows where qSpecies_id = 9 sorted by Zip Codes
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 171005 | 232902 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 190 Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004739.0219 | 2109365.37327 | 37.7721833421315 | -122.42700556265 | (37.7721833421315, -122.42700556265) | 7 | 9 | 5 | 28852 | 10 | |||
| 173460 | 103582 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 55X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005242.6 | 2108960.5 | 37.7711001201992 | -122.425234826708 | (37.7711001201992, -122.425234826708) | 7 | 9 | 5 | 28852 | 10 | ||||
| 174302 | 246520 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 155 Laguna St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 6005167.3236 | 2109440.76034 | 37.7724145461197 | -122.425529395676 | (37.7724145461197, -122.425529395676) | 7 | 9 | 5 | 28852 | 10 | |||
| 179692 | 139986 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 625 GOUGH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005793.4562 | 2111911.0062 | 37.7792326006972 | -122.423539194782 | (37.7792326006972, -122.423539194782) | 7 | 9 | 11 | 28852 | 41 | |||
| 179697 | 131932 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 67 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008169.8089 | 2112651.85385 | 37.7814006349608 | -122.415370845393 | (37.7814006349608, -122.415370845393) | 7 | 10 | 9 | 28852 | 36 | |||
| 183707 | 9733 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 649 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4x4 | 6005777.60667 | 2112009.54549 | 37.7795022709045 | -122.423601032727 | (37.7795022709045, -122.423601032727) | 7 | 9 | 11 | 28852 | 41 | |||
| 185531 | 114738 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 | |||
| 185703 | 9729 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 633 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6005786.04675 | 2111952.13361 | 37.7793451083039 | -122.423567751964 | (37.7793451083039, -122.423567751964) | 7 | 9 | 11 | 28852 | 41 | |||
| 187436 | 114429 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 455 EDDY ST | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | 3x3 | 6008254 | 2113439 | 37.7835666804498 | -122.415135318852 | (37.7835666804498, -122.415135318852) | 7 | 10 | 9 | 28852 | 36 | |||
| 189229 | 88020 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 198 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/2008 12:00:00 AM | 3x3 | Permit Number 51047 | 6008282.3 | 2112522.3 | 37.7810512330082 | -122.41497250722 | (37.7810512330082, -122.41497250722) | 7 | 10 | 9 | 28852 | 36 | ||
| 191119 | 9730 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 637 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6005783.8123 | 2111973.7899 | 37.7794044450654 | -122.423577021981 | (37.7794044450654, -122.423577021981) | 7 | 9 | 11 | 28852 | 41 | |||
| 642 | 260182 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
| 2693 | 72299 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 790 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6011682.79959 | 2109646.37516 | 37.7733451034182 | -122.403006076485 | (37.7733451034182, -122.403006076485) | 14 | 2 | 9 | 28853 | 34 | |||
| 4113 | 194123 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 7099 | 103526 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006435.6 | 2109828.8 | 37.7735515891286 | -122.421169857317 | (37.7735515891286, -122.421169857317) | 8 | 2 | 9 | 28853 | 19 | |||
| 8102 | 260181 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
| 12636 | 233814 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 76 Colton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006700.12713 | 2109639.8219 | 37.7730476095043 | -122.420241401833 | (37.7730476095043, -122.420241401833) | 8 | 2 | 9 | 28853 | 19 | |||
| 14403 | 260183 | Planning Code 138.1 required 2 | Olea europaea :: Olive Tree 9 | 66x McCoppin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2019 12:00:00 AM | 3 | 3x3 | 6006141 | 2109130 | 37.7716162396968 | -122.422139269172 | (37.7716162396968, -122.422139269172) | 8 | 2 | 9 | 28853 | 19 | ||
| 14962 | 41296 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 65 McCoppin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 41973 | 6006281.33179879 | 2109112.42754659 | 37.7715759040746 | -122.421652604165 | (37.7715759040746, -122.421652604165) | 8 | 2 | 9 | 28853 | 19 | ||
| 15376 | 233816 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 41 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006595.43726 | 2109656.08938 | 37.7730863765667 | -122.420604692871 | (37.7730863765667, -122.420604692871) | 8 | 2 | 9 | 28853 | 19 | |||
| 16889 | 194212 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 539 Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009479.48801 | 2112419.8132 | 37.7808370289509 | -122.410823580868 | (37.7808370289509, -122.410823580868) | 14 | 2 | 9 | 28853 | 34 | |||
| 21706 | 88180 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 435 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51188 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
| 24774 | 107077 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 10 BRADY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x4 | 6006482 | 2109752 | 37.7733433304068 | -122.421003898549 | (37.7733433304068, -122.421003898549) | 8 | 2 | 9 | 28853 | 19 | |||
| 26374 | 65083 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 453 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/09/1995 12:00:00 AM | Permit Number 27047 | 6010566.1381684 | 2112563.56806909 | 37.7812926155318 | -122.407074445388 | (37.7812926155318, -122.407074445388) | 14 | 2 | 9 | 28853 | 34 | ||
| 32507 | 194124 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 3 | Sidewalk: Curb side : Hanging Pot | Tree | Private 2 | 9 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 33680 | 233820 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006474.05486 | 2109741.72486 | 37.7733146694671 | -122.42103065224 | (37.7733146694671, -122.42103065224) | 8 | 2 | 9 | 28853 | 19 | |||
| 34633 | 194206 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 457 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011140.13289 | 2111994.65704 | 37.7797626232839 | -122.40504862481 | (37.7797626232839, -122.40504862481) | 14 | 2 | 9 | 28853 | 34 | |||
| 40761 | 194213 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 539 Stevenson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009498.57489 | 2112438.36356 | 37.7808890340394 | -122.410758860237 | (37.7808890340394, -122.410758860237) | 14 | 2 | 9 | 28853 | 34 | |||
| 40915 | 194210 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 539 Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6009440.06083 | 2112382.42728 | 37.7807321652893 | -122.410957337912 | (37.7807321652893, -122.410957337912) | 14 | 2 | 9 | 28853 | 34 | |||
| 43788 | 194157 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301 Rhode Island St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6011751.61895 | 2106914.05853 | 37.7658466245494 | -122.402575844407 | (37.7658466245494, -122.402575844407) | 8 | 3 | 8 | 28853 | 20 | |||
| 44702 | 233811 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 85 Colton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006692.98087 | 2109598.65836 | 37.7729341815885 | -122.42026319959 | (37.7729341815885, -122.42026319959) | 8 | 2 | 9 | 28853 | 19 | |||
| 46134 | 194209 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 443 Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011185.40035 | 2112038.41946 | 37.7798853150983 | -122.40489510602 | (37.7798853150983, -122.40489510602) | 14 | 2 | 9 | 28853 | 34 | |||
| 47642 | 233828 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | 8 | 2 | 9 | 28853 | 19 | |||
| 49563 | 66226 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1092 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1991 12:00:00 AM | Permit Number 29321 | 6007625.68875547 | 2109532.95268759 | 37.7728062813888 | -122.417032186184 | (37.7728062813888, -122.417032186184) | 8 | 2 | 9 | 28853 | 19 | ||
| 49637 | 233819 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 37 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6006543.42029 | 2109705.78827 | 37.7732199061125 | -122.420788155474 | (37.7732199061125, -122.420788155474) | 8 | 2 | 9 | 28853 | 19 | |||
| 51724 | 233821 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006494.075 | 2109719.35125 | 37.7732543654184 | -122.420959810866 | (37.7732543654184, -122.420959810866) | 8 | 2 | 9 | 28853 | 19 | |||
| 52494 | 253139 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Brady St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | 8 | 2 | 9 | 28853 | 19 | ||||
| 53254 | 31901 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 973 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 6 | Permit Number 35326 | 6007886.26854 | 2110026.25074 | 37.7741754160005 | -122.416165751655 | (37.7741754160005, -122.416165751655) | 8 | 2 | 9 | 28853 | 34 | |
| 59707 | 194126 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 61160 | 106800 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 443 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6011195 | 2112052 | 37.7799231406809 | -122.404862852803 | (37.7799231406809, -122.404862852803) | 14 | 2 | 9 | 28853 | 34 | |||||
| 63772 | 253140 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Brady St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | 8 | 2 | 9 | 28853 | 19 | ||||
| 64143 | 112601 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 6 BRADY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6006424 | 2109783 | 37.7734251793628 | -122.421206730662 | (37.7734251793628, -122.421206730662) | 8 | 2 | 9 | 28853 | 19 | |||
| 71654 | 88179 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 435 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51188 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
| 73135 | 233827 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Brady St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6006602.54325 | 2109605.74349 | 37.7729485392742 | -122.420576537786 | (37.7729485392742, -122.420576537786) | 8 | 2 | 9 | 28853 | 19 | |||
| 73203 | 233826 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Brady St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6006589.60431 | 2109621.50063 | 37.772991075401 | -122.420622413992 | (37.772991075401, -122.420622413992) | 8 | 2 | 9 | 28853 | 19 | |||
| 73227 | 194128 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 75802 | 254197 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 539 Stevenson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6009498.57489 | 2112438.36356 | 37.7808890340394 | -122.410758860237 | (37.7808890340394, -122.410758860237) | 14 | 2 | 9 | 28853 | 34 | ||||
| 76608 | 233810 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 85 Colton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006682.82551 | 2109589.97692 | 37.7729097721908 | -122.420297711981 | (37.7729097721908, -122.420297711981) | 8 | 2 | 9 | 28853 | 19 | |||
| 77578 | 233817 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 37 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006580.02808 | 2109672.87753 | 37.7731316043669 | -122.420659187277 | (37.7731316043669, -122.420659187277) | 8 | 2 | 9 | 28853 | 19 | |||
| 77897 | 103525 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 21X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006570.3 | 2109690.3 | 37.773178894024 | -122.420694075081 | (37.773178894024, -122.420694075081) | 8 | 2 | 9 | 28853 | 19 | |||
| 78122 | 41269 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 44 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/07/1999 12:00:00 AM | Permit Number 47888 | 6006372.39336546 | 2109513.04186009 | 37.7726810295415 | -122.42136607091 | (37.7726810295415, -122.42136607091) | 8 | 2 | 9 | 28853 | 19 | ||
| 83731 | 194208 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 443 Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6011171.46915 | 2112023.89083 | 37.7798446441471 | -122.404942277258 | (37.7798446441471, -122.404942277258) | 14 | 2 | 9 | 28853 | 34 | |||
| 88247 | 253141 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Brady St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | 8 | 2 | 9 | 28853 | 19 | ||||
| 95056 | 41086 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1453 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/11/2005 12:00:00 AM | Permit Number 41837 | 6007800.3814676 | 2110226.65901823 | 37.7747208599359 | -122.41647704979 | (37.7747208599359, -122.41647704979) | 8 | 2 | 9 | 28853 | 34 | ||
| 96792 | 41082 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1453 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | Permit Number 41837 | 6007800.3814676 | 2110226.65901823 | 37.7747208599359 | -122.41647704979 | (37.7747208599359, -122.41647704979) | 8 | 2 | 9 | 28853 | 34 | ||
| 102203 | 233818 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 37 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006566.3543 | 2109684.66241 | 37.7731631921689 | -122.420707323509 | (37.7731631921689, -122.420707323509) | 8 | 2 | 9 | 28853 | 19 | |||
| 102412 | 253138 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | 8 | 2 | 9 | 28853 | 19 | ||||
| 103142 | 194207 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 443 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011160.10683 | 2112013.75352 | 37.7798161743168 | -122.404980870787 | (37.7798161743168, -122.404980870787) | 14 | 2 | 9 | 28853 | 34 | |||
| 103220 | 88183 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 459 Clementina St | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51190 | 6011089 | 2111952 | 37.7796426384682 | -122.405222512117 | (37.7796426384682, -122.405222512117) | 14 | 2 | 9 | 28853 | 34 | |||
| 108773 | 255780 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 10 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006476 | 2109729 | 37.7732798396992 | -122.421023020053 | (37.7732798396992, -122.421023020053) | 8 | 2 | 9 | 28853 | 19 | ||||
| 108780 | 233813 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 76 Colton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6006712.71956 | 2109652.11382 | 37.7730820697195 | -122.4201987155 | (37.7730820697195, -122.4201987155) | 8 | 2 | 9 | 28853 | 19 | |||
| 108848 | 41084 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1453 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | Permit Number 41837 | 6007800.3814676 | 2110226.65901823 | 37.7747208599359 | -122.41647704979 | (37.7747208599359, -122.41647704979) | 8 | 2 | 9 | 28853 | 34 | ||
| 108853 | 194125 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 112151 | 233823 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006554.92333 | 2109652.21468 | 37.7730734542033 | -122.420744560833 | (37.7730734542033, -122.420744560833) | 8 | 2 | 9 | 28853 | 19 | |||
| 112195 | 95829 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 174 Langton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/29/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767563 | 6010460.23417 | 2110421.60059 | 37.775405346827 | -122.407289780317 | (37.775405346827, -122.407289780317) | 8 | 2 | 9 | 28853 | 34 |
| 112961 | 41078 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 465 10th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | Permit Number 41835 | 6009579.19850345 | 2108775.779871 | 37.7708369582351 | -122.410221276734 | (37.7708369582351, -122.410221276734) | 8 | 2 | 9 | 28853 | 34 | ||
| 114799 | 88178 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 435 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/08/2008 12:00:00 AM | 3x3 | Permit Number 51188 | 6011272.5 | 2112058.5 | 37.7799453198016 | -122.404595202044 | (37.7799453198016, -122.404595202044) | 14 | 2 | 9 | 28853 | 34 | ||
| 119600 | 194211 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 539 Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6009462.60815 | 2112402.45945 | 37.7807884331872 | -122.410880750763 | (37.7807884331872, -122.410880750763) | 14 | 2 | 9 | 28853 | 34 | |||
| 120256 | 194204 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 459 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011095.09283 | 2111949.90223 | 37.7796372191084 | -122.405201286513 | (37.7796372191084, -122.405201286513) | 14 | 2 | 9 | 28853 | 34 | |||
| 122455 | 232449 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 87 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005224.99434 | 2107348.16354 | 37.7666720367088 | -122.425180979441 | (37.7666720367088, -122.425180979441) | 8 | 4 | 5 | 28853 | 19 | |||
| 124987 | 94313 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 83 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2010 12:00:00 AM | 3x3 | Permit Number 53622 | 6006792 | 2109451 | 37.7725343260039 | -122.419910199889 | (37.7725343260039, -122.419910199889) | 8 | 2 | 9 | 28853 | 19 | ||
| 131016 | 41083 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1453 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | Permit Number 41837 | 6007800.3814676 | 2110226.65901823 | 37.7747208599359 | -122.41647704979 | (37.7747208599359, -122.41647704979) | 8 | 2 | 9 | 28853 | 34 | ||
| 132850 | 51398 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 409 Tehama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/13/2004 12:00:00 AM | 7 | Permit Number 47725 | 6011224.1618 | 2112342.59231 | 37.7807226693432 | -122.404782432666 | (37.7807226693432, -122.404782432666) | 14 | 2 | 9 | 28853 | 34 | |
| 132947 | 233815 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 78 Colton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006685.92768 | 2109625.99474 | 37.7730088433182 | -122.420289538034 | (37.7730088433182, -122.420289538034) | 8 | 2 | 9 | 28853 | 19 | |||
| 134403 | 194205 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 457 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011130.49 | 2111983.74386 | 37.7797321191806 | -122.40508121532 | (37.7797321191806, -122.40508121532) | 14 | 2 | 9 | 28853 | 34 | |||
| 134538 | 233812 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 76 Colton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6006728.18845 | 2109663.82332 | 37.7731150928059 | -122.420146037721 | (37.7731150928059, -122.420146037721) | 8 | 2 | 9 | 28853 | 19 | |||
| 136445 | 194127 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 137536 | 63892 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24601 | 6006420.02915075 | 2109778.87489817 | 37.7734136289627 | -122.421220173442 | (37.7734136289627, -122.421220173442) | 8 | 2 | 9 | 28853 | 19 | ||
| 138089 | 49611 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 147511th/10th Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2003 12:00:00 AM | 2 | Permit Number 46476 | 6008600.1188 | 2109233.9595 | 37.7720400828494 | -122.413640358642 | (37.7720400828494, -122.413640358642) | 8 | 2 | 9 | 28853 | 34 | |
| 143645 | 233824 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6006568.33465 | 2109640.43519 | 37.7730418664232 | -122.42069733291 | (37.7730418664232, -122.42069733291) | 8 | 2 | 9 | 28853 | 19 | |||
| 147751 | 232450 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Trainor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6008305.53635 | 2108197.25512 | 37.7691769894516 | -122.414585971069 | (37.7691769894516, -122.414585971069) | 8 | 4 | 7 | 28853 | 19 | |||
| 149249 | 194121 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 174 Langton St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6010449.01935 | 2110432.74871 | 37.7754353293039 | -122.407329361273 | (37.7754353293039, -122.407329361273) | 8 | 2 | 9 | 28853 | 34 | |||
| 151546 | 41085 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1453 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | Permit Number 41837 | 6007800.3814676 | 2110226.65901823 | 37.7747208599359 | -122.41647704979 | (37.7747208599359, -122.41647704979) | 8 | 2 | 9 | 28853 | 34 | ||
| 152249 | 85759 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1180 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009784.0631 | 2110452.1961 | 37.7754514883024 | -122.409630984869 | (37.7754514883024, -122.409630984869) | 8 | 2 | 9 | 28853 | 34 | ||
| 153651 | 94907 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 180 Langton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53965 | 6010470.49633 | 2110410.47188 | 37.7753753643152 | -122.407253496251 | (37.7753753643152, -122.407253496251) | 8 | 2 | 9 | 28853 | 34 | |
| 156359 | 103527 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1X Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006435.6 | 2109828.8 | 37.7735515891286 | -122.421169857317 | (37.7735515891286, -122.421169857317) | 8 | 2 | 9 | 28853 | 19 | |||
| 157341 | 233825 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 20 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6006580.12185 | 2109628.40278 | 37.7730094926319 | -122.420655705111 | (37.7730094926319, -122.420655705111) | 8 | 2 | 9 | 28853 | 19 | |||
| 157569 | 41081 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1453 Mission St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | Permit Number 41837 | 6007800.3814676 | 2110226.65901823 | 37.7747208599359 | -122.41647704979 | (37.7747208599359, -122.41647704979) | 8 | 2 | 9 | 28853 | 34 | ||
| 159221 | 253137 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 40 Brady St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6006614.59932 | 2109591.90022 | 37.7729112084036 | -122.42053385147 | (37.7729112084036, -122.42053385147) | 8 | 2 | 9 | 28853 | 19 | ||||
| 159927 | 232453 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 344 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6007353.293 | 2107645.37306 | 37.7676081068443 | -122.417840611257 | (37.7676081068443, -122.417840611257) | 8 | 4 | 7 | 28853 | 19 | |||
| 164024 | 254196 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 539 Stevenson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 2ft | 6009498.57489 | 2112438.36356 | 37.7808890340394 | -122.410758860237 | (37.7808890340394, -122.410758860237) | 14 | 2 | 9 | 28853 | 34 | ||||
| 169392 | 32671 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 452 Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51345 | 6011114.30345 | 2112004.56404 | 37.7797883816575 | -122.405138678422 | (37.7797883816575, -122.405138678422) | 14 | 2 | 9 | 28853 | 34 | |
| 169436 | 233822 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 18 Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 3ft | 6006510.72111 | 2109698.8775 | 37.773199087705 | -122.420900775755 | (37.773199087705, -122.420900775755) | 8 | 2 | 9 | 28853 | 19 | |||
| 174630 | 194122 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 963 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007973 | 2110046 | 37.7742345191157 | -122.415867130014 | (37.7742345191157, -122.415867130014) | 8 | 2 | 9 | 28853 | 34 | |||
| 177624 | 112480 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 23X Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006599.99796 | 2109631.20374 | 37.7730183035842 | -122.420587149931 | (37.7730183035842, -122.420587149931) | 8 | 2 | 9 | 28853 | 19 | ||||
| 179113 | 41080 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1453 Mission St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/1999 12:00:00 AM | Permit Number 41837 | 6007800.3814676 | 2110226.65901823 | 37.7747208599359 | -122.41647704979 | (37.7747208599359, -122.41647704979) | 8 | 2 | 9 | 28853 | 34 | ||
| 181504 | 103528 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1X Brady St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6006435.6 | 2109828.8 | 37.7735515891286 | -122.421169857317 | (37.7735515891286, -122.421169857317) | 8 | 2 | 9 | 28853 | 19 | |||
| 184849 | 233809 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 83 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6006776.89182 | 2109465.42197 | 37.7725730741221 | -122.419963484333 | (37.7725730741221, -122.419963484333) | 8 | 2 | 9 | 28853 | 19 | |||
| 185633 | 38331 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 346 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | 8 | Permit Number 40385 | 6007360.11088377 | 2107658.94238864 | 37.7676457487192 | -122.417817990969 | (37.7676457487192, -122.417817990969) | 8 | 4 | 7 | 28853 | 19 | |
| 304 | 132028 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 33x Battery St | 1 | Median : Yard | Tree | DPW 1 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.399447311639 | (37.7911327033699, -122.399447311639) | 4 | 1 | 10 | 28854 | 6 |
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) );