trees
3,709 rows where qSpecies_id = 9 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63091 | 110213 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1628 YORK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6010458.2 | 2100135.1 | 37.7471608214363 | -122.406571786092 | (37.7471608214363, -122.406571786092) | 2 | 7 | 7 | 28859 | 2 | |||
129374 | 110930 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 6013101.5791 | 2106846.11839 | 37.7657353505351 | -122.397901817734 | (37.7657353505351, -122.397901817734) | 14 | 3 | 8 | 28856 | 20 | ||||
121366 | 110931 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013092.21392497 | 2107061.02739926 | 37.7663249213263 | -122.397949287209 | (37.7663249213263, -122.397949287209) | 14 | 3 | 8 | 28856 | 20 | |||||
90278 | 110932 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013092.21392497 | 2107061.02739926 | 37.7663249213263 | -122.397949287209 | (37.7663249213263, -122.397949287209) | 14 | 3 | 8 | 28856 | 20 | |||||
78500 | 110933 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013092.21392497 | 2107061.02739926 | 37.7663249213263 | -122.397949287209 | (37.7663249213263, -122.397949287209) | 14 | 3 | 8 | 28856 | 20 | |||||
122964 | 110934 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6013092.21392497 | 2107061.02739926 | 37.7663249213263 | -122.397949287209 | (37.7663249213263, -122.397949287209) | 14 | 3 | 8 | 28856 | 20 | |||||
14018 | 111009 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1801x WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003409 | 2114904 | 37.7873157334926 | -122.432001790592 | (37.7873157334926, -122.432001790592) | 13 | 9 | 11 | 29490 | 27 | ||||
108015 | 111010 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1801x WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003409 | 2114904 | 37.7873157334926 | -122.432001790592 | (37.7873157334926, -122.432001790592) | 13 | 9 | 11 | 29490 | 27 | ||||
158819 | 111011 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 1801x WEBSTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003409 | 2114904 | 37.7873157334926 | -122.432001790592 | (37.7873157334926, -122.432001790592) | 13 | 9 | 11 | 29490 | 27 | ||||
112755 | 111035 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 927 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 774368 | 5999163.7 | 2106974.1 | 37.7653006717936 | -122.446118968287 | (37.7653006717936, -122.446118968287) | 15 | 5 | 11 | 29492 | 9 | ||||
136 | 11131 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2400X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6007074.9072505 | 2120528.613771 | 37.802966665104 | -122.419717737051 | (37.802966665104, -122.419717737051) | 5 | 1 | 1 | 28858 | 32 | |||
143812 | 11132 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2425 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6007002.1553976 | 2120687.0718744 | 37.803397652325 | -122.419980748154 | (37.803397652325, -122.419980748154) | 5 | 1 | 1 | 28858 | 32 | |||
46156 | 11134 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2454 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007041.13953 | 2120754.1462 | 37.8035840176492 | -122.419850604133 | (37.8035840176492, -122.419850604133) | 5 | 1 | 1 | 28858 | 32 | |||
54945 | 11135 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2454 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007038.94291 | 2120769.93446 | 37.8036272444521 | -122.419859326652 | (37.8036272444521, -122.419859326652) | 5 | 1 | 1 | 28858 | 32 | |||
136920 | 11136 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2454 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6007037.38216 | 2120783.1998 | 37.8036635797792 | -122.419865669583 | (37.8036635797792, -122.419865669583) | 5 | 1 | 1 | 28858 | 32 | |||
111979 | 11137 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2455X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6006975.5076786 | 2120876.6023829 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | 5 | 1 | 1 | 28858 | 32 | |||
167879 | 11138 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2455X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6006975.5076786 | 2120876.6023829 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | 5 | 1 | 1 | 28858 | 32 | |||
165790 | 11140 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2455X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6006975.5076786 | 2120876.6023829 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | 5 | 1 | 1 | 28858 | 32 | |||
157799 | 11141 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2455X Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6006975.5076786 | 2120876.6023829 | 37.8039165535698 | -122.420086422377 | (37.8039165535698, -122.420086422377) | 5 | 1 | 1 | 28858 | 32 | |||
87342 | 11143 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.12852 | 2121148.49105 | 37.804660646435 | -122.420255847653 | (37.804660646435, -122.420255847653) | 5 | 1 | 1 | 28858 | 32 | |||
154418 | 11144 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2553X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006934.8566 | 2121129.59308 | 37.8046089111446 | -122.420245064768 | (37.8046089111446, -122.420245064768) | 5 | 1 | 1 | 28858 | 32 | |||
111891 | 11145 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
35922 | 11146 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
187882 | 11147 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 6 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
112297 | 11148 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 4 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 40 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
156707 | 11149 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 5 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
102742 | 11150 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 6 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
161832 | 11151 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 7 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
139815 | 11152 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 2595X Hyde St | 8 | Sidewalk: Curb side : Cutout | Tree | PUC 8 | 36 | 3X3 | 6006932.7654086 | 2121177.816266 | 37.8047412018915 | -122.420255726238 | (37.8047412018915, -122.420255726238) | 5 | 1 | 1 | 28858 | 32 | |||
26318 | 11153 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2603 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006916.69653 | 2121280.21725 | 37.8050214634311 | -122.420318606842 | (37.8050214634311, -122.420318606842) | 5 | 1 | 1 | 28858 | 32 | |||
133899 | 11154 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2603 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006919.78752 | 2121256.32481 | 37.8049560350585 | -122.420306213261 | (37.8049560350585, -122.420306213261) | 5 | 1 | 1 | 28858 | 32 | |||
34833 | 11155 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | 5 | 1 | 1 | 28858 | 32 | |||
129045 | 11156 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2618 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006962.61287 | 2121312.50549 | 37.8051127059477 | -122.420162000697 | (37.8051127059477, -122.420162000697) | 5 | 1 | 1 | 28858 | 32 | |||
150559 | 11157 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2621 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6006915.48876 | 2121316.55267 | 37.8051211631688 | -122.420325367033 | (37.8051211631688, -122.420325367033) | 5 | 1 | 1 | 28858 | 32 | |||
104593 | 11158 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2626 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006955.38483 | 2121356.90745 | 37.8052342151411 | -122.420190167466 | (37.8052342151411, -122.420190167466) | 5 | 1 | 1 | 28858 | 32 | |||
112201 | 11159 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2627 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006915.19061 | 2121341.6845 | 37.8051901519615 | -122.420328183697 | (37.8051901519615, -122.420328183697) | 5 | 1 | 1 | 28858 | 32 | |||
182301 | 11160 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2632 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006954.37609 | 2121379.1362 | 37.80529519278 | -122.420195236936 | (37.80529519278, -122.420195236936) | 5 | 1 | 1 | 28858 | 32 | |||
102723 | 11161 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2638 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3X3 | 6006954.2638733 | 2121382.2190943 | 37.8053036512983 | -122.420195844212 | (37.8053036512983, -122.420195844212) | 5 | 1 | 1 | 28858 | 32 | |||
172291 | 11162 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2640 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006953.5572074 | 2121387.1992739 | 37.8053172857834 | -122.420198643397 | (37.8053172857834, -122.420198643397) | 5 | 1 | 1 | 28858 | 32 | |||
183912 | 11163 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2646 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6006947.21164 | 2121442.50233 | 37.8054687763153 | -122.420224530547 | (37.8054687763153, -122.420224530547) | 5 | 1 | 1 | 28858 | 32 | |||
117137 | 11164 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2650 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6006942.2149 | 2121476.64604 | 37.8055622446775 | -122.42024424729 | (37.8055622446775, -122.42024424729) | 5 | 1 | 1 | 28858 | 32 | |||
102942 | 11165 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2655 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6006893.18193 | 2121482.83945 | 37.8055764872155 | -122.42041437295 | (37.8055764872155, -122.42041437295) | 5 | 1 | 1 | 28858 | 32 | |||
76276 | 11166 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2655 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006897.54428 | 2121449.51941 | 37.8054852447207 | -122.420396909886 | (37.8054852447207, -122.420396909886) | 5 | 1 | 1 | 28858 | 32 | |||
93468 | 11167 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2655 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | 3X3 | 6006899.01173 | 2121433.76541 | 37.805442070952 | -122.420390712665 | (37.805442070952, -122.420390712665) | 5 | 1 | 1 | 28858 | 32 | |||
3058 | 11168 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2666 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | 3X3 | 6006944.2763295 | 2121452.6056321 | 37.8054963520093 | -122.420235406119 | (37.8054963520093, -122.420235406119) | 5 | 1 | 1 | 28858 | 32 | |||
89322 | 11169 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2700 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006924.13035 | 2121583.86925 | 37.8058556331999 | -122.420314446577 | (37.8058556331999, -122.420314446577) | 5 | 1 | 1 | 28858 | 32 | |||
183018 | 11170 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2706 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006921.64786 | 2121607.86712 | 37.805921385333 | -122.42032474199 | (37.805921385333, -122.42032474199) | 5 | 1 | 1 | 28858 | 32 | |||
95330 | 11171 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2714 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3X3 | 6006919.28151 | 2121625.44427 | 37.8059695143526 | -122.420334179488 | (37.8059695143526, -122.420334179488) | 5 | 1 | 1 | 28858 | 32 | |||
16856 | 11172 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2717 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6006856.95142 | 2121692.8865 | 37.8061511809927 | -122.420554673483 | (37.8061511809927, -122.420554673483) | 5 | 1 | 1 | 28858 | 32 | |||
32861 | 11174 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2721 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006871.9159428 | 2121607.3582758 | 37.8059171856884 | -122.420496811264 | (37.8059171856884, -122.420496811264) | 5 | 1 | 1 | 28858 | 32 | |||
184736 | 111773 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 215 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 5998285.1385 | 2109899.1988 | 37.7732820368573 | -122.449368462439 | (37.7732820368573, -122.449368462439) | 15 | 5 | 11 | 29492 | 16 | |||
1842 | 11178 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2741 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6006856.2652 | 2121744.00393 | 37.8062914977061 | -122.420560679149 | (37.8062914977061, -122.420560679149) | 5 | 1 | 1 | 28858 | 32 | |||
39137 | 11183 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2765 Hyde St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/15/1997 12:00:00 AM | 12 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | ||
98064 | 11184 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2765 Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 3X3 | 6006851.5978528 | 2121751.8788051 | 37.8063128570627 | -122.420577390706 | (37.8063128570627, -122.420577390706) | 5 | 1 | 1 | 28858 | 32 | |||
129712 | 111972 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 240 Bridgeview Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/22/2015 12:00:00 AM | 1 | 3x3 | 6012967.33594 | 2095411.30766 | 37.7343303393552 | -122.39756408274 | (37.7343303393552, -122.39756408274) | 10 | 3 | 8 | 58 | 1 | ||
72661 | 11198 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 186 Idora Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 8 | 5995344.6608195 | 2099448.7962231 | 37.7444192662253 | -122.458783177848 | (37.7444192662253, -122.458783177848) | 1 | 8 | 4 | 59 | 40 | |||
115231 | 112118 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1816 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775883 | 5999532.43444 | 2115241.76784 | 37.7880226220009 | -122.445438140154 | (37.7880226220009, -122.445438140154) | 13 | 6 | 1 | 29490 | 27 | |
148340 | 112292 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 501x 27TH AVE | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3xe | 5987510 | 2112219 | 37.7790293092803 | -122.486811036923 | (37.7790293092803, -122.486811036923) | 11 | 6 | 2 | 55 | 26 | ||||
83873 | 112293 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 501x 27TH AVE | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3xe | 5987510 | 2112219 | 37.7790293092803 | -122.486811036923 | (37.7790293092803, -122.486811036923) | 11 | 6 | 2 | 55 | 26 | ||||
151308 | 112345 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 12 Perine Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 2x2 | 6002270.40051 | 2115593.91143 | 37.7891454381677 | -122.435990485098 | (37.7891454381677, -122.435990485098) | 13 | 6 | 1 | 29490 | 27 | |||
140000 | 112425 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17 Arguello Blvd | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3x3 | Permit Number 774100 | 5995478.7 | 2115781.3 | 37.7892717842545 | -122.459502338276 | (37.7892717842545, -122.459502338276) | 11 | 6 | 1 | 54 | 11 | ||
58109 | 112429 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17 Arguello Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3x3 | 5995478.7 | 2115781.3 | 37.7892717842545 | -122.459502338276 | (37.7892717842545, -122.459502338276) | 11 | 6 | 1 | 54 | 11 | |||
171304 | 112430 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 17 Arguello Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 07/29/2015 12:00:00 AM | 3x3 | 5995478.7 | 2115781.3 | 37.7892717842545 | -122.459502338276 | (37.7892717842545, -122.459502338276) | 11 | 6 | 1 | 54 | 11 | |||
176712 | 112433 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Arguello Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 3x3 | Permit Number 774101 | 5995479 | 2115773.8 | 37.7892512085361 | -122.459500756916 | (37.7892512085361, -122.459500756916) | 11 | 6 | 1 | 54 | 11 | |||
57072 | 112434 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 19 Arguello Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 774101 | 5995479 | 2115773.8 | 37.7892512085361 | -122.459500756916 | (37.7892512085361, -122.459500756916) | 11 | 6 | 1 | 54 | 11 | |||
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 | ||||
146995 | 112519 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 152x Arleta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 6010410.07132 | 2087941.8611 | 37.7136780650609 | -122.4058794257 | (37.7136780650609, -122.4058794257) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
16991 | 112614 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 1799x 22ND ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 12/09/2015 12:00:00 AM | 3 | Permit Number 776524 | 6012792 | 2103743 | 37.7571976263526 | -122.398754797925 | (37.7571976263526, -122.398754797925) | 10 | 3 | 8 | 28856 | 29 | ||
142720 | 112712 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 416 Bay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008783.11467 | 2121477.20046 | 37.8056673241578 | -122.413873574 | (37.8056673241578, -122.413873574) | 3 | 1 | 10 | 308 | 23 | |||
125249 | 112713 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 416 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6008763.59145 | 2121474.42141 | 37.80565859714 | -122.41394094044 | (37.80565859714, -122.41394094044) | 3 | 1 | 10 | 308 | 23 | |||
20724 | 112714 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 416 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6008746.75593 | 2121471.08922 | 37.8056485022522 | -122.413998966505 | (37.8056485022522, -122.413998966505) | 3 | 1 | 10 | 308 | 23 | |||
183171 | 113075 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 3456 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/14/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775955 | 5999259.12859 | 2120682.68554 | 37.8029463281663 | -122.446775374497 | (37.8029463281663, -122.446775374497) | 13 | 9 | 1 | 57 | 17 | |
95008 | 113138 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 1314 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 3x3 | 5989906.482 | 2103151.3142 | 37.754271329673 | -122.477857678481 | (37.754271329673, -122.477857678481) | 1 | 8 | 3 | 56 | 35 | |||
2714 | 113322 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | ||||
101830 | 113323 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 100 Church St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6004079.74050315 | 2108375.213269 | 37.7694273021614 | -122.42921545709 | (37.7694273021614, -122.42921545709) | 7 | 9 | 5 | 28862 | 3 | |||
83610 | 113527 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 2 Connecticut St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 6013095.17315 | 2106916.8102 | 37.7659290977746 | -122.39792893408 | (37.7659290977746, -122.39792893408) | 14 | 3 | 8 | 28856 | 20 | ||||
69927 | 113600 | Section 143 10 | Olea europaea :: Olive Tree 9 | 550 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773946 | 6009233 | 2105681 | 37.7623199946126 | -122.411200142124 | (37.7623199946126, -122.411200142124) | 8 | 4 | 7 | 28859 | 19 | |
157435 | 113601 | Section 143 10 | Olea europaea :: Olive Tree 9 | 550 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233 | 2105681 | 37.7623199946126 | -122.411200142124 | (37.7623199946126, -122.411200142124) | 8 | 4 | 7 | 28859 | 19 | ||
71895 | 113602 | Section 143 10 | Olea europaea :: Olive Tree 9 | 550 FLORIDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233 | 2105681 | 37.7623199946126 | -122.411200142124 | (37.7623199946126, -122.411200142124) | 8 | 4 | 7 | 28859 | 19 | ||
89445 | 113603 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
163668 | 113604 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
59693 | 113605 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
15934 | 113606 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
138839 | 113607 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
115452 | 113608 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
181612 | 113609 | Section 143 10 | Olea europaea :: Olive Tree 9 | 2900 18TH ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009122 | 2105484 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | 8 | 4 | 7 | 28859 | 19 | |||
38713 | 113610 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
106808 | 113611 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
193056 | 113612 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
65275 | 113613 | Section 143 10 | Olea europaea :: Olive Tree 9 | 595 ALABAMA ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/2015 12:00:00 AM | 3x3 | 6009000 | 2105472 | 37.7617330585457 | -122.411991234579 | (37.7617330585457, -122.411991234579) | 8 | 4 | 7 | 28859 | 19 | |||
145786 | 11431 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 301X Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/15/2002 12:00:00 AM | 3 | 3X3 | 6012526.0110026 | 2118137.4589098 | 37.796706690547 | -122.400685892184 | (37.796706690547, -122.400685892184) | 3 | 1 | 10 | 28860 | 4 | ||
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 | |||
30260 | 114430 | Significant Tree 6 | Olea europaea :: Olive Tree 9 | 455 EDDY ST | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3x3 | 6008254 | 2113439 | 37.7835666804498 | -122.415135318852 | (37.7835666804498, -122.415135318852) | 7 | 10 | 9 | 28852 | 36 | ||||
33765 | 114495 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6013529.42992 | 2111411.97981 | 37.7782959999017 | -122.396742081688 | (37.7782959999017, -122.396742081688) | 6 | 2 | 9 | 28856 | 34 | |||
11947 | 114496 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6013514.3964 | 2111397.60401 | 37.778255690483 | -122.396793080454 | (37.778255690483, -122.396793080454) | 6 | 2 | 9 | 28856 | 34 | |||
22646 | 114497 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6013500.00708 | 2111383.84435 | 37.7782171086788 | -122.396841893834 | (37.7782171086788, -122.396841893834) | 6 | 2 | 9 | 28856 | 34 | |||
179680 | 114498 | DPW Maintained 1 | Olea europaea :: Olive Tree 9 | 506 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/27/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777227 | 6013489.27726 | 2111373.99556 | 37.778189468908 | -122.396878321792 | (37.778189468908, -122.396878321792) | 6 | 2 | 9 | 28856 | 34 | |
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 | |||
152077 | 114739 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 188 BUCHANAN ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6004735 | 2109327 | 37.7720777510232 | -122.427016741179 | (37.7720777510232, -122.427016741179) | 7 | 9 | 5 | 28852 | 10 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );