trees
194 rows where Supervisor Districts = 1 and qSpecies_id = 53 sorted by Neighborhoods (old)
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) ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
177091 | 108561 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 141 02nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5995170 | 2114629.2 | 37.7860906748156 | -122.460486880145 | (37.7860906748156, -122.460486880145) | 11 | 6 | 1 | 54 | 11 | ||||
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 | |||
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 | |||
177292 | 16729 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1519 O'Farrell St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 5999136.4110982 | 2112734.4359693 | 37.7811155269813 | -122.446627836224 | (37.7811155269813, -122.446627836224) | 15 | 5 | 1 | 54 | 16 | |||
2653 | 100053 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 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 | |
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 | |||
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 | |||||
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 | |||
15062 | 102786 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3345 Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 4.5x6 | Permit Number 772480 | 6003174.4 | 2119873.2 | 37.8009465759098 | -122.433168646536 | (37.8009465759098, -122.433168646536) | 13 | 9 | 1 | 57 | 17 | ||
16922 | 59787 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1755 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1981 12:00:00 AM | Permit Number 19237 | 6004552.42886001 | 2119092.68520918 | 37.7988815571833 | -122.428344419585 | (37.7988815571833, -122.428344419585) | 13 | 9 | 1 | 57 | 17 | ||
20994 | 100049 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | Permit Number 768990 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 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 | ||
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 | |||
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 | |||
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 | ||
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 | ||||
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 | |||||
49412 | 94931 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1771 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6004522 | 2118744 | 37.7979224352085 | -122.428424847305 | (37.7979224352085, -122.428424847305) | 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 | ||||
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 | |||
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 | |||
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 | ||
67334 | 99615 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
75083 | 46223 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1888 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/2002 12:00:00 AM | Permit Number 44530 | 6003335.27744655 | 2119677.01043482 | 37.8004170150887 | -122.432597920925 | (37.8004170150887, -122.432597920925) | 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 | ||||
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 | |||
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 | ||
85651 | 100050 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 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 | ||||
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 | |||
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 | |||
99582 | 99612 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||||
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 | ||
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 | |||||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |
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 | |||
147848 | 101072 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1828 Union St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6004239 | 2118751 | 37.7979256371892 | -122.429404607028 | (37.7979256371892, -122.429404607028) | 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 | ||||
156467 | 109326 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1624 VALLEJO ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005582.1 | 2118270.7 | 37.7966828044962 | -122.424722909098 | (37.7966828044962, -122.424722909098) | 13 | 9 | 1 | 57 | 17 | |||||
158341 | 1760 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 3041X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4x4 | 6005500.29496 | 2120778.87447 | 37.8035649903432 | -122.425184535531 | (37.8035649903432, -122.425184535531) | 13 | 9 | 1 | 28858 | 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 | |||||
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 | |||
175212 | 13101 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1501 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005049.00181 | 2119804.80205 | 37.800864933484 | -122.426676850993 | (37.800864933484, -122.426676850993) | 13 | 9 | 1 | 57 | 17 | |||
176842 | 99613 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
179011 | 100052 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
182401 | 99616 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 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 | ||
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 | |||||
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 | |||
187091 | 100051 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
188786 | 99614 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3233X Buchanan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003300 | 2119605 | 37.8002172925371 | -122.432714848025 | (37.8002172925371, -122.432714848025) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
117 | 108152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
3559 | 55849 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2801X Washington St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/13/2003 12:00:00 AM | Permit Number 46336 | 6001333.31634171 | 2116022.21010841 | 37.7902681559585 | -122.439263383199 | (37.7902681559585, -122.439263383199) | 13 | 6 | 1 | 29490 | 27 | ||
11744 | 56147 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2311 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1973 12:00:00 AM | 16 | Permit Number 12254 | 6001277.58181 | 2116437.20889 | 37.7914044631939 | -122.439485981699 | (37.7914044631939, -122.439485981699) | 13 | 6 | 1 | 29490 | 27 | ||
13236 | 92386 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2810 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/30/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774470 | 6001269 | 2116290 | 37.7909997773984 | -122.439505117215 | (37.7909997773984, -122.439505117215) | 13 | 6 | 1 | 29490 | 27 | |
22585 | 23704 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 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 | |||
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 | |||
37406 | 18007 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2700X Pine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x4 | 6001006.5406952 | 2114902.0443839 | 37.7871738702805 | -122.440313633737 | (37.7871738702805, -122.440313633737) | 13 | 6 | 1 | 29490 | 27 | |||
38327 | 17368 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2308X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6005067.32521 | 2117488.78546 | 37.794506778582 | -122.426448444628 | (37.794506778582, -122.426448444628) | 13 | 9 | 1 | 28858 | 27 | |||
38651 | 113775 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1712 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6000121 | 2114885 | 37.7870766118482 | -122.443376178084 | (37.7870766118482, -122.443376178084) | 13 | 6 | 1 | 29490 | 27 | |||
39309 | 61493 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3149 Washington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/19/1984 12:00:00 AM | Permit Number 777095 | 5999649.96958977 | 2116015.59113069 | 37.7901540469754 | -122.445087143888 | (37.7901540469754, -122.445087143888) | 13 | 6 | 1 | 29490 | 27 | |||
39319 | 23703 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2119X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6005103.6033 | 2116867.23334 | 37.7928022043515 | -122.426278644375 | (37.7928022043515, -122.426278644375) | 13 | 9 | 1 | 28858 | 27 | |||
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 | |||
47028 | 110967 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2439 WASHINGTON ST | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003043 | 2116458 | 37.7915618650441 | -122.433379161821 | (37.7915618650441, -122.433379161821) | 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 | |||
51742 | 11446 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2191X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005072.64937 | 2117089.85961 | 37.7934117301419 | -122.426401604865 | (37.7934117301419, -122.426401604865) | 13 | 9 | 1 | 28858 | 27 | |||
52557 | 106525 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2510 Jackson St | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | 13 | 6 | 1 | 29490 | 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 | |||
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 | ||
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 | |||
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 | ||||
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 | |||
66108 | 92850 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3150 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | Permit Number 53071 | 5999589 | 2116381 | 37.7911538835614 | -122.445324377175 | (37.7911538835614, -122.445324377175) | 13 | 6 | 1 | 29490 | 27 | |||
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 | ||||
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 | |||
72126 | 106522 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2510 Jackson St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | 13 | 6 | 1 | 29490 | 27 | ||||
73128 | 63094 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2780 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/03/1986 12:00:00 AM | 3x3 | Permit Number 23579 | 6001505.6405737 | 2115674.07424093 | 37.789322069479 | -122.438642199545 | (37.789322069479, -122.438642199545) | 13 | 6 | 1 | 29490 | 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 | ||
77904 | 56931 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1909 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 17 | Permit Number 14175 | 6004317.92538 | 2118019.69798 | 37.795922137343 | -122.429079333669 | (37.795922137343, -122.429079333669) | 13 | 9 | 1 | 28858 | 27 | ||
83449 | 106526 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2510 Jackson St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | Permit Number 772624 | 6002049.7 | 2116744.4 | 37.7922918429251 | -122.436836472971 | (37.7922918429251, -122.436836472971) | 13 | 6 | 1 | 29490 | 27 | ||||
84337 | 9917 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1905X Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3x3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
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 |
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) );