trees
1,794 rows where qSpecies_id = 95 sorted by TreeID descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
87430 | 99813 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 721x Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 795-797 Elizabeth St same address; corner property | 6001267.3 | 2102059 | 37.751924908035 | -122.438490940634 | (37.751924908035, -122.438490940634) | 2 | 4 | 5 | 28862 | 22 | |||
110919 | 99784 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 4281 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001386 | 2101717 | 37.7509926092516 | -122.438055964302 | (37.7509926092516, -122.438055964302) | 2 | 4 | 5 | 28862 | 22 | ||||
133804 | 99755 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 519 Clipper St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001824 | 2100869 | 37.7486891023588 | -122.43648063187 | (37.7486891023588, -122.43648063187) | 2 | 4 | 5 | 28862 | 22 | ||||
50176 | 99498 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6002794.02408 | 2092508.79842 | 37.7257889832596 | -122.432529234659 | (37.7257889832596, -122.432529234659) | 9 | 7 | 6 | 28861 | 5 | ||
77601 | 9924 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x3 | 6005199.42754 | 2116554.24063 | 37.7919482211773 | -122.425924797914 | (37.7919482211773, -122.425924797914) | 13 | 9 | 1 | 28858 | 27 | |||
99910 | 9923 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2000 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6005200.36117 | 2116532.07759 | 37.791887419813 | -122.425919989211 | (37.791887419813, -122.425919989211) | 13 | 9 | 1 | 28858 | 27 | |||
25409 | 9921 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1950 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005216.73932 | 2116427.47967 | 37.7916011458249 | -122.425855872064 | (37.7916011458249, -122.425855872064) | 13 | 9 | 1 | 28858 | 27 | |||
92769 | 9919 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
67766 | 9918 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1905X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 20 | 3X3 | Permit Number 768908 | 6005198.9827241 | 2116181.2464075 | 37.7909240477297 | -122.425899774562 | (37.7909240477297, -122.425899774562) | 13 | 9 | 1 | 28858 | 27 | ||
12584 | 9912 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1850 Gough St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X3 | 6005256.71716 | 2116118.9463 | 37.7907562498626 | -122.425695579589 | (37.7907562498626, -122.425695579589) | 13 | 9 | 1 | 28858 | 27 | |||
158881 | 9911 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1850 Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6005261.31756 | 2116094.86183 | 37.7906903799087 | -122.425677947496 | (37.7906903799087, -122.425677947496) | 13 | 9 | 1 | 28858 | 27 | |||
29243 | 9902 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6005282.34014 | 2115923.27251 | 37.7902204265742 | -122.425592993016 | (37.7902204265742, -122.425592993016) | 13 | 9 | 1 | 28858 | 27 | |||
151448 | 9901 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Gough St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6005290.73846 | 2115881.11756 | 37.7901051541858 | -122.42556093401 | (37.7901051541858, -122.42556093401) | 13 | 9 | 1 | 28858 | 27 | |||
48151 | 98950 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 10 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
69454 | 98948 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 95 | 401 Grove St | 8 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
95809 | 9888 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1666 Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6005355.48435 | 2115413.01457 | 37.7888235186322 | -122.425303593892 | (37.7888235186322, -122.425303593892) | 13 | 9 | 1 | 28858 | 41 | |||
180852 | 98066 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5235 Diamond Heights Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6001081.8 | 2099374.5 | 37.7445433581402 | -122.43894005993 | (37.7445433581402, -122.43894005993) | 2 | 7 | 5 | 63 | 22 | |||
52610 | 977 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1599 Alemany Blvd | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6001822.91607 | 2092853.3598 | 37.7266799530333 | -122.43591092131 | (37.7266799530333, -122.43591092131) | 9 | 7 | 6 | 28861 | 25 | |||
106463 | 975 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1599 Alemany Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X5 | 6001957.29298 | 2093112.49768 | 37.7273991195728 | -122.43546491497 | (37.7273991195728, -122.43546491497) | 9 | 7 | 6 | 28861 | 25 | |||
106168 | 97337 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 166 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x6 | 5988702.39254 | 2114219.96893 | 37.7845928511848 | -122.482832802565 | (37.7845928511848, -122.482832802565) | 11 | 6 | 2 | 55 | 26 | |||
187125 | 97314 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 939 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5990332.7 | 2099029.1 | 37.7429775357045 | -122.47608267022 | (37.7429775357045, -122.47608267022) | 1 | 8 | 3 | 29491 | 35 | ||||
2340 | 969 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1594 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X4 | 6001782.25409 | 2092939.24295 | 37.7269134586749 | -122.436057631174 | (37.7269134586749, -122.436057631174) | 9 | 7 | 6 | 28861 | 25 | |||
40944 | 95611 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
67803 | 95610 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
150190 | 95609 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 345 08th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5993380.9 | 2113168.3 | 37.7819763561044 | -122.466570411383 | (37.7819763561044, -122.466570411383) | 11 | 6 | 2 | 54 | 11 | ||||
42509 | 94981 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 1088 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 6007813 | 2118904 | 37.7985474336912 | -122.417048365627 | (37.7985474336912, -122.417048365627) | 5 | 1 | 10 | 308 | 32 | |||
163243 | 94977 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2040@Jackson Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |||
82621 | 94976 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2040@Jackson Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |||
110925 | 94974 | Undocumented 4 | Pittosporum crassifolium :: Karo Tree 95 | 2040@Jackson Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6005619 | 2117006 | 37.7932123416077 | -122.42450522172 | (37.7932123416077, -122.42450522172) | 13 | 9 | 1 | 28858 | 27 | |||
15360 | 94683 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1496 La Playa | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/27/2010 12:00:00 AM | 2 | 3x3 | Permit Number 53823 | 5980955.2273 | 2104911.2096 | 37.7585799229956 | -122.508943475923 | (37.7585799229956, -122.508943475923) | 1 | 8 | 3 | 56 | 35 |
8749 | 934 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1295 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X6 | 6002685.65968 | 2093990.26069 | 37.7298505986268 | -122.43300963811 | (37.7298505986268, -122.43300963811) | 9 | 7 | 6 | 28861 | 25 | |||
170864 | 9339 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 187 Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 6000798.3699591 | 2098653.6744451 | 37.7425480118371 | -122.439868429368 | (37.7425480118371, -122.439868429368) | 2 | 7 | 5 | 63 | 7 | |||
108601 | 9338 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 187 Gold Mine Dr | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 2X2 | 6000798.3699591 | 2098653.6744451 | 37.7425480118371 | -122.439868429368 | (37.7425480118371, -122.439868429368) | 2 | 7 | 5 | 63 | 7 | |||
120111 | 9337 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 187 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 2X2 | 6000798.3699591 | 2098653.6744451 | 37.7425480118371 | -122.439868429368 | (37.7425480118371, -122.439868429368) | 2 | 7 | 5 | 63 | 7 | |||
123897 | 9336 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 183 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 2X2 | 6000834.431691 | 2098665.006699 | 37.7425811802181 | -122.439744551086 | (37.7425811802181, -122.439744551086) | 2 | 7 | 5 | 63 | 7 | |||
148302 | 9320 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
122652 | 9318 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2x2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
125252 | 9316 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
92555 | 9315 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 99X Gold Mine Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 2X2 | 6001391.6487444 | 2098856.3848919 | 37.7431383606087 | -122.437831565564 | (37.7431383606087, -122.437831565564) | 2 | 7 | 5 | 63 | 7 | |||
860 | 9301 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1 Mansell St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6011832.70408 | 2090706.21234 | 37.7213478755834 | -122.401156387751 | (37.7213478755834, -122.401156387751) | 10 | 7 | 8 | 309 | 28 | |||
11325 | 92820 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4410 Geary Blvd | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53029 | 5993333.8 | 2112848.6 | 37.7810958286268 | -122.466710108029 | (37.7810958286268, -122.466710108029) | 11 | 6 | 2 | 54 | 11 | |||
113409 | 92745 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 65 Lily St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2009 12:00:00 AM | Permit Number 52969 | 6006237.3 | 2110147.2 | 37.7744146578956 | -122.42187842919 | (37.7744146578956, -122.42187842919) | 7 | 9 | 11 | 28852 | 10 | |||
82857 | 9274 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6800 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12/24/2014 02:02:00 PM | 3 | 8M | 5985760.86534 | 2112510.31266 | 37.7797270399328 | -122.492883376766 | (37.7797270399328, -122.492883376766) | 11 | 6 | 2 | 55 | 26 | ||
170991 | 9273 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6800 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5985817.56987 | 2112511.8313 | 37.7797345255146 | -122.492687325732 | (37.7797345255146, -122.492687325732) | 11 | 6 | 2 | 55 | 26 | |||
129039 | 9236 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6400 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 18 | 8M | 5987194.6568724 | 2112586.3612843 | 37.7800195894976 | -122.487928920824 | (37.7800195894976, -122.487928920824) | 11 | 6 | 2 | 55 | 26 | |||
64682 | 9162 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6000 Geary Blvd | 4 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5988250.2307 | 2112596.0926 | 37.7801078273208 | -122.484277974986 | (37.7801078273208, -122.484277974986) | 11 | 6 | 2 | 55 | 26 | |||
178988 | 9161 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 6000 Geary Blvd | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5988297.5183 | 2112599.4463 | 37.7801197888911 | -122.48411463373 | (37.7801197888911, -122.48411463373) | 11 | 6 | 2 | 55 | 26 | |||
72960 | 9133 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5845 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/16/1994 12:00:00 AM | 12 | 3X3 | 5988825.8583 | 2112567.4837 | 37.7800627749855 | -122.48228454478 | (37.7800627749855, -122.48228454478) | 11 | 6 | 2 | 55 | 26 | ||
131164 | 9073 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 299X 20TH AVE | 3 | Median : Cutout | Tree | DPW 1 | 12 | 8M | 5989630 | 2113690 | 37.7831916330881 | -122.479584840343 | (37.7831916330881, -122.479584840343) | 11 | 6 | 2 | 55 | 26 | |||
124239 | 9059 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5515 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 5989871.6343 | 2112606.4651 | 37.7802305817586 | -122.478669624646 | (37.7802305817586, -122.478669624646) | 11 | 6 | 2 | 55 | 26 | |||
66420 | 9058 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5515 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1994 12:00:00 AM | 12 | 3x3 | 5989856.0418 | 2112605.3897 | 37.7802267236739 | -122.478723487003 | (37.7802267236739, -122.478723487003) | 11 | 6 | 2 | 55 | 26 | ||
62480 | 9036 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5411 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1994 12:00:00 AM | 12 | 3X3 | 5990215.7457 | 2112619.1004 | 37.780285248386 | -122.477480121729 | (37.780285248386, -122.477480121729) | 11 | 6 | 2 | 55 | 26 | ||
58882 | 9035 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 5411 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/01/1994 12:00:00 AM | 18 | 3X3 | 5990179.7216 | 2112616.9497 | 37.7802772527405 | -122.477604587149 | (37.7802772527405, -122.477604587149) | 11 | 6 | 2 | 55 | 26 | ||
185379 | 9032 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 5401 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/01/1994 12:00:00 AM | 12 | 3X3 | 5990239.95827 | 2112557.38019 | 37.7801171867577 | -122.477391848024 | (37.7801171867577, -122.477391848024) | 11 | 6 | 2 | 55 | 26 | ||
62290 | 89628 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3601 Anza St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/21/2008 12:00:00 AM | 3 | 3x3 | 5987450.45197 | 2111839.29799 | 37.7779832830206 | -122.486989142097 | (37.7779832830206, -122.486989142097) | 11 | 6 | 2 | 55 | 26 | ||
143804 | 88992 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 680 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013080.3 | 2113726.9 | 37.784627230328 | -122.398458274764 | (37.784627230328, -122.398458274764) | 6 | 2 | 9 | 28853 | 6 | ||||
173010 | 8827 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3921 Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 5994748.28687 | 2112776.22267 | 37.7809786291953 | -122.461811476639 | (37.7809786291953, -122.461811476639) | 11 | 6 | 2 | 54 | 11 | |||
85093 | 8821 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3901X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994887.84136 | 2112763.14159 | 37.7809507447777 | -122.461327743547 | (37.7809507447777, -122.461327743547) | 11 | 6 | 2 | 54 | 11 | |||
62861 | 8820 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 3901X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 5994887.84136 | 2112763.14159 | 37.7809507447777 | -122.461327743547 | (37.7809507447777, -122.461327743547) | 11 | 6 | 2 | 54 | 11 | |||
53963 | 84931 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 101 Jefferson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 49345 | 6008717 | 2122460 | 37.8083621304447 | -122.41417194996 | (37.8083621304447, -122.41417194996) | 3 | 1 | 10 | 308 | 23 | ||||
34930 | 84726 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 20 Cherry St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2007 12:00:00 AM | 27 | Permit No. 49296 | 5996103.83143 | 2115975.82593 | 37.7898418245875 | -122.457353550252 | (37.7898418245875, -122.457353550252) | 11 | 6 | 1 | 54 | 31 | ||
20766 | 84183 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 496 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50711 | 6010074.8980178 | 2089472.05898173 | 37.7178609244136 | -122.407145708761 | (37.7178609244136, -122.407145708761) | 10 | 7 | 8 | 309 | 39 | ||
115361 | 83929 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
9102 | 83833 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 1220 La Playa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/28/2008 12:00:00 AM | 3x3 | Permit Number 50199 | 5980896.51884717 | 2106747.16910548 | 37.7636174777723 | -122.509282857292 | (37.7636174777723, -122.509282857292) | 1 | 8 | 3 | 56 | 35 | ||
155144 | 83804 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1930 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/24/2008 12:00:00 AM | 2 | 3x3 | Permit Number 50176 | 5981678.3666 | 2101922.0131 | 37.7504150384206 | -122.506220927159 | (37.7504150384206, -122.506220927159) | 1 | 8 | 3 | 29491 | 35 | |
69066 | 83404 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4161-4165 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/11/2008 12:00:00 AM | 3x3 | Permit Number 50774 | 6002116.5949366 | 2102338.3887788 | 37.7527403167837 | -122.435573947989 | (37.7527403167837, -122.435573947989) | 2 | 4 | 5 | 28862 | 22 | ||
81945 | 83247 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
65349 | 83246 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
154901 | 83220 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4431 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/2008 12:00:00 AM | 3x3 | Permit Number 51278 | 5981138.26503887 | 2104833.82596272 | 37.7583782380396 | -122.508304716049 | (37.7583782380396, -122.508304716049) | 1 | 8 | 3 | 56 | 35 | ||
194218 | 82349 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 238 Lisbon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50654 | 6002996.74050399 | 2092045.80464214 | 37.7245291995552 | -122.431795416268 | (37.7245291995552, -122.431795416268) | 9 | 7 | 6 | 28861 | 5 | ||
614 | 82138 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 360 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 5993114.28903 | 2113170.01374 | 37.7819656727858 | -122.467492879752 | (37.7819656727858, -122.467492879752) | 11 | 6 | 2 | 54 | 11 | |||
164961 | 81981 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 468 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/11/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49994 | 5982862.28104 | 2112646.79088 | 37.779931837918 | -122.502920784353 | (37.779931837918, -122.502920784353) | 11 | 6 | 2 | 55 | 26 | |
128960 | 81950 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2194 44th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/09/2008 12:00:00 AM | 3x3 | Permit Number 50729 | 5982670.93030487 | 2100194.17282904 | 37.7457292516177 | -122.502660748962 | (37.7457292516177, -122.502660748962) | 1 | 8 | 3 | 29491 | 35 | ||
95251 | 81819 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 56 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/2008 12:00:00 AM | 3x3 | Permit Number 50797 | 6001670.65658428 | 2105505.28086123 | 37.7614104988666 | -122.437342827434 | (37.7614104988666, -122.437342827434) | 15 | 4 | 5 | 28862 | 3 | ||
75088 | 80866 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 167 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | 3x3 | Permit Number 50662 | 6003060.92852227 | 2092556.70085542 | 37.7259356446911 | -122.43160998466 | (37.7259356446911, -122.43160998466) | 9 | 7 | 6 | 28861 | 5 | ||
11959 | 80608 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1525 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6013013.8761 | 2105640.89968 | 37.7624212021999 | -122.398120604778 | (37.7624212021999, -122.398120604778) | 10 | 3 | 8 | 28856 | 29 | |||
15534 | 80384 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 10 Bridgeview Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6014069.48963 | 2095395.06223 | 37.7343470415729 | -122.393752415043 | (37.7343470415729, -122.393752415043) | 10 | 3 | 8 | 58 | 1 | |||
45533 | 79908 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 4668 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/24/2007 12:00:00 AM | 3x3 | Permit Number 50048 | 6000123.33109091 | 2105202.65192777 | 37.7604914689072 | -122.442672635485 | (37.7604914689072, -122.442672635485) | 15 | 4 | 5 | 28862 | 3 | ||
43358 | 7984 | Permitted Site 7 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005624.48524 | 2117113.11255 | 37.7935067554767 | -122.424493864894 | (37.7935067554767, -122.424493864894) | 13 | 9 | 1 | 28858 | 27 | |||
133880 | 7983 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005599.00069 | 2117137.84326 | 37.7935732205869 | -122.424583803523 | (37.7935732205869, -122.424583803523) | 13 | 9 | 1 | 28858 | 27 | |||
104123 | 7982 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005602.68214 | 2117114.10003 | 37.7935082355629 | -122.424569375675 | (37.7935082355629, -122.424569375675) | 13 | 9 | 1 | 28858 | 27 | |||
30166 | 7981 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10 | 3X3 | 6005603.29363 | 2117103.29165 | 37.793478593006 | -122.424566490678 | (37.793478593006, -122.424566490678) | 13 | 9 | 1 | 28858 | 27 | |||
30170 | 7980 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2040 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005605.28232 | 2117078.33764 | 37.7934101878854 | -122.424557833777 | (37.7934101878854, -122.424557833777) | 13 | 9 | 1 | 28858 | 27 | |||
87887 | 7973 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1955 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005592.81541 | 2116805.41322 | 37.7926601020218 | -122.42458154712 | (37.7926601020218, -122.42458154712) | 13 | 9 | 1 | 28858 | 27 | |||
61576 | 7964 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1845 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005641.9445 | 2116491.16052 | 37.7918000174095 | -122.424389196528 | (37.7918000174095, -122.424389196528) | 13 | 9 | 1 | 28858 | 27 | |||
122186 | 7958 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1800 Franklin St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6005719.63486 | 2116291.57932 | 37.7912564042045 | -122.424106187976 | (37.7912564042045, -122.424106187976) | 13 | 9 | 1 | 28858 | 27 | |||
88691 | 7956 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1755 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6005681.33133 | 2116176.18238 | 37.7909373903882 | -122.424230506628 | (37.7909373903882, -122.424230506628) | 13 | 9 | 1 | 28858 | 27 | |||
568 | 78813 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 110 Foote Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998921.12979 | 2088066.27223 | 37.713370441156 | -122.445598173631 | (37.713370441156, -122.445598173631) | 9 | 7 | 6 | 28861 | 25 | |||
504 | 78734 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 901 Huron Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5997023.15719 | 2086886.03529 | 37.710021240846 | -122.452073093618 | (37.710021240846, -122.452073093618) | 9 | 7 | 6 | 28861 | 25 | |||
11291 | 78733 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 901.2 Huron Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5997045.64692 | 2086908.46309 | 37.7100841106663 | -122.451996982198 | (37.7100841106663, -122.451996982198) | 9 | 7 | 6 | 28861 | 25 | |||
7430 | 78727 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 110 Foote Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5998904.8782 | 2088083.88832 | 37.7134178830944 | -122.445655610625 | (37.7134178830944, -122.445655610625) | 9 | 7 | 6 | 28861 | 25 | |||
9923 | 78554 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2210 44th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5982671.6049 | 2100049.9563 | 37.745333312577 | -122.50264774354 | (37.745333312577, -122.50264774354) | 1 | 8 | 3 | 29491 | 35 | |||
84632 | 77991 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 163X London St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 04/01/2000 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 | |
118036 | 7723 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 175X Fell St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006514.1274 | 2110757.9768 | 37.7761073119325 | -122.420964203399 | (37.7761073119325, -122.420964203399) | 7 | 9 | 11 | 28852 | 10 | |||
5633 | 76756 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 2 | 3x12 | 5983095.0741 | 2104639.3384 | 37.757959352781 | -122.501522927406 | (37.757959352781, -122.501522927406) | 1 | 8 | 3 | 56 | 35 | ||
3628 | 76755 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 1501X 42nd Ave | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x12 | 5983093.5463 | 2104662.8676 | 37.758023867602 | -122.501529951702 | (37.758023867602, -122.501529951702) | 1 | 8 | 3 | 56 | 35 | ||
18509 | 76705 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 148X Paris St | 5 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 4 | 3x3 | 6003030.53484 | 2092605.75448 | 37.7260686121528 | -122.431718554264 | (37.7260686121528, -122.431718554264) | 9 | 7 | 6 | 28861 | 5 | ||
80091 | 7670 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2574X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5998491.68866 | 2088612.8368 | 37.7148466558292 | -122.447121776248 | (37.7148466558292, -122.447121776248) | 9 | 7 | 6 | 28861 | 25 | |||
40807 | 7669 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 2574X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3X3 | 5998511.51637 | 2088624.61192 | 37.7148801204842 | -122.447054090567 | (37.7148801204842, -122.447054090567) | 9 | 7 | 6 | 28861 | 25 | |||
79676 | 75385 | DPW Maintained 1 | Pittosporum crassifolium :: Karo Tree 95 | 163X London St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 05/08/1992 12:00:00 AM | 10 | 3x3 | 6002837 | 2092721 | 37.7263740781507 | -122.432395819389 | (37.7263740781507, -122.432395819389) | 9 | 7 | 6 | 28861 | 5 |
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) );