trees
7,322 rows where qSpecies_id = 1 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
99927 | 244505 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 697 Oak St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003712.7095 | 2110021.2984 | 37.7739262645997 | -122.430602475909 | (37.7739262645997, -122.430602475909) | 7 | 9 | 11 | 29492 | 10 | |||
100071 | 57525 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 500 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/05/1976 12:00:00 AM | 9 | Permit Number 16384 | 6005330.9453 | 2111340.195 | 37.7776391759665 | -122.42509858662 | (37.7776391759665, -122.42509858662) | 7 | 9 | 11 | 28852 | 10 | ||
101181 | 242293 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 351 30th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004217.81546 | 2098363.50133 | 37.7419453164355 | -122.42802431739 | (37.7419453164355, -122.42802431739) | 2 | 7 | 5 | 63 | 7 | |||
101586 | 241804 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 173 Chattanooga St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004764.16808 | 2102653.14523 | 37.7537545840146 | -122.42644056808 | (37.7537545840146, -122.42644056808) | 2 | 4 | 5 | 28862 | 22 | |||
102490 | 218635 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 62 Forest Side Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992564.6944 | 2098695.01874 | 37.7421894050115 | -122.468340814101 | (37.7421894050115, -122.468340814101) | 1 | 8 | 4 | 29491 | 40 | |||
104467 | 218439 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 263 Flood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5999013.58684 | 2094065.49788 | 37.7298482100176 | -122.4457097777 | (37.7298482100176, -122.4457097777) | 9 | 7 | 4 | 28861 | 40 | |||
105930 | 35143 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 924 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/28/1998 12:00:00 AM | 9 | Permit Number 38673 | 6001802.40306 | 2088613.28285 | 37.7150364874261 | -122.435678614599 | (37.7150364874261, -122.435678614599) | 9 | 7 | 6 | 28861 | 5 | |
106797 | 218663 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 45 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5993303.89141 | 2093346.77691 | 37.7275471308885 | -122.465396502067 | (37.7275471308885, -122.465396502067) | 9 | 8 | 4 | 59 | 40 | |||
107722 | 180320 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 817 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6001210.40568 | 2092189.73212 | 37.7248229683925 | -122.437980831368 | (37.7248229683925, -122.437980831368) | 9 | 7 | 6 | 28861 | 25 | |||
108953 | 180128 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6001970.18924 | 2088805.07605 | 37.7155726380425 | -122.435112384346 | (37.7155726380425, -122.435112384346) | 9 | 7 | 6 | 28861 | 5 | |||
108999 | 136796 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2451 Steiner St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6002261.27112 | 2116364.65368 | 37.7912611796159 | -122.436077247185 | (37.7912611796159, -122.436077247185) | 13 | 9 | 1 | 29490 | 27 | |||
109001 | 242067 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4040 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004381.82121 | 2095095.04322 | 37.7329801485133 | -122.427224474752 | (37.7329801485133, -122.427224474752) | 9 | 7 | 5 | 28861 | 25 | |||
109893 | 62230 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 181 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/30/1985 12:00:00 AM | 9 | Permit Number 22356 | 6001312.33103 | 2093366.89872 | 37.7280609954021 | -122.437712756953 | (37.7280609954021, -122.437712756953) | 9 | 7 | 6 | 28861 | 25 | |
112876 | 180326 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 467 Capistrano Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6000881.2183 | 2092142.07592 | 37.7246733895406 | -122.439115376482 | (37.7246733895406, -122.439115376482) | 9 | 7 | 6 | 28861 | 25 | ||||
112934 | 180347 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 San Jose Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999525.40963 | 2092018.24426 | 37.7242561356068 | -122.443793328721 | (37.7242561356068, -122.443793328721) | 9 | 7 | 6 | 28861 | 25 | |||
114279 | 26349 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2670 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/26/1997 12:00:00 AM | 9 | 3X3 | 5997166.1857 | 2088608.28644 | 37.7147583379124 | -122.451702916455 | (37.7147583379124, -122.451702916455) | 9 | 8 | 6 | 28861 | 24 | ||
114673 | 241846 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 618 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007646.37592 | 2096458.54802 | 37.7369081129164 | -122.416034553163 | (37.7369081129164, -122.416034553163) | 2 | 7 | 7 | 28859 | 2 | |||
115086 | 180002 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2379 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 5999329.07357 | 2089071.75958 | 37.7161545632636 | -122.444260393411 | (37.7161545632636, -122.444260393411) | 9 | 7 | 6 | 28861 | 25 | |||
117281 | 241611 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 119 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008313.33184 | 2097909.73076 | 37.7409302192602 | -122.41383120424 | (37.7409302192602, -122.41383120424) | 2 | 7 | 7 | 28859 | 2 | |||
118071 | 139598 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 110 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000717.0466 | 2112538.0513 | 37.7806664661291 | -122.441145546812 | (37.7806664661291, -122.441145546812) | 15 | 5 | 1 | 29490 | 41 | |||
118506 | 247781 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 266 30th St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6004850.70069 | 2098447.83797 | 37.7422126713879 | -122.425842004521 | (37.7422126713879, -122.425842004521) | 2 | 7 | 5 | 63 | 22 | |||
121267 | 218433 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 335 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999176.75958 | 2094357.67972 | 37.7306597879214 | -122.44516667083 | (37.7306597879214, -122.44516667083) | 9 | 7 | 4 | 28861 | 40 | |||
123117 | 218606 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 428 Carl St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5996375.12296 | 2106964.99711 | 37.7651160369052 | -122.455763284455 | (37.7651160369052, -122.455763284455) | 15 | 5 | 11 | 29492 | 12 | |||
128660 | 241799 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3822 26th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004998.782 | 2100791.88655 | 37.7486572590238 | -122.425496767366 | (37.7486572590238, -122.425496767366) | 2 | 4 | 5 | 28862 | 22 | |||
130975 | 41183 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2246 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/24/1999 12:00:00 AM | 9 | Permit Number 41901 | 5999456.41796 | 2120862.19039 | 37.8034504683333 | -122.446105572921 | (37.8034504683333, -122.446105572921) | 13 | 9 | 1 | 57 | 17 | |
131670 | 180158 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 579 Madrid St | 22 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6002520.13209 | 2090692.25327 | 37.7207856212475 | -122.433346310091 | (37.7207856212475, -122.433346310091) | 9 | 7 | 6 | 28861 | 5 | |||
133910 | 241464 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 110 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000584.64265 | 2102423.42546 | 37.7528866770847 | -122.440877800392 | (37.7528866770847, -122.440877800392) | 2 | 4 | 5 | 28862 | 22 | |||
136118 | 119178 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 756 La Playa | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 5980765.96509 | 2110596.91774 | 37.7741800640196 | -122.510020413475 | (37.7741800640196, -122.510020413475) | 11 | 6 | 2 | 55 | 26 | |||
137963 | 62239 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 480 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/03/1985 12:00:00 AM | 9 | Permit Number 22365 | 6000820.9181 | 2092122.60182 | 37.7246164867477 | -122.439322430982 | (37.7246164867477, -122.439322430982) | 9 | 7 | 6 | 28861 | 25 | |
138599 | 218610 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1866 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990654.21369 | 2102680.299 | 37.7530214144155 | -122.475237476523 | (37.7530214144155, -122.475237476523) | 1 | 8 | 4 | 56 | 12 | |||
139010 | 139571 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 124 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6000694.0339 | 2112709.2927 | 37.7811353404014 | -122.4412374486 | (37.7811353404014, -122.4412374486) | 15 | 5 | 1 | 29490 | 41 | |||
139247 | 242109 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 186 Jersey St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003906.86702 | 2101606.45402 | 37.7508321156131 | -122.429330676163 | (37.7508321156131, -122.429330676163) | 2 | 4 | 5 | 28862 | 22 | |||
139999 | 218769 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1900 San Jose Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999558.6619 | 2092063.32126 | 37.7243818032662 | -122.443681617625 | (37.7243818032662, -122.443681617625) | 9 | 7 | 6 | 28861 | 25 | |||
140691 | 250824 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 25 Sea View Ter | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5986320.13068 | 2114141.71743 | 37.7842390986088 | -122.491068750642 | (37.7842390986088, -122.491068750642) | 11 | 6 | 1 | 55 | 33 | |||
141212 | 242295 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 271 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004753.85137 | 2098392.1803 | 37.742054374503 | -122.426172918142 | (37.742054374503, -122.426172918142) | 2 | 7 | 5 | 63 | 7 | |||
143064 | 241569 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 176 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 5ft | 5997468.43063 | 2107123.32124 | 37.7656134384409 | -122.451993242792 | (37.7656134384409, -122.451993242792) | 15 | 5 | 11 | 29492 | 9 | |||
143885 | 180180 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5800 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5997294.9638 | 2086664.46286 | 37.7094284194653 | -122.451117714107 | (37.7094284194653, -122.451117714107) | 9 | 7 | 6 | 28861 | 25 | |||
144052 | 62172 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 11 Rudden Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/26/1985 12:00:00 AM | 9 | Permit Number 22288 | 6000332.12983 | 2091919.69679 | 37.7240315281222 | -122.440997555008 | (37.7240315281222, -122.440997555008) | 9 | 7 | 6 | 28861 | 25 | |
145715 | 198082 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011712.7254 | 2102495.42185 | 37.7537118581194 | -122.402399649231 | (37.7537118581194, -122.402399649231) | 10 | 3 | 8 | 28856 | 29 | |||
145966 | 66841 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 35 Chabot Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/15/1991 12:00:00 AM | 9 | Permit Number 30144 | 5997698.5472 | 2111460.9599 | 37.7775366565456 | -122.451510221257 | (37.7775366565456, -122.451510221257) | 15 | 6 | 2 | 54 | 16 | |
146445 | 241599 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 625 Anderson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007808.49618 | 2095970.64623 | 37.7355775551426 | -122.415439498728 | (37.7355775551426, -122.415439498728) | 2 | 7 | 7 | 28859 | 2 | |||
146624 | 241791 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 172 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004765.54841 | 2099610.72625 | 37.7454008840513 | -122.426219207144 | (37.7454008840513, -122.426219207144) | 2 | 7 | 5 | 63 | 22 | |||
148091 | 218434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 251 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5999743.2071 | 2094349.39165 | 37.7306693467912 | -122.443207786427 | (37.7306693467912, -122.443207786427) | 9 | 7 | 4 | 63 | 40 | |||
151794 | 41921 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 684 02nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | 9 | Permit Number 42282 | 5995365.10662 | 2110901.06053 | 37.7758654211269 | -122.459541756399 | (37.7758654211269, -122.459541756399) | 11 | 6 | 2 | 54 | 11 | |
155236 | 241420 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 92 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005875.99908 | 2099086.18658 | 37.744023320529 | -122.42234218035 | (37.744023320529, -122.42234218035) | 2 | 7 | 5 | 28859 | 2 | |||
156765 | 218645 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2535 14th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992035.19189 | 2098164.45765 | 37.7407020216726 | -122.470133027135 | (37.7407020216726, -122.470133027135) | 1 | 8 | 4 | 59 | 40 | |||
157934 | 241597 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 627 Anderson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007805.77873 | 2095938.0394 | 37.7354878711743 | -122.415446586307 | (37.7354878711743, -122.415446586307) | 2 | 7 | 7 | 28859 | 2 | |||
159225 | 218629 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2427 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991358.15777 | 2098883.93846 | 37.7426383681642 | -122.4725263722 | (37.7426383681642, -122.4725263722) | 1 | 8 | 4 | 29491 | 40 | |||
159478 | 241860 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 148 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008284.80969 | 2097901.69849 | 37.7409065625834 | -122.413929255552 | (37.7409065625834, -122.413929255552) | 2 | 7 | 7 | 28859 | 2 | |||
160288 | 26231 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 705 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | 3X3 | 6005812.2386247 | 2099008.4874519 | 37.7438063794529 | -122.422557129822 | (37.7438063794529, -122.422557129822) | 2 | 7 | 7 | 28859 | 2 | |||
161379 | 26079 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 233 Broad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/1997 12:00:00 AM | 9 | 3X3 | 5994695.0262 | 2088049.5542 | 37.7130823559233 | -122.460203749322 | (37.7130823559233, -122.460203749322) | 9 | 8 | 6 | 28861 | 24 | ||
161439 | 241866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 663 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008691.68406 | 2095758.35366 | 37.7350442472899 | -122.41237096965 | (37.7350442472899, -122.41237096965) | 10 | 7 | 7 | 28859 | 2 | |||
161720 | 65704 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 219 Allison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1990 12:00:00 AM | 9 | Permit Number 28633 | 6000112.02462 | 2087581.3858 | 37.7121069701409 | -122.441447264603 | (37.7121069701409, -122.441447264603) | 9 | 7 | 6 | 28861 | 5 | |
162440 | 198127 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2 Lucy St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6014137.80276 | 2093994.81434 | 37.7305060425038 | -122.393418272834 | (37.7305060425038, -122.393418272834) | 10 | 3 | 8 | 58 | 1 | |||
162683 | 69226 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 506 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | 9 | Permit Number 33278 | 6005300.9511 | 2111335.3122 | 37.7776240745803 | -122.425201999284 | (37.7776240745803, -122.425201999284) | 7 | 9 | 11 | 28852 | 10 | |
163134 | 26037 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 32 Broad St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/1997 12:00:00 AM | 9 | 3x3 | 5996338.32358 | 2088087.62846 | 37.7132812850863 | -122.454526743638 | (37.7132812850863, -122.454526743638) | 9 | 8 | 6 | 28861 | 24 | ||
163349 | 241865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 156 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008638.84118 | 2097802.85619 | 37.7406550402009 | -122.412698155623 | (37.7406550402009, -122.412698155623) | 10 | 7 | 7 | 28859 | 2 | |||
166812 | 241833 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 44 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998386.54425 | 2107247.8491 | 37.7660079062525 | -122.448826675005 | (37.7660079062525, -122.448826675005) | 15 | 5 | 11 | 29492 | 9 | |||
167933 | 198091 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201 Kansas St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011706.8942 | 2102698.90725 | 37.7542702588843 | -122.402434122061 | (37.7542702588843, -122.402434122061) | 10 | 3 | 8 | 28856 | 29 | |||
168038 | 218659 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 401 Montecito Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5995750.90192 | 2093985.2508 | 37.729441048245 | -122.456983382097 | (37.729441048245, -122.456983382097) | 9 | 7 | 4 | 28861 | 40 | |||
168311 | 241788 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 110 28th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6005139.08437 | 2099630.31349 | 37.7454757724008 | -122.424928972321 | (37.7454757724008, -122.424928972321) | 2 | 7 | 5 | 63 | 22 | |||
168969 | 241606 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 571 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008183.49921 | 2096172.16067 | 37.7361519404478 | -122.414157218373 | (37.7361519404478, -122.414157218373) | 2 | 7 | 7 | 28859 | 2 | |||
170855 | 241869 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 615 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008711.67151 | 2095961.46641 | 37.7356030725223 | -122.412316217131 | (37.7356030725223, -122.412316217131) | 10 | 7 | 7 | 28859 | 2 | |||
171064 | 180183 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 5810 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5997223.97549 | 2086636.40948 | 37.7093473266958 | -122.451361038275 | (37.7093473266958, -122.451361038275) | 9 | 7 | 6 | 28861 | 25 | |||
172344 | 23657 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 300 Virginia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1997 12:00:00 AM | 9 | 3X3 | 6006889.92909 | 2098258.78575 | 37.7418086059815 | -122.418777564558 | (37.7418086059815, -122.418777564558) | 2 | 7 | 7 | 28859 | 2 | ||
173004 | 136765 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3248 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5999349.57703 | 2120035.43346 | 37.801174314804 | -122.446415785968 | (37.801174314804, -122.446415785968) | 13 | 9 | 1 | 57 | 17 | |||
173611 | 30650 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Lafayette St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1995 12:00:00 AM | 9 | Permit Number 34589 | 6007455.20289 | 2109681.25412 | 37.7732038900692 | -122.417632430809 | (37.7732038900692, -122.417632430809) | 8 | 2 | 9 | 28853 | 19 | ||
174190 | 66974 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 290 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/22/1992 12:00:00 AM | 9 | Permit Number 30317 | 5996737.0249 | 2110855.143 | 37.7758181337994 | -122.45479264802 | (37.7758181337994, -122.45479264802) | 15 | 6 | 2 | 54 | 16 | |
175437 | 242325 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 99X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006215.7234 | 2102729.1867 | 37.7540453249341 | -122.421426151609 | (37.7540453249341, -122.421426151609) | 2 | 4 | 5 | 28859 | 19 | |||
177656 | 218674 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 111 Colon Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996129.26759 | 2093829.69076 | 37.7290356383815 | -122.455664103641 | (37.7290356383815, -122.455664103641) | 9 | 7 | 4 | 28861 | 40 | |||
177945 | 218451 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 442 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5997217.77483 | 2093837.51208 | 37.7291195199359 | -122.451901633359 | (37.7291195199359, -122.451901633359) | 9 | 7 | 4 | 28861 | 40 | |||
178682 | 140282 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 2111 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997756.6909 | 2110222.2195 | 37.774138725954 | -122.451219725793 | (37.774138725954, -122.451219725793) | 15 | 5 | 11 | 29492 | 16 | |||
180055 | 26051 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 144 Broad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/1997 12:00:00 AM | 9 | 3X3 | 5995427.3711 | 2088097.1376 | 37.713255106322 | -122.457675976804 | (37.713255106322, -122.457675976804) | 9 | 8 | 6 | 28861 | 24 | ||
181228 | 242270 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 4 Whitney St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004247.71361 | 2098276.47604 | 37.7417080563831 | -122.427914739472 | (37.7417080563831, -122.427914739472) | 2 | 7 | 5 | 63 | 7 | |||
181347 | 241411 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 130 Milton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6003752.23332 | 2095043.24019 | 37.7328022841872 | -122.429397431053 | (37.7328022841872, -122.429397431053) | 9 | 7 | 5 | 28861 | 25 | |||
184298 | 241818 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 157 Chattanooga St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004744.01194 | 2103001.62978 | 37.7547103016581 | -122.426535085039 | (37.7547103016581, -122.426535085039) | 2 | 4 | 5 | 28862 | 22 | |||
184320 | 242292 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 351 30th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6004196.55481 | 2098362.22479 | 37.7419406084852 | -122.428097738927 | (37.7419406084852, -122.428097738927) | 2 | 7 | 5 | 63 | 7 | |||
184799 | 109195 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3124 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5993662.38748 | 2110089.48079 | 37.7735389861421 | -122.465372883509 | (37.7735389861421, -122.465372883509) | 11 | 6 | 2 | 54 | 11 | |||
185084 | 180131 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 Naples St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6002011.626 | 2088868.77544 | 37.7157498953227 | -122.434973713382 | (37.7157498953227, -122.434973713382) | 9 | 7 | 6 | 28861 | 5 | |||
185822 | 214883 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1759 18th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5990584.61344 | 2103385.2354 | 37.7549529495235 | -122.475529632987 | (37.7549529495235, -122.475529632987) | 1 | 8 | 4 | 56 | 12 | |||
187825 | 241466 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 200 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6000596.15237 | 2102243.91372 | 37.7523944367565 | -122.440825121697 | (37.7523944367565, -122.440825121697) | 2 | 4 | 5 | 28862 | 22 | |||
188283 | 67401 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 543 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1992 12:00:00 AM | 9 | Permit Number 30898 | 5990607.88855 | 2111670.71644 | 37.7777039947588 | -122.476054246609 | (37.7777039947588, -122.476054246609) | 11 | 6 | 2 | 55 | 26 | |
188498 | 242150 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 180 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6001060.59943 | 2105394.5689 | 37.7610718108367 | -122.439444819734 | (37.7610718108367, -122.439444819734) | 15 | 4 | 5 | 28862 | 3 | |||
188626 | 248418 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1757 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5997316.374 | 2108092.7223 | 37.7682664550348 | -122.452589137037 | (37.7682664550348, -122.452589137037) | 15 | 5 | 11 | 29492 | 9 | |||
190647 | 180157 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 579 Madrid St | 21 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 2ft | 6002506.03817 | 2090671.05856 | 37.7207266257051 | -122.433393514622 | (37.7207266257051, -122.433393514622) | 9 | 7 | 6 | 28861 | 5 | |||
192582 | 198113 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 453 Mississippi St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6014103.66815 | 2105000.08777 | 37.7607223118011 | -122.394306519737 | (37.7607223118011, -122.394306519737) | 10 | 3 | 8 | 28856 | 29 | |||
194277 | 180017 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1985 Alemany Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 785142 | 6000882.12551 | 2090726.03967 | 37.7207853271706 | -122.439010804221 | (37.7207853271706, -122.439010804221) | 9 | 7 | 6 | 28861 | 25 | ||
105806 | 5718 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1651 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 3X3 | 6005348.21594 | 2098686.18257 | 37.7428952145313 | -122.424138695771 | (37.7428952145313, -122.424138695771) | 2 | 7 | 5 | 28859 | 22 | |||
153287 | 5727 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1677X Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6005353.56233 | 2098539.50836 | 37.742492782318 | -122.424109780756 | (37.742492782318, -122.424109780756) | 2 | 7 | 5 | 28859 | 22 | |||
1729 | 75952 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 6555 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5986669.94788 | 2112490.96622 | 37.7797270399513 | -122.489737083171 | (37.7797270399513, -122.489737083171) | 11 | 6 | 2 | 55 | 26 | |||
1854 | 241885 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 118 Ellert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007147.65495 | 2096997.64072 | 37.7383602895823 | -122.417797058006 | (37.7383602895823, -122.417797058006) | 2 | 7 | 7 | 28859 | 2 | |||
1870 | 70434 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 855 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 3x3 | 5982604.49779 | 2109922.26737 | 37.772435937677 | -122.503610737191 | (37.772435937677, -122.503610737191) | 11 | 6 | 2 | 55 | 26 | ||
2354 | 65134 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 608 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1989 12:00:00 AM | 8 | Permit Number 27109 | 5984138.754 | 2111678.31461 | 37.7773476222303 | -122.498433409341 | (37.7773476222303, -122.498433409341) | 11 | 6 | 2 | 55 | 26 | |
3406 | 26232 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 705X San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/23/1997 12:00:00 AM | 8 | 3X3 | 6005809.35017 | 2099009.02543 | 37.7438076936648 | -122.422567155652 | (37.7438076936648, -122.422567155652) | 2 | 7 | 7 | 28859 | 2 | ||
3423 | 71632 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 623 38th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5984096.43813 | 2111562.96127 | 37.7770284137687 | -122.498571268398 | (37.7770284137687, -122.498571268398) | 11 | 6 | 2 | 55 | 26 | |||
4464 | 241896 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1201X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008351.5522 | 2097694.26148 | 37.7403407343459 | -122.413683815267 | (37.7403407343459, -122.413683815267) | 2 | 7 | 7 | 28859 | 2 | |||
4706 | 71655 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 551 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6010904.1531 | 2118940.5182 | 37.7988211063956 | -122.406354529449 | (37.7988211063956, -122.406354529449) | 3 | 1 | 10 | 308 | 23 | |||
4767 | 40166 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3031 Octavia St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/1999 12:00:00 AM | 8 | 6x6 | Permit Number 41359 | 6004240.20521 | 2119600.37832 | 37.8002578795473 | -122.429461041019 | (37.8002578795473, -122.429461041019) | 13 | 9 | 1 | 57 | 17 |
5139 | 19520 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 127 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 4X4 | 6000564 | 2112525 | 37.7806219117946 | -122.44167407009 | (37.7806219117946, -122.44167407009) | 15 | 5 | 1 | 29490 | 16 | |||
8153 | 198101 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1272 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011939.76005 | 2102498.21472 | 37.7537321980948 | -122.401614703879 | (37.7537321980948, -122.401614703879) | 10 | 3 | 8 | 28856 | 29 |
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) );