Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 973 | 973 | 248014 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 525 Franconia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 4ft | 6009926.50706 | 2098096.5279599996 | 37.7415335869952 | -122.40826658702801 | (37.7415335869952, -122.408266587028) | |||
| 1791 | 1791 | 251711 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 3 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1793 | 1793 | 251713 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 5 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1795 | 1795 | 251712 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 4 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1797 | 1797 | 251710 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 2 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1799 | 1799 | 251715 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 7 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1805 | 1805 | 251709 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 1 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 1807 | 1807 | 251714 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 902 Market St | 6 | Front Yard : Cutout 8 | Tree 1 | DPW 2 | 3x3 | 6010270.0 | 2113565.0 | 37.7840257341798 | -122.4081695922 | (37.7840257341798, -122.4081695922) | ||||
| 18807 | 18807 | 4403 | DPW Maintained 3 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1044 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004378.89078 | 2102815.5899099996 | 37.754178832009295 | -122.42778451855101 | (37.7541788320093, -122.427784518551) | |||
| 19699 | 19699 | 113640 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 545X Minna St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.40872210131901 | (37.7800965567953, -122.408722101319) | |||||
| 24554 | 24554 | 197424 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015005.7210099995 | 2109404.95283 | 37.77286720818179 | -122.39149465358 | (37.7728672081818, -122.39149465358) | |||
| 25675 | 25675 | 240946 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 192 Laidley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6004126.6518 | 2097259.6464 | 37.7389092249709 | -122.42826087863199 | (37.7389092249709, -122.428260878632) | |||
| 25742 | 25742 | 240895 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008713.19989 | 2101208.21335 | 37.7500095705047 | -122.41268172948999 | (37.7500095705047, -122.41268172949) | |||
| 26063 | 26063 | 197421 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015000.4324199995 | 2109495.8046 | 37.7731163734468 | -122.391519300385 | (37.7731163734468, -122.391519300385) | |||
| 26382 | 26382 | 197390 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1350 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015085.78148 | 2108970.82178 | 37.771679623744895 | -122.39118736151 | (37.7716796237449, -122.39118736151) | |||
| 27001 | 27001 | 240920 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 83 Bemis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003674.035680001 | 2096782.4089099998 | 37.7375732191201 | -122.42979178467199 | (37.7375732191201, -122.429791784672) | |||
| 27075 | 27075 | 136353 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1508 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005781.66694 | 2118620.21558 | 37.7976537549681 | -122.424057229776 | (37.7976537549681, -122.424057229776) | |||
| 27380 | 27380 | 240911 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1051 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009458.354780001 | 2103057.57846 | 37.755129308388796 | -122.410235489878 | (37.7551293083888, -122.410235489878) | |||
| 27443 | 27443 | 136362 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1715 Taylor St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6008714.5466 | 2118843.19382 | 37.7984311487376 | -122.413924418086 | (37.7984311487376, -122.413924418086) | |||
| 29594 | 29594 | 136360 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1725 Taylor St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008711.32926 | 2118885.42513 | 37.7985469247543 | -122.41393854015499 | (37.7985469247543, -122.413938540155) | |||
| 29651 | 29651 | 240512 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 301 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009219.21952 | 2106751.79124 | 37.7652593690624 | -122.41132345193998 | (37.7652593690624, -122.41132345194) | |||
| 29703 | 29703 | 197375 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 300 San Bruno Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010873.43891 | 2106555.26332 | 37.7648123871029 | -122.405588027383 | (37.7648123871029, -122.405588027383) | |||
| 30840 | 30840 | 248013 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 525 Franconia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009922.12667 | 2098078.01565 | 37.741482510922395 | -122.408280427599 | (37.7414825109224, -122.408280427599) | |||
| 31301 | 31301 | 136352 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 301 Euclid Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 5997962.800430001 | 2113889.01187 | 37.7842185814711 | -122.450771195452 | (37.7842185814711, -122.450771195452) | |||
| 31538 | 31538 | 197428 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015013.65902 | 2109278.1968400003 | 37.7725196049206 | -122.39145833173 | (37.7725196049206, -122.39145833173) | |||
| 32059 | 32059 | 240896 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008710.779680001 | 2101249.00025 | 37.7501214263764 | -122.41269298178999 | (37.7501214263764, -122.41269298179) | |||
| 33768 | 33768 | 46508 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 675 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | 5 | Permit Number 44677 | 6009091.30835 | 2111167.9463 | 37.777377926079 | -122.412077991228 | (37.777377926079, -122.412077991228) | ||
| 35818 | 35818 | 248016 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 525 Franconia St | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6009938.8027 | 2098138.8555900003 | 37.7416504979844 | -122.408227057349 | (37.7416504979844, -122.408227057349) | |||
| 36656 | 36656 | 136354 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1508 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005758.24578 | 2118617.72057 | 37.79764558194071 | -122.42413809590401 | (37.7976455819407, -122.424138095904) | |||
| 36929 | 36929 | 197417 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1110 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014986.84616 | 2109711.37392 | 37.7737075248119 | -122.391581371605 | (37.7737075248119, -122.391581371605) | |||
| 36973 | 36973 | 197446 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 577 Nelson Rising Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013697.348569999 | 2108075.95156 | 37.7691453611896 | -122.39592735257798 | (37.7691453611896, -122.395927352578) | |||
| 37373 | 37373 | 36876 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2400 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 6 | Permit Number 39539 | 6000808.4477 | 2116625.0074 | 37.791893398513395 | -122.44112265160601 | (37.7918933985134, -122.441122651606) | |
| 37840 | 37840 | 197380 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2251 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6012873.308019999 | 2096314.08493 | 37.7368039417418 | -122.39795247834299 | (37.7368039417418, -122.397952478343) | |||
| 37953 | 37953 | 197420 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014998.578369999 | 2109523.60508 | 37.773192604486105 | -122.391527657797 | (37.7731926044861, -122.391527657797) | |||
| 38124 | 38124 | 197384 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1350 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015096.00206 | 2108800.56286 | 37.7712126975445 | -122.391140104833 | (37.7712126975445, -122.391140104833) | |||
| 39414 | 39414 | 119522 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 790 31st Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5986359.69309 | 2110558.27509 | 37.7744022999761 | -122.490668135755 | (37.7744022999761, -122.490668135755) | |||
| 39658 | 39658 | 197389 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1350 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015087.5689199995 | 2108946.60059 | 37.771613216903894 | -122.39117948526001 | (37.7716132169039, -122.39117948526) | |||
| 41777 | 41777 | 240887 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 3009 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 5ft | 6009470.6055 | 2100993.60175 | 37.7494627754843 | -122.41004742097601 | (37.7494627754843, -122.410047420976) | |||
| 42363 | 42363 | 240915 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 315 Lexington St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006533.583380001 | 2104305.2413 | 37.7583907231708 | -122.420438775123 | (37.7583907231708, -122.420438775123) | |||
| 43111 | 43111 | 197438 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015034.670969999 | 2108883.60182 | 37.7714373005145 | -122.391358059129 | (37.7714373005145, -122.391358059129) | |||
| 43994 | 43994 | 136359 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1725 Taylor St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6008708.52224 | 2118897.8442599997 | 37.7985808669576 | -122.413949132363 | (37.7985808669576, -122.413949132363) | |||
| 44403 | 44403 | 197400 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1155 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015059.961759999 | 2109443.9934900003 | 37.7729774155998 | -122.391309756557 | (37.7729774155998, -122.391309756557) | |||
| 44420 | 44420 | 197457 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009096.316000001 | 2110957.37076 | 37.77680001633121 | -122.412045782913 | (37.7768000163312, -122.412045782913) | |||
| 44992 | 44992 | 240941 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 53 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004292.854119999 | 2105210.6370599996 | 37.760750197983896 | -122.4282527371 | (37.7607501979839, -122.4282527371) | |||
| 45338 | 45338 | 240929 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 147 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005793.48345 | 2096408.78374 | 37.7366671197906 | -122.42243729804399 | (37.7366671197906, -122.422437298044) | |||
| 45643 | 45643 | 197407 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1101 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015042.44961 | 2109744.00575 | 37.7738002107574 | -122.39139131066999 | (37.7738002107574, -122.39139131067) | |||
| 46280 | 46280 | 197411 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1101 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015024.81769 | 2109879.0365400002 | 37.774169996686 | -122.391461744659 | (37.774169996686, -122.391461744659) | |||
| 47169 | 47169 | 38986 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 300x San Bruno Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1998 12:00:00 AM | 5 | 3x3 | Permit Number 40762 | 6010873.0726 | 2106579.5754400003 | 37.764879122199 | -122.405591006845 | (37.764879122199, -122.405591006845) | |
| 48334 | 48334 | 197414 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1110 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6014981.739440001 | 2109803.00942 | 37.7739588520651 | -122.391605444662 | (37.7739588520651, -122.391605444662) | |||
| 48402 | 48402 | 240890 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008720.4908300005 | 2101064.55739 | 37.749615532544 | -122.412646362752 | (37.749615532544, -122.412646362752) | |||
| 48807 | 48807 | 240912 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 85 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006337.237319999 | 2105831.0184 | 37.7625690840066 | -122.421226172049 | (37.7625690840066, -122.421226172049) | |||
| 50197 | 50197 | 240889 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008721.46882 | 2101044.16868 | 37.7495596045891 | -122.41264153966999 | (37.7495596045891, -122.41264153967) | |||
| 51110 | 51110 | 197419 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1110 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014990.758169999 | 2109661.0531900004 | 37.7735695724098 | -122.39156432044399 | (37.7735695724098, -122.391564320444) | |||
| 52247 | 52247 | 240888 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008723.38535 | 2101024.2236 | 37.7495049474174 | -122.41263350244199 | (37.7495049474174, -122.412633502442) | |||
| 53759 | 53759 | 136355 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1639 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6002367.638040001 | 2121224.4246 | 37.8046108851334 | -122.436057126653 | (37.8046108851334, -122.436057126653) | |||
| 53894 | 53894 | 36877 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2400 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 7 | Permit Number 39539 | 6000814.63294 | 2116594.68212 | 37.7918104855159 | -122.441099074089 | (37.7918104855159, -122.441099074089) | |
| 54022 | 54022 | 197440 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015037.520269999 | 2108824.47635 | 37.7712751131743 | -122.391344069293 | (37.7712751131743, -122.391344069293) | |||
| 54799 | 54799 | 240891 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008718.64971 | 2101088.20431 | 37.7496803583719 | -122.41265440088999 | (37.7496803583719, -122.41265440089) | |||
| 54834 | 54834 | 96395 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 800 Tennessee St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2011 12:00:00 AM | 7 | 3x3 | Permit Number 767136 | 6015448.2444 | 2105163.7417200003 | 37.761246318881 | -122.389667624156 | (37.761246318881, -122.389667624156) | |
| 54852 | 54852 | 240919 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 556 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002989.394780001 | 2095969.72486 | 37.7353029813381 | -122.432100892951 | (37.7353029813381, -122.432100892951) | |||
| 55562 | 55562 | 197427 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015011.5330300005 | 2109302.8867 | 37.772587279805705 | -122.39146741218599 | (37.7725872798057, -122.391467412186) | |||
| 55890 | 55890 | 46507 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 675 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/2002 12:00:00 AM | 7 | Permit Number 44677 | 6009082.35488 | 2111157.53331 | 37.7773488321059 | -122.41210822822599 | (37.7773488321059, -122.412108228226) | ||
| 56966 | 56966 | 197399 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1255 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015067.88959 | 2109305.99464 | 37.7725989413206 | -122.39127268468201 | (37.7725989413206, -122.391272684682) | |||
| 57862 | 57862 | 197386 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1350 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015093.74839 | 2108858.0484599997 | 37.7713704152436 | -122.39115191923901 | (37.7713704152436, -122.391151919239) | |||
| 58442 | 58442 | 197432 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015019.54428 | 2109161.1913 | 37.7721986602722 | -122.39142979267599 | (37.7721986602722, -122.391429792676) | |||
| 58866 | 58866 | 197423 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015003.8063199995 | 2109440.09446 | 37.77296359302979 | -122.391503734027 | (37.7729635930298, -122.391503734027) | |||
| 59323 | 59323 | 240918 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 4158 26th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6002863.78754 | 2100671.92533 | 37.748207011640794 | -122.43287098151 | (37.7482070116408, -122.43287098151) | |||
| 59554 | 59554 | 197455 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009137.470430001 | 2110995.28328 | 37.7769064241241 | -122.41190609659999 | (37.7769064241241, -122.4119060966) | |||
| 59927 | 59927 | 197410 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1101 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015033.4092 | 2109848.12885 | 37.7740856078918 | -122.39142986370301 | (37.7740856078918, -122.391429863703) | |||
| 61129 | 61129 | 179418 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 416 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6012204.41611 | 2086714.8275099997 | 37.710409062701395 | -122.399591381259 | (37.7104090627014, -122.399591381259) | |||
| 61264 | 61264 | 248011 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 525 Franconia St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 6009911.76805 | 2098028.06886 | 37.7413447878202 | -122.408312722264 | (37.7413447878202, -122.408312722264) | |||
| 61382 | 61382 | 240885 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 3013 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 6ft | 6009432.4377 | 2100992.16843 | 37.7494567005869 | -122.410179305636 | (37.7494567005869, -122.410179305636) | |||
| 61868 | 61868 | 197451 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009234.5273400005 | 2111091.20385 | 37.77717524406629 | -122.41157712459 | (37.7771752440663, -122.41157712459) | |||
| 62026 | 62026 | 240905 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008695.452190001 | 2101477.07086 | 37.750746796947396 | -122.412762107295 | (37.7507467969474, -122.412762107295) | |||
| 62745 | 62745 | 240901 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008702.87271 | 2101385.26076 | 37.7504951234628 | -122.41272995653601 | (37.7504951234628, -122.412729956536) | |||
| 63145 | 63145 | 197385 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1350 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015094.6551 | 2108827.79856 | 37.7712874060154 | -122.391146668097 | (37.7712874060154, -122.391146668097) | |||
| 63621 | 63621 | 197397 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1255 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015070.62155 | 2109253.41262 | 37.7724547143562 | -122.391259558193 | (37.7724547143562, -122.391259558193) | |||
| 63669 | 63669 | 96392 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 800 Tennessee St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2011 12:00:00 AM | 6 | 3x3 | Permit Number 767136 | 6015444.53946 | 2105235.26093 | 37.761442489801105 | -122.389685433429 | (37.7614424898011, -122.389685433429) | |
| 63712 | 63712 | 197401 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1155 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015056.142469999 | 2109498.92263 | 37.7731280268706 | -122.391326808588 | (37.7731280268706, -122.391326808588) | |||
| 63747 | 63747 | 197415 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1110 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6014984.865540001 | 2109771.18409 | 37.77387164030579 | -122.391592405366 | (37.7738716403058, -122.391592405366) | |||
| 63969 | 63969 | 240940 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 52 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 6004314.46376 | 2105211.05218 | 37.7607525605073 | -122.428178028592 | (37.7607525605073, -122.428178028592) | |||
| 64024 | 64024 | 240907 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 355 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007123.31174 | 2096296.95431 | 37.736434989479896 | -122.417831571267 | (37.7364349894799, -122.417831571267) | |||
| 64844 | 64844 | 38496 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1520 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1998 12:00:00 AM | 7 | Permit Number 40490 | 6005695.28325 | 2118608.46159 | 37.797616603979996 | -122.424355304657 | (37.79761660398, -122.424355304657) | |
| 64881 | 64881 | 240906 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008696.38021 | 2101499.73493 | 37.7508090794957 | -122.412760500211 | (37.7508090794957, -122.412760500211) | |||
| 65164 | 65164 | 197405 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1145 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015047.0197 | 2109662.59609 | 37.7735769315563 | -122.391369809678 | (37.7735769315563, -122.391369809678) | |||
| 65397 | 65397 | 240931 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 4596 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000667.48938 | 2104674.07897 | 37.7590711421385 | -122.440752730779 | (37.7590711421385, -122.440752730779) | |||
| 66327 | 66327 | 240908 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 725 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6009319.31515 | 2104845.25039 | 37.76003005686479 | -122.410842580843 | (37.7600300568648, -122.410842580843) | |||
| 66952 | 66952 | 240514 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 457 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005714.7802800005 | 2107820.47236 | 37.7679965411359 | -122.423520473904 | (37.7679965411359, -122.423520473904) | |||
| 67125 | 67125 | 197449 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009262.53236 | 2111115.69015 | 37.777244048518206 | -122.41148197633301 | (37.7772440485182, -122.411481976333) | |||
| 67184 | 67184 | 197435 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015029.61492 | 2108966.93535 | 37.7716658353527 | -122.391381374959 | (37.7716658353527, -122.391381374959) | |||
| 67549 | 67549 | 240945 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 192 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6004100.4699 | 2097291.61636 | 37.738995525713 | -122.428353681499 | (37.738995525713, -122.428353681499) | |||
| 67657 | 67657 | 197442 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015041.42072 | 2108767.34362 | 37.7711184557895 | -122.391326582849 | (37.7711184557895, -122.391326582849) | |||
| 67808 | 67808 | 38390 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 2435 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 5 | 3x5 | Permit Number 40447 | 6006235.29717 | 2119188.7184099997 | 37.799240320944904 | -122.42252796141399 | (37.7992403209449, -122.422527961414) | |
| 67915 | 67915 | 240938 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 50 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 3ft | 6004312.93129 | 2105220.54809 | 37.760778547308895 | -122.428184005481 | (37.7607785473089, -122.428184005481) | |||
| 68386 | 68386 | 240924 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009473.34401 | 2102092.1266 | 37.752479233853705 | -122.410115496035 | (37.7524792338537, -122.410115496035) | |||
| 68738 | 68738 | 240927 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1148 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008036.38125 | 2101261.79072 | 37.750118671749796 | -122.415026003064 | (37.7501186717498, -122.415026003064) | |||
| 68933 | 68933 | 240899 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1201 Treat Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6008706.04279 | 2101335.66338 | 37.750359118082706 | -122.412715488225 | (37.7503591180827, -122.412715488225) | |||
| 71098 | 71098 | 240926 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 Florida St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009479.18585 | 2101981.64475 | 37.752176202776 | -122.410087494765 | (37.752176202776, -122.410087494765) | |||
| 71315 | 71315 | 240944 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 88 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004279.64168 | 2097645.58275 | 37.7399775737156 | -122.427759401399 | (37.7399775737156, -122.427759401399) | |||
| 72200 | 72200 | 197422 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015001.02116 | 2109469.2789 | 37.7730435724386 | -122.39151540903099 | (37.7730435724386, -122.391515409031) |
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");