Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1593 | 1593 | 9458 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005390.9525 | 2112398.9001 | 37.780549510570204 | -122.424966344778 | (37.7805495105702, -122.424966344778) | ||
| 1713 | 1713 | 233361 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 28 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 3ft | 6005734.12152 | 2106385.89097 | 37.7640586131313 | -122.42335158033501 | (37.7640586131313, -122.423351580335) | ||
| 2191 | 2191 | 9460 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 6 | 3X3 | 6005350.8775 | 2112393.4845 | 37.7805323769118 | -122.42510459789499 | (37.7805323769118, -122.425104597895) | ||
| 2279 | 2279 | 9454 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005489.5152 | 2112411.3558 | 37.7805892777689 | -122.424626255587 | (37.7805892777689, -122.424626255587) | ||
| 3201 | 3201 | 150469 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 100 Southern Heights Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 776550 | 6012042.59416 | 2104165.28662 | 37.758315349182794 | -122.40137622523899 | (37.7583153491828, -122.401376225239) | |
| 3228 | 3228 | 253372 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 100 Southern Heights Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | 6012159.87787 | 2104118.04133 | 37.7581921670504 | -122.400967284676 | (37.7581921670504, -122.400967284676) | |||
| 3235 | 3235 | 150468 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 100 Southern Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 776550 | 6012105.23351 | 2104143.6419 | 37.758259412251206 | -122.401158068605 | (37.7582594122512, -122.401158068605) | |
| 3240 | 3240 | 253370 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 896 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | 6012140.05864 | 2104123.74749 | 37.758206729333295 | -122.40103622951901 | (37.7582067293333, -122.401036229519) | |||
| 3243 | 3243 | 253371 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 100 Southern Heights Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | 6012159.87787 | 2104118.04133 | 37.7581921670504 | -122.400967284676 | (37.7581921670504, -122.400967284676) | |||
| 3252 | 3252 | 9455 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005466.2284 | 2112408.648 | 37.7805805276453 | -122.424706623116 | (37.7805805276453, -122.424706623116) | ||
| 3483 | 3483 | 9453 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005504.6787 | 2112415.6882 | 37.7806020298362 | -122.42457410603201 | (37.7806020298362, -122.424574106032) | ||
| 3688 | 3688 | 9457 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6005414.2393 | 2112401.6078 | 37.7805582605963 | -122.424885977306 | (37.7805582605963, -122.424885977306) | |||
| 6101 | 6101 | 9452 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6005518.2175 | 2112416.7713 | 37.780605768348295 | -122.424527345883 | (37.7806057683483, -122.424527345883) | ||
| 6260 | 6260 | 9500 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 915 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005267.772000001 | 2112322.2041 | 37.780331963481295 | -122.425387025394 | (37.7803319634813, -122.425387025394) | ||
| 7057 | 7057 | 14514 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 507 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999077.3967 | 2111056.5759 | 37.776505184882204 | -122.446711235239 | (37.7765051848822, -122.446711235239) | |||
| 7676 | 7676 | 9450 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 800X Golden Gate Ave | 6 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005543.6705 | 2112420.5622 | 37.780617614602896 | -122.424439561439 | (37.7806176146029, -122.424439561439) | |||
| 9306 | 9306 | 91819 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2415 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 8 | 3x3 | 6008857.839983 | 2104395.646442 | 37.7587696603701 | -122.412406827225 | (37.7587696603701, -122.412406827225) | ||
| 9361 | 9361 | 91805 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2959 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009030.2311080005 | 2101235.1434150003 | 37.7501013029605 | -122.41158731707701 | (37.7501013029605, -122.411587317077) | ||
| 9364 | 9364 | 91742 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2870 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008961.550736 | 2101748.066686 | 37.75150582289721 | -122.41186105930001 | (37.7515058228972, -122.4118610593) | ||
| 9392 | 9392 | 91804 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2959 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6009030.2311080005 | 2101235.1434150003 | 37.7501013029605 | -122.41158731707701 | (37.7501013029605, -122.411587317077) | ||
| 9400 | 9400 | 91744 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2770 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6008929.558301999 | 2102330.3351209997 | 37.753102806589204 | -122.412012837787 | (37.7531028065892, -122.412012837787) | ||
| 10038 | 10038 | 96503 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | |||
| 10141 | 10141 | 35805 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 633 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39049 | 6007507.54352575 | 2105966.04756896 | 37.763005750747205 | -122.41718806542102 | (37.7630057507472, -122.417188065421) | ||
| 11409 | 11409 | 52759 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 22 Gaven St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2014 12:00:00 AM | 3 | Permit Number 774111 | 6010286.03762 | 2095339.86575 | 37.7339845095792 | -122.406829209621 | (37.7339845095792, -122.406829209621) | ||
| 12116 | 12116 | 117434 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 71 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/14/2016 12:00:00 AM | 3 | Permit Number 775886 | 6000675.587280001 | 2092024.5104 | 37.7243388786085 | -122.43981779016899 | (37.7243388786085, -122.439817790169) | ||
| 13803 | 13803 | 29650 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015718.9286 | 2096019.8862 | 37.736154203998794 | -122.388093308135 | (37.7361542039988, -122.388093308135) | ||
| 13827 | 13827 | 29649 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015738.3943 | 2096009.2115 | 37.73612597190029 | -122.38802526198299 | (37.7361259719003, -122.388025261983) | ||
| 13981 | 13981 | 29648 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015756.6041 | 2095993.5134 | 37.736083876945294 | -122.38796120765 | (37.7360838769453, -122.38796120765) | ||
| 14996 | 14996 | 29645 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015832.5829 | 2095938.2561 | 37.7359363605469 | -122.38769466166599 | (37.7359363605469, -122.387694661666) | ||
| 15928 | 15928 | 29646 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015803.0705 | 2095958.3496 | 37.7359898984178 | -122.387798100273 | (37.7359898984178, -122.387798100273) | ||
| 16418 | 16418 | 29647 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 1500X La Salle Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/07/2006 12:00:00 AM | 3 | 12x31 | 6015782.348999999 | 2095974.6757 | 37.7360335786804 | -122.387870882274 | (37.7360335786804, -122.387870882274) | ||
| 16986 | 16986 | 22826 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 84 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 02:48:00 PM | 3 | 3x3 | 5999343.3761 | 2099052.93009 | 37.743561341476 | -122.444928046502 | (37.743561341476, -122.444928046502) | ||
| 17439 | 17439 | 16950 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 630 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003955.1515 | 2110112.5344 | 37.774190507936794 | -122.42977033764099 | (37.7741905079368, -122.429770337641) | |||
| 17520 | 17520 | 507 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2755X Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2007 12:00:00 AM | 6 | 3x3 | 6008976.16945 | 2102362.07248 | 37.753192565308204 | -122.411853889149 | (37.7531925653082, -122.411853889149) | ||
| 17597 | 17597 | 26520 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2859 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 1X1 | 6009005.0010400005 | 2101862.3389 | 37.7518220263649 | -122.41171887573299 | (37.7518220263649, -122.411718875733) | |||
| 18376 | 18376 | 91748 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2600 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008877.354104 | 2103306.550106 | 37.7557803438331 | -122.41226236274099 | (37.7557803438331, -122.412262362741) | ||
| 19132 | 19132 | 96505 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 19356 | 19356 | 91743 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2708 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/07/2007 12:00:00 AM | 3 | 3x3 | 6008911.299202 | 2102677.621362 | 37.7540553520509 | -122.412100523216 | (37.7540553520509, -122.412100523216) | ||
| 21521 | 21521 | 28133 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 400X Eugenia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 6x9 | 6006730.12639 | 2098017.46298 | 37.7411369886855 | -122.419312995691 | (37.7411369886855, -122.419312995691) | |||
| 22215 | 22215 | 26526 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2791 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/30/2011 12:00:00 AM | 3 | 3x3 | 6008986.10283 | 2102201.02805 | 37.752750930716 | -122.411808158615 | (37.752750930716, -122.411808158615) | ||
| 22995 | 22995 | 11883 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 400X Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017703.731269999 | 2096843.30561 | 37.73852491679771 | -122.381288201801 | (37.7385249167977, -122.381288201801) | |||
| 23511 | 23511 | 233467 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2355 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008792.16391 | 2104566.15897 | 37.7592341631379 | -122.412646020091 | (37.7592341631379, -122.412646020091) | |||
| 24088 | 24088 | 233450 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3050 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009002.96054 | 2100768.18815 | 37.748817618046104 | -122.411648631477 | (37.7488176180461, -122.411648631477) | |||
| 24479 | 24479 | 178359 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 235 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6003629.76511 | 2092456.5835099998 | 37.72569297073721 | -122.42963641778401 | (37.7256929707372, -122.429636417784) | |||
| 24720 | 24720 | 233368 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3505 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6006128.237380001 | 2104906.34475 | 37.7600183620686 | -122.421883341755 | (37.7600183620686, -122.421883341755) | |||
| 25595 | 25595 | 233370 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3698 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005218.25871 | 2101973.53157 | 37.7519141816957 | -122.424821872029 | (37.7519141816957, -122.424821872029) | |||
| 25661 | 25661 | 141827 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1040 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004564.2329 | 2112276.6178 | 37.7801670209735 | -122.427817645466 | (37.7801670209735, -122.427817645466) | |||
| 25840 | 25840 | 233423 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2349 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008850.79758 | 2104700.64825 | 37.7596067306737 | -122.412452742325 | (37.7596067306737, -122.412452742325) | |||
| 26405 | 26405 | 211313 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2331 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992606.241280001 | 2099598.3023200002 | 37.7446719916245 | -122.468262856359 | (37.7446719916245, -122.468262856359) | |||
| 27181 | 27181 | 96265 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2776 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2011 12:00:00 AM | Permit Number 767311 | 6004841.3 | 2119075.5 | 37.798850712467 | -122.42734360527399 | (37.798850712467, -122.427343605274) | |||
| 27600 | 27600 | 233376 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 476 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003431.53598 | 2100120.0067 | 37.746723757115205 | -122.430868343305 | (37.7467237571152, -122.430868343305) | |||
| 28190 | 28190 | 233454 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2816 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008939.131680001 | 2102033.55386 | 37.7522884489586 | -122.411958759988 | (37.7522884489586, -122.411958759988) | |||
| 28212 | 28212 | 233420 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2475 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008882.84351 | 2104050.40662 | 37.75782311337 | -122.41229595182301 | (37.75782311337, -122.412295951823) | |||
| 29165 | 29165 | 233457 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2652 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008877.75301 | 2103039.18027 | 37.755046229026796 | -122.41224208691999 | (37.7550462290268, -122.41224208692) | |||
| 29622 | 29622 | 233417 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2595 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008920.692530001 | 2103375.8900599997 | 37.7559731674471 | -122.412117384237 | (37.7559731674471, -122.412117384237) | |||
| 29833 | 29833 | 233363 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1750 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008602.87705 | 2108217.80859 | 37.7692501250135 | -122.413558936315 | (37.7692501250135, -122.413558936315) | |||
| 29887 | 29887 | 233463 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2598 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008858.41145 | 2103392.91601 | 37.7560164221241 | -122.41233397693998 | (37.7560164221241, -122.41233397694) | |||
| 30700 | 30700 | 233437 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 4221 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002351.48314 | 2100601.8225 | 37.7479854555773 | -122.43463750001601 | (37.7479854555773, -122.434637500016) | |||
| 30902 | 30902 | 233395 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 271 Shotwell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007786.02518 | 2106562.96746 | 37.7646604169782 | -122.41626717000601 | (37.7646604169782, -122.416267170006) | |||
| 30944 | 30944 | 233460 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2652 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6008873.95519 | 2103097.13758 | 37.7552051536125 | -122.41225931703 | (37.7552051536125, -122.41225931703) | |||
| 31027 | 31027 | 233489 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1850 Harrison St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008682.13256 | 2107685.3009099998 | 37.7677924328048 | -122.413247133243 | (37.7677924328048, -122.413247133243) | |||
| 31232 | 31232 | 233386 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1830 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6008614.93876 | 2107785.11216 | 37.7680627186577 | -122.41348660922199 | (37.7680627186577, -122.413486609222) | |||
| 31582 | 31582 | 194547 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 590 Keith St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6017544.15385 | 2096613.95658 | 37.737886359456205 | -122.381824001685 | (37.7378863594562, -122.381824001685) | |||
| 31885 | 31885 | 233487 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1815 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008673.30569 | 2107876.17641 | 37.768316036993 | -122.41329116408001 | (37.768316036993, -122.41329116408) | |||
| 32296 | 32296 | 233396 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 271 Shotwell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007784.70136 | 2106598.65312 | 37.7647583270588 | -122.416274276453 | (37.7647583270588, -122.416274276453) | |||
| 33966 | 33966 | 233405 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2989 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009047.23113 | 2101093.61607 | 37.7497136539827 | -122.411518531957 | (37.7497136539827, -122.411518531957) | |||
| 34369 | 34369 | 233478 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2355 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008776.66854 | 2104837.1168299997 | 37.7599772819377 | -122.41271876626001 | (37.7599772819377, -122.41271876626) | |||
| 34674 | 34674 | 233369 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3698 24th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005236.6856 | 2101975.24545 | 37.7519199283811 | -122.42475827109101 | (37.7519199283811, -122.424758271091) | |||
| 35044 | 35044 | 233399 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 271 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007778.39498 | 2106706.34258 | 37.7650536626339 | -122.416303716638 | (37.7650536626339, -122.416303716638) | |||
| 35090 | 35090 | 233456 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2708 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008901.956069999 | 2102598.24372 | 37.7538368746765 | -122.41212722461799 | (37.7538368746765, -122.412127224618) | |||
| 35402 | 35402 | 211317 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 45 Linares Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 3ft | 5993928.12229 | 2102221.5591700003 | 37.7519510476114 | -122.463882461023 | (37.7519510476114, -122.463882461023) | |||
| 36779 | 36779 | 233394 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 271 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007790.53489 | 2106496.5266299997 | 37.76447823949471 | -122.416246865994 | (37.7644782394947, -122.416246865994) | |||
| 36785 | 36785 | 233474 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2355 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008786.04636 | 2104727.2357400004 | 37.759676099877794 | -122.412678564777 | (37.7596760998778, -122.412678564777) | |||
| 36797 | 36797 | 194543 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 184 Hooper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6012559.7859 | 2107618.8810799997 | 37.7678269955571 | -122.399830043335 | (37.7678269955571, -122.399830043335) | |||
| 37139 | 37139 | 233402 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 3025 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008058.99429 | 2103844.13337 | 37.757210470003294 | -122.41513057351101 | (37.7572104700033, -122.415130573511) | |||
| 37466 | 37466 | 73861 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 322 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/20/1993 12:00:00 AM | 2 | 6005837.5808 | 2110875.7018 | 37.776392397126706 | -122.42331293279301 | (37.7763923971267, -122.423312932793) | ||
| 38321 | 38321 | 194530 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 616 Carolina St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 6012360.41946 | 2105070.75065 | 37.760819281207496 | -122.400340636111 | (37.7608192812075, -122.400340636111) | |||
| 38649 | 38649 | 233455 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2774 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008918.08813 | 2102304.0986 | 37.753030123442706 | -122.412050650042 | (37.7530301234427, -122.412050650042) | |||
| 39665 | 39665 | 233473 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2355 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008782.8633 | 2104706.9065099997 | 37.75962010179779 | -122.412688136266 | (37.7596201017978, -122.412688136266) | |||
| 39805 | 39805 | 233507 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1941 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008711.02427 | 2107230.56462 | 37.7665454544263 | -122.413115041722 | (37.7665454544263, -122.413115041722) | |||
| 40098 | 40098 | 233469 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2355 Harrison St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008788.18662 | 2104615.29768 | 37.7593688636119 | -122.41266324931499 | (37.7593688636119, -122.412663249315) | |||
| 40218 | 40218 | 233504 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 303 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004169.36699 | 2109042.8259799997 | 37.7712654778421 | -122.428953047263 | (37.7712654778421, -122.428953047263) | |||
| 40392 | 40392 | 233380 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 397 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007405.88509 | 2096272.2720299999 | 37.7363831156735 | -122.41685284539801 | (37.7363831156735, -122.416852845398) | |||
| 41175 | 41175 | 132218 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2860 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5999271.44145 | 2118406.78235 | 37.796698012158 | -122.44656892611799 | (37.796698012158, -122.446568926118) | |||
| 41886 | 41886 | 233498 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 101 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000562.671680001 | 2104881.27171 | 37.7596340727711 | -122.441130104275 | (37.7596340727711, -122.441130104275) | |||
| 41922 | 41922 | 233388 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1815 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6008673.84119 | 2107870.27122 | 37.768299852779606 | -122.41328889418399 | (37.7682998527796, -122.413288894184) | |||
| 42003 | 42003 | 233443 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 550 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008940.03801 | 2105662.09914 | 37.7622516628983 | -122.412212055847 | (37.7622516628983, -122.412212055847) | |||
| 43470 | 43470 | 132212 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2654 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000265.269640001 | 2118199.18789 | 37.7961847294893 | -122.443115149071 | (37.7961847294893, -122.443115149071) | |||
| 44541 | 44541 | 249943 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 331 Filbert St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011269.12703 | 2120027.36915 | 37.8018257441226 | -122.405168167193 | (37.8018257441226, -122.405168167193) | |||
| 44700 | 44700 | 233365 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 200 Lexington St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006473.17565 | 2104847.55108 | 37.75987637530879 | -122.420686190322 | (37.7598763753088, -122.420686190322) | |||
| 44850 | 44850 | 54918 | Permitted Site 1 | Pistacia chinensis :: Chinese Pistache 150 | 2836 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 9 | Permit Number 10785 | 5999351.3134 | 2118417.6127299997 | 37.7967323114142 | -122.446293331595 | (37.7967323114142, -122.446293331595) | ||
| 44852 | 44852 | 139955 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 900 GOLDEN GATE AVE | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6004851.0238 | 2112323.6242 | 37.7803123083991 | -122.426828852854 | (37.7803123083991, -122.426828852854) | |||
| 45120 | 45120 | 233411 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2709 Harrison St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 8ft | 6008945.30625 | 2102700.68655 | 37.754120591896 | -122.411984548072 | (37.754120591896, -122.411984548072) | |||
| 46353 | 46353 | 233451 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2870 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008950.63348 | 2101756.58641 | 37.751528603671 | -122.411899414636 | (37.751528603671, -122.411899414636) | |||
| 46476 | 46476 | 233488 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 1815 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008674.820280001 | 2107841.97486 | 37.768222212525004 | -122.413283506332 | (37.768222212525, -122.413283506332) | |||
| 47250 | 47250 | 194545 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 184 Hooper St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6012495.5993 | 2107561.45835 | 37.76766574711311 | -122.400048025518 | (37.7676657471131, -122.400048025518) | |||
| 47702 | 47702 | 233400 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 2807 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009350.246780001 | 2103328.60933 | 37.755867437740605 | -122.410628499003 | (37.7558674377406, -122.410628499003) | |||
| 47732 | 47732 | 178357 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 700 Olmstead St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6009625.93878 | 2090631.7553 | 37.7210200744845 | -122.408779340021 | (37.7210200744845, -122.408779340021) | |||
| 49101 | 49101 | 233493 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 4103 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6001723.63115 | 2103489.69631 | 37.7558792035671 | -122.437015303929 | (37.7558792035671, -122.437015303929) | |||
| 49360 | 49360 | 233364 | Undocumented 2 | Pistacia chinensis :: Chinese Pistache 150 | 200 Lexington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6006470.8211900005 | 2104891.7812900003 | 37.75999768845939 | -122.42069747321301 | (37.7599976884594, -122.420697473213) |
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");