Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14166 | 14166 | 110369 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x Alameda St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010361.75992 | 2107841.88666 | 37.7683165361048 | -122.40744851604201 | (37.7683165361048, -122.407448516042) | |||
15077 | 15077 | 110368 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010339.5627 | 2107839.67142 | 37.768309211116 | -122.407525138277 | (37.768309211116, -122.407525138277) | |||
24377 | 24377 | 229828 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1456 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010092.99129 | 2100772.65012 | 37.748890955071396 | -122.407879605175 | (37.7488909550714, -122.407879605175) | |||
24394 | 24394 | 190725 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2211 Alameda St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010439.75315 | 2107847.13146 | 37.7683353022519 | -122.40717911333599 | (37.7683353022519, -122.407179113336) | |||
28067 | 28067 | 190735 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 128 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010531.76595 | 2107657.21316 | 37.7678189790021 | -122.406847461368 | (37.7678189790021, -122.406847461368) | |||
30489 | 30489 | 229761 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6011456.4035 | 2102287.48645 | 37.753126600912296 | -122.40327144663401 | (37.7531266009123, -122.403271446634) | |||
32128 | 32128 | 138952 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 715 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004470.5657 | 2110964.0931 | 37.7765578523866 | -122.428048123596 | (37.7765578523866, -122.428048123596) | |||
33670 | 33670 | 67525 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1237 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/22/1992 12:00:00 AM | 5 | Permit Number 31063 | 6013863.96904 | 2105222.10332 | 37.7613185911004 | -122.395151089252 | (37.7613185911004, -122.395151089252) | |
33672 | 33672 | 229850 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 86 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005369.9834199995 | 2103227.0230799997 | 37.7553645467641 | -122.424386333963 | (37.7553645467641, -122.424386333963) | |||
35178 | 35178 | 226804 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3520 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004856.92636 | 2103707.06921 | 37.75665365567029 | -122.42619481576 | (37.7566536556703, -122.42619481576) | |||
37583 | 37583 | 226819 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 70 Potomac St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003113.42277 | 2108740.53818 | 37.7703756436569 | -122.432584004272 | (37.7703756436569, -122.432584004272) | |||
38164 | 38164 | 229739 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 28 Dorland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005381.68276 | 2105771.85713 | 37.7623527242205 | -122.424526883603 | (37.7623527242205, -122.424526883603) | |||
43204 | 43204 | 228534 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009327.35781 | 2107359.80868 | 37.7669349094434 | -122.41099237460699 | (37.7669349094434, -122.410992374607) | |||
43221 | 43221 | 226788 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 133 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002056.46904 | 2105062.33058 | 37.760216190457605 | -122.43597676863999 | (37.7602161904576, -122.43597676864) | |||
43435 | 43435 | 226821 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1883 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004617.16315 | 2097706.60415 | 37.740164211802 | -122.42659673536998 | (37.740164211802, -122.42659673537) | |||
43915 | 43915 | 226404 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 47 Mirabel Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007592.36819 | 2099969.05914 | 37.746544160700005 | -122.416469871814 | (37.7465441607, -122.416469871814) | |||
45830 | 45830 | 226462 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007188.60102 | 2106179.3508900004 | 37.763573483764894 | -122.41830630538601 | (37.7635734837649, -122.418306305386) | |||
46199 | 46199 | 226315 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1045 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007642.72664 | 2103585.2825 | 37.756476322828 | -122.416551856705 | (37.756476322828, -122.416551856705) | |||
47742 | 47742 | 229875 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3771 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004599.42844 | 2102480.0904900003 | 37.7532701021595 | -122.42699795081002 | (37.7532701021595, -122.42699795081) | |||
48327 | 48327 | 226794 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 267 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001783.4277 | 2104311.13216 | 37.7581380667326 | -122.4368673106 | (37.7581380667326, -122.4368673106) | |||
48448 | 48448 | 37938 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1833 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1998 12:00:00 AM | 5 | Permit Number 40182 | 6012201.799319999 | 2105128.09339 | 37.7609678851705 | -122.40089326501499 | (37.7609678851705, -122.400893265015) | |
48681 | 48681 | 229888 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 83 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008255.19246 | 2099602.19695 | 37.745574091677206 | -122.414151939365 | (37.7455740916772, -122.414151939365) | |||
50961 | 50961 | 229852 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3631 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005555.32091 | 2102533.44251 | 37.7534705997005 | -122.423696068331 | (37.7534705997005, -122.423696068331) | |||
51857 | 51857 | 229793 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2 Trainor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008301.706069999 | 2108167.22951 | 37.7690943309545 | -122.414597094793 | (37.7690943309545, -122.414597094793) | |||
54064 | 54064 | 226815 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 4132 17th St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6001471.84267 | 2105861.76416 | 37.7623780104526 | -122.438055976903 | (37.7623780104526, -122.438055976903) | |||
58334 | 58334 | 229846 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3494 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6005141.9373 | 2103725.25099 | 37.7567196838778 | -122.425210437638 | (37.7567196838778, -122.425210437638) | |||
60786 | 60786 | 226304 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1425 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008016.149119999 | 2099877.20359 | 37.7463157688762 | -122.41499797839899 | (37.7463157688762, -122.414997978399) | |||
62972 | 62972 | 190689 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1001 Minnesota St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6015296.26829 | 2103832.96006 | 37.757583849644796 | -122.39010027902701 | (37.7575838496448, -122.390100279027) | |||
65946 | 65946 | 52722 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1115 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/2006 12:00:00 AM | 5 | Permit Number 48775 | 6011675.49817 | 2103219.4484 | 37.755697797718796 | -122.40257930049201 | (37.7556977977188, -122.402579300492) | ||
66237 | 66237 | 226316 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1314 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007669.0206 | 2101973.5832700003 | 37.7520524425716 | -122.416346770813 | (37.7520524425716, -122.416346770813) | |||
69439 | 69439 | 229879 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 402 27th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003795.058999999 | 2100140.55813 | 37.7468007768344 | -122.429612782729 | (37.7468007768344, -122.429612782729) | |||
71491 | 71491 | 229885 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1420 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007989.39364 | 2099739.3415900003 | 37.74593572706829 | -122.415080739378 | (37.7459357270683, -122.415080739378) | |||
72637 | 72637 | 226324 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1055 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008046.21468 | 2101786.36501 | 37.7515595871229 | -122.415029123693 | (37.7515595871229, -122.415029123693) | |||
75537 | 75537 | 229812 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3000 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009519.76237 | 2101043.00477 | 37.7496011802691 | -122.409880921395 | (37.7496011802691, -122.409880921395) | |||
75738 | 75738 | 228537 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009258.78622 | 2107356.5369700002 | 37.76692208062529 | -122.411229322595 | (37.7669220806253, -122.411229322595) | |||
76392 | 76392 | 229827 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1450 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6010090.15715 | 2100798.67472 | 37.748962254223706 | -122.407891240603 | (37.7489622542237, -122.407891240603) | |||
77258 | 77258 | 226414 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1174 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009199.3273 | 2102350.17557 | 37.7531724159966 | -122.411081321155 | (37.7531724159966, -122.411081321155) | |||
86573 | 86573 | 34754 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 825 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 04/07/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53353 | 6007982.56974873 | 2103121.8781615 | 37.7552230267666 | -122.415343751113 | (37.7552230267666, -122.415343751113) |
88402 | 88402 | 110371 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
88451 | 88451 | 107808 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3979 18TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6003121.6 | 2105304.0 | 37.7609402081383 | -122.43231024636299 | (37.7609402081383, -122.432310246363) | |||
92794 | 92794 | 102177 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 267 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/31/2012 12:00:00 AM | 5 | 6x9 | Permit Number 769769 | 6001804.7 | 2104316.3 | 37.758153465363996 | -122.436794111878 | (37.758153465364, -122.436794111878) |
94248 | 94248 | 228533 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009349.90879 | 2107361.21702 | 37.7669400409627 | -122.410914473531 | (37.7669400409627, -122.410914473531) | |||
101192 | 101192 | 110372 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
102388 | 102388 | 110374 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
113636 | 113636 | 226801 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 545 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002785.55177 | 2103842.18407 | 37.7569073526207 | -122.433368026935 | (37.7569073526207, -122.433368026935) | |||
123636 | 123636 | 110373 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
129634 | 129634 | 190684 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 801 Mariposa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6014721.7183 | 2106200.75287 | 37.764053413244206 | -122.39225291963301 | (37.7640534132442, -122.392252919633) | |||
129881 | 129881 | 229877 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 376 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004079.13209 | 2100156.42335 | 37.7468604198839 | -122.428631616054 | (37.7468604198839, -122.428631616054) | |||
130035 | 130035 | 229845 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3494 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6005155.25082 | 2103726.26853 | 37.756723229919 | -122.425164466987 | (37.756723229919, -122.425164466987) | |||
130816 | 130816 | 229820 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 709 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009884.4018 | 2104852.89904 | 37.7600827274654 | -122.40888874884199 | (37.7600827274654, -122.408888748842) | |||
132520 | 132520 | 190729 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010522.648990001 | 2107794.80164 | 37.7681962553765 | -122.406888694378 | (37.7681962553765, -122.406888694378) | |||
133471 | 133471 | 38381 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1464 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 5 | Permit Number 48279 | 6011990.103569999 | 2101552.6120700003 | 37.7511385883967 | -122.401374155011 | (37.7511385883967, -122.401374155011) | |
133490 | 133490 | 226344 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3175 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008415.435409999 | 2101520.84505 | 37.7508512702694 | -122.41373352889299 | (37.7508512702694, -122.413733528893) | |||
133983 | 133983 | 228543 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1459 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009587.00796 | 2100726.59956 | 37.7487361700459 | -122.409626053498 | (37.7487361700459, -122.409626053498) | |||
136583 | 136583 | 229881 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 130 Belgrave Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997916.14381 | 2104919.64182 | 37.7595883251505 | -122.45028584571999 | (37.7595883251505, -122.45028584572) | |||
137761 | 137761 | 226777 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 323 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004194.763830001 | 2103338.46367 | 37.7556041027521 | -122.42845854153099 | (37.7556041027521, -122.428458541531) | |||
143988 | 143988 | 110370 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2299x ALAMEDA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6010419.0 | 2107687.0 | 37.7678944564601 | -122.407239607329 | (37.7678944564601, -122.407239607329) | |||
146597 | 146597 | 229766 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6011452.91917 | 2102390.65584 | 37.7534096868171 | -122.403290753279 | (37.7534096868171, -122.403290753279) | |||
148202 | 148202 | 67540 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 619 Wisconsin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 5 | Permit Number 31080 | 6012728.40675 | 2104463.00984 | 37.7591710721042 | -122.399025265205 | (37.7591710721042, -122.399025265205) | |
154055 | 154055 | 226823 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 192 Laidley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004115.91768 | 2097275.83468 | 37.738953066925895 | -122.42829914569201 | (37.7389530669259, -122.428299145692) | |||
154565 | 154565 | 229776 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6011441.50409 | 2102586.88485 | 37.7539478510307 | -122.40334403271002 | (37.7539478510307, -122.40334403271) | |||
158462 | 158462 | 229757 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1201 Vermont St | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6011461.99954 | 2102213.77594 | 37.752924520553 | -122.40324690953301 | (37.752924520553, -122.403246909533) | |||
159141 | 159141 | 38602 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1556 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50557 | 6015367.191000001 | 2094226.9780000001 | 37.731211746308105 | -122.389184266735 | (37.7312117463081, -122.389184266735) | |
161405 | 161405 | 190708 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2033 22nd St | 4 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6011986.6004 | 2103715.0173 | 37.7570758846471 | -122.40153823182399 | (37.7570758846471, -122.401538231824) | |||
164165 | 164165 | 229748 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3729 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005508.5081400005 | 2100776.42881 | 37.7486436028343 | -122.42373303855 | (37.7486436028343, -122.42373303855) | |||
164271 | 164271 | 190731 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 100 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010525.632230001 | 2107742.1208900004 | 37.7680517730114 | -122.406874662236 | (37.7680517730114, -122.406874662236) | |||
165746 | 165746 | 84622 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 382 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/2006 12:00:00 AM | 5 | 6013742.24361 | 2105343.88141 | 37.761646197043 | -122.395580621644 | (37.761646197043, -122.395580621644) | ||
166034 | 166034 | 190704 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1446 Kansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6011711.12531 | 2101607.11223 | 37.7512726647182 | -122.402342728461 | (37.7512726647182, -122.402342728461) | |||
166356 | 166356 | 226449 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 23rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008388.15696 | 2102735.22418 | 37.7541841496905 | -122.41391375574 | (37.7541841496905, -122.41391375574) | |||
168776 | 168776 | 229813 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3000 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009511.58464 | 2101042.5615 | 37.7495995048357 | -122.409909169093 | (37.7495995048357, -122.409909169093) | |||
168979 | 168979 | 190740 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 168 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010535.588140001 | 2107583.9844299997 | 37.7676181235051 | -122.40682907919701 | (37.7676181235051, -122.406829079197) | |||
168999 | 168999 | 190738 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 168 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010533.72626 | 2107613.44503 | 37.767698911404096 | -122.406837595798 | (37.7676989114041, -122.406837595798) | |||
173177 | 173177 | 229854 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 318 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005450.52958 | 2101809.91595 | 37.7514780473814 | -122.424007011614 | (37.7514780473814, -122.424007011614) | |||
174734 | 174734 | 78725 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1300 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53574 | 6011951.3466300005 | 2102291.29231 | 37.753164680908206 | -122.401560092537 | (37.7531646809082, -122.401560092537) | |
174815 | 174815 | 78494 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2131 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 5 | 6012056.35315 | 2102319.0062700002 | 37.753246636133206 | -122.401198904113 | (37.7532466361332, -122.401198904113) | ||
176827 | 176827 | 190739 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 168 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010536.509219999 | 2107598.9835599996 | 37.7676593592282 | -122.406826950508 | (37.7676593592282, -122.406826950508) | |||
178077 | 178077 | 228538 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1000 15th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009238.1018900005 | 2107354.62318 | 37.7669156657401 | -122.411300731452 | (37.7669156657401, -122.411300731452) | |||
182421 | 182421 | 229809 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1801 Bryant St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009528.66718 | 2106237.67868 | 37.7638650844166 | -122.410216840643 | (37.7638650844166, -122.410216840643) | |||
183146 | 183146 | 129102 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 701 Buchanan St | 5 | : 4 | Tree 1 | Private 1 | 5 | Width 6ft | 6004465.70248 | 2110959.4385 | 37.7765447968535 | -122.428064615105 | (37.7765447968535, -122.428064615105) | |||
183258 | 183258 | 226328 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 351 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007822.68734 | 2105830.6205599997 | 37.762651623808104 | -122.416088496301 | (37.7626516238081, -122.416088496301) | |||
188915 | 188915 | 138953 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 717 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6004472.5713 | 2110950.3879 | 37.7765203347407 | -122.42804020876001 | (37.7765203347407, -122.42804020876) |
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");