Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 182431 | 182431 | 218284 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50x Junipero Serra Frontage West | 0 | Median : Yard 3 | Tree 1 | DPW 2 | 28 | 5991438.8932 | 2095398.7783700002 | 37.7330736770928 | -122.4719932523 | (37.7330736770928, -122.4719932523) | ||||
| 1709 | 1709 | 237551 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 102 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779869 | 6003586.068 | 2105101.14828 | 37.760409550968205 | -122.430689380017 | (37.7604095509682, -122.430689380017) | |
| 3561 | 3561 | 253462 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 98X Marston Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 09/12/2017 12:00:00 AM | 3 | 3x3 | 5998793.0 | 2093251.0 | 37.7275991927727 | -122.446413796362 | (37.7275991927727, -122.446413796362) | ||
| 4658 | 4658 | 176983 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | Width 3ft | 5996974.67191 | 2087476.2225099998 | 37.711638981816 | -122.452283225586 | (37.711638981816, -122.452283225586) | |||
| 8136 | 8136 | 2477 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2307X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6003648.68016 | 2115921.80581 | 37.790123955413705 | -122.43124522668998 | (37.7901239554137, -122.43124522669) | |||
| 9386 | 9386 | 926 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1278 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6002807.701830001 | 2094157.47604 | 37.7303166558715 | -122.432599664217 | (37.7303166558715, -122.432599664217) | |||
| 11074 | 11074 | 882 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1138X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2016 12:00:00 AM | 28 | 3x3 | 6003576.60001 | 2094409.9739299999 | 37.7310535326811 | -122.429959483056 | (37.7310535326811, -122.429959483056) | ||
| 11146 | 11146 | 890 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1146 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 4X4 | 6003547.94647 | 2094400.70663 | 37.7310264639915 | -122.430057882374 | (37.7310264639915, -122.430057882374) | |||
| 11690 | 11690 | 1262 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X5 | 5992602.03225 | 2087509.49597 | 37.7114788737215 | -122.467398529617 | (37.7114788737215, -122.467398529617) | |||
| 12047 | 12047 | 909 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1217 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 6003163.68633 | 2094174.8948400002 | 37.7303846655151 | -122.431370220756 | (37.7303846655151, -122.431370220756) | |||
| 17570 | 17570 | 1213 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3411 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 5993897.04108 | 2087339.7447 | 37.711087454604204 | -122.46291036762199 | (37.7110874546042, -122.462910367622) | |||
| 18415 | 18415 | 13417 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 400 Marietta Dr | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 5 | 5999553.15658 | 2097034.9165400001 | 37.7380323275191 | -122.444057708717 | (37.7380323275191, -122.444057708717) | |||
| 18602 | 18602 | 234 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2994 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 2X3 | 5990616.60068 | 2095284.10448 | 37.7327111945568 | -122.474827739114 | (37.7327111945568, -122.474827739114) | |||
| 22307 | 22307 | 246123 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 35 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779621 | 5998184.8878 | 2108385.4066 | 37.7691198159889 | -122.44960613908701 | (37.7691198159889, -122.449606139087) | |
| 23861 | 23861 | 184307 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1553 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982166.1739 | 2104530.0154 | 37.7576045827244 | -122.50472730219 | (37.7576045827244, -122.50472730219) | |||
| 25429 | 25429 | 119085 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 886 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5982037.396000001 | 2109722.65545 | 37.7718545033558 | -122.50555756428601 | (37.7718545033558, -122.505557564286) | |||
| 26252 | 26252 | 227697 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | |||
| 28427 | 28427 | 83251 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2210 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50737 | 5982365.40001882 | 2100051.8832382 | 37.7453206044327 | -122.503706674483 | (37.7453206044327, -122.503706674483) | |
| 29076 | 29076 | 227690 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 307 Bocana St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006885.1558 | 2097215.40267 | 37.7389434396991 | -122.41872009246299 | (37.7389434396991, -122.418720092463) | |||
| 29645 | 29645 | 50707 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1658 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/28/2004 12:00:00 AM | 5 | Permit Number 47266 | 5983788.66504778 | 2103867.70402192 | 37.75588137239 | -122.499067221884 | (37.75588137239, -122.499067221884) | |
| 31036 | 31036 | 181438 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1319 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981181.6009 | 2106068.5638 | 37.761771027502 | -122.508246492496 | (37.761771027502, -122.508246492496) | |||
| 32724 | 32724 | 227696 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003774.74871 | 2108065.2472200003 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | |||
| 33610 | 33610 | 84133 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 23 Tucker Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/05/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50705 | 6011012.12355 | 2088466.5124700002 | 37.7151523039101 | -122.403835398892 | (37.7151523039101, -122.403835398892) | |
| 33669 | 33669 | 247869 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 394 Mayflower St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 9 | 6009720.84865 | 2098403.35069 | 37.7423645372013 | -122.408999330354 | (37.7423645372013, -122.408999330354) | ||||
| 35457 | 35457 | 46390 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2447 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 7 | Permit Number 44623 | 5982678.99712077 | 2098464.70885711 | 37.7409810943186 | -122.502504874921 | (37.7409810943186, -122.502504874921) | |
| 37103 | 37103 | 207104 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 242 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5995372.52306 | 2091590.05793 | 37.7228426882306 | -122.458118187099 | (37.7228426882306, -122.458118187099) | |||
| 37604 | 37604 | 184574 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1706 Lower Great Hwy | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5981029.903 | 2103411.5484 | 37.754466683478604 | -122.50857388751899 | (37.7544666834786, -122.508573887519) | |||
| 38129 | 38129 | 191390 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 845 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | 6011298.55233 | 2104376.91383 | 37.7588548893488 | -122.403964355369 | (37.7588548893488, -122.403964355369) | ||||
| 38448 | 38448 | 35388 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 753 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 7 | Permit Number 38842 | 6011306.158319999 | 2104840.46729 | 37.7601281288176 | -122.40397067131799 | (37.7601281288176, -122.403970671318) | |
| 40391 | 40391 | 129467 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1331 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6006504.317480001 | 2119710.78815 | 37.8006889650949 | -122.42163415671301 | (37.8006889650949, -122.421634156713) | |||
| 41282 | 41282 | 227693 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 337 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002979.940119999 | 2100929.17253 | 37.748919939311705 | -122.432487701248 | (37.7489199393117, -122.432487701248) | |||
| 42954 | 42954 | 79486 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2323 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 0 | 3x3 | Permit Number 50743 | 5981719.67239804 | 2099271.03998771 | 37.7431386384508 | -122.505881575612 | (37.7431386384508, -122.505881575612) | |
| 44170 | 44170 | 227687 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1003 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997630.84664 | 2107024.34604 | 37.7653509793933 | -122.45142434518401 | (37.7653509793933, -122.451424345184) | |||
| 46923 | 46923 | 50575 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1347 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/06/2003 12:00:00 AM | 0 | Permit Number 47190 | 5983353.97136461 | 2105974.76120709 | 37.7616412492229 | -122.50072631562 | (37.7616412492229, -122.50072631562) | |
| 47735 | 47735 | 46973 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1783 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 7 | Permit Number 44992 | 5982214.017865701 | 2102979.50871383 | 37.753350143755796 | -122.504446973742 | (37.7533501437558, -122.504446973742) | |
| 48955 | 48955 | 183430 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2508 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988945.948 | 2098228.8968 | 37.7406998772059 | -122.480819050828 | (37.7406998772059, -122.480819050828) | |||
| 49254 | 49254 | 48530 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2251(REVISED) 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 6 | Permit Number 45852 | 5988214.95937948 | 2099991.18132471 | 37.7454961303111 | -122.48347566224899 | (37.7454961303111, -122.483475662249) | |
| 52773 | 52773 | 183252 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1300 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5980914.4873 | 2106074.2169999997 | 37.761770805091096 | -122.50917073482799 | (37.7617708050911, -122.509170734828) | |||
| 56497 | 56497 | 118789 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 718 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5981995.4955 | 2110847.43445 | 37.7749403522663 | -122.505785898051 | (37.7749403522663, -122.505785898051) | |||
| 56915 | 56915 | 38348 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1607 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/29/1998 12:00:00 AM | 0 | Permit Number 40415 | 5981863.96536039 | 2104143.69244361 | 37.756526067201705 | -122.505743805317 | (37.7565260672017, -122.505743805317) | |
| 57032 | 57032 | 30756 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1547 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | 1 | Permit Number 34637 | 6015015.9888 | 2093715.5638 | 37.729788030208795 | -122.390362726863 | (37.7297880302088, -122.390362726863) | |
| 57626 | 57626 | 129464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1974 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005282.18317 | 2116523.47353 | 37.7918684189526 | -122.425636272008 | (37.7918684189526, -122.425636272008) | |||
| 60744 | 60744 | 59481 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 701 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05513 | 2110730.54303 | 37.7753593652253 | -122.461805741777 | (37.7753593652253, -122.461805741777) | ||
| 61754 | 61754 | 227689 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 84 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008214.299790001 | 2099586.39862 | 37.7455284159971 | -122.41429222281 | (37.7455284159971, -122.41429222281) | |||
| 61815 | 61815 | 227684 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2560 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002253.36783 | 2096984.49578 | 37.7380475512412 | -122.434718147625 | (37.7380475512412, -122.434718147625) | |||
| 63814 | 63814 | 41465 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3445 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2000 12:00:00 AM | 24 | Permit Number 42050 | 5983633.32729372 | 2103553.20607522 | 37.755008735539 | -122.49958117988501 | (37.755008735539, -122.499581179885) | ||
| 64529 | 64529 | 129477 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6012514.7758 | 2120236.23138 | 37.8024687881724 | -122.40087229823901 | (37.8024687881724, -122.400872298239) | ||||
| 65265 | 65265 | 83279 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2147 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50736 | 5982298.449010201 | 2100494.71161235 | 37.7465325514695 | -122.503970969286 | (37.7465325514695, -122.503970969286) | |
| 65640 | 65640 | 46969 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1658 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 7 | Permit Number 44989 | 5982547.49278996 | 2103828.23178681 | 37.7557001072445 | -122.503356606053 | (37.7557001072445, -122.503356606053) | |
| 66262 | 66262 | 138270 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 218 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998383.8821 | 2112677.2272 | 37.7809154323836 | -122.44922707658199 | (37.7809154323836, -122.449227076582) | |||
| 66597 | 66597 | 227677 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003907.029080001 | 2099270.15617 | 37.7444171939021 | -122.42916354887801 | (37.7444171939021, -122.429163548878) | |||
| 66736 | 66736 | 68069 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 239 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1993 12:00:00 AM | Permit Number 31806 | 5993313.66059206 | 2103207.09024288 | 37.7546216328473 | -122.466078949095 | (37.7546216328473, -122.466078949095) | ||
| 66814 | 66814 | 52554 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1719 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 8 | Permit Number 48649 | 5984370.92860727 | 2103469.2332854997 | 37.754821420904996 | -122.49702418509099 | (37.754821420905, -122.497024185091) | |
| 67487 | 67487 | 47082 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 175 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 5 | Permit Number 45068 | 5996827.60082146 | 2111762.20695793 | 37.778313889032205 | -122.45454486671998 | (37.7783138890322, -122.45454486672) | |
| 67932 | 67932 | 227679 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 361 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003556.92712 | 2099495.0366599998 | 37.745014838355395 | -122.430390170187 | (37.7450148383554, -122.430390170187) | |||
| 68946 | 68946 | 207113 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 53 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992170.39113 | 2088282.9530900002 | 37.7135776719473 | -122.468946631596 | (37.7135776719473, -122.468946631596) | ||||
| 69872 | 69872 | 50219 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2726 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2004 12:00:00 AM | 8 | 3x3 | Permit Number 46926 | 5987073.255969999 | 2111201.4718400002 | 37.776209992885 | -122.48824709613301 | (37.776209992885, -122.488247096133) |
| 70974 | 70974 | 121603 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 749 Carolina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3x3 | 6012453.25739 | 2104452.2107 | 37.7591260835233 | -122.399976111225 | (37.7591260835233, -122.399976111225) | |||
| 72687 | 72687 | 119095 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 6700 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5982534.89521 | 2109675.70682 | 37.7717548615052 | -122.503833231018 | (37.7717548615052, -122.503833231018) | |||
| 77293 | 77293 | 227685 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997626.030809999 | 2107071.20572 | 37.765479368391 | -122.45144438204599 | (37.765479368391, -122.451444382046) | |||
| 78902 | 78902 | 52384 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 36TA MARINA Gladys St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/2005 12:00:00 AM | Permit Number 48509 | 6005730.58900637 | 2097520.8738626 | 37.739717121816604 | -122.422733759035 | (37.7397171218166, -122.422733759035) | ||
| 78959 | 78959 | 52269 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 403 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48434 | 6005520.49766263 | 2101354.49181367 | 37.7502315077339 | -122.423732674774 | (37.7502315077339, -122.423732674774) | ||
| 79212 | 79212 | 33405 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 390 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/04/1998 12:00:00 AM | Permit Number 40744 | 5992420.09105205 | 2094203.06284675 | 37.729847269288896 | -122.468514054616 | (37.7298472692889, -122.468514054616) | ||
| 79594 | 79594 | 12917 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2935X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 5996989.32715 | 2087489.72289 | 37.7116768903089 | -122.452233546915 | (37.7116768903089, -122.452233546915) | |||
| 81689 | 81689 | 57377 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3505 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52081 | 6006157.87748572 | 2102561.9990288 | 37.7535830045092 | -122.42161432346902 | (37.7535830045092, -122.421614323469) | ||
| 83364 | 83364 | 31185 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 720 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | Permit Number 34883 | 5992147.8527206 | 2089880.99524616 | 37.7179642061069 | -122.469140766842 | (37.7179642061069, -122.469140766842) | ||
| 83936 | 83936 | 31575 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1922 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35114 | 5989431.17806618 | 2102257.22974077 | 37.7517888142139 | -122.479435972521 | (37.7517888142139, -122.479435972521) | ||
| 84780 | 84780 | 33391 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 129 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37510 | 5993545.21642202 | 2093774.31911417 | 37.7287349718633 | -122.464593277929 | (37.7287349718633, -122.464593277929) | ||
| 84781 | 84781 | 101254 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3700X Cesar Chavez St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6005840.6 | 2100555.6 | 37.74805599841039 | -122.422568977073 | (37.7480559984104, -122.422568977073) | |||||
| 85274 | 85274 | 52492 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 390ON GATES Tompkins Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2005 12:00:00 AM | Permit Number 48601 | 6008184.68107457 | 2096494.82661811 | 37.7370379770988 | -122.41417595350599 | (37.7370379770988, -122.414175953506) | ||
| 85479 | 85479 | 49654 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 81 Alpha St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/2003 12:00:00 AM | Permit Number 46507 | 6011171.19956943 | 2088331.01703059 | 37.7147891465513 | -122.403276034448 | (37.7147891465513, -122.403276034448) | ||
| 86481 | 86481 | 52106 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 727 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48298 | 5997405.05193713 | 2098248.96190456 | 37.741243026323 | -122.451572279627 | (37.741243026323, -122.451572279627) | ||
| 87840 | 87840 | 50881 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2040 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/26/2004 12:00:00 AM | Permit Number 47391 | 5991642.80129947 | 2101534.85210656 | 37.7499335653235 | -122.47173531309299 | (37.7499335653235, -122.471735313093) | ||
| 88035 | 88035 | 34348 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 330 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1997 12:00:00 AM | Permit Number 38106 | 6004294.50938701 | 2096370.47715627 | 37.7364772644099 | -122.42761717220199 | (37.7364772644099, -122.427617172202) | ||
| 88909 | 88909 | 45437 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50 Urbano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/2001 12:00:00 AM | Permit Number 44224 | 5993813.83621392 | 2092411.23769418 | 37.7250077648019 | -122.46356576496599 | (37.7250077648019, -122.463565764966) | ||
| 89703 | 89703 | 37850 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 211 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/07/1998 12:00:00 AM | Permit Number 40141 | 6003943.02561838 | 2092441.0681196998 | 37.725668101811706 | -122.42855239521201 | (37.7256681018117, -122.428552395212) | ||
| 90495 | 90495 | 49718 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1195 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2003 12:00:00 AM | Permit Number 46529 | 6014698.72785663 | 2090465.4227663002 | 37.7208461876659 | -122.39123244275801 | (37.7208461876659, -122.391232442758) | |||
| 91138 | 91138 | 47550 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1681 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45414 | 6003392.60348895 | 2098449.5926945 | 37.7421349817765 | -122.430883775787 | (37.7421349817765, -122.430883775787) | ||
| 92356 | 92356 | 79056 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1862 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2007 12:00:00 AM | 3x3 | Permit Number 50038 | 5983215.17096299 | 2102463.12302331 | 37.7519911277095 | -122.500946646871 | (37.7519911277095, -122.500946646871) | ||
| 92573 | 92573 | 31375 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 630 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/21/1995 12:00:00 AM | Permit Number 34977 | 5991276.37232485 | 2099107.33925567 | 37.7432470351435 | -122.47282544581499 | (37.7432470351435, -122.472825445815) | ||
| 92847 | 92847 | 81868 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 3012-3014 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2009 12:00:00 AM | 3x3 | Permit Number 52207 | 6009486.0303434 | 2101043.89087343 | 37.749601722793 | -122.40999763091601 | (37.749601722793, -122.409997630916) | ||
| 93065 | 93065 | 31600 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1631 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | Permit Number 35126 | 5988991.64827869 | 2102380.23074862 | 37.7521010026968 | -122.480964913447 | (37.7521010026968, -122.480964913447) | ||
| 93184 | 93184 | 119281 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 59x Ralston St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5992077.0 | 2088275.0 | 37.713550438396396 | -122.469268843393 | (37.7135504383964, -122.469268843393) | ||||
| 93390 | 93390 | 33301 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1120 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37453 | 6009052.27411403 | 2116787.86536385 | 37.7928066833324 | -122.412610401728 | (37.7928066833324, -122.412610401728) | ||
| 93449 | 93449 | 56335 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 354 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777757 | 5987487.44856113 | 2113581.55129815 | 37.782769173736206 | -122.486989143207 | (37.7827691737362, -122.486989143207) | |
| 93638 | 93638 | 31942 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1300 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39715 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807626999 | (37.761983899941, -122.50916807627) | ||
| 94127 | 94127 | 30765 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1593 Underwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1995 12:00:00 AM | Permit Number 34646 | 6014616.43299999 | 2093667.83534348 | 37.729634805621096 | -122.391740711397 | (37.7296348056211, -122.391740711397) | ||
| 94727 | 94727 | 68575 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32467 | 5983299.26193695 | 2112364.72668983 | 37.779183045029896 | -122.501388226383 | (37.7791830450299, -122.501388226383) | ||
| 96489 | 96489 | 50428 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Lee Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | Permit Number 47081 | 5996479.47890892 | 2089951.8399168998 | 37.7184080697361 | -122.454173429085 | (37.7184080697361, -122.454173429085) | ||
| 96706 | 96706 | 52103 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 641 Rockdale Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/26/2005 12:00:00 AM | Permit Number 48295 | 5997742.5728031 | 2098061.02519693 | 37.7407463206184 | -122.450391713191 | (37.7407463206184, -122.450391713191) | ||
| 97029 | 97029 | 33402 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 377 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1996 12:00:00 AM | Permit Number 37520 | 5992522.58969687 | 2094276.01733921 | 37.730053504422 | -122.468165013068 | (37.730053504422, -122.468165013068) | ||
| 98101 | 98101 | 47351 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 246 Monticello St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/13/2002 12:00:00 AM | Permit Number 45277 | 5991716.56988019 | 2090163.16086716 | 37.7187140338834 | -122.470652049529 | (37.7187140338834, -122.470652049529) | ||
| 98528 | 98528 | 47604 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 645 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/20/2002 12:00:00 AM | Permit Number 45440 | 6008713.69382569 | 2095849.48701302 | 37.7352957148385 | -122.412301312985 | (37.7352957148385, -122.412301312985) | ||
| 98932 | 98932 | 52980 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 531 Arch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/2006 12:00:00 AM | Permit Number 49067 | 5992711.66457877 | 2090721.03501475 | 37.720303313737105 | -122.467252978798 | (37.7203033137371, -122.467252978798) | ||
| 99225 | 99225 | 46761 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 343 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44859 | 6006106.65621717 | 2092210.20384218 | 37.725156404551896 | -122.421056498489 | (37.7251564045519, -122.421056498489) | |||
| 99862 | 99862 | 67131 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30551 | 5994253.6761319 | 2105720.38065143 | 37.761576666998295 | -122.463010486718 | (37.7615766669983, -122.463010486718) | ||
| 101609 | 101609 | 43632 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50556 | 5996213.47474732 | 2098545.79305022 | 37.7419897418411 | -122.455713757113 | (37.7419897418411, -122.455713757113) | ||
| 102052 | 102052 | 23670 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 317 Virginia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 12 | 6006937.941544901 | 2098264.8464559 | 37.7418279505329 | -122.41861198258002 | (37.7418279505329, -122.41861198258) | |||
| 102346 | 102346 | 50292 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 300 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/28/2003 12:00:00 AM | 3x3 | Permit Number 47005 | 6003944.88624926 | 2099274.1797933998 | 37.744430384839504 | -122.42903293346001 | (37.7444303848395, -122.42903293346) | |
| 103188 | 103188 | 32605 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1370 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/23/1996 12:00:00 AM | Permit Number 37071 | 5984960.54583105 | 2105873.44387063 | 37.7614572492102 | -122.49516243722 | (37.7614572492102, -122.49516243722) |
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");