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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | |||||
| 102854 | 102854 | 113637 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1X Russ St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6009949.394180001 | 2111947.85897 | 37.7795674908256 | -122.40916462626801 | (37.7795674908256, -122.409164626268) | |||||
| 103276 | 103276 | 94983 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 480 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2010 12:00:00 AM | 3x3 | Permit Number 54004 | 6008557.0 | 2113884.0 | 37.784805566420005 | -122.414118544888 | (37.78480556642, -122.414118544888) | ||
| 105747 | 105747 | 113638 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1X Russ St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6009949.394180001 | 2111947.85897 | 37.7795674908256 | -122.40916462626801 | (37.7795674908256, -122.409164626268) | |||||
| 126401 | 126401 | 113639 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1X Russ St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6009949.394180001 | 2111947.85897 | 37.7795674908256 | -122.40916462626801 | (37.7795674908256, -122.409164626268) | |||||
| 142266 | 142266 | 98139 | Property Tree 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 556 Laidley St | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6003085.0 | 2096041.0 | 37.7355041065287 | -122.431775438062 | (37.7355041065287, -122.431775438062) | |||||
| 142453 | 142453 | 113641 | Significant Tree 6 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 545X Minna St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010081.18772 | 2112137.85468 | 37.7800965567953 | -122.40872210131901 | (37.7800965567953, -122.408722101319) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 164629 | 164629 | 240934 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 4069 19th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6002570.92304 | 2104708.1255900003 | 37.75927284118389 | -122.434172195294 | (37.7592728411839, -122.434172195294) | |||
| 176203 | 176203 | 197450 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6009244.39331 | 2111101.4918 | 37.777204045757706 | -122.41154372197701 | (37.7772040457577, -122.411543721977) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 149573 | 149573 | 197448 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009272.74588 | 2111128.58634 | 37.7772800312881 | -122.411447555674 | (37.7772800312881, -122.411447555674) | |||
| 164610 | 164610 | 240913 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 85 Sycamore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006349.99918 | 2105832.52537 | 37.7625739412505 | -122.421182140339 | (37.7625739412505, -122.421182140339) | |||
| 169428 | 169428 | 197454 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6009151.50306 | 2111008.9827799997 | 37.7769448269774 | -122.41185852156 | (37.7769448269774, -122.41185852156) | |||
| 180425 | 180425 | 240886 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 3009 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 6ft | 6009453.92739 | 2100992.8361400003 | 37.74945973849329 | -122.41010504053101 | (37.7494597384933, -122.410105040531) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 72748 | 72748 | 197453 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009170.60283 | 2111027.24083 | 37.776996030778896 | -122.411793739793 | (37.7769960307789, -122.411793739793) | |||
| 79898 | 79898 | 240910 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 725 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6009324.1679 | 2104803.20752 | 37.7599148887933 | -122.410822828117 | (37.7599148887933, -122.410822828117) | |||
| 103582 | 103582 | 36119 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1374 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/2016 12:00:00 AM | 3 | 5x3 | Permit Number 43440 | 5991487.33915366 | 2106070.76020768 | 37.7623789807661 | -122.47260356904499 | (37.7623789807661, -122.472603569045) |
| 165340 | 165340 | 197429 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6015013.85039 | 2109250.55837 | 37.7724437264277 | -122.39145573721201 | (37.7724437264277, -122.391455737212) | |||
| 182226 | 182226 | 103279 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 221 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2013 12:00:00 AM | 3 | 5x6 | Permit Number 770111 | 6004127.45538 | 2092231.09561 | 37.725101999253894 | -122.42789988087699 | (37.7251019992539, -122.427899880877) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 72493 | 72493 | 197408 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1101 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015042.21783 | 2109774.95767 | 37.773885184987996 | -122.391394276636 | (37.773885184988, -122.391394276636) | |||
| 117671 | 117671 | 197376 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 300 San Bruno Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010875.09874 | 2106538.07352 | 37.7647652806152 | -122.405581075631 | (37.7647652806152, -122.405581075631) | |||
| 134685 | 134685 | 197394 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1255 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015074.87374 | 2109163.38918 | 37.7722077659022 | -122.391238555416 | (37.7722077659022, -122.391238555416) | |||
| 149695 | 149695 | 240510 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 180 Guerrero St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6005414.721480001 | 2107962.30986 | 37.7683690520207 | -122.424568435908 | (37.7683690520207, -122.424568435908) | |||
| 157530 | 157530 | 197445 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 577 Nelson Rising Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013675.59633 | 2108064.3212200003 | 37.7691122166786 | -122.39600177775499 | (37.7691122166786, -122.396001777755) | |||
| 159722 | 159722 | 38984 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 300x San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1998 12:00:00 AM | 4 | 3x3 | Permit Number 40762 | 6010859.35781 | 2106780.294 | 37.7654294829959 | -122.40565258161699 | (37.7654294829959, -122.405652581617) | |
| 161536 | 161536 | 197443 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 577 Nelson Rising Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013632.067840001 | 2108039.85381 | 37.7690426127674 | -122.396150626374 | (37.7690426127674, -122.396150626374) | |||
| 168235 | 168235 | 197403 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1155 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015051.73928 | 2109577.98183 | 37.7733448615187 | -122.391347567643 | (37.7733448615187, -122.391347567643) | |||
| 168717 | 168717 | 197444 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 577 Nelson Rising Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013653.6839 | 2108052.2415 | 37.7690778293104 | -122.396076725459 | (37.7690778293104, -122.396076725459) | |||
| 169944 | 169944 | 197441 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015039.64568 | 2108796.242 | 37.771197705845296 | -122.39133474329901 | (37.7711977058453, -122.391334743299) | |||
| 177407 | 177407 | 197456 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 668 Natoma St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6009124.387019999 | 2110985.0611099997 | 37.7768776224341 | -122.411950633731 | (37.7768776224341, -122.411950633731) | |||
| 177644 | 177644 | 96393 | Permitted Site 1 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 800 Tennessee St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767136 | 6015446.34816 | 2105205.82612 | 37.761361768441205 | -122.389677121926 | (37.7613617684412, -122.389677121926) | |
| 179886 | 179886 | 197439 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015038.53037 | 2108853.8565700003 | 37.7713558408268 | -122.39134262946001 | (37.7713558408268, -122.39134262946) | |||
| 183825 | 183825 | 197434 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015028.191000001 | 2108995.6844900004 | 37.771744695104395 | -122.391388310536 | (37.7717446951044, -122.391388310536) | |||
| 188943 | 188943 | 240914 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 85 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006391.17124 | 2105833.44907 | 37.762578798502204 | -122.421039806442 | (37.7625787985022, -122.421039806442) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 75284 | 75284 | 197387 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1350 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015092.10625 | 2108889.4468 | 37.771456537020995 | -122.391159794592 | (37.771456537021, -122.391159794592) | |||
| 76461 | 76461 | 240943 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 671 Church St | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6004289.81829 | 2105251.99931 | 37.7608635971022 | -122.428266184633 | (37.7608635971022, -122.428266184633) | |||
| 76583 | 76583 | 197396 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1255 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015072.3173400005 | 2109224.6589599997 | 37.7723758572837 | -122.391251681939 | (37.7723758572837, -122.391251681939) | |||
| 121086 | 121086 | 136356 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 400 Leavenworth St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6008467.36905 | 2113992.78863 | 37.7850992389805 | -122.414436340073 | (37.7850992389805, -122.414436340073) | |||
| 133904 | 133904 | 197433 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015022.47536 | 2109102.12836 | 37.7720366491947 | -122.39141552402701 | (37.7720366491947, -122.391415524027) | |||
| 134227 | 134227 | 197406 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1101 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015045.28656 | 2109714.70824 | 37.773719923756204 | -122.39137944862301 | (37.7737199237562, -122.391379448623) | |||
| 134957 | 134957 | 197436 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1300 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015031.80159 | 2108941.72055 | 37.7715967224486 | -122.391372048095 | (37.7715967224486, -122.391372048095) | |||
| 137023 | 137023 | 197430 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015016.26814 | 2109221.75475 | 37.7723647722597 | -122.39144535991001 | (37.7723647722597, -122.39144535991) | |||
| 138156 | 138156 | 197381 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 500 Berry St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 6012346.20487 | 2108477.39645 | 37.770172376184 | -122.400629116167 | (37.770172376184, -122.400629116167) | |||
| 146440 | 146440 | 197447 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 577 Nelson Rising Ln | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013720.003 | 2108087.26166 | 37.769177676536 | -122.395849784245 | (37.769177676536, -122.395849784245) | |||
| 146732 | 146732 | 197426 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015010.27752 | 2109333.53408 | 37.772671361033 | -122.391473898118 | (37.772671361033, -122.391473898118) | |||
| 147155 | 147155 | 197425 | Undocumented 2 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 1200 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6015006.55649 | 2109372.07332 | 37.772776974711206 | -122.391489464471 | (37.7727769747112, -122.391489464471) |
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");