Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 687 | 687 | 13252 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3X3 | 6001005.1632 | 2119265.163 | 37.7991537757264 | -122.440631471061 | (37.7991537757264, -122.440631471061) | |||
| 739 | 739 | 13244 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/18/2012 12:00:00 AM | 3 | 3x3 | 6001169.3018 | 2119289.54 | 37.7992300540772 | -122.44006524578501 | (37.7992300540772, -122.440065245785) | ||
| 979 | 979 | 200925 | Undocumented 2 | Tristania conferta :: 79 | 4100 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/2017 12:00:00 AM | 3 | Width 0ft | 6015478.3928 | 2097437.2349 | 37.7400326248174 | -122.389023874228 | (37.7400326248174, -122.389023874228) | ||
| 1017 | 1017 | 6253 | Permitted Site 1 | Tristania conferta :: 79 | 1315 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2004 12:00:00 AM | 9 | 3X3 | 6004522.7205 | 2113262.2432 | 37.782870955582794 | -122.428031512738 | (37.7828709555828, -122.428031512738) | ||
| 2329 | 2329 | 6184 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005484.2824 | 2113445.6337 | 37.7834288547985 | -122.424717956993 | (37.7834288547985, -122.424717956993) | |||
| 2981 | 2981 | 245990 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/2010 12:00:00 AM | 11 | Width 0ft | Permit Number 53135 | 5999824.4044 | 2108487.46 | 37.76949368743671 | -122.44394249781901 | (37.7694936874367, -122.443942497819) | |
| 3105 | 3105 | 199929 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 02/28/2006 12:00:00 AM | 6 | Width 0ft | 6016487.4596 | 2092903.0942 | 37.727638663365 | -122.385219049049 | (37.727638663365, -122.385219049049) | ||
| 4457 | 4457 | 13208 | Permitted Site 1 | Tristania conferta :: 79 | 2199 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 6 | 3X3 | 6001971.1512 | 2119400.3389 | 37.7995798943259 | -122.437298513288 | (37.7995798943259, -122.437298513288) | ||
| 5483 | 5483 | 17683 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002401.1721 | 2112213.0575 | 37.7798698996827 | -122.43529610278401 | (37.7798698996827, -122.435296102784) | |||
| 5503 | 5503 | 7044 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2010 12:00:00 AM | 12 | 3X3 | 6001092.4662 | 2110057.6748 | 37.7738773565747 | -122.439668919992 | (37.7738773565747, -122.439668919992) | ||
| 5834 | 5834 | 6999 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002754.2205 | 2110289.0229 | 37.774607023478 | -122.433937185692 | (37.774607023478, -122.433937185692) | ||
| 6447 | 6447 | 9761 | Permitted Site 1 | Tristania conferta :: 79 | 745 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/25/1997 12:00:00 AM | 8 | 4x4 | 6005736.7899 | 2112320.9115 | 37.7803549018091 | -122.423764380812 | (37.7803549018091, -122.423764380812) | ||
| 6645 | 6645 | 1662 | Permitted Site 1 | Tristania conferta :: 79 | 1400X Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000535.6523 | 2109979.223 | 37.7736302396696 | -122.441589394177 | (37.7736302396696, -122.441589394177) | ||
| 6823 | 6823 | 28076 | DPW Maintained 3 | Tristania conferta :: 79 | 915 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/13/2003 12:00:00 AM | 25 | 3X3 | 6008674.8876 | 2120493.8068 | 37.8029610933815 | -122.41417849255801 | (37.8029610933815, -122.414178492558) | ||
| 6841 | 6841 | 14479 | DPW Maintained 3 | Tristania conferta :: 79 | 270 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5998992.7029 | 2112117.3083 | 37.7794128442998 | -122.44708056796001 | (37.7794128442998, -122.44708056796) | |||
| 7599 | 7599 | 6198 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005211.2623 | 2113352.5609 | 37.7831578763581 | -122.425655873927 | (37.7831578763581, -122.425655873927) | |||
| 7726 | 7726 | 14482 | DPW Maintained 3 | Tristania conferta :: 79 | 281 Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 5998940.9244 | 2112049.1164 | 37.7792226484867 | -122.447254781672 | (37.7792226484867, -122.447254781672) | |||
| 8127 | 8127 | 12344 | DPW Maintained 3 | Tristania conferta :: 79 | 1200 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 6 | 4X4 | 6004712.8065 | 2113066.0947 | 37.782343132875795 | -122.427359916847 | (37.7823431328758, -122.427359916847) | ||
| 8171 | 8171 | 21598 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005231.4306 | 2114747.34 | 37.7869887331779 | -122.425685404725 | (37.7869887331779, -122.425685404725) | |||
| 8450 | 8450 | 13160 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003384.5853 | 2119677.9886 | 37.800422496977795 | -122.43242736604999 | (37.8004224969778, -122.43242736605) | |||
| 8543 | 8543 | 9758 | DPW Maintained 3 | Tristania conferta :: 79 | 735 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/1997 12:00:00 AM | 18 | 4x4 | 6005747.9577 | 2112242.2179 | 37.78013945886 | -122.423720149275 | (37.78013945886, -122.423720149275) | ||
| 8648 | 8648 | 9718 | Permitted Site 1 | Tristania conferta :: 79 | 555 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 4X4 | 6005827.0659 | 2111648.8185 | 37.7785145942054 | -122.423404280737 | (37.7785145942054, -122.423404280737) | |||
| 8816 | 8816 | 17671 | DPW Maintained 3 | Tristania conferta :: 79 | 1015X Pierce St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/05/1995 12:00:00 AM | 12 | 3X3 | 6002380.7463 | 2112056.356 | 37.779438476782 | -122.43535555227301 | (37.779438476782, -122.435355552273) | ||
| 8923 | 8923 | 9562 | Permitted Site 1 | Tristania conferta :: 79 | 1201 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003785.6894 | 2112111.0558 | 37.77966835631079 | -122.43049916558701 | (37.7796683563108, -122.430499165587) | |||
| 9013 | 9013 | 23929 | Permitted Site 1 | Tristania conferta :: 79 | 1715 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1992 12:00:00 AM | 20 | 4X4 | 6003463.555 | 2114659.6298 | 37.786647847412404 | -122.431795587112 | (37.7866478474124, -122.431795587112) | ||
| 9443 | 9443 | 4536 | Permitted Site 1 | Tristania conferta :: 79 | 65 Cleary Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1991 12:00:00 AM | 12 | 3X3 | 6004897.6525 | 2113656.6857 | 37.783975201758 | -122.426762502798 | (37.783975201758, -122.426762502798) | ||
| 13454 | 13454 | 29437 | DPW Maintained 3 | Tristania conferta :: 79 | 2307X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015612.318 | 2091732.5629 | 37.72437616438229 | -122.388162796666 | (37.7243761643823, -122.388162796666) | ||
| 13739 | 13739 | 30026 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6013442.0581 | 2091191.4573 | 37.7227699118645 | -122.39562724256201 | (37.7227699118645, -122.395627242562) | ||
| 13756 | 13756 | 29432 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015452.0518 | 2091514.7509 | 37.7237692145382 | -122.38870162152 | (37.7237692145382, -122.38870162152) | ||
| 13996 | 13996 | 29494 | DPW Maintained 3 | Tristania conferta :: 79 | 1700X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016622.9685 | 2093155.9340000001 | 37.7283404071211 | -122.384768194628 | (37.7283404071211, -122.384768194628) | ||
| 14103 | 14103 | 22403 | DPW Maintained 3 | Tristania conferta :: 79 | 5800 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/1995 12:00:00 AM | 4 | 3X3 | 6013795.569 | 2092117.5258 | 37.7253323678743 | -122.394470034522 | (37.7253323678743, -122.394470034522) | ||
| 14107 | 14107 | 29383 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014243.8989 | 2089896.7929 | 37.7192595907189 | -122.39276490097099 | (37.7192595907189, -122.392764900971) | ||
| 14486 | 14486 | 22367 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6014252.0584 | 2093100.0082 | 37.7280554333447 | -122.392960690106 | (37.7280554333447, -122.392960690106) | |||
| 15418 | 15418 | 94801 | Permitted Site 1 | Tristania conferta :: 79 | 3950X 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6015629.3168 | 2097929.6865 | 37.7413931608426 | -122.388536401689 | (37.7413931608426, -122.388536401689) | |||
| 15436 | 15436 | 29533 | DPW Maintained 3 | Tristania conferta :: 79 | 2304X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015579.3413 | 2091755.0969999998 | 37.724436211393396 | -122.388278365495 | (37.7244362113934, -122.388278365495) | ||
| 15697 | 15697 | 12242 | DPW Maintained 3 | Tristania conferta :: 79 | 1130 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/1997 12:00:00 AM | 6 | 3X3 | 6015460.5377 | 2096047.2009 | 37.7362148852375 | -122.388988585219 | (37.7362148852375, -122.388988585219) | ||
| 15973 | 15973 | 22420 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6013860.9167 | 2092056.0916 | 37.725167314492104 | -122.39423983281799 | (37.7251673144921, -122.394239832818) | ||
| 16118 | 16118 | 22394 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6013900.6343 | 2092382.1168 | 37.7260647216629 | -122.394125346164 | (37.7260647216629, -122.394125346164) | ||
| 16191 | 16191 | 22439 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2011 12:00:00 AM | 3 | 3X3 | 6013618.2519 | 2091420.3228 | 37.7234081298852 | -122.39503419617901 | (37.7234081298852, -122.395034196179) | ||
| 16422 | 16422 | 28834 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 16 | 4x4 | 6016954.1963 | 2093605.3666 | 37.7295927742855 | -122.38365439115499 | (37.7295927742855, -122.383654391155) | ||
| 16447 | 16447 | 29423 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 5 | 3x3 | 6015296.9511 | 2091308.8081 | 37.7231951390157 | -122.38922340969101 | (37.7231951390157, -122.389223409691) | ||
| 16696 | 16696 | 29546 | DPW Maintained 3 | Tristania conferta :: 79 | 2900X Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6014598.9886 | 2090439.4771 | 37.7207694102971 | -122.39157540084999 | (37.7207694102971, -122.39157540085) | ||
| 18571 | 18571 | 15284 | DPW Maintained 3 | Tristania conferta :: 79 | 1600 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 6 | 3x3 | 6007065.8524 | 2109440.6797 | 37.7725214132882 | -122.418962182475 | (37.7725214132882, -122.418962182475) | ||
| 19234 | 19234 | 2174 | DPW Maintained 3 | Tristania conferta :: 79 | 1012X Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | 3X3 | 6001267.8248 | 2109041.6287 | 37.7710975275243 | -122.43898949646601 | (37.7710975275243, -122.438989496466) | |||
| 20200 | 20200 | 9655 | DPW Maintained 3 | Tristania conferta :: 79 | 95 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006065.5245 | 2109925.4044 | 37.7737959717838 | -122.42245687094999 | (37.7737959717838, -122.42245687095) | ||
| 23022 | 23022 | 18237 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 4 | 4X4 | 6003723.9754 | 2114242.1212 | 37.7855162327444 | -122.43086478876002 | (37.7855162327444, -122.43086478876) | ||
| 23200 | 23200 | 22221 | DPW Maintained 3 | Tristania conferta :: 79 | 4301 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/1997 12:00:00 AM | 2 | 3x3 | 6015398.3252 | 2096867.7861 | 37.7384645963363 | -122.389260963878 | (37.7384645963363, -122.389260963878) | ||
| 25095 | 25095 | 139803 | Undocumented 2 | Tristania conferta :: 79 | 1101 GOUGH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6005645.0945 | 2112991.4978 | 37.7821909905379 | -122.42412930203699 | (37.7821909905379, -122.424129302037) | |||
| 25813 | 25813 | 50649 | Permitted Site 1 | Tristania conferta :: 79 | 821 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51399 | 6012160.9197 | 2112637.3571 | 37.7815843393908 | -122.401562438489 | (37.7815843393908, -122.401562438489) | |
| 25828 | 25828 | 122838 | Undocumented 2 | Tristania conferta :: 79 | 945 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 2x3 | 6001931.7611 | 2111776.6298 | 37.7786449107474 | -122.436888748547 | (37.7786449107474, -122.436888748547) | |||
| 26582 | 26582 | 244213 | Undocumented 2 | Tristania conferta :: 79 | 322 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004508.1464 | 2109493.0779 | 37.7725209302455 | -122.427813281818 | (37.7725209302455, -122.427813281818) | |||
| 28165 | 28165 | 244387 | Undocumented 2 | Tristania conferta :: 79 | 877 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003242.3169 | 2110300.201 | 37.774665402715705 | -122.432249563339 | (37.7746654027157, -122.432249563339) | |||
| 29017 | 29017 | 47568 | Permitted Site 1 | Tristania conferta :: 79 | 301 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/2002 12:00:00 AM | 7 | Permit Number 45427 | 6014701.4667 | 2115063.502 | 37.7883874115209 | -122.392943084604 | (37.7883874115209, -122.392943084604) | ||
| 30970 | 30970 | 141807 | Undocumented 2 | Tristania conferta :: 79 | 1398 WILLOW ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6004301.1437 | 2113069.4068 | 37.7823289364611 | -122.42878432451201 | (37.7823289364611, -122.428784324512) | |||
| 31503 | 31503 | 142082 | Undocumented 2 | Tristania conferta :: 79 | 1593 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000216.454 | 2110924.9728 | 37.776208837743894 | -122.442761469865 | (37.7762088377439, -122.442761469865) | |||
| 32392 | 32392 | 137777 | Undocumented 2 | Tristania conferta :: 79 | 1773 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6001052.3759 | 2111729.7512 | 37.7784661743304 | -122.439927511873 | (37.7784661743304, -122.439927511873) | |||
| 35829 | 35829 | 139042 | Undocumented 2 | Tristania conferta :: 79 | 1434 BAKER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6000193.0745 | 2113977.6097 | 37.7845892631082 | -122.443061626662 | (37.7845892631082, -122.443061626662) | |||
| 38764 | 38764 | 140349 | Undocumented 2 | Tristania conferta :: 79 | 1314 ELLIS ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6004502.4614 | 2113302.7614 | 37.7829810622913 | -122.42810448919901 | (37.7829810622913, -122.428104489199) | |||
| 39393 | 39393 | 200515 | Undocumented 2 | Tristania conferta :: 79 | 5701 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6013933.5199 | 2092242.5052 | 37.7256832041027 | -122.394001892797 | (37.7256832041027, -122.394001892797) | |||
| 39892 | 39892 | 246103 | Undocumented 2 | Tristania conferta :: 79 | 1764 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997227.3423 | 2108124.3680000002 | 37.768348244409204 | -122.452899371868 | (37.7683482444092, -122.452899371868) | |||
| 39994 | 39994 | 245888 | Undocumented 2 | Tristania conferta :: 79 | 206 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001304.6614 | 2109491.6324 | 37.7723352211599 | -122.43889433138901 | (37.7723352211599, -122.438894331389) | |||
| 40049 | 40049 | 140097 | Undocumented 2 | Tristania conferta :: 79 | 515 GOUGH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005837.56 | 2111570.1127 | 37.7782990795293 | -122.42336238105301 | (37.7782990795293, -122.423362381053) | |||
| 41024 | 41024 | 200988 | Undocumented 2 | Tristania conferta :: 79 | 75 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015383.195 | 2115715.4111 | 37.79021524820921 | -122.39062996700899 | (37.7902152482092, -122.390629967009) | |||
| 42950 | 42950 | 32145 | Permitted Site 1 | Tristania conferta :: 79 | 563 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1995 12:00:00 AM | 11 | Permit Number 35498 | 6003116.0093 | 2110209.6426 | 37.77440958934721 | -122.432680016089 | (37.7744095893472, -122.432680016089) | ||
| 43577 | 43577 | 248528 | Undocumented 2 | Tristania conferta :: 79 | 55 Beulah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997696.5759 | 2107800.7951 | 37.7674866743633 | -122.45125300592599 | (37.7674866743633, -122.451253005926) | |||
| 44400 | 44400 | 141459 | Undocumented 2 | Tristania conferta :: 79 | 15 Kittredge Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997948.2961 | 2111555.5927 | 37.7778107922486 | -122.450653084923 | (37.7778107922486, -122.450653084923) | |||
| 45469 | 45469 | 246308 | Undocumented 2 | Tristania conferta :: 79 | 1601 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6007054.0219 | 2109305.099 | 37.7721484747698 | -122.418993487345 | (37.7721484747698, -122.418993487345) | |||
| 45722 | 45722 | 200896 | Undocumented 2 | Tristania conferta :: 79 | 4249 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6015450.0503 | 2097040.9117 | 37.7389428313024 | -122.38909420666201 | (37.7389428313024, -122.389094206662) | |||
| 46832 | 46832 | 94612 | Permitted Site 1 | Tristania conferta :: 79 | 5600@ Armstrong 03rd St | 3 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 10/13/2010 12:00:00 AM | 4 | Permit Number 53777 | 6013990.2772 | 2092621.1644 | 37.726726080275604 | -122.393832179047 | (37.7267260802756, -122.393832179047) | ||
| 47844 | 47844 | 138598 | Undocumented 2 | Tristania conferta :: 79 | 1951 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6001454.5399 | 2115120.9706 | 37.7878004824405 | -122.43877935081998 | (37.7878004824405, -122.43877935082) | |||
| 56101 | 56101 | 245465 | Undocumented 2 | Tristania conferta :: 79 | 2601 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008856.7977 | 2106814.5159 | 37.7654112631592 | -122.412581421905 | (37.7654112631592, -122.412581421905) | |||
| 56512 | 56512 | 142369 | Undocumented 2 | Tristania conferta :: 79 | 1051 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6005596.8056 | 2113324.6423 | 37.7831029967419 | -122.424320062115 | (37.7831029967419, -122.424320062115) | |||
| 57175 | 57175 | 199703 | Undocumented 2 | Tristania conferta :: 79 | 1920 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016265.2574 | 2092686.1401 | 37.7270306554464 | -122.385972095124 | (37.7270306554464, -122.385972095124) | |||
| 58276 | 58276 | 122823 | Permitted Site 1 | Tristania conferta :: 79 | 1736 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 7 | 4x4 | 6010043.2132 | 2120098.5684 | 37.8019526289989 | -122.409415446027 | (37.8019526289989, -122.409415446027) | ||
| 59858 | 59858 | 107147 | Undocumented 2 | Tristania conferta :: 79 | 2466 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5985833.5095 | 2098430.6846 | 37.7410725309134 | -122.49159537855301 | (37.7410725309134, -122.491595378553) | ||||
| 60890 | 60890 | 142785 | Undocumented 2 | Tristania conferta :: 79 | 730 POLK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6007074.6935 | 2113542.206 | 37.7837837144855 | -122.419222597686 | (37.7837837144855, -122.419222597686) | |||
| 63684 | 63684 | 141092 | Undocumented 2 | Tristania conferta :: 79 | 192 Jordan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996267.8998 | 2112993.8208 | 37.781663458081205 | -122.45657015648099 | (37.7816634580812, -122.456570156481) | |||
| 64856 | 64856 | 139755 | Undocumented 2 | Tristania conferta :: 79 | 1151 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005560.6004 | 2113546.3461 | 37.7837096962291 | -122.42446109226499 | (37.7837096962291, -122.424461092265) | |||
| 65455 | 65455 | 244271 | Undocumented 2 | Tristania conferta :: 79 | 114 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005957.8115 | 2110036.9608 | 37.77409620184329 | -122.422837397781 | (37.7740962018433, -122.422837397781) | |||
| 66249 | 66249 | 244950 | Undocumented 2 | Tristania conferta :: 79 | 261 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6005976.2472 | 2110605.9955 | 37.7756596739035 | -122.422814074007 | (37.7756596739035, -122.422814074007) | |||
| 66271 | 66271 | 142793 | Undocumented 2 | Tristania conferta :: 79 | 539 Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6007552.407000001 | 2113254.1595 | 37.783019700595496 | -122.41754946205099 | (37.7830197005955, -122.417549462051) | |||
| 67395 | 67395 | 143429 | Undocumented 2 | Tristania conferta :: 79 | 855 SACRAMENTO ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6010687.6362 | 2116910.2621 | 37.7932344012545 | -122.406960577759 | (37.7932344012545, -122.406960577759) | |||
| 68253 | 68253 | 140043 | Undocumented 2 | Tristania conferta :: 79 | 910 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6001994.1202 | 2111638.8314 | 37.7782700950378 | -122.436663158472 | (37.7782700950378, -122.436663158472) | |||
| 68894 | 68894 | 137924 | Undocumented 2 | Tristania conferta :: 79 | 1901 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003382.682999999 | 2115264.2206 | 37.78830331594779 | -122.432118575792 | (37.7883033159478, -122.432118575792) | |||
| 70557 | 70557 | 141354 | Undocumented 2 | Tristania conferta :: 79 | 501 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6002138.2285 | 2110254.9329 | 37.774478444597 | -122.43606558066799 | (37.774478444597, -122.436065580668) | |||
| 71167 | 71167 | 247331 | Undocumented 2 | Tristania conferta :: 79 | 765 Fell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003739.8743 | 2110369.7612 | 37.7748845966355 | -122.43053337748199 | (37.7748845966355, -122.430533377482) | |||
| 72934 | 72934 | 138714 | Undocumented 2 | Tristania conferta :: 79 | 1642 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6000616.1387 | 2114405.7569999998 | 37.7857889577881 | -122.441628707296 | (37.7857889577881, -122.441628707296) | |||
| 73046 | 73046 | 199661 | Undocumented 2 | Tristania conferta :: 79 | 2799 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014931.4027 | 2090815.1889 | 37.7218194863987 | -122.390452576229 | (37.7218194863987, -122.390452576229) | |||
| 73164 | 73164 | 138782 | Undocumented 2 | Tristania conferta :: 79 | 1600 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003605.5991 | 2114290.1506 | 37.785641401605 | -122.431277765367 | (37.785641401605, -122.431277765367) | |||
| 73571 | 73571 | 199818 | Undocumented 2 | Tristania conferta :: 79 | 2226 Ingalls St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6015709.0498 | 2091939.7667 | 37.7249504642567 | -122.387842856465 | (37.7249504642567, -122.387842856465) | |||
| 75180 | 75180 | 200505 | Undocumented 2 | Tristania conferta :: 79 | 5835 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6013828.2125 | 2091967.7903 | 37.7249230389794 | -122.394346709006 | (37.7249230389794, -122.394346709006) | |||
| 76477 | 76477 | 140436 | Undocumented 2 | Tristania conferta :: 79 | 1001 WEBSTER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003630.7136 | 2112143.9541 | 37.7797499065425 | -122.431037642518 | (37.7797499065425, -122.431037642518) | |||
| 77364 | 77364 | 139454 | Undocumented 2 | Tristania conferta :: 79 | 901 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001961.876 | 2111598.6783 | 37.778158012267205 | -122.436771827776 | (37.7781580122672, -122.436771827776) | |||
| 130320 | 130320 | 141068 | Undocumented 2 | Tristania conferta :: 79 | 516 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997528.6902 | 2112557.7643 | 37.7805384665203 | -122.45217696844 | (37.7805384665203, -122.45217696844) | |||
| 130426 | 130426 | 140500 | Undocumented 2 | Tristania conferta :: 79 | 971 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003831.2673 | 2112037.3714 | 37.7794686190462 | -122.43033623333599 | (37.7794686190462, -122.430336233336) | |||
| 131688 | 131688 | 139929 | Undocumented 2 | Tristania conferta :: 79 | 800 GOUGH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6005694.4032 | 2112619.0761 | 37.7811711958921 | -122.42393222480499 | (37.7811711958921, -122.423932224805) | |||
| 132688 | 132688 | 200661 | Undocumented 2 | Tristania conferta :: 79 | 1530 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6015191.3151 | 2095402.8734 | 37.7344307659905 | -122.38987441314801 | (37.7344307659905, -122.389874413148) | |||
| 132892 | 132892 | 200820 | Undocumented 2 | Tristania conferta :: 79 | 5210 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6014432.2484 | 2093951.9392 | 37.7304046712584 | -122.392397325576 | (37.7304046712584, -122.392397325576) | |||
| 133213 | 133213 | 140396 | Undocumented 2 | Tristania conferta :: 79 | 1260 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6004649.1654 | 2113184.6997 | 37.7826651932841 | -122.427588539655 | (37.7826651932841, -122.427588539655) | |||
| 136454 | 136454 | 245023 | Undocumented 2 | Tristania conferta :: 79 | 291 Broderick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001245.3315 | 2109593.1746 | 37.77261065490929 | -122.439106837408 | (37.7726106549093, -122.439106837408) |
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");