Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10844 | 10844 | 43316 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 263 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51344 | 6004441.12036 | 2091738.6459 | 37.7237675806909 | -122.426780519916 | (37.7237675806909, -122.426780519916) | |
12084 | 12084 | 43317 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 263 Athens St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51344 | 6004450.31399 | 2091734.8767 | 37.7237577510972 | -122.42674847077299 | (37.7237577510972, -122.426748470773) | |
18677 | 18677 | 88330 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 544 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51318 | 6001416.8 | 2090660.3 | 37.720635228492206 | -122.437157897339 | (37.7206352284922, -122.437157897339) | |||
18733 | 18733 | 88323 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 125 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51312 | 6003417.0 | 2092629.0 | 37.7261543381556 | -122.430384225952 | (37.7261543381556, -122.430384225952) | |||
25590 | 25590 | 32671 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 452 Clementina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51345 | 6011114.30345 | 2112004.56404 | 37.779788381657504 | -122.40513867842199 | (37.7797883816575, -122.405138678422) | |
26663 | 26663 | 88370 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1647 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51351 | 6001238.8669 | 2111411.7366 | 37.777603600897706 | -122.43925957050699 | (37.7776036008977, -122.439259570507) | |
28196 | 28196 | 88382 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 355 17th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51360 | 5990561.77007 | 2113010.94096 | 37.7813812065074 | -122.476311706446 | (37.7813812065074, -122.476311706446) | ||
29713 | 29713 | 88413 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51386 | 6009439.10659 | 2116768.27237 | 37.792774588415796 | -122.411270553799 | (37.7927745884158, -122.411270553799) | |
31826 | 31826 | 88412 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51386 | 6009452.7788 | 2116769.6537 | 37.792779147992796 | -122.411223344786 | (37.7927791479928, -122.411223344786) | |
32227 | 32227 | 85092 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 73 Commonwealth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51392 | 5996497.3497 | 2114054.7732 | 37.784589722316106 | -122.455853092183 | (37.7845897223161, -122.455853092183) | |
32567 | 32567 | 88336 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 554 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51323 | 6002921.31529 | 2090398.52495 | 37.7200018602822 | -122.43193858060499 | (37.7200018602822, -122.431938580605) | |
34103 | 34103 | 88390 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 258 22nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51368 | 5989033.92216 | 2113597.32101 | 37.7829025195026 | -122.48164021539301 | (37.7829025195026, -122.481640215393) | ||
34436 | 34436 | 88394 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 139 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 1 | 3x3 | Permit Number 51373 | 5988000.05712 | 2115038.19323 | 37.78679857243979 | -122.485322676521 | (37.7867985724398, -122.485322676521) | ||
37809 | 37809 | 88368 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1629 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51350 | 6001300.3869 | 2111420.8069 | 37.7776320062666 | -122.439047402755 | (37.7776320062666, -122.439047402755) | |
45717 | 45717 | 88369 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1629 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51350 | 6001320.1049 | 2111423.9618 | 37.7776417907396 | -122.438979417819 | (37.7776417907396, -122.438979417819) | |
54371 | 54371 | 72248 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 471 Lisbon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51334 | 6002218.571 | 2090723.2796599998 | 37.7208536999265 | -122.434390930208 | (37.7208536999265, -122.434390930208) | |
59589 | 59589 | 88375 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 365 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51353 | 5991523.32351 | 2112975.7244700002 | 37.7813402274639 | -122.472982663209 | (37.7813402274639, -122.472982663209) | ||
68753 | 68753 | 88371 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1647 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 4 | 3x3 | Permit Number 51351 | 6001264.1059 | 2111416.0746 | 37.7776169481477 | -122.43917257148 | (37.7776169481477, -122.43917257148) | |
69262 | 69262 | 85091 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 73 Commonwealth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51392 | 5996496.6729 | 2114067.9716 | 37.784625922764 | -122.45585638810302 | (37.784625922764, -122.455856388103) | |
73311 | 73311 | 88432 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 484 09th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51378 | 5993150.78025 | 2112142.69993 | 37.7791470546035 | -122.46729191673201 | (37.7791470546035, -122.467291916732) | |
75295 | 75295 | 88331 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 635 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51319 | 6002224.0 | 2090226.0 | 37.7194885890815 | -122.434336629443 | (37.7194885890815, -122.434336629443) | |||
76506 | 76506 | 88411 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 1135 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51385 | 6009845.51627 | 2117657.9226900004 | 37.79524013646721 | -122.409927183403 | (37.7952401364672, -122.409927183403) | |
77051 | 77051 | 88389 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 238 22nd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51367 | 5989030.6035 | 2113722.2392700003 | 37.7832453168995 | -122.481660848787 | (37.7832453168995, -122.481660848787) | ||
78421 | 78421 | 88365 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 10 Lyon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51347 | 6000409.7 | 2108931.9 | 37.7707473776731 | -122.44194989411001 | (37.7707473776731, -122.44194989411) | |||
79735 | 79735 | 88396 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 635 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51375 | 5988132.3051849995 | 2111648.444046 | 37.777498983924204 | -122.484616395841 | (37.7774989839242, -122.484616395841) | |||
79887 | 79887 | 88362 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 680 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51339 | 5990515.1 | 2110799.3 | 37.7753059441075 | -122.476311561554 | (37.7753059441075, -122.476311561554) | ||
81200 | 81200 | 88338 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 315 Paris St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51325 | 6002541.0 | 2091742.0 | 37.723669175153205 | -122.43334915015801 | (37.7236691751532, -122.433349150158) | |||
81508 | 81508 | 88416 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
82375 | 82375 | 88393 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.785370404226796 | -122.48281165726401 | (37.7853704042268, -122.482811657264) | |||
82526 | 82526 | 88406 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1716 Larkin St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51383 | 6007055.0 | 2117126.0 | 37.7936228211286 | -122.41954507638901 | (37.7936228211286, -122.419545076389) | |||
82966 | 82966 | 88341 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 51 Prague St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51327 | 6004823.0 | 2090807.0 | 37.721231068747294 | -122.425394157088 | (37.7212310687473, -122.425394157088) | |||
83192 | 83192 | 88401 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 160 BERNARD ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51379 | 6008069.0 | 2118060.0 | 37.7962444170868 | -122.41610271872601 | (37.7962444170868, -122.416102718726) | ||
84744 | 84744 | 88349 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 100 Vienna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | ||
86663 | 86663 | 88313 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 638 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51304 | 6003091.0 | 2089648.0 | 37.7179507025626 | -122.43129849323799 | (37.7179507025626, -122.431298493238) | |||
89202 | 89202 | 88314 | Permitted Site 1 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 536 Brazil Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51305 | 6003410.9 | 2091265.7 | 37.7224106741337 | -122.430308091157 | (37.7224106741337, -122.430308091157) | |||
90378 | 90378 | 88350 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 100 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | ||
91147 | 91147 | 88310 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
91442 | 91442 | 88308 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
91560 | 91560 | 88337 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 686 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51324 | 6002465.0 | 2089669.0 | 37.717972867232795 | -122.43346379852699 | (37.7179728672328, -122.433463798527) | |||
91640 | 91640 | 88352 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 700 VIENNA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51333 | 6002601.8 | 2089436.1 | 37.717341135839604 | -122.43297431107901 | (37.7173411358396, -122.432974311079) | ||
91694 | 91694 | 88359 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1443 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51337 | 5992382.4 | 2105622.1 | 37.7611988469011 | -122.46947525322099 | (37.7611988469011, -122.469475253221) | |||
92168 | 92168 | 88355 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 698X France Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51333 | 6002601.8 | 2089436.1 | 37.717341135839604 | -122.43297431107901 | (37.7173411358396, -122.432974311079) | ||
92263 | 92263 | 88346 | Permitted Site 1 | Pyrus calleryana 'Aristocrat' :: Aristocrat Callery Pear 131 | 351 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51331 | 6003903.0 | 2091384.0 | 37.722763361623294 | -122.428615443614 | (37.7227633616233, -122.428615443614) | |||
93103 | 93103 | 88423 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1451 Taylor St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861.0 | 2117824.0 | 37.795640918050104 | -122.413345528397 | (37.7956409180501, -122.413345528397) | |||
93530 | 93530 | 88397 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 405 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51376 | 5987436.1 | 2113196.8 | 37.781709762111795 | -122.487138517946 | (37.7817097621118, -122.487138517946) | ||
94108 | 94108 | 88329 | Permitted Site 1 | Ulmus parvifolia :: Chinese Elm 46 | 120 London St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51317 | 6002940.0 | 2092960.0 | 37.7270361584814 | -122.432056812936 | (37.7270361584814, -122.432056812936) | |||
95030 | 95030 | 88376 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 563 14th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51354 | 5991545.8 | 2111599.6 | 37.777563068378704 | -122.472804534873 | (37.7775630683787, -122.472804534873) | |||
95585 | 95585 | 88434 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 484 09th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51378 | 5993167.6 | 2112179.5 | 37.7792490685843 | -122.467236407287 | (37.7792490685843, -122.467236407287) | ||
96088 | 96088 | 88353 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 698X France Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51333 | 6002601.8 | 2089436.1 | 37.717341135839604 | -122.43297431107901 | (37.7173411358396, -122.432974311079) | ||
97319 | 97319 | 88347 | Permitted Site 1 | Juniperus chinensis :: Juniper 19 | 100x Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004738.0 | 2092796.0 | 37.7266876232591 | -122.425829482771 | (37.7266876232591, -122.425829482771) | |||
97381 | 97381 | 88421 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
98401 | 98401 | 88306 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 575 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51300 | 6003350.0 | 2089985.0 | 37.718890705147 | -122.43042727566299 | (37.718890705147, -122.430427275663) | |||
99023 | 99023 | 88357 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 245 11th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51336 | 6008270.0 | 2109444.0 | 37.7725982617206 | -122.41479713662399 | (37.7725982617206, -122.414797136624) | ||
99057 | 99057 | 88425 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 999 Bush St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51391 | 6001075.0 | 2114514.0 | 37.7861122979784 | -122.44004894455799 | (37.7861122979784, -122.440048944558) | |||
99152 | 99152 | 88309 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
99205 | 99205 | 88343 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1118 Russia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51328 | 6004013.1 | 2089324.0 | 37.717113283576204 | -122.428088120605 | (37.7171132835762, -122.428088120605) | |||
101846 | 101846 | 88384 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 326 18th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51362 | 5990315.5 | 2113175.5 | 37.7818187550425 | -122.477175701056 | (37.7818187550425, -122.477175701056) | |||
102459 | 102459 | 88404 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Hyde St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51381 | 6007655.0 | 2116328.0 | 37.7914654879488 | -122.417412441264 | (37.7914654879488, -122.417412441264) | |||
103099 | 103099 | 88326 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911.0 | 2090236.0 | 37.7194982755804 | -122.43541926902701 | (37.7194982755804, -122.435419269027) | |||
104045 | 104045 | 88333 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 443 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51321 | 6003357.0 | 2091009.0 | 37.7217027796011 | -122.43047610401301 | (37.7217027796011, -122.430476104013) | |||
105977 | 105977 | 88399 | Permitted Site 1 | Pittosporum spp :: Pittosporum spp 128 | 793 29th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51377 | 5986869.4 | 2110536.4 | 37.7743719977486 | -122.488903378785 | (37.7743719977486, -122.488903378785) | |||
106370 | 106370 | 41975 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 101X NORTHGATE DR | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51393 | 5994409.0 | 2094096.0 | 37.7296679875594 | -122.461630458557 | (37.7296679875594, -122.461630458557) | ||
106504 | 106504 | 88322 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 645 France Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.717507319615706 | -122.432824059512 | (37.7175073196157, -122.432824059512) | ||
108201 | 108201 | 88405 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1140 Green St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51382 | 6007541.2 | 2118862.0 | 37.7984168187982 | -122.41798590203699 | (37.7984168187982, -122.417985902037) | |||
108296 | 108296 | 88324 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 182 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51313 | 6003195.0 | 2092351.0 | 37.7253784345628 | -122.431131833246 | (37.7253784345628, -122.431131833246) | |||
108755 | 108755 | 88422 | Permitted Site 1 | Pyrus kawakamii :: Evergreen Pear 82 | 1451 Taylor St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51387 | 6008861.0 | 2117824.0 | 37.795640918050104 | -122.413345528397 | (37.7956409180501, -122.413345528397) | |||
110021 | 110021 | 88360 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 4969 17th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51338 | 5997573.8 | 2105584.6 | 37.761394534839894 | -122.451517798676 | (37.7613945348399, -122.451517798676) | |||
110943 | 110943 | 88424 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1465 Washington St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51388 | 6007689.0 | 2117147.0 | 37.7937161726159 | -122.417352866644 | (37.7937161726159, -122.417352866644) | |||
111280 | 111280 | 41979 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 101X NORTHGATE DR | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51393 | 5994409.0 | 2094096.0 | 37.7296679875594 | -122.461630458557 | (37.7296679875594, -122.461630458557) | ||
111659 | 111659 | 88356 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 245 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51336 | 6008270.0 | 2109444.0 | 37.7725982617206 | -122.41479713662399 | (37.7725982617206, -122.414797136624) | ||
112316 | 112316 | 88332 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 659 Madrid St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51320 | 6002140.0 | 2090092.0 | 37.7191158866353 | -122.434617409737 | (37.7191158866353, -122.434617409737) | |||
112603 | 112603 | 88418 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
112669 | 112669 | 88403 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 824 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51380 | 6009071.0 | 2119078.0 | 37.7990958810139 | -122.412707583659 | (37.7990958810139, -122.412707583659) | ||
115459 | 115459 | 88311 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 55 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51302 | 6005208.0 | 2092949.0 | 37.7271342768906 | -122.42421558283002 | (37.7271342768906, -122.42421558283) | |||
116129 | 116129 | 88379 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 351 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51357 | 5990853.6 | 2113045.1 | 37.7814919173335 | -122.475304621963 | (37.7814919173335, -122.475304621963) | |||
116421 | 116421 | 88344 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1127 Russia Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51329 | 6004077.0 | 2089373.5 | 37.7172528149217 | -122.42787077390301 | (37.7172528149217, -122.427870773903) | |||
116912 | 116912 | 88417 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
119037 | 119037 | 88334 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 470 Naples St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51322 | 6003225.0 | 2090876.0 | 37.721330112648104 | -122.430922905786 | (37.7213301126481, -122.430922905786) | |||
119445 | 119445 | 88345 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 347 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51330 | 6003917.0 | 2091407.0 | 37.7228273068445 | -122.428568687279 | (37.7228273068445, -122.428568687279) | |||
119752 | 119752 | 88358 | Permitted Site 1 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 245 11th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51336 | 6008270.0 | 2109444.0 | 37.7725982617206 | -122.41479713662399 | (37.7725982617206, -122.414797136624) | ||
120151 | 120151 | 88327 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 559 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51315 | 6001911.0 | 2090236.0 | 37.7194982755804 | -122.43541926902701 | (37.7194982755804, -122.435419269027) | ||
121228 | 121228 | 88378 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 479 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51356 | 5991211.4 | 2112156.0 | 37.7790714261909 | -122.474001930206 | (37.7790714261909, -122.474001930206) | |||
121566 | 121566 | 35778 | Permitted Site 1 | Fraxinus americana :: American Ash 23 | 3426 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51390 | 6007395.20860977 | 2104436.57542117 | 37.7587998540815 | -122.417468193596 | (37.7587998540815, -122.417468193596) | ||
123370 | 123370 | 88381 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 423 16th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51359 | 5990873.7 | 2112494.8 | 37.779982110660896 | -122.475194900005 | (37.7799821106609, -122.475194900005) | |||
124247 | 124247 | 88364 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 2559 33rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51343 | 5986101.6 | 2097823.5 | 37.739421027827 | -122.490623769288 | (37.739421027827, -122.490623769288) | |||
124279 | 124279 | 46337 | Permitted Site 1 | Magnolia doltsopa :: Himalayan Magnolia 187 | 3703 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51341 | 6005824.5079347 | 2100789.51596522 | 37.7486973702763 | -122.422641242993 | (37.7486973702763, -122.422641242993) | |
124754 | 124754 | 88348 | Permitted Site 1 | Magnolia grandiflora 'Russet' :: Russet Magnolia 229 | 100 Vienna St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51332 | 6004690.8 | 2092754.8 | 37.7265718296959 | -122.425989720183 | (37.7265718296959, -122.425989720183) | |||
124961 | 124961 | 88312 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 518 Athens St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51303 | 6003514.0 | 2090320.0 | 37.7198198301278 | -122.42988427506201 | (37.7198198301278, -122.429884275062) | |||
125503 | 125503 | 88316 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 447 Edinburg St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51307 | 6003165.8 | 2091093.0 | 37.7219225920035 | -122.43114302422501 | (37.7219225920035, -122.431143024225) | |||
125699 | 125699 | 88320 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 645 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51311 | 6002646.5 | 2089495.7 | 37.717507319615706 | -122.432824059512 | (37.7175073196157, -122.432824059512) | |||
126451 | 126451 | 88307 | Permitted Site 1 | Eriobotrya deflexa :: Bronze Loquat 49 | 401 Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51301 | 6001480.2 | 2088981.7 | 37.7160297722944 | -122.436818641634 | (37.7160297722944, -122.436818641634) | ||
126791 | 126791 | 88318 | Permitted Site 1 | Olea europaea 'Wilsonii' :: Wilson Olive Semi-fruitless 207 | 607 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51309 | 6002519.4 | 2089575.2 | 37.717718399475295 | -122.43326906293899 | (37.7177183994753, -122.433269062939) | |||
126931 | 126931 | 88325 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 346 Lisbon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51314 | 6002623.0 | 2091442.0 | 37.7228500939634 | -122.433044266804 | (37.7228500939634, -122.433044266804) | |||
127020 | 127020 | 88426 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 73 Commonwealth Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51392 | 5996480.7 | 2114051.6 | 37.784580053980704 | -122.455910464712 | (37.7845800539807, -122.455910464712) | |||
129025 | 129025 | 88319 | Permitted Site 1 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 631 France Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51310 | 6002604.8 | 2089521.8 | 37.7175766192591 | -122.43297006078501 | (37.7175766192591, -122.432970060785) | |||
133299 | 133299 | 88377 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 458 15th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51355 | 5991270.95609 | 2112280.85053 | 37.7794176810179 | -122.47380501423599 | (37.7794176810179, -122.473805014236) | ||
135556 | 135556 | 88395 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 150 25th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51374 | 5988059.13984 | 2114984.30463 | 37.78665405150971 | -122.48511431139 | (37.7866540515097, -122.48511431139) | ||
137287 | 137287 | 88335 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 554 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 7 | 3x3 | Permit Number 51323 | 6002930.314119999 | 2090411.63192 | 37.7200383592665 | -122.431908410163 | (37.7200383592665, -122.431908410163) | |
138283 | 138283 | 88419 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1100 Sacramento St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51386 | 6009510.0 | 2116776.0 | 37.7927997823299 | -122.411025804578 | (37.7927997823299, -122.411025804578) | ||
139857 | 139857 | 88361 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 680 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51339 | 5990515.1 | 2110799.3 | 37.7753059441075 | -122.476311561554 | (37.7753059441075, -122.476311561554) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" ( "TreeID" INTEGER, "qLegalStatus" INTEGER, "qSpecies" INTEGER, "qAddress" TEXT, "SiteOrder" INTEGER, "qSiteInfo" INTEGER, "PlantType" INTEGER, "qCaretaker" INTEGER, "qCareAssistant" INTEGER, "PlantDate" TEXT, "DBH" INTEGER, "PlotSize" TEXT, "PermitNotes" TEXT, "XCoord" REAL, "YCoord" REAL, "Latitude" REAL, "Longitude" REAL, "Location" TEXT , FOREIGN KEY ("PlantType") REFERENCES [PlantType](id), FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id), FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id), FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id), FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id), FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id)); CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType"); CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker"); CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies"); CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo"); CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant"); CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");