trees
408 rows where Police Districts = 9 and qSpecies_id = 53 sorted by XCoord
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 107261 | 18696 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 3 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
| 171543 | 18697 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 251X Richardson Ave | 4 | Median : Cutout | Tree | DPW 1 | 12 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.447389461083 | (37.8006252370733, -122.447389461083) | 13 | 9 | 1 | 57 | 17 | |||
| 183408 | 50980 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 201 Richardson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/06/2004 12:00:00 AM | 3x3 | Permit Number 47465 | 5999116.7 | 2119758.3 | 37.8004000774175 | -122.447201682136 | (37.8004000774175, -122.447201682136) | 13 | 9 | 1 | 57 | 17 | ||
| 95876 | 26159 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 210 Richardson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5999117.59522 | 2119823.02413 | 37.800577843616 | -122.447203245105 | (37.800577843616, -122.447203245105) | 13 | 9 | 1 | 57 | 17 | |||
| 134352 | 18684 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 165X Richardson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5999250.42609 | 2119592.62258 | 37.7999528116563 | -122.446727010779 | (37.7999528116563, -122.446727010779) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 120455 | 1669 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2679X LOMBARD ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 13 | 3X3 | 5999625 | 2119128 | 37.7986984723422 | -122.445397421769 | (37.7986984723422, -122.445397421769) | 13 | 9 | 1 | 57 | 17 | |||
| 162297 | 108098 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2800X Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5999639 | 2117762 | 37.7949485989127 | -122.445250712888 | (37.7949485989127, -122.445250712888) | 13 | 9 | 1 | 57 | 17 | |||||
| 21498 | 98979 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 38 MILEY ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | Permit Number 778225 | 5999656 | 2118689 | 37.7974948649915 | -122.4452585722 | (37.7974948649915, -122.4452585722) | 13 | 9 | 1 | 57 | 17 | ||
| 171446 | 257980 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 3 | Front Yard : Yard | Tree | Private 2 | Permit Number 782825 | 5999909.76407 | 2117098.92712 | 37.7931434275556 | -122.444266160734 | (37.7931434275556, -122.444266160734) | 13 | 9 | 1 | 57 | 27 | ||||
| 184158 | 127219 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 8 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999916.98549 | 2117117.82475 | 37.7931957274607 | -122.444242532876 | (37.7931957274607, -122.444242532876) | 13 | 9 | 1 | 57 | 27 | ||
| 76207 | 127218 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 7 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999923.49955 | 2117118.25276 | 37.7931972742965 | -122.44422002466 | (37.7931972742965, -122.44422002466) | 13 | 9 | 1 | 57 | 27 | ||
| 109441 | 127217 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 6 | Front Yard : Yard | Tree | Private 2 | 7 | Width 4ft | Permit Number 782825 | 5999928.92975 | 2117120.95639 | 37.7932050075467 | -122.444201430254 | (37.7932050075467, -122.444201430254) | 13 | 9 | 1 | 57 | 27 | ||
| 147341 | 127216 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 5 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999932.8876 | 2117120.87416 | 37.7932050075595 | -122.444187729973 | (37.7932050075595, -122.444187729973) | 13 | 9 | 1 | 57 | 27 | ||
| 59694 | 127215 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2864 Broadway | 4 | Front Yard : Yard | Tree | Private 2 | 8 | Width 4ft | Permit Number 782825 | 5999937.99418 | 2117121.61309 | 37.7932073277938 | -122.44417011406 | (37.7932073277938, -122.44417011406) | 13 | 9 | 1 | 57 | 27 | ||
| 77847 | 13285 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2576 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/26/1993 12:00:00 AM | 3 | 3X3 | 6000068.81033 | 2119230.46658 | 37.799005143246 | -122.443869066799 | (37.799005143246, -122.443869066799) | 13 | 9 | 1 | 57 | 17 | ||
| 41634 | 13254 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2408 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1993 12:00:00 AM | 45 | 3X3 | 6000832.23006 | 2119380.36917 | 37.7994602521243 | -122.441238147567 | (37.7994602521243, -122.441238147567) | 13 | 9 | 1 | 57 | 17 | ||
| 6921 | 95036 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 11093 | 95037 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 8 | Sidewalk: Property side : Cutout | Tree | Dept of Real Estate 7 | 10 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 11986 | 95043 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 4 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 9 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 43653 | 95034 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 50801 | 95033 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 50984 | 95035 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 77560 | 95038 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 87780 | 95040 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 13 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 120981 | 95046 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 10 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 13 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 122270 | 95039 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 129349 | 95041 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 141424 | 95044 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 6 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | ||||
| 142881 | 95042 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3224 Pierce St | 2 | Sidewalk: Property side : Cutout | Tree | DPW for City Agency 14 | 11 | 3x3 | 6001388 | 2119447 | 37.7996748454742 | -122.4393197689 | (37.7996748454742, -122.4393197689) | 13 | 9 | 1 | 57 | 17 | |||
| 39370 | 107630 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2164 CHESTNUT ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6001495 | 2119755 | 37.8005266206576 | -122.438971595662 | (37.8005266206576, -122.438971595662) | 13 | 9 | 1 | 57 | 17 | |||
| 131050 | 110659 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2393 FILBERT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001559 | 2118656 | 37.7975126970015 | -122.438671337949 | (37.7975126970015, -122.438671337949) | 13 | 9 | 1 | 57 | 17 | ||||
| 66213 | 50374 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2727 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47038 | 6001577.22511674 | 2117761.13132823 | 37.7950566585474 | -122.43854412401 | (37.7950566585474, -122.43854412401) | 13 | 9 | 1 | 57 | 27 | ||||
| 169402 | 50375 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2727 Pierce St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47038 | 6001577.22511674 | 2117761.13132823 | 37.7950566585474 | -122.43854412401 | (37.7950566585474, -122.43854412401) | 13 | 9 | 1 | 57 | 27 | ||||
| 193344 | 13225 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2265 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001602.67751 | 2119341.9386 | 37.799398588794 | -122.438569375951 | (37.799398588794, -122.438569375951) | 13 | 9 | 1 | 57 | 17 | |||
| 29776 | 44063 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 | |||
| 56427 | 44064 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 | |||
| 70447 | 44061 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/19/2000 12:00:00 AM | Permit Number 43588 | 6001640.58397077 | 2117683.20689336 | 37.7948463022786 | -122.438319307967 | (37.7948463022786, -122.438319307967) | 13 | 9 | 1 | 57 | 27 | |||
| 11207 | 108105 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
| 48110 | 108103 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
| 127089 | 108101 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2390X Green St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 6001806.63782 | 2118043.59498 | 37.7958452773357 | -122.437770563269 | (37.7958452773357, -122.437770563269) | 13 | 9 | 1 | 57 | 17 | |||||
| 90065 | 13211 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2190 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 70 | 3X3 | 6001897.52108 | 2119466.22991 | 37.7997566277665 | -122.437558020868 | (37.7997566277665, -122.437558020868) | 13 | 9 | 1 | 57 | 17 | |||
| 115478 | 13204 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2150 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | 3X3 | 6001979.60867 | 2119494.8171 | 37.7998397874351 | -122.437276016047 | (37.7998397874351, -122.437276016047) | 13 | 9 | 1 | 57 | 17 | |||
| 55002 | 13200 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
| 120658 | 13201 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
| 186277 | 13199 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2130X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6002179.06604 | 2119515.41872 | 37.7999076905723 | -122.436587295662 | (37.7999076905723, -122.436587295662) | 13 | 9 | 1 | 57 | 17 | |||
| 4658 | 46466 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3310X Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/25/2002 12:00:00 AM | 12 | 3x3 | Permit Number 44668 | 6002328.64862435 | 2119517.88465055 | 37.7999229605029 | -122.436069860968 | (37.7999229605029, -122.436069860968) | 13 | 9 | 1 | 57 | 17 | |
| 135783 | 13192 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2095 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002431.86629 | 2119459.61132 | 37.7997688205881 | -122.435708517981 | (37.7997688205881, -122.435708517981) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 155737 | 117286 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3500 FILLMORE ST | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6002513 | 2120207 | 37.8018255621759 | -122.435481260672 | (37.8018255621759, -122.435481260672) | 13 | 9 | 1 | 57 | 17 | ||||
| 184916 | 20245 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1823 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/13/1989 12:00:00 AM | 12 | 3X3 | 6002519.5885419 | 2114476.0123893 | 37.7860901257054 | -122.435048341611 | (37.7860901257054, -122.435048341611) | 13 | 9 | 1 | 29490 | 27 | ||
| 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 | |||
| 50810 | 20244 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002529.5506914 | 2114404.1561918 | 37.7858933925245 | -122.435008734319 | (37.7858933925245, -122.435008734319) | 13 | 9 | 1 | 29490 | 27 | |||
| 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 | |||
| 163000 | 20243 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1801X Steiner St | 2 | 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 | |||
| 112969 | 21752 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1787X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002537.7996519 | 2114344.6571005 | 37.7857304915222 | -122.434975938446 | (37.7857304915222, -122.434975938446) | 13 | 9 | 11 | 29490 | 13 | |||
| 190566 | 21751 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1787X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6002537.7996519 | 2114344.6571005 | 37.7857304915222 | -122.434975938446 | (37.7857304915222, -122.434975938446) | 13 | 9 | 11 | 29490 | 13 | |||
| 151636 | 20239 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1757X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002551.4219946 | 2114246.4002369 | 37.7854614766008 | -122.434921779618 | (37.7854614766008, -122.434921779618) | 13 | 9 | 11 | 29490 | 13 | |||
| 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 | |||
| 104550 | 21748 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1840X Steiner St | 1 | 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 | |||
| 123574 | 21750 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1840X Steiner St | 3 | 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 | |||
| 60795 | 94982 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2301 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002562.1 | 2117394.1 | 37.7941048599095 | -122.435110049481 | (37.7941048599095, -122.435110049481) | 13 | 9 | 1 | 29490 | 27 | ||||
| 115585 | 13186 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2051X Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6002574.7502816 | 2119473.5963948 | 37.7998153348368 | -122.435215088035 | (37.7998153348368, -122.435215088035) | 13 | 9 | 1 | 57 | 17 | |||
| 193568 | 26953 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002643.91242 | 2114436.71459 | 37.7859892824562 | -122.43461540376 | (37.7859892824562, -122.43461540376) | 13 | 9 | 11 | 29490 | 27 | |||
| 139533 | 26952 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x6 | 6002662.57908 | 2114440.54738 | 37.7860008659914 | -122.434551096425 | (37.7860008659914, -122.434551096425) | 13 | 9 | 11 | 29490 | 27 | |||
| 93727 | 26951 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 5x6 | 6002681.79801 | 2114441.89018 | 37.7860056439611 | -122.434484700269 | (37.7860056439611, -122.434484700269) | 13 | 9 | 11 | 29490 | 27 | |||
| 123904 | 98659 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2110 Greenwich St | 13 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW | 20 | 7x7 | 6002683.8 | 2119245.6 | 37.7991955081761 | -122.434821422435 | (37.7991955081761, -122.434821422435) | 13 | 9 | 1 | 57 | 17 | ||
| 67743 | 26950 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 17 | 3X3 | 6002695.46817 | 2114444.00008 | 37.7860122131882 | -122.434437556188 | (37.7860122131882, -122.434437556188) | 13 | 9 | 11 | 29490 | 27 | |||
| 137263 | 27617 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2512 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002699.61445 | 2115865.03401 | 37.7899142453613 | -122.434524853763 | (37.7899142453613, -122.434524853763) | 13 | 9 | 1 | 29490 | 27 | |||
| 154378 | 26949 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002710.37506 | 2114446.07693 | 37.7860187618492 | -122.434386130989 | (37.7860187618492, -122.434386130989) | 13 | 9 | 11 | 29490 | 27 | |||
| 184672 | 113275 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2147 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6002730.25600058 | 2118492.02135193 | 37.7971290147198 | -122.43460675571 | (37.7971290147198, -122.43460675571) | 13 | 9 | 1 | 57 | 17 | |||||
| 125597 | 7374 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2498 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5x5 | 6002741.92214 | 2116738.58592 | 37.7923151963696 | -122.43444095639 | (37.7923151963696, -122.43444095639) | 13 | 9 | 1 | 29490 | 27 | |||
| 51362 | 2729 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2250 Bush St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002744.1445 | 2114802.6476 | 37.7869997310528 | -122.434294799469 | (37.7869997310528, -122.434294799469) | 13 | 9 | 11 | 29490 | 27 | |||
| 24360 | 26948 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6002746.89171 | 2114446.33864 | 37.7860215531341 | -122.434259812125 | (37.7860215531341, -122.434259812125) | 13 | 9 | 11 | 29490 | 27 | |||
| 164124 | 57410 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 109 Wilmot St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/08/1976 12:00:00 AM | 15 | Permit Number 770100 | 6002753.5601 | 2114939.9175 | 37.7873771736852 | -122.434272041026 | (37.7873771736852, -122.434272041026) | 13 | 9 | 11 | 29490 | 27 | ||
| 147266 | 26947 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002779.24505 | 2114452.89969 | 37.786041404384 | -122.434148347649 | (37.786041404384, -122.434148347649) | 13 | 9 | 11 | 29490 | 27 | |||
| 32254 | 26946 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002793.58315 | 2114456.84816 | 37.7860530596313 | -122.434099024105 | (37.7860530596313, -122.434099024105) | 13 | 9 | 11 | 29490 | 27 | |||
| 148416 | 26945 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6002804.14495 | 2114458.42232 | 37.7860579812909 | -122.434062595727 | (37.7860579812909, -122.434062595727) | 13 | 9 | 11 | 29490 | 27 | |||
| 45474 | 26944 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6002826.48876 | 2114460.91922 | 37.7860661051899 | -122.433985470782 | (37.7860661051899, -122.433985470782) | 13 | 9 | 11 | 29490 | 27 | |||
| 44254 | 20167 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1175 Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 4X4 | 6002828.6579039 | 2112263.6806979 | 37.7800331654734 | -122.433820860908 | (37.7800331654734, -122.433820860908) | 15 | 9 | 11 | 29490 | 41 | |||
| 84820 | 98591 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2375 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 9808 | 6002830 | 2116793 | 37.7924696026791 | -122.434140096981 | (37.7924696026791, -122.434140096981) | 13 | 9 | 1 | 29490 | 27 | |||
| 35663 | 26954 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x6 | 6002832.1331203 | 2114461.0177044 | 37.7860666959211 | -122.433965949874 | (37.7860666959211, -122.433965949874) | 13 | 9 | 11 | 29490 | 27 | |||
| 155152 | 26943 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2040 Sutter St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 5x6 | 6002846.96094 | 2114462.84733 | 37.7860725610737 | -122.43391478048 | (37.7860725610737, -122.43391478048) | 13 | 9 | 11 | 29490 | 27 | |||
| 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 | |||
| 166398 | 9620 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1165X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/16/1990 12:00:00 AM | 50 | 3X3 | 6002862.99505 | 2112096.1743 | 37.779575183286 | -122.433690098242 | (37.779575183286, -122.433690098242) | 15 | 9 | 11 | 29490 | 41 | ||
| 90875 | 110969 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2475 Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6002881.27515757 | 2116466.21692287 | 37.7915752502174 | -122.433939314763 | (37.7915752502174, -122.433939314763) | 13 | 9 | 1 | 29490 | 27 | |||
| 67395 | 20160 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1150X Steiner St | 3 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4X4 | 6002889.114145 | 2112192.180758 | 37.7798402749908 | -122.433606604391 | (37.7798402749908, -122.433606604391) | 15 | 9 | 11 | 29490 | 41 | |||
| 74795 | 20161 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1150X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4X4 | 6002889.114145 | 2112192.180758 | 37.7798402749908 | -122.433606604391 | (37.7798402749908, -122.433606604391) | 15 | 9 | 11 | 29490 | 41 | |||
| 94472 | 20162 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1150X Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Police Dept 10 | 18 | 4X4 | 6002889.114145 | 2112192.180758 | 37.7798402749908 | -122.433606604391 | (37.7798402749908, -122.433606604391) | 15 | 9 | 11 | 29490 | 41 | |||
| 70974 | 23955 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1985X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6002890.93346 | 2119517.51166 | 37.7999538645084 | -122.434124118866 | (37.7999538645084, -122.434124118866) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 178705 | 59665 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 993 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/1981 12:00:00 AM | 12 | 2x2 | Permit Number 19087 | 6002914.43276984 | 2111641.44659541 | 37.7783295332017 | -122.433479648258 | (37.7783295332017, -122.433479648258) | 15 | 9 | 11 | 29492 | 41 | |
| 106301 | 98984 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 993 Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 19087 | 6002920 | 2111648 | 37.7783478430736 | -122.433460857601 | (37.7783478430736, -122.433460857601) | 15 | 9 | 11 | 29492 | 41 | ||
| 57390 | 9617 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Steiner St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002921.99888 | 2111973.13636 | 37.7792406996886 | -122.433477183837 | (37.7792406996886, -122.433477183837) | 15 | 9 | 11 | 29490 | 41 | |||
| 69526 | 9615 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002927.21435 | 2111923.58629 | 37.7791049434867 | -122.433455599491 | (37.7791049434867, -122.433455599491) | 15 | 9 | 11 | 29490 | 41 | |||
| 63529 | 56688 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1865X Grant Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 17346 | 6002930 | 2119911 | 37.801036497901 | -122.434017077007 | (37.801036497901, -122.434017077007) | 13 | 9 | 1 | 57 | 17 | ||
| 142649 | 58321 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1865X Grant Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1978 12:00:00 AM | 12 | 3x3 | Permit Number 17346 | 6002930 | 2119911 | 37.801036497901 | -122.434017077007 | (37.801036497901, -122.434017077007) | 13 | 9 | 1 | 57 | 17 | |
| 121492 | 7292 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1895X Fillmore St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4x4 | 6002963.99476 | 2114778.43194 | 37.7869457171278 | -122.433532436565 | (37.7869457171278, -122.433532436565) | 13 | 9 | 11 | 29490 | 27 | |||
| 101481 | 7279 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1803 Fillmore St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6x6 | 6002990.14459 | 2114551.19489 | 37.7863232654697 | -122.43342571959 | (37.7863232654697, -122.43342571959) | 13 | 9 | 11 | 29490 | 27 |
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) );