trees
2,694 rows where qSpecies_id = 84 sorted by Location
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
884 | 261406 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
3071 | 31851 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
4023 | 31850 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
4740 | 119761 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
4940 | 39332 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
5244 | 261407 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
6169 | 39333 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
7788 | 39331 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
8270 | 261411 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
8717 | 119762 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
8992 | 261405 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
10081 | 119760 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
11366 | 53918 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
12262 | 261408 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14089 | 261410 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
14566 | 31845 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
15267 | 119759 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 101X Octavia St Frontage West | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | ||||||||||||||
15516 | 39334 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 0 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/21/1998 12:00:00 AM | Permit Number 40897 | |||||||||||||
16965 | 31849 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35298 | ||||||||||||||
17187 | 261409 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
18369 | 261412 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 779 Broadway | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | |||||||||||||||
19387 | 31852 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 1117 Houston St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/19/1995 12:00:00 AM | Permit Number 35299 | |||||||||||||
91328 | 178905 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 320 Hanover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5999575.27021 | 2086527.10376 | 37.7091815546459 | -122.443226763913 | (37.7091815546459, -122.443226763913) | 9 | 7 | 6 | 28861 | 5 | |||
194112 | 117182 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 26 Watt Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6000152.35367 | 2086600.71374 | 37.709416560993 | -122.441237557982 | (37.709416560993, -122.441237557982) | 9 | 7 | 6 | 28861 | 5 | |||
132970 | 178914 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993788.47929 | 2086756.58168 | 37.7094799730978 | -122.463243292153 | (37.7094799730978, -122.463243292153) | 9 | 8 | 6 | 28861 | 25 | ||||
162711 | 178915 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993789.8911 | 2086758.89685 | 37.7094864113418 | -122.46323858062 | (37.7094864113418, -122.46323858062) | 9 | 8 | 6 | 28861 | 25 | ||||
107115 | 178916 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993790.44094 | 2086761.47706 | 37.7094935276652 | -122.463236867396 | (37.7094935276652, -122.463236867396) | 9 | 8 | 6 | 28861 | 25 | ||||
86015 | 178907 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993774.9758 | 2086763.55645 | 37.7094983462303 | -122.463290467905 | (37.7094983462303, -122.463290467905) | 9 | 8 | 6 | 28861 | 25 | ||||
191625 | 178917 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993792.21408 | 2086763.29106 | 37.7094986106303 | -122.463230870712 | (37.7094986106303, -122.463230870712) | 9 | 8 | 6 | 28861 | 25 | ||||
32055 | 178918 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993792.01538 | 2086765.64003 | 37.7095050489005 | -122.46323172778 | (37.7095050489005, -122.46323172778) | 9 | 8 | 6 | 28861 | 25 | ||||
111461 | 178908 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993776.62184 | 2086766.22044 | 37.7095057557476 | -122.463284972138 | (37.7095057557476, -122.463284972138) | 9 | 8 | 6 | 28861 | 25 | ||||
24064 | 178910 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993781.83724 | 2086767.02745 | 37.7095082720684 | -122.463267005492 | (37.7095082720684, -122.463267005492) | 9 | 8 | 6 | 28861 | 25 | ||||
193655 | 178919 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5993793.90715 | 2086767.20458 | 37.7095094537686 | -122.463225303004 | (37.7095094537686, -122.463225303004) | 9 | 8 | 6 | 28861 | 25 | ||||
115257 | 178920 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 15 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5993797.37837 | 2086767.25523 | 37.7095097928145 | -122.463213309645 | (37.7095097928145, -122.463213309645) | 9 | 8 | 6 | 28861 | 25 | ||||
139728 | 178909 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5993779.42986 | 2086768.12245 | 37.7095111399898 | -122.463275405145 | (37.7095111399898, -122.463275405145) | 9 | 8 | 6 | 28861 | 25 | ||||
129593 | 178911 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 5993783.22919 | 2086769.82188 | 37.7095160251039 | -122.463262397352 | (37.7095160251039, -122.463262397352) | 9 | 8 | 6 | 28861 | 25 | ||||
44352 | 178912 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5993780.74611 | 2086770.03775 | 37.7095164747811 | -122.463270994886 | (37.7095164747811, -122.463270994886) | 9 | 8 | 6 | 28861 | 25 | ||||
102862 | 178921 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 5993794.96049 | 2086770.14434 | 37.7095175863374 | -122.463221875682 | (37.7095175863374, -122.463221875682) | 9 | 8 | 6 | 28861 | 25 | ||||
76871 | 178913 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 263 Flournoy St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 5993781.9303 | 2086773.16178 | 37.7095251208514 | -122.463267128695 | (37.7095251208514, -122.463267128695) | 9 | 8 | 6 | 28861 | 25 | ||||
168274 | 37344 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 571 Brunswick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | Permit Number 39852 | 5999120.28976365 | 2086823.35415522 | 37.7099690371181 | -122.444820521553 | (37.7099690371181, -122.444820521553) | 9 | 7 | 6 | 28861 | 5 | ||
80325 | 178895 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 240 Concord St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 10ft | 5999918.78145 | 2087003.9139 | 37.7105103506437 | -122.442073742208 | (37.7105103506437, -122.442073742208) | 9 | 7 | 6 | 28861 | 5 | |||
159518 | 51531 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 175 Rae Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | 1 | Permit Number 47833 | 5997697.55511 | 2087175.49932 | 37.7108546506849 | -122.449763101302 | (37.7108546506849, -122.449763101302) | 9 | 7 | 6 | 28861 | 25 | ||
62393 | 51530 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 169 Rae Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2005 12:00:00 AM | Permit Number 47832 | 5997730.87276608 | 2087189.13752554 | 37.7108940042642 | -122.449648930425 | (37.7108940042642, -122.449648930425) | 9 | 7 | 6 | 28861 | 25 | |||
121404 | 54661 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 345 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/27/1972 12:00:00 AM | 2 | Permit Number 10485 | 6012308.35839 | 2086909.49761 | 37.7109493816857 | -122.399245788885 | (37.7109493816857, -122.399245788885) | 10 | 3 | 8 | 309 | 1 | ||
190721 | 108896 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 312 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772786 | 6000205.0169 | 2087170.16849 | 37.7109831566161 | -122.441096373403 | (37.7109831566161, -122.441096373403) | 9 | 7 | 6 | 28861 | 5 |
137148 | 178896 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 424 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6012763.5947 | 2086999.98496 | 37.7112232027683 | -122.397678716599 | (37.7112232027683, -122.397678716599) | 10 | 3 | 8 | 309 | 1 | |||
59660 | 89359 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 308 Tocoloma Ave | 3 | Front Yard : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 3x3 | Permit Number 50704 | 6012556.9 | 2087009.2 | 37.7112369933076 | -122.398393755853 | (37.7112369933076, -122.398393755853) | 10 | 3 | 8 | 309 | 1 | ||
172218 | 178965 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 748 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002497.19746 | 2087222.1001 | 37.7112560450962 | -122.433177768149 | (37.7112560450962, -122.433177768149) | 9 | 7 | 6 | 28861 | 5 | |||
165003 | 95029 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 13 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010870.6461 | 2087075.073 | 37.71132378726 | -122.40422653482 | (37.71132378726, -122.40422653482) | 9 | 7 | 8 | 309 | 39 | |||
107810 | 26783 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 6 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6010951.9721 | 2087077.0783 | 37.7113338374082 | -122.403945591033 | (37.7113338374082, -122.403945591033) | 9 | 7 | 8 | 309 | 39 | |||
38192 | 95028 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 21 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010854.6037 | 2087083.0942 | 37.711344915432 | -122.404282545919 | (37.711344915432, -122.404282545919) | 9 | 7 | 8 | 309 | 39 | |||
193738 | 95027 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 29 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010839.0069 | 2087091.1154 | 37.711366068478 | -122.404337016935 | (37.711366068478, -122.404337016935) | 9 | 7 | 8 | 309 | 39 | |||
71544 | 26784 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 6 Leland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6010928.7998 | 2087090.8926 | 37.7113704740421 | -122.40402665237 | (37.7113704740421, -122.40402665237) | 9 | 7 | 8 | 309 | 39 | |||
61630 | 94985 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 6 Leland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010907.8555 | 2087101.5876 | 37.7113986701374 | -122.404099793818 | (37.7113986701374, -122.404099793818) | 9 | 7 | 8 | 309 | 39 | |||
124463 | 95026 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 33 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010809.5958 | 2087105.821 | 37.7114048035242 | -122.404439704211 | (37.7114048035242, -122.404439704211) | 9 | 7 | 8 | 309 | 39 | |||
54895 | 95025 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 37 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010791.7709 | 2087116.9615 | 37.7114343969477 | -122.404502095677 | (37.7114343969477, -122.404502095677) | 9 | 7 | 8 | 309 | 39 | |||
129191 | 94986 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 6 Leland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010873.097 | 2087120.3037 | 37.711448118617 | -122.404221245197 | (37.711448118617, -122.404221245197) | 9 | 7 | 8 | 309 | 39 | |||
3508 | 95024 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 41 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010769.0442 | 2087127.6565 | 37.7114624931322 | -122.404581397838 | (37.7114624931322, -122.404581397838) | 9 | 7 | 8 | 309 | 39 | |||
184829 | 95023 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 45 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010750.3281 | 2087136.1233 | 37.7114846952293 | -122.404646681546 | (37.7114846952293, -122.404646681546) | 9 | 7 | 8 | 309 | 39 | |||
26182 | 26785 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 28 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/13/1999 12:00:00 AM | 3 | 3X3 | 6010847.2509 | 2087135.4549 | 37.7114882765061 | -122.404311642231 | (37.7114882765061, -122.404311642231) | 9 | 7 | 8 | 309 | 39 | ||
43496 | 52333 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 30 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/2005 12:00:00 AM | 3 | Permit Number 48484 | 6010821.8504 | 2087147.4867 | 37.7115198939825 | -122.404400279817 | (37.7115198939825, -122.404400279817) | 9 | 7 | 8 | 309 | 39 | ||
140315 | 26786 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 34 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6010794.6675 | 2087161.3009 | 37.7115563058928 | -122.404495203342 | (37.7115563058928, -122.404495203342) | 9 | 7 | 8 | 309 | 39 | |||
103144 | 94988 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 38 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010771.4951 | 2087173.3327 | 37.7115880477556 | -122.404576140139 | (37.7115880477556, -122.404576140139) | 9 | 7 | 8 | 309 | 39 | |||
69554 | 95020 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 57 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6010631.1241 | 2087198.2876 | 37.7116487227907 | -122.405063058177 | (37.7116487227907, -122.405063058177) | 9 | 7 | 8 | 309 | 39 | |||
138756 | 95019 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 65 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010608.3974 | 2087210.3194 | 37.7116804891797 | -122.40514245485 | (37.7116804891797, -122.40514245485) | 9 | 7 | 8 | 309 | 39 | |||
184475 | 94987 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 36 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/08/2015 03:25:00 PM | 3 | 3x3 | 6010827.4 | 2087210.2 | 37.7116924022071 | -122.404385510244 | (37.7116924022071, -122.404385510244) | 9 | 7 | 8 | 309 | 39 | ||
102021 | 95018 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 65 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010587.8988 | 2087221.4599 | 37.7117099327517 | -122.405214087909 | (37.7117099327517, -122.405214087909) | 9 | 7 | 8 | 309 | 39 | |||
124096 | 95017 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 73 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010561.1615 | 2087236.1655 | 37.7117488165229 | -122.405307534685 | (37.7117488165229, -122.405307534685) | 9 | 7 | 8 | 309 | 39 | |||
109310 | 94992 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 66 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6010640.4822 | 2087242.4042 | 37.7117703812114 | -122.40503381823 | (37.7117703812114, -122.40503381823) | 9 | 7 | 8 | 309 | 39 | |||
105759 | 94993 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 66 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010619.538 | 2087251.7622 | 37.7117949055531 | -122.405106866024 | (37.7117949055531, -122.405106866024) | 9 | 7 | 8 | 309 | 39 | |||
89258 | 95015 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 83 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6010521.9467 | 2087254.8816 | 37.7117980145873 | -122.40544438972 | (37.7117980145873, -122.40544438972) | 9 | 7 | 8 | 309 | 39 | ||||
11497 | 26788 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 78 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1999 12:00:00 AM | 4 | 3X3 | 6010596.3656 | 2087261.1203 | 37.711819305554 | -122.405187615188 | (37.711819305554, -122.405187615188) | 9 | 7 | 8 | 309 | 39 | ||
48293 | 94994 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 82 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010574.5301 | 2087274.9346 | 37.7118560160688 | -122.405264057289 | (37.7118560160688, -122.405264057289) | 9 | 7 | 8 | 309 | 39 | |||
70148 | 94995 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 88 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010547.3472 | 2087288.7489 | 37.7118924275558 | -122.405358981673 | (37.7118924275558, -122.405358981673) | 9 | 7 | 8 | 309 | 39 | |||
193888 | 31050 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 25 South Hill Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51560 | 6002835.19583 | 2087448.13614 | 37.7118958587859 | -122.432025692555 | (37.7118958587859, -122.432025692555) | 9 | 7 | 6 | 28861 | 5 | |
53207 | 26789 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 96 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/2010 12:00:00 AM | 3 | 3X3 | 6010520.1642 | 2087302.5632 | 37.7119288389604 | -122.405453906496 | (37.7119288389604, -122.405453906496) | 9 | 7 | 8 | 309 | 39 | ||
53697 | 95012 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 107 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/12/1998 12:00:00 AM | 3 | 3x3 | 6010407.8674 | 2087313.2581 | 37.7119519253908 | -122.405842790713 | (37.7119519253908, -122.405842790713) | 9 | 7 | 8 | 309 | 39 | ||
179816 | 26800 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 117 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1999 12:00:00 AM | 5 | 3x3 | 6010377.1195 | 2087327.518 | 37.7119893605537 | -122.405950068589 | (37.7119893605537, -122.405950068589) | 9 | 7 | 8 | 309 | 39 | ||
166282 | 178899 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Tocoloma Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6012660.08669 | 2087284.72268 | 37.7119992718279 | -122.398056430958 | (37.7119992718279, -122.398056430958) | 10 | 3 | 8 | 309 | 1 | |||
62719 | 178898 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Tocoloma Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012665.55046 | 2087301.61111 | 37.7120459484316 | -122.398038730507 | (37.7120459484316, -122.398038730507) | 10 | 3 | 8 | 309 | 1 | |||
90421 | 26790 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 106 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/03/2015 09:40:00 AM | 3 | 3X3 | 6010430.5942 | 2087350.2448 | 37.7120547543657 | -122.405766843704 | (37.7120547543657, -122.405766843704) | 9 | 7 | 8 | 309 | 39 | ||
173162 | 95011 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 141 Leland Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6010324.7589 | 2087356.7063 | 37.7120665771229 | -122.406133097694 | (37.7120665771229, -122.406133097694) | 9 | 7 | 8 | 309 | 39 | |||
119540 | 178897 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 250 Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012667.83856 | 2087309.2144 | 37.7120669530014 | -122.398031355176 | (37.7120669530014, -122.398031355176) | 10 | 3 | 8 | 309 | 1 | |||
28270 | 26791 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 110 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/06/1999 12:00:00 AM | 4 | 3x3 | 6010397.1725 | 2087366.7328 | 37.7120981579726 | -122.405883520018 | (37.7120981579726, -122.405883520018) | 9 | 7 | 8 | 309 | 39 | ||
132667 | 95010 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 141 Leland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010304.2603 | 2087368.7381 | 37.7120984674199 | -122.406204794273 | (37.7120984674199, -122.406204794273) | 9 | 7 | 8 | 309 | 39 | |||
122289 | 26799 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 141 Leland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010285.5441 | 2087377.2049 | 37.7121206686095 | -122.40627007937 | (37.7121206686095, -122.40627007937) | 9 | 7 | 8 | 309 | 39 | |||
58312 | 94996 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 116 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010370.4352 | 2087379.2102 | 37.7121309230244 | -122.405976810763 | (37.7121309230244, -122.405976810763) | 9 | 7 | 8 | 309 | 39 | |||
60756 | 26798 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 141 Leland Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010259.698 | 2087389.6823 | 37.7121534832093 | -122.406360290051 | (37.7121534832093, -122.406360290051) | 9 | 7 | 8 | 309 | 39 | |||
36061 | 26792 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 128 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/29/2002 12:00:00 AM | 3 | 3x3 | 6010340.5785 | 2087395.6982 | 37.7121745258223 | -122.406081165572 | (37.7121745258223, -122.406081165572) | 9 | 7 | 8 | 309 | 39 | ||
148474 | 94997 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 134 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010302.5304 | 2087413.7951 | 37.7122220880479 | -122.406213945824 | (37.7122220880479, -122.406213945824) | 9 | 7 | 8 | 309 | 39 | |||
186944 | 26795 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 159 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/15/2010 12:00:00 AM | 3 | 3x3 | 6010135.8151 | 2087452.9607 | 37.7123203019902 | -122.406792924435 | (37.7123203019902, -122.406792924435) | 9 | 7 | 8 | 309 | 39 | ||
115182 | 51590 | Permitted Site 7 | Prunus serrulata :: Ornamental Cherry 84 | 252 Sadowa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/28/2005 12:00:00 AM | Permit Number 47881 | 5994487.68194175 | 2087789.14028904 | 37.7123553921006 | -122.460901533422 | (37.7123553921006, -122.460901533422) | 9 | 8 | 6 | 28861 | 24 | |||
9212 | 259382 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
17072 | 259381 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 225 Whipple Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 5997701 | 2087724 | 37.7123609051901 | -122.449790697309 | (37.7123609051901, -122.449790697309) | 9 | 7 | 6 | 28861 | 25 | ||||
133576 | 95008 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 167 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010080.5579 | 2087480.5892 | 37.7123930722617 | -122.406985856935 | (37.7123930722617, -122.406985856935) | 9 | 7 | 8 | 309 | 39 | |||
51022 | 95001 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 166 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010153.2106 | 2087493.0431 | 37.712431333442 | -122.406735623081 | (37.712431333442, -122.406735623081) | 9 | 7 | 8 | 309 | 39 | |||
99895 | 95007 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 185 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010037.7782 | 2087495.7404 | 37.7124322803777 | -122.40713478458 | (37.7124322803777, -122.40713478458) | 9 | 7 | 8 | 309 | 39 | |||
97110 | 95002 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 170 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010131.1046 | 2087504.7217 | 37.7124621636148 | -122.406812851088 | (37.7124621636148, -122.406812851088) | 9 | 7 | 8 | 309 | 39 | |||
130098 | 95003 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 176 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6010111.9182 | 2087516.8174 | 37.7124943023778 | -122.406880017452 | (37.7124943023778, -122.406880017452) | 9 | 7 | 8 | 309 | 39 | |||
59347 | 37353 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 131 Curtis St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/15/1998 12:00:00 AM | 4 | Permit Number 39859 | 6000725.37102 | 2087720.25032 | 37.7125231844795 | -122.43933731388 | (37.7125231844795, -122.43933731388) | 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) );