trees
1,194 rows where qSpecies_id = 50 sorted by qSiteInfo 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1084 | 229775 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011442.57459 | 2102566.84517 | 37.7538928862632 | -122.403338920978 | (37.7538928862632, -122.403338920978) | 10 | 4 | 8 | 28859 | 19 | |||
15057 | 229773 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 43 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011446.65854 | 2102520.54386 | 37.7537659811344 | -122.403321540662 | (37.7537659811344, -122.403321540662) | 10 | 4 | 8 | 28859 | 19 | |||
18290 | 229761 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 31 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011456.4035 | 2102287.48645 | 37.7531266009123 | -122.403271446634 | (37.7531266009123, -122.403271446634) | 10 | 4 | 8 | 28859 | 19 | |||
26709 | 201517 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 911 Innes Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 5ft | 6019123.25931 | 2094488.31096 | 37.7321368236424 | -122.376216835747 | (37.7321368236424, -122.376216835747) | 10 | 3 | 8 | 58 | 1 | |||
29151 | 229756 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.15557 | 2102190.87321 | 37.7528617550894 | -122.403237842573 | (37.7528617550894, -122.403237842573) | 10 | 4 | 8 | 28859 | 19 | |||
32924 | 190747 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 200 Kansas St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 4ft | 6011390.12769 | 2107238.80287 | 37.7667181107881 | -122.403849027209 | (37.7667181107881, -122.403849027209) | 8 | 2 | 8 | 28853 | 20 | |||
36074 | 229770 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011448.51225 | 2102466.33912 | 37.753617250357 | -122.403311317166 | (37.753617250357, -122.403311317166) | 10 | 4 | 8 | 28859 | 19 | |||
38692 | 229763 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 6011453.21392 | 2102329.36922 | 37.7532414236718 | -122.403285422977 | (37.7532414236718, -122.403285422977) | 10 | 4 | 8 | 28859 | 19 | |||
39351 | 226812 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2 Belcher St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 1ft | 6003760.63198 | 2108231.56549 | 37.7690148102126 | -122.430308989291 | (37.7690148102126, -122.430308989291) | 7 | 9 | 5 | 28862 | 3 | |||
41300 | 229766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 36 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011452.91917 | 2102390.65584 | 37.7534096868171 | -122.403290753279 | (37.7534096868171, -122.403290753279) | 10 | 4 | 8 | 28859 | 19 | |||
41670 | 229778 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 48 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011440.8047 | 2102625.16918 | 37.7540529323224 | -122.403349144463 | (37.7540529323224, -122.403349144463) | 10 | 4 | 8 | 28859 | 19 | |||
47608 | 176585 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Seneca Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 5999821.59853 | 2090369.86807 | 37.719746961831 | -122.442651149242 | (37.719746961831, -122.442651149242) | 9 | 7 | 6 | 28861 | 25 | |||
54681 | 229760 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011458.91565 | 2102265.65077 | 37.7530667852271 | -122.403261223145 | (37.7530667852271, -122.403261223145) | 10 | 4 | 8 | 28859 | 19 | |||
55327 | 229772 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 42 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011446.86383 | 2102500.86077 | 37.7537119471592 | -122.403319446151 | (37.7537119471592, -122.403319446151) | 10 | 4 | 8 | 28859 | 19 | |||
57678 | 226799 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 701 Sanchez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6003733.12478 | 2104096.27114 | 37.7576587280713 | -122.430109091559 | (37.7576587280713, -122.430109091559) | 2 | 4 | 5 | 28862 | 3 | |||
70019 | 229864 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 76 Peralta Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 5ft | 6010511.83754 | 2100376.53881 | 37.7478267603098 | -122.406403320374 | (37.7478267603098, -122.406403320374) | 2 | 7 | 7 | 28859 | 2 | |||
70055 | 229765 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011453.42278 | 2102371.80516 | 37.7533579551144 | -122.403287685694 | (37.7533579551144, -122.403287685694) | 10 | 4 | 8 | 28859 | 19 | |||
88805 | 229752 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011465.52618 | 2102102.51804 | 37.7526192277045 | -122.403226887931 | (37.7526192277045, -122.403226887931) | 10 | 4 | 8 | 28859 | 19 | |||
91184 | 226792 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 379 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002133.75148 | 2103664.46985 | 37.7563823922541 | -122.435609479191 | (37.7563823922541, -122.435609479191) | 2 | 4 | 5 | 28862 | 3 | |||
92812 | 229776 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011441.50409 | 2102586.88485 | 37.7539478510307 | -122.40334403271 | (37.7539478510307, -122.40334403271) | 10 | 4 | 8 | 28859 | 19 | |||
93661 | 229780 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 4ft | 6011438.15067 | 2102669.08614 | 37.7541733704045 | -122.403361412121 | (37.7541733704045, -122.403361412121) | 10 | 4 | 8 | 28859 | 19 | |||
95325 | 229771 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 41 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011447.67718 | 2102483.4305 | 37.7536641328931 | -122.403315407293 | (37.7536641328931, -122.403315407293) | 10 | 4 | 8 | 28859 | 19 | |||
95655 | 229774 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 44 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011445.35286 | 2102545.22023 | 37.7538336641006 | -122.403327791844 | (37.7538336641006, -122.403327791844) | 10 | 4 | 8 | 28859 | 19 | |||
101836 | 190716 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 333 Arkansas St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6012961.26572 | 2105490.25457 | 37.7620046335244 | -122.398291995789 | (37.7620046335244, -122.398291995789) | 10 | 3 | 8 | 28856 | 29 | |||
102641 | 229758 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 28 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011460.45759 | 2102239.71319 | 37.7529956524374 | -122.403254066338 | (37.7529956524374, -122.403254066338) | 10 | 4 | 8 | 28859 | 19 | |||
106216 | 226380 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Nebraska St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6009262.96454 | 2097691.62969 | 37.7403846464258 | -122.410532314727 | (37.7403846464258, -122.410532314727) | 10 | 7 | 7 | 28859 | 2 | |||
106642 | 229781 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011437.0323 | 2102686.77187 | 37.7542218690658 | -122.403366523848 | (37.7542218690658, -122.403366523848) | 10 | 4 | 8 | 28859 | 19 | |||
107367 | 229764 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011452.97986 | 2102350.02958 | 37.753298139414 | -122.403287685686 | (37.753298139414, -122.403287685686) | 10 | 4 | 8 | 28859 | 19 | |||
109658 | 190748 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 200 Kansas St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 4ft | 6011391.69355 | 2107207.84436 | 37.7666331931997 | -122.403841432442 | (37.7666331931997, -122.403841432442) | 8 | 2 | 8 | 28853 | 20 | |||
120093 | 229753 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011465.79162 | 2102125.84808 | 37.7526833017063 | -122.403227610989 | (37.7526833017063, -122.403227610989) | 10 | 4 | 8 | 28859 | 19 | |||
120945 | 229754 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.93054 | 2102145.24186 | 37.7527365046859 | -122.403231952908 | (37.7527365046859, -122.403231952908) | 10 | 4 | 8 | 28859 | 19 | |||
122297 | 229767 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 37 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011451.55336 | 2102410.70185 | 37.7534646524788 | -122.403296886638 | (37.7534646524788, -122.403296886638) | 10 | 4 | 8 | 28859 | 19 | |||
127332 | 229777 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 47 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011441.00674 | 2102606.02985 | 37.7540003912143 | -122.403347099413 | (37.7540003912143, -122.403347099413) | 10 | 4 | 8 | 28859 | 19 | |||
140532 | 226793 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 379 Collingwood St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 6002133.14773 | 2103676.31571 | 37.7564148838461 | -122.435612414605 | (37.7564148838461, -122.435612414605) | 2 | 4 | 5 | 28862 | 3 | |||
143926 | 229768 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 38 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011450.10406 | 2102428.33109 | 37.7535129775571 | -122.403303138733 | (37.7535129775571, -122.403303138733) | 10 | 4 | 8 | 28859 | 19 | |||
146308 | 226381 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 60 Nebraska St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 3ft | 6009264.00065 | 2097705.48363 | 37.7404227444144 | -122.410529710297 | (37.7404227444144, -122.410529710297) | 10 | 7 | 7 | 28859 | 2 | |||
154582 | 229782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011435.78224 | 2102697.98371 | 37.7542525844934 | -122.403371635592 | (37.7542525844934, -122.403371635592) | 10 | 4 | 8 | 28859 | 19 | |||
159856 | 229762 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011454.29465 | 2102314.61303 | 37.7532009667707 | -122.403280647606 | (37.7532009667707, -122.403280647606) | 10 | 4 | 8 | 28859 | 19 | |||
164341 | 229751 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011465.75975 | 2102083.13702 | 37.7525660247145 | -122.40322471697 | (37.7525660247145, -122.40322471697) | 10 | 4 | 8 | 28859 | 19 | |||
165791 | 229757 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 4ft | 6011461.99954 | 2102213.77594 | 37.752924520553 | -122.403246909533 | (37.752924520553, -122.403246909533) | 10 | 4 | 8 | 28859 | 19 | |||
168519 | 229779 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 49 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011439.17328 | 2102646.69218 | 37.75411193863 | -122.403356300366 | (37.75411193863, -122.403356300366) | 10 | 4 | 8 | 28859 | 19 | |||
170096 | 229769 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6011449.91996 | 2102448.35306 | 37.7535679432079 | -122.403305183785 | (37.7535679432079, -122.403305183785) | 10 | 4 | 8 | 28859 | 19 | |||
177270 | 176586 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 205 Seneca Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 6ft | 5999824.12192 | 2090353.83878 | 37.7197030929005 | -122.442641276491 | (37.7197030929005, -122.442641276491) | 9 | 7 | 6 | 28861 | 25 | |||
187690 | 229759 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6011459.21947 | 2102251.51401 | 37.753027985753 | -122.403259178089 | (37.753027985753, -122.403259178089) | 10 | 4 | 8 | 28859 | 19 | |||
193911 | 229755 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1201 Vermont St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 6011464.24481 | 2102169.9708 | 37.7528043666378 | -122.403236063707 | (37.7528043666378, -122.403236063707) | 10 | 4 | 8 | 28859 | 19 | |||
13592 | 162301 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 238 Olmstead St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 08/17/2019 12:00:00 AM | 3 | Width 0ft | 6010941.2062 | 2091035.49966 | 37.7222022558199 | -122.404261226995 | (37.7222022558199, -122.404261226995) | 10 | 3 | 7 | 309 | 28 | ||
93499 | 106047 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 618- 622 Carolina St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | 15 | 6x7 | 6012364.1992 | 2105044.14437 | 37.7607464370199 | -122.400325694786 | (37.7607464370199, -122.400325694786) | 10 | 3 | 8 | 28856 | 29 | |||
34108 | 190689 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6015296.26829 | 2103832.96006 | 37.7575838496448 | -122.390100279027 | (37.7575838496448, -122.390100279027) | 10 | 3 | 8 | 28856 | 29 | |||
49110 | 190693 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 949 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 6ft | 6015286.01268 | 2104068.80958 | 37.7582308731831 | -122.390152223841 | (37.7582308731831, -122.390152223841) | 10 | 3 | 8 | 28856 | 29 | |||
53104 | 229794 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 270 14th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006938.57132 | 2107935.81183 | 37.7683822351787 | -122.419295689168 | (37.7683822351787, -122.419295689168) | 8 | 4 | 7 | 28853 | 19 | |||
63197 | 190746 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014545.66843 | 2096162.71895 | 37.7364813198484 | -122.392159766062 | (37.7364813198484, -122.392159766062) | 10 | 3 | 8 | 58 | 1 | |||
63895 | 226815 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4132 17th St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6001471.84267 | 2105861.76416 | 37.7623780104526 | -122.438055976903 | (37.7623780104526, -122.438055976903) | 15 | 5 | 5 | 28862 | 3 | |||
65837 | 190717 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1150 19th St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6014133.64605 | 2105280.55607 | 37.7614940829991 | -122.394222475384 | (37.7614940829991, -122.394222475384) | 10 | 3 | 8 | 28856 | 29 | |||
72353 | 190688 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015295.35609 | 2103854.98706 | 37.7576442804869 | -122.390104972579 | (37.7576442804869, -122.390104972579) | 10 | 3 | 8 | 28856 | 29 | |||
74231 | 226816 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4132 17th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 6001458.28578 | 2105860.25499 | 37.7623730956507 | -122.438102756943 | (37.7623730956507, -122.438102756943) | 15 | 5 | 5 | 28862 | 3 | |||
102465 | 190690 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1003 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015296.6982 | 2103817.69544 | 37.7575419601034 | -122.390097725855 | (37.7575419601034, -122.390097725855) | 10 | 3 | 8 | 28856 | 29 | |||
105814 | 229742 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 749 Dolores St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 8ft | 6005048.07948 | 2104060.60475 | 37.7576351838315 | -122.425558898838 | (37.7576351838315, -122.425558898838) | 2 | 4 | 5 | 28859 | 19 | |||
108539 | 219235 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 5 Sequoia Way | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5998215.18129 | 2097817.79881 | 37.7401055166597 | -122.448740104476 | (37.7401055166597, -122.448740104476) | 9 | 7 | 4 | 59 | 40 | |||
129660 | 190687 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1001 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015294.95519 | 2103873.52866 | 37.7576951695231 | -122.390107654354 | (37.7576951695231, -122.390107654354) | 10 | 3 | 8 | 28856 | 29 | |||
146544 | 190691 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1005 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6015298.33049 | 2103800.67785 | 37.757495323968 | -122.390090891879 | (37.757495323968, -122.390090891879) | 10 | 3 | 8 | 28856 | 29 | |||
153023 | 226782 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 6003036.36439 | 2104869.3742 | 37.7597419968272 | -122.432573993 | (37.7597419968272, -122.432573993) | 2 | 4 | 5 | 28862 | 3 | |||
163736 | 226783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 579 Noe St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003034.17518 | 2104887.2525 | 37.7597909621971 | -122.432582841439 | (37.7597909621971, -122.432582841439) | 2 | 4 | 5 | 28862 | 3 | |||
24224 | 229868 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 248 28th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6004337.80093 | 2099585.86328 | 37.7453084292413 | -122.427696518086 | (37.7453084292413, -122.427696518086) | 2 | 7 | 5 | 63 | 22 | |||
50723 | 229783 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 975 San Bruno Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 4ft | 6011090.02369 | 2103815.82999 | 37.7573026253193 | -122.404646049572 | (37.7573026253193, -122.404646049572) | 10 | 4 | 8 | 28859 | 19 | |||
64645 | 190712 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 204 Texas St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6013703.78505 | 2106091.36578 | 37.7636964858312 | -122.395766012395 | (37.7636964858312, -122.395766012395) | 14 | 3 | 8 | 28856 | 29 | |||
98840 | 229870 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3952 26th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 6004170.69747 | 2100746.77802 | 37.7484865785056 | -122.42835706113 | (37.7484865785056, -122.42835706113) | 2 | 4 | 5 | 28862 | 22 | |||
123971 | 229884 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 137 Bradford St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 11 | Width 5ft | 6009563.00843 | 2097787.48407 | 37.7406646584401 | -122.409501640412 | (37.7406646584401, -122.409501640412) | 10 | 7 | 7 | 28859 | 2 | |||
165178 | 226466 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 7 28th St | 4 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 6005836.7555 | 2099627.17961 | 37.7455065507954 | -122.422516309799 | (37.7455065507954, -122.422516309799) | 2 | 7 | 5 | 28859 | 22 | |||
104 | 260590 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3099x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | ||||||||||||
114 | 251458 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
543 | 100400 | Undocumented 4 | Jacaranda mimosifolia :: Jacaranda 50 | 88 Manchester St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 6x3 | 6008223 | 2099495 | 37.7452779444232 | -122.414255673266 | (37.7452779444232, -122.414255673266) | 2 | 7 | 7 | 28859 | 2 | |||
571 | 91075 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 576 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2008 12:00:00 AM | 3x3 | Permit Number 51977 | 6007858 | 2104570 | 37.7591922359052 | -122.415877090614 | (37.7591922359052, -122.415877090614) | 2 | 4 | 7 | 28859 | 19 | ||
685 | 151339 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 1411 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2019 12:00:00 AM | 3 | 6x6 | Permit Number 781016 | 6009578.8057 | 2100900.01209 | 37.7492118628581 | -122.409666655187 | (37.7492118628581, -122.409666655187) | 2 | 4 | 7 | 28859 | 19 | |
761 | 224987 | Planning Code 138.1 required 2 | Jacaranda mimosifolia :: Jacaranda 50 | 484 Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2019 12:00:00 AM | 3 | 4x4 | Permit Number 782366 | 6003591.74199 | 2105457.02251 | 37.7613870178149 | -122.430695151865 | (37.7613870178149, -122.430695151865) | 15 | 4 | 5 | 28862 | 3 | |
779 | 69766 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1725 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 6014547.15395 | 2096165.56329 | 37.7364892123042 | -122.392154828809 | (37.7364892123042, -122.392154828809) | 10 | 3 | 8 | 58 | 1 | |||
852 | 108444 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/22/2014 12:00:00 AM | 2 | 3x2.5 | 6014877 | 2117007 | 37.7937335561349 | -122.392471758503 | (37.7937335561349, -122.392471758503) | 12 | 2 | 9 | 28855 | 6 | |
938 | 167297 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3500 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6004922.20627 | 2103712.53255 | 37.7566723462619 | -122.425969442941 | (37.7566723462619, -122.425969442941) | 2 | 4 | 5 | 28862 | 3 | |||
991 | 38251 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 1475 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1998 12:00:00 AM | Permit Number 40361 | 6007534.04468586 | 2107333.12590687 | 37.7667609198383 | -122.417193284079 | (37.7667609198383, -122.417193284079) | 8 | 4 | 7 | 28853 | 19 | ||
1529 | 36010 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 190 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/27/1998 12:00:00 AM | Permit Number 39158 | 6005991.6913929 | 2099142.23667474 | 37.7441837468315 | -122.421946122617 | (37.7441837468315, -122.421946122617) | 2 | 7 | 5 | 28859 | 2 | ||
1622 | 78494 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2131 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6012056.35315 | 2102319.00627 | 37.7532466361332 | -122.401198904113 | (37.7532466361332, -122.401198904113) | 10 | 3 | 8 | 28856 | 29 | |||
1652 | 243315 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 40 San Carlos St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006628.53628 | 2105662.75814 | 37.7621234987325 | -122.420206730272 | (37.7621234987325, -122.420206730272) | 8 | 4 | 7 | 28859 | 19 | |||
1698 | 244767 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2500 Harrison St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 09:35:00 PM | 3 | Width 3ft | 6008837.10491 | 2103758.81421 | 37.7570199000752 | -122.412433524704 | (37.7570199000752, -122.412433524704) | 2 | 4 | 7 | 28859 | 19 | ||
1823 | 162258 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 800 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/23/2020 12:00:00 AM | 3 | Width 0ft | 6011414.80687 | 2091110.91102 | 37.7224357728692 | -122.402629394533 | (37.7224357728692, -122.402629394533) | 10 | 3 | 7 | 309 | 28 | ||
1963 | 229848 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3494 21st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6005112.08271 | 2103723.92824 | 37.7567143652889 | -122.425313591669 | (37.7567143652889, -122.425313591669) | 2 | 4 | 5 | 28859 | 19 | |||
1985 | 47 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 810 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1998 12:00:00 AM | 6 | 3x3 | 6003389.55254 | 2107739.47109 | 37.7676426129451 | -122.431557393053 | (37.7676426129451, -122.431557393053) | 15 | 5 | 5 | 28862 | 3 | ||
2118 | 73083 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 3246 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/18/1999 12:00:00 AM | 3x3 | 6007158.13725384 | 2106179.72119915 | 37.7635727856768 | -122.418411696436 | (37.7635727856768, -122.418411696436) | 8 | 4 | 7 | 28859 | 19 | ||
2273 | 228542 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1465 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 6ft | 6009587.77635 | 2100703.29886 | 37.7486722345333 | -122.409621752043 | (37.7486722345333, -122.409621752043) | 2 | 4 | 7 | 28859 | 19 | |||
2344 | 190703 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 707 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6012441.45218 | 2104621.0711 | 37.759589078787 | -122.400028798005 | (37.759589078787, -122.400028798005) | 10 | 3 | 8 | 28856 | 29 | |||
2360 | 190701 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 199 Texas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013753.34046 | 2106269.97699 | 37.7641896695377 | -122.395607129171 | (37.7641896695377, -122.395607129171) | 14 | 3 | 8 | 28856 | 29 | |||
2363 | 243655 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 4140 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6002213.79042 | 2102389.84201 | 37.7528871150509 | -122.435241509003 | (37.7528871150509, -122.435241509003) | 2 | 4 | 5 | 28862 | 22 | |||
2489 | 224583 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 2701 16th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/13/2020 12:00:00 AM | 3 | 6x3 | Permit Number 781047 | 6008562.45401 | 2106796.83945 | 37.7653462039852 | -122.413598242063 | (37.7653462039852, -122.413598242063) | 8 | 4 | 7 | 28859 | 19 | |
2827 | 253039 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 531 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/11/2017 12:00:00 AM | 3 | 13x6.5 | 6003687 | 2105184 | 37.7606427596565 | -122.43034621439 | (37.7606427596565, -122.43034621439) | 2 | 4 | 5 | 28862 | 3 | ||
2916 | 53252 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 18 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1969 12:00:00 AM | 7 | Permit Number 6139 | 6004056.10022951 | 2102948.9340362 | 37.754526698445 | -122.428910313961 | (37.754526698445, -122.428910313961) | 2 | 4 | 5 | 28862 | 22 | ||
3571 | 102167 | Permitted Site 7 | Jacaranda mimosifolia :: Jacaranda 50 | 677 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/31/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769761 | 6002448.6 | 2104297.1 | 37.7581373205651 | -122.4345658575 | (37.7581373205651, -122.4345658575) | 2 | 4 | 5 | 28862 | 3 |
3601 | 32960 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 934 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 16 | 6x12 | Permit Number 37274 | 6015218.03519 | 2104239.88822 | 37.7586968478982 | -122.390399274809 | (37.7586968478982, -122.390399274809) | 10 | 3 | 8 | 28856 | 29 |
3670 | 229792 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1347 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006987.3466 | 2107613.99379 | 37.7675013456445 | -122.419104149736 | (37.7675013456445, -122.419104149736) | 8 | 4 | 7 | 28853 | 19 | |||
3767 | 226772 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 580 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002600.09968 | 2103291.61408 | 37.7553850962495 | -122.433970034883 | (37.7553850962495, -122.433970034883) | 2 | 4 | 5 | 28862 | 22 | |||
3860 | 106 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 927 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 3x3 | 6002652.29309 | 2107649.54302 | 37.7673538775163 | -122.434101048134 | (37.7673538775163, -122.434101048134) | 15 | 5 | 5 | 28862 | 3 | |||
3966 | 249038 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 22 Carr St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6013079.09197 | 2090984.85367 | 37.7221824230653 | -122.396867469658 | (37.7221824230653, -122.396867469658) | 10 | 3 | 8 | 58 | 1 | |
4309 | 69898 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 1019 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011946.5334 | 2103437.3528 | 37.756311243277 | -122.401657284058 | (37.756311243277, -122.401657284058) | 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) );