trees
150 rows where Supervisor Districts = 7 and qSpecies_id = 53 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
148177 | 100480 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 245 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6007080 | 2107899 | 37.7682891227663 | -122.418803888241 | (37.7682891227663, -122.418803888241) | 8 | 4 | 7 | 28853 | 19 | |||
150296 | 100481 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1849 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | Permit Number 26048 | 6008683 | 2107773 | 37.7680332828269 | -122.413250335235 | (37.7680332828269, -122.413250335235) | 8 | 4 | 7 | 28853 | 19 | ||
133574 | 100482 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1849 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008683 | 2107773 | 37.7680332828269 | -122.413250335235 | (37.7680332828269, -122.413250335235) | 8 | 4 | 7 | 28853 | 19 | |||
117580 | 100483 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1849 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6008683 | 2107773 | 37.7680332828269 | -122.413250335235 | (37.7680332828269, -122.413250335235) | 8 | 4 | 7 | 28853 | 19 | |||
71888 | 102035 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2400 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x5 | 6008197 | 2104472 | 37.7589422028837 | -122.414697726814 | (37.7589422028837, -122.414697726814) | 2 | 4 | 7 | 28859 | 19 | |||
117076 | 102235 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1104 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009987 | 2102770 | 37.7543693005663 | -122.408386989199 | (37.7543693005663, -122.408386989199) | 2 | 4 | 7 | 28859 | 19 | ||||
97918 | 102451 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | |||
133761 | 102454 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
119605 | 102455 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
10859 | 102456 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
64858 | 102457 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3365 20th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6007790 | 2104415 | 37.7587628183764 | -122.416101290754 | (37.7587628183764, -122.416101290754) | 2 | 4 | 7 | 28859 | 19 | |||
8209 | 103628 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
112964 | 103629 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
120567 | 103630 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
92126 | 103631 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
164853 | 103632 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
122861 | 103633 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
136552 | 103634 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
95503 | 103635 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
166088 | 103636 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
160281 | 103637 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 1450X Stevenson St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | Permit Number 777592 | 6006328.29748 | 2108087.53462 | 37.7687644406503 | -122.421417350008 | (37.7687644406503, -122.421417350008) | 8 | 4 | 7 | 28853 | 19 | ||
76306 | 108943 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 105 Richland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | 2 | 7 | 7 | 28859 | 2 | |||||
32689 | 108945 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 105 Richland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005294.9 | 2096235.5 | 37.7361631827636 | -122.424148798432 | (37.7361631827636, -122.424148798432) | 2 | 7 | 7 | 28859 | 2 | |||||
51092 | 109603 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 602 SHOTWELL ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007851.6 | 2104381.9 | 37.758675396701 | -122.415885905109 | (37.758675396701, -122.415885905109) | 2 | 4 | 7 | 28859 | 19 | ||||
99827 | 109850 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3250x 22ND ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6006518 | 2103190 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | 2 | 4 | 7 | 28859 | 19 | |||
60410 | 111206 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
63970 | 111213 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
64312 | 111215 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3100x 19TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008781 | 2105093 | 37.7606801217813 | -122.412721875792 | (37.7606801217813, -122.412721875792) | 2 | 4 | 7 | 28859 | 19 | |||
135014 | 111218 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
61037 | 111219 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
188189 | 111222 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
56413 | 111223 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
142406 | 111224 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
21841 | 111225 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
110191 | 111226 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3150x 19TH ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008324 | 2105048 | 37.7605309015758 | -122.41429925401 | (37.7605309015758, -122.41429925401) | 2 | 4 | 7 | 28859 | 19 | |||
152427 | 112646 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 3101 26TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6008718 | 2100791 | 37.7488642652044 | -122.412635640211 | (37.7488642652044, -122.412635640211) | 2 | 4 | 7 | 28859 | 19 | |||
110718 | 113188 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x12 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
25734 | 113701 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 12 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6007151 | 2099622 | 37.7455663833026 | -122.417971480149 | (37.7455663833026, -122.417971480149) | 2 | 7 | 7 | 28859 | 2 | |||
79797 | 113702 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 14 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6007138 | 2099599 | 37.7455024988094 | -122.418014802057 | (37.7455024988094, -122.418014802057) | 2 | 7 | 7 | 28859 | 2 | |||
81588 | 113833 | Significant Tree 6 | Ficus nitida :: Laurel Fig 53 | 932 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6007966 | 2102301 | 37.7529681504442 | -122.415342945464 | (37.7529681504442, -122.415342945464) | 2 | 4 | 7 | 28859 | 19 | ||||
122363 | 116519 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2050 BRYANT ST | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6009415 | 2105202 | 37.7610149749795 | -122.410536843727 | (37.7610149749795, -122.410536843727) | 2 | 4 | 7 | 28859 | 19 | |||
169697 | 117565 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
99014 | 117566 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2450 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 3x3 | 6008799 | 2104200 | 37.7582291576174 | -122.412596493354 | (37.7582291576174, -122.412596493354) | 2 | 4 | 7 | 28859 | 19 | |||
106094 | 117567 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2498 HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6008843 | 2103923 | 37.7574710478396 | -122.41242474225 | (37.7574710478396, -122.41242474225) | 2 | 4 | 7 | 28859 | 19 | |||
106064 | 121117 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | |||
64233 | 121118 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
77226 | 121119 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
131499 | 121120 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
56222 | 121122 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 6 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | ||||
151070 | 121123 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2701X 24th St | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 24 | 3x3 | 6010429 | 2102109 | 37.7525790830309 | -122.406811850318 | (37.7525790830309, -122.406811850318) | 10 | 4 | 7 | 28859 | 19 | |||
177969 | 122633 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 260 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6006915 | 2105702 | 37.7622473847542 | -122.419218743707 | (37.7622473847542, -122.419218743707) | 8 | 4 | 7 | 28859 | 19 | |||
146667 | 15335 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1720 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006691.81678 | 2108397.85831 | 37.7696370050813 | -122.420181988192 | (37.7696370050813, -122.420181988192) | 8 | 4 | 7 | 28853 | 19 | |||
70053 | 15430 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2125 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6006871.65728 | 2105982.3734 | 37.7630147835921 | -122.419388541195 | (37.7630147835921, -122.419388541195) | 8 | 4 | 7 | 28859 | 19 | |||
80775 | 15434 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2137 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006871.30054 | 2105936.92899 | 37.7628899837695 | -122.419386550959 | (37.7628899837695, -122.419386550959) | 8 | 4 | 7 | 28859 | 19 | |||
70074 | 173891 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 24 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007185 | 2099410 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | 2 | 7 | 7 | 28859 | 2 | ||||
145761 | 173892 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 24 Prospect Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007185 | 2099410 | 37.7449861923813 | -122.417838888286 | (37.7449861923813, -122.417838888286) | 2 | 7 | 7 | 28859 | 2 | ||||
32305 | 173934 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9x9 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||||
53550 | 18383 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 804 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 3x3 | 6010399.792436 | 2104541.9824298 | 37.7592578761131 | -122.407084334673 | (37.7592578761131, -122.407084334673) | 10 | 4 | 7 | 28859 | 19 | |||
142871 | 18385 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 812 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 16x5 | 6010402.1602537 | 2104496.7929466 | 37.759133928444 | -122.407072960308 | (37.759133928444, -122.407072960308) | 10 | 4 | 7 | 28859 | 19 | |||
158510 | 18390 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 866 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3x3 | 6010418.2672605 | 2104189.3928818 | 37.7582907781506 | -122.406995587546 | (37.7582907781506, -122.406995587546) | 10 | 4 | 7 | 28859 | 19 | |||
97770 | 18392 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
186502 | 18393 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 886 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 6010424.2598856 | 2104075.0244367 | 37.7579770833513 | -122.406966801395 | (37.7579770833513, -122.406966801395) | 10 | 4 | 7 | 28859 | 19 | |||
66172 | 18444 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1020 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010472.2950908 | 2103284.5044843 | 37.7558091798762 | -122.406744963711 | (37.7558091798762, -122.406744963711) | 10 | 4 | 7 | 28859 | 19 | |||
185861 | 18445 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1024 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 4x4 | 6010473.6370906 | 2103261.6949103 | 37.7557466249525 | -122.406738715199 | (37.7557466249525, -122.406738715199) | 10 | 4 | 7 | 28859 | 19 | |||
139905 | 18447 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1036 Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6010477.6303584 | 2103193.8225196 | 37.7555604859056 | -122.406720122129 | (37.7555604859056, -122.406720122129) | 10 | 4 | 7 | 28859 | 19 | |||
141160 | 18451 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1082 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4x4 | 6010493.0142586 | 2102932.3469158 | 37.7548433927728 | -122.40664849396 | (37.7548433927728, -122.40664849396) | 10 | 4 | 7 | 28859 | 19 | |||
191197 | 18454 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1106 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3x3 | 6010521.1889393 | 2102709.7477141 | 37.7542337610764 | -122.406535372627 | (37.7542337610764, -122.406535372627) | 10 | 4 | 7 | 28859 | 19 | |||
133106 | 18462 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1170 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6010530.25012 | 2102443.0228 | 37.7535019005095 | -122.406485243092 | (37.7535019005095, -122.406485243092) | 10 | 4 | 7 | 28859 | 19 | |||
91776 | 18465 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1176 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/05/2015 12:00:00 AM | 45 | 3X4 | 6010529.14326 | 2102401.59944 | 37.7533880992141 | -122.40648615219 | (37.7533880992141, -122.40648615219) | 10 | 4 | 7 | 28859 | 19 | ||
172812 | 18468 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 4X4 | 6010533.61703 | 2102196.70237 | 37.7528257474783 | -122.406456244122 | (37.7528257474783, -122.406456244122) | 10 | 4 | 7 | 28859 | 19 | |||
24869 | 18469 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1200X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 4X4 | 6010532.643 | 2102160.24981 | 37.7527256023187 | -122.406457044136 | (37.7527256023187, -122.406457044136) | 10 | 4 | 7 | 28859 | 19 | |||
133311 | 26518 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2881 Harrison St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6009034.88918 | 2101730.9691 | 37.7514629908808 | -122.411606237117 | (37.7514629908808, -122.411606237117) | 2 | 4 | 7 | 28859 | 19 | |||
172873 | 33586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 248 Bonview St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/11/2006 12:00:00 AM | 3x3 | Permit Number 48813 | 6006863.32350459 | 2097675.63643968 | 37.7402059100197 | -122.418828210102 | (37.7402059100197, -122.418828210102) | 2 | 7 | 7 | 28859 | 2 | ||
165793 | 39111 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 145 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | 20 | Permit Number 40799 | 6006719.36046982 | 2102938.94159671 | 37.7546496469874 | -122.41969933167 | (37.7546496469874, -122.41969933167) | 2 | 4 | 7 | 28859 | 19 | |
64328 | 44245 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 10 Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43680 | 6010447.16728471 | 2099896.56831072 | 37.7465052482739 | -122.406593130128 | (37.7465052482739, -122.406593130128) | 2 | 7 | 7 | 28859 | 2 | |||
145968 | 45426 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||
78273 | 45427 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | 9x9 | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | ||
132675 | 45428 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 614 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/12/2001 12:00:00 AM | Permit Number 44218 | 6008960.61704517 | 2105361.82717089 | 37.7614283394777 | -122.412119658359 | (37.7614283394777, -122.412119658359) | 2 | 4 | 7 | 28859 | 19 | |||
151621 | 482 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 1182X Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3x3 | 6010538.0981 | 2102333.37734 | 37.7532012773937 | -122.406450377502 | (37.7532012773937, -122.406450377502) | 10 | 4 | 7 | 28859 | 19 | |||
33912 | 484 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2704 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010466.15731 | 2102352.85565 | 37.7532507356841 | -122.406700537042 | (37.7532507356841, -122.406700537042) | 10 | 4 | 7 | 28859 | 19 | |||
16900 | 485 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2706 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010468.2249 | 2102315.41281 | 37.7531480416193 | -122.406690748371 | (37.7531480416193, -122.406690748371) | 10 | 4 | 7 | 28859 | 19 | |||
142433 | 486 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2708 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010515.41751 | 2102258.44338 | 37.7529942564805 | -122.406523532023 | (37.7529942564805, -122.406523532023) | 10 | 4 | 7 | 28859 | 19 | |||
64711 | 488 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2728 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
178044 | 48952 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 3046 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/26/2002 12:00:00 AM | 28 | Permit Number 46137 | 6008657.12939462 | 2102169.92315078 | 37.7526470627455 | -122.412943613067 | (37.7526470627455, -122.412943613067) | 2 | 4 | 7 | 28859 | 19 | |
90532 | 490 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2734 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010357.12636 | 2102291.83707 | 37.7530770912847 | -122.407073289419 | (37.7530770912847, -122.407073289419) | 10 | 4 | 7 | 28859 | 19 | |||
127664 | 499 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2751 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/29/2017 12:00:00 AM | 3 | 4x4 | Permit Number 780031 | 6010232.5569 | 2102206.4482 | 37.7528356605554 | -122.407498057365 | (37.7528356605554, -122.407498057365) | 2 | 4 | 7 | 28859 | 19 | |
70728 | 504 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2763 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6010225.39225 | 2102202.2647 | 37.7528237725585 | -122.407522539236 | (37.7528237725585, -122.407522539236) | 2 | 4 | 7 | 28859 | 19 | |||
191336 | 505 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2766X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010189.63609 | 2102250.35484 | 37.7529538159215 | -122.407649581645 | (37.7529538159215, -122.407649581645) | 2 | 4 | 7 | 28859 | 19 | |||
71942 | 50566 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
115348 | 50571 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | ||
173070 | 50573 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2295 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/2003 12:00:00 AM | Permit Number 47188 | 6008194 | 2105070 | 37.7605840051662 | -122.414750422926 | (37.7605840051662, -122.414750422926) | 2 | 4 | 7 | 28859 | 19 | |||
121361 | 506 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2773 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.7526526827318 | -122.407779587097 | (37.7526526827318, -122.407779587097) | 2 | 4 | 7 | 28859 | 19 | |||
152589 | 510 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2781 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010149.8233 | 2102141.49518 | 37.7526526827318 | -122.407779587097 | (37.7526526827318, -122.407779587097) | 2 | 4 | 7 | 28859 | 19 | |||
145297 | 511 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2782 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6010123.24297 | 2102258.68458 | 37.7529729707581 | -122.407879770058 | (37.7529729707581, -122.407879770058) | 2 | 4 | 7 | 28859 | 19 | |||
23368 | 512 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 2790 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6010086.59475 | 2102267.66488 | 37.7529955768562 | -122.408007140426 | (37.7529955768562, -122.408007140426) | 2 | 4 | 7 | 28859 | 19 | |||
20364 | 516 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2800 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6010023.971 | 2102231.13329 | 37.7528917628192 | -122.408221130018 | (37.7528917628192, -122.408221130018) | 2 | 4 | 7 | 28859 | 19 | |||
44695 | 525 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2829 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6009855.90033 | 2102163.70478 | 37.7526972066188 | -122.408797595672 | (37.7526972066188, -122.408797595672) | 2 | 4 | 7 | 28859 | 19 | |||
126549 | 541 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2869 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009654.44601 | 2102141.49288 | 37.752624931831 | -122.409492696033 | (37.752624931831, -122.409492696033) | 2 | 4 | 7 | 28859 | 19 | |||
115602 | 550 | DPW Maintained 1 | Ficus nitida :: Laurel Fig 53 | 2899 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6009498.42946 | 2102171.88233 | 37.7526996313063 | -122.410034375932 | (37.7526996313063, -122.410034375932) | 2 | 4 | 7 | 28859 | 19 | |||
90722 | 56236 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 147 Bartlett St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/20/1973 12:00:00 AM | 24 | Permit Number 12362 | 6006719.97734959 | 2102927.77810186 | 37.7546190293471 | -122.419696406291 | (37.7546190293471, -122.419696406291) | 2 | 4 | 7 | 28859 | 19 |
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) );