Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7459 | 7459 | 7015 | Permitted Site 1 | Tristania conferta :: 79 | 1050 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002372.7109 | 2110234.5481 | 37.7744357915241 | -122.435253003778 | (37.7744357915241, -122.435253003778) | ||
| 7516 | 7516 | 6182 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005530.6795 | 2113448.9143 | 37.7834404828465 | -122.424557674459 | (37.7834404828465, -122.424557674459) | |||
| 7519 | 7519 | 14445 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5998940.7552 | 2112468.0825 | 37.7803730113246 | -122.44728552935801 | (37.7803730113246, -122.447285529358) | |||
| 7522 | 7522 | 13182 | DPW Maintained 3 | Tristania conferta :: 79 | 2001 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6002733.3901 | 2119504.96 | 37.7999104584024 | -122.434668379841 | (37.7999104584024, -122.434668379841) | |||
| 7529 | 7529 | 13218 | DPW Maintained 3 | Tristania conferta :: 79 | 2230 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 20 | 3X3 | 6001666.6293 | 2119436.4581 | 37.799661752140295 | -122.43835485597299 | (37.7996617521403, -122.438354855973) | ||
| 7530 | 7530 | 6981 | DPW Maintained 3 | Tristania conferta :: 79 | 802 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003535.9112 | 2110394.3354 | 37.77494051486671 | -122.431240682973 | (37.7749405148667, -122.431240682973) | |||
| 7533 | 7533 | 23864 | DPW Maintained 3 | Tristania conferta :: 79 | 1440 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4X4 | 6003698.6329 | 2113675.0331 | 37.7839577153907 | -122.43091198011601 | (37.7839577153907, -122.430911980116) | |||
| 7536 | 7536 | 6323 | DPW Maintained 3 | Tristania conferta :: 79 | 1864 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001889.2551 | 2112939.5041 | 37.7818354537074 | -122.437119073338 | (37.7818354537074, -122.437119073338) | |||
| 7540 | 7540 | 6040 | DPW Maintained 3 | Tristania conferta :: 79 | 1819 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/18/1997 12:00:00 AM | 12 | 4X4 | 6001713.6698 | 2112519.6828 | 37.7806727486492 | -122.43769643941002 | (37.7806727486492, -122.43769643941) | ||
| 7594 | 7594 | 21603 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005357.043 | 2114765.7223 | 37.7870463035591 | -122.42525212232901 | (37.7870463035591, -122.425252122329) | |||
| 7595 | 7595 | 13237 | Permitted Site 1 | Tristania conferta :: 79 | 2320 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 30 | 3X3 | 6001278.1859 | 2119382.1727 | 37.7994905970471 | -122.439695114779 | (37.7994905970471, -122.439695114779) | ||
| 7596 | 7596 | 21601 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005314.151000001 | 2114757.5524 | 37.7870214478079 | -122.42539993758999 | (37.7870214478079, -122.42539993759) | |||
| 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) | |||
| 7714 | 7714 | 14450 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 5998930.2641 | 2112586.1918 | 37.7806967093816 | -122.44733032611299 | (37.7806967093816, -122.447330326113) | |||
| 7721 | 7721 | 13116 | Permitted Site 1 | Tristania conferta :: 79 | 1627 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 20 | 3x3 | 6004563.6038 | 2119765.555 | 37.8007297168722 | -122.42835373390601 | (37.8007297168722, -122.428353733906) | ||
| 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) | |||
| 7818 | 7818 | 6321 | DPW Maintained 3 | Tristania conferta :: 79 | 1862 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6001938.3263 | 2112944.9189 | 37.781853110577 | -122.43694969789301 | (37.781853110577, -122.436949697893) | |||
| 7828 | 7828 | 14470 | DPW Maintained 3 | Tristania conferta :: 79 | 223 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/1994 12:00:00 AM | 70 | 3X3 | 5998913.5122 | 2112227.1262 | 37.77970985099329 | -122.447362427254 | (37.7797098509933, -122.447362427254) | ||
| 7874 | 7874 | 26540 | DPW Maintained 3 | Tristania conferta :: 79 | 530 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6008777.828 | 2121123.8926 | 37.8046969326474 | -122.413866861434 | (37.8046969326474, -122.413866861434) | |||
| 7899 | 7899 | 101329 | Undocumented 2 | Tristania conferta :: 79 | 2703 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997904.4066 | 2111642.2894 | 37.7780463265361 | -122.45081116588301 | (37.7780463265361, -122.450811165883) | |||
| 7923 | 7923 | 12350 | DPW Maintained 3 | Tristania conferta :: 79 | 1280 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1997 12:00:00 AM | 3 | 4x4 | 6004697.5402 | 2113177.8166 | 37.782649030091704 | -122.42742069293699 | (37.7826490300917, -122.427420692937) | ||
| 7966 | 7966 | 100969 | Undocumented 2 | Tristania conferta :: 79 | 418 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6007656.9693 | 2112859.914 | 37.7819430807706 | -122.417159773401 | (37.7819430807706, -122.417159773401) | |||
| 7978 | 7978 | 18236 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/27/2007 12:00:00 AM | 3 | 4X4 | 6003740.4545 | 2114242.5919999997 | 37.7855184591156 | -122.43080780955201 | (37.7855184591156, -122.430807809552) | ||
| 8060 | 8060 | 6320 | DPW Maintained 3 | Tristania conferta :: 79 | 1862 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6001964.3848 | 2112948.6415 | 37.78186481295621 | -122.436859814321 | (37.7818648129562, -122.436859814321) | |||
| 8081 | 8081 | 4614 | Permitted Site 1 | Tristania conferta :: 79 | 347 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/1991 12:00:00 AM | 30 | 3x3 | 6010525.6854 | 2118803.2675 | 37.7984230708943 | -122.407654474652 | (37.7984230708943, -122.407654474652) | ||
| 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) | ||
| 8135 | 8135 | 26165 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 10 | 3x3 | 6003705.1408 | 2119642.0239 | 37.800341918970396 | -122.431315547527 | (37.8003419189704, -122.431315547527) | ||
| 8162 | 8162 | 13268 | Permitted Site 1 | Tristania conferta :: 79 | 2467 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2002 12:00:00 AM | 3 | 3X3 | 6000591.5664 | 2119207.4707 | 37.7989718069145 | -122.442058509671 | (37.7989718069145, -122.442058509671) | ||
| 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) | |||
| 8199 | 8199 | 7101 | DPW Maintained 3 | Tristania conferta :: 79 | 2070 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1994 12:00:00 AM | 6 | 4X4 | 5997541.7411 | 2109558.8408 | 37.7723049499053 | -122.451915402773 | (37.7723049499053, -122.451915402773) | ||
| 8200 | 8200 | 17682 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/20/1992 12:00:00 AM | 12 | 4X4 | 6002406.1709 | 2112191.9515 | 37.7798122317892 | -122.43527729963002 | (37.7798122317892, -122.43527729963) | ||
| 8284 | 8284 | 7069 | DPW Maintained 3 | Tristania conferta :: 79 | 1620 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999644.1221 | 2109852.7822 | 37.7732322313227 | -122.44466423249399 | (37.7732322313227, -122.444664232494) | |||
| 8384 | 8384 | 13148 | Permitted Site 1 | Tristania conferta :: 79 | 1839 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 18 | 3X3 | 6003562.8454 | 2119623.2596 | 37.8002823318939 | -122.431806605227 | (37.8002823318939, -122.431806605227) | ||
| 8397 | 8397 | 13233 | DPW Maintained 3 | Tristania conferta :: 79 | 2301X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001245.6832 | 2119299.2908 | 37.7992611751931 | -122.439801639901 | (37.7992611751931, -122.439801639901) | |||
| 8401 | 8401 | 24417 | Permitted Site 1 | Tristania conferta :: 79 | 1615 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3x3 | 6005329.2314 | 2115203.2857 | 37.788246172329 | -122.42537949452299 | (37.788246172329, -122.425379494523) | ||
| 8409 | 8409 | 14468 | DPW Maintained 3 | Tristania conferta :: 79 | 211 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 2X3 | 5998906.7438 | 2112277.8895 | 37.779848847108795 | -122.447389496791 | (37.7798488471088, -122.447389496791) | |||
| 8442 | 8442 | 6187 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005423.3129 | 2113433.3911 | 37.783391795987 | -122.424928016493 | (37.783391795987, -122.424928016493) | |||
| 8445 | 8445 | 5893 | DPW Maintained 3 | Tristania conferta :: 79 | 1136 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/15/1998 12:00:00 AM | 3 | 3X3 | 6004974.4162 | 2113025.1532 | 37.7822455097776 | -122.42645194629401 | (37.7822455097776, -122.426451946294) | ||
| 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) | |||
| 8453 | 8453 | 6306 | DPW Maintained 3 | Tristania conferta :: 79 | 1804 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6002160.6694 | 2112978.761 | 37.7819586673159 | -122.436182917866 | (37.7819586673159, -122.436182917866) | |||
| 8455 | 8455 | 13169 | DPW Maintained 3 | Tristania conferta :: 79 | 1929 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6003141.2876 | 2119559.1387 | 37.8000823670196 | -122.433260775641 | (37.8000823670196, -122.433260775641) | ||
| 8463 | 8463 | 13221 | Permitted Site 1 | Tristania conferta :: 79 | 2240 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/14/1997 12:00:00 AM | 12 | 3X3 | 6001619.3007 | 2119428.9852 | 37.799638541433794 | -122.438518094144 | (37.7996385414338, -122.438518094144) | ||
| 8481 | 8481 | 5881 | Permitted Site 1 | Tristania conferta :: 79 | 1106 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005104.874 | 2113043.8892 | 37.7823043280422 | -122.426001954403 | (37.7823043280422, -122.426001954403) | ||
| 8483 | 8483 | 21607 | DPW Maintained 3 | Tristania conferta :: 79 | 1525 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6005102.2438 | 2114726.9152 | 37.7869253509843 | -122.426130907603 | (37.7869253509843, -122.426130907603) | |||
| 8487 | 8487 | 5215 | DPW Maintained 3 | Tristania conferta :: 79 | 846 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/1990 12:00:00 AM | 18 | 3X3 | 6001547.7869 | 2111374.9525 | 37.7775201753497 | -122.43818827840599 | (37.7775201753497, -122.438188278406) | ||
| 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) | ||
| 8554 | 8554 | 13141 | DPW Maintained 3 | Tristania conferta :: 79 | 1790 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003874.0187 | 2119744.4452 | 37.8006327105148 | -122.430738476202 | (37.8006327105148, -122.430738476202) | |||
| 8597 | 8597 | 7014 | Permitted Site 1 | Tristania conferta :: 79 | 1050 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2008 12:00:00 AM | 3 | 3X3 | 6002429.2937 | 2110241.5336 | 37.774458185014296 | -122.43505777310101 | (37.7744581850143, -122.435057773101) | ||
| 8600 | 8600 | 12267 | DPW Maintained 3 | Tristania conferta :: 79 | 649 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2005 12:00:00 AM | 3 | 3X3 | 6004918.0391 | 2111202.3941 | 37.7772374748382 | -122.42651715535101 | (37.7772374748382, -122.426517155351) | ||
| 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) | |||
| 8695 | 8695 | 6189 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005309.0043 | 2113417.5143 | 37.7833417448711 | -122.425322349467 | (37.7833417448711, -122.425322349467) | |||
| 8724 | 8724 | 5903 | DPW Maintained 3 | Tristania conferta :: 79 | 1240 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2008 12:00:00 AM | 6 | 3X3 | 6004495.1999 | 2112958.3268 | 37.7820349196083 | -122.42810505731 | (37.7820349196083, -122.42810505731) | ||
| 8741 | 8741 | 55480 | Permitted Site 1 | Tristania conferta :: 79 | 501 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/1972 12:00:00 AM | 17 | 8x6 | Permit Number 11433 | 6002131.5729 | 2110303.9871 | 37.7746127570805 | -122.436092114636 | (37.7746127570805, -122.436092114636) | |
| 8752 | 8752 | 14467 | DPW Maintained 3 | Tristania conferta :: 79 | 211 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 2X3 | 5998904.0364 | 2112297.518 | 37.7799025871774 | -122.447400276043 | (37.7799025871774, -122.447400276043) | |||
| 8764 | 8764 | 6196 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005120.1943 | 2113340.5958 | 37.7831198768419 | -122.42597008062401 | (37.7831198768419, -122.425970080624) | |||
| 8775 | 8775 | 9640 | Permitted Site 1 | Tristania conferta :: 79 | 1475 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/13/2002 12:00:00 AM | 3 | 3X3 | 6002575.9976 | 2111942.0905 | 37.779135818895 | -122.434671923313 | (37.779135818895, -122.434671923313) | ||
| 8781 | 8781 | 5985 | Permitted Site 1 | Tristania conferta :: 79 | 1632 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1997 12:00:00 AM | 12 | 4X4 | 6002675.1551 | 2112702.5242 | 37.7812294076413 | -122.434383280063 | (37.7812294076413, -122.434383280063) | ||
| 8785 | 8785 | 13129 | Permitted Site 1 | Tristania conferta :: 79 | 1721 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6004129.6812 | 2119699.0984 | 37.800522681160494 | -122.42985054289801 | (37.8005226811605, -122.429850542898) | |||
| 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) | ||
| 8818 | 8818 | 6201 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005283.7179 | 2113361.2024 | 37.783185697693604 | -122.42540582178002 | (37.7831856976936, -122.42540582178) | |||
| 8825 | 8825 | 9639 | DPW Maintained 3 | Tristania conferta :: 79 | 1475 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002557.0459 | 2111940.0599 | 37.779129167459004 | -122.434737339662 | (37.779129167459, -122.434737339662) | |||
| 8831 | 8831 | 9560 | Permitted Site 1 | Tristania conferta :: 79 | 1201 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/1991 12:00:00 AM | 12 | 3x3 | 6003719.6013 | 2112101.1806 | 37.77963749747521 | -122.430727087996 | (37.7796374974752, -122.430727087996) | ||
| 8882 | 8882 | 99306 | Permitted Site 1 | Tristania conferta :: 79 | 1345 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/2012 12:00:00 AM | 3x3 | Permit Number 768843 | 6003605.0174 | 2112439.8748 | 37.780560974986 | -122.43114766452 | (37.780560974986, -122.43114766452) | ||
| 8907 | 8907 | 17685 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002392.8724 | 2112252.5847 | 37.779977960097 | -122.43532764329201 | (37.779977960097, -122.435327643292) | |||
| 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) | |||
| 8926 | 8926 | 6195 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005185.2786 | 2113401.5799 | 37.7832910021365 | -122.425749257253 | (37.7832910021365, -122.425749257253) | |||
| 8929 | 8929 | 5882 | DPW Maintained 3 | Tristania conferta :: 79 | 1112 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005074.3413 | 2113041.8074 | 37.782296886294496 | -122.42610743581699 | (37.7822968862945, -122.426107435817) | ||
| 8947 | 8947 | 5892 | DPW Maintained 3 | Tristania conferta :: 79 | 1130 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6004999.3975 | 2113030.0107 | 37.7822602594178 | -122.426365868057 | (37.7822602594178, -122.426365868057) | ||
| 8959 | 8959 | 13279 | DPW Maintained 3 | Tristania conferta :: 79 | 2525 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2008 12:00:00 AM | 6 | 3X3 | 6000265.7268 | 2119165.2172 | 37.7988372159853 | -122.44318298328501 | (37.7988372159853, -122.443182983285) | ||
| 9005 | 9005 | 7012 | Permitted Site 1 | Tristania conferta :: 79 | 1030 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6002476.0968 | 2110247.1221 | 37.774476187107 | -122.43489627219601 | (37.774476187107, -122.434896272196) | ||
| 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) | ||
| 9049 | 9049 | 26865 | Permitted Site 1 | Tristania conferta :: 79 | 639 Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004491.8585 | 2110789.0984 | 37.7760785645134 | -122.427961992802 | (37.7760785645134, -122.427961992802) | |||
| 9084 | 9084 | 7073 | Permitted Site 1 | Tristania conferta :: 79 | 1664 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5999470.1137 | 2109827.3502 | 37.773152470395296 | -122.44526431981701 | (37.7731524703953, -122.445264319817) | |||
| 9096 | 9096 | 24422 | Permitted Site 1 | Tristania conferta :: 79 | 1709 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 17 | 3X3 | 6005271.4523 | 2115623.5999 | 37.789396985458104 | -122.42560932697799 | (37.7893969854581, -122.425609326978) | ||
| 9169 | 9169 | 7068 | Permitted Site 1 | Tristania conferta :: 79 | 1600 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3X3 | 5999680.2623 | 2109860.1441 | 37.7732545074631 | -122.444539748344 | (37.7732545074631, -122.444539748344) | |||
| 9173 | 9173 | 21676 | Permitted Site 1 | Tristania conferta :: 79 | 1788 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004058.6995 | 2114630.6202 | 37.7866019128099 | -122.42973446123199 | (37.7866019128099, -122.429734461232) | |||
| 9229 | 9229 | 10682 | Permitted Site 1 | Tristania conferta :: 79 | 1145 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002385.9834 | 2110534.2276 | 37.7752593905207 | -122.43522853143 | (37.7752593905207, -122.43522853143) | |||
| 9292 | 9292 | 18027 | Permitted Site 1 | Tristania conferta :: 79 | 2770 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/03/2011 12:00:00 AM | 4 | 3x3 | 6000645.3835 | 2114854.2782 | 37.7870221472222 | -122.441559726807 | (37.7870221472222, -122.441559726807) | ||
| 9376 | 9376 | 14452 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 80 | 3x3 | 5998927.5567 | 2112628.8329 | 37.7808136360807 | -122.44734276226002 | (37.7808136360807, -122.44734276226) | |||
| 9426 | 9426 | 14444 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5998945.1546 | 2112453.5304 | 37.7803333064109 | -122.447269262196 | (37.7803333064109, -122.447269262196) | |||
| 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) | ||
| 9466 | 9466 | 14453 | Permitted Site 1 | Tristania conferta :: 79 | 100 Masonic Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 5998924.1725 | 2112667.0746 | 37.7809184444903 | -122.447357223078 | (37.7809184444903, -122.447357223078) | |||
| 9485 | 9485 | 24424 | Permitted Site 1 | Tristania conferta :: 79 | 1705 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005279.8538 | 2115571.2522 | 37.7892537264959 | -122.42557653158 | (37.7892537264959, -122.42557653158) | ||
| 9532 | 9532 | 2443 | DPW Maintained 3 | Tristania conferta :: 79 | 1296X Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/22/1990 12:00:00 AM | 12 | 3X3 | 6004305.6638 | 2112931.8799 | 37.7819515776166 | -122.42875887985501 | (37.7819515776166, -122.428758879855) | ||
| 9586 | 9586 | 115011 | Undocumented 2 | Tristania conferta :: 79 | 1600 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6001663.1427 | 2114000.6718 | 37.784736294492795 | -122.437977348952 | (37.7847362944928, -122.437977348952) | |||
| 9607 | 9607 | 6248 | DPW Maintained 3 | Tristania conferta :: 79 | 1310X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004578.6077 | 2113315.336 | 37.783019896919605 | -122.427841950596 | (37.7830198969196, -122.427841950596) | |||
| 9620 | 9620 | 12359 | DPW Maintained 3 | Tristania conferta :: 79 | 1295X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X6 | 6004744.0331 | 2113287.4568 | 37.7829527043097 | -122.427267659807 | (37.7829527043097, -122.427267659807) | |||
| 9849 | 9849 | 106206 | DPW Maintained 3 | Tristania conferta :: 79 | 1600X Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 5x5 | 6003113.3747 | 2114020.7176 | 37.784873699559 | -122.432961462333 | (37.784873699559, -122.432961462333) | |||
| 10218 | 10218 | 16871 | DPW Maintained 3 | Tristania conferta :: 79 | 254 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6005762.2091 | 2110361.0964 | 37.7749751613383 | -122.42353707049601 | (37.7749751613383, -122.423537070496) | ||
| 10436 | 10436 | 115660 | DPW Maintained 3 | Tristania conferta :: 79 | 2574 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 6x10 | 5987719.8552 | 2097767.8758 | 37.739362692059295 | -122.48502454471901 | (37.7393626920593, -122.485024544719) | |||
| 13376 | 13376 | 22408 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53653 | 6013764.0013 | 2092044.0283 | 37.7251288035961 | -122.394574017561 | (37.7251288035961, -122.394574017561) | |
| 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) | ||
| 13485 | 13485 | 22331 | Permitted Site 1 | Tristania conferta :: 79 | 5172 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1995 12:00:00 AM | 6 | 3X3 | 6014515.3867 | 2094222.6833 | 37.731152696117704 | -122.392128829508 | (37.7311526961177, -122.392128829508) | ||
| 13492 | 13492 | 29408 | Permitted Site 1 | Tristania conferta :: 79 | 2715X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014970.0169 | 2090872.4668 | 37.7219789022018 | -122.39032309567 | (37.7219789022018, -122.39032309567) | ||
| 13494 | 13494 | 22395 | DPW Maintained 3 | Tristania conferta :: 79 | 5700 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/31/2011 12:00:00 AM | 6 | 3x3 | 6013894.8509 | 2092365.7305 | 37.726019406734295 | -122.394144192498 | (37.7260194067343, -122.394144192498) | ||
| 13508 | 13508 | 29427 | DPW Maintained 3 | Tristania conferta :: 79 | 2501X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015373.5361 | 2091407.2745 | 37.7234697537221 | -122.38896553930401 | (37.7234697537221, -122.388965539304) | ||
| 13516 | 13516 | 22409 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53653 | 6013757.7359 | 2092026.1961 | 37.7250794916417 | -122.394594428416 | (37.7250794916417, -122.394594428416) | |
| 13531 | 13531 | 29526 | DPW Maintained 3 | Tristania conferta :: 79 | 2200X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 4 | 2X3 | 6015798.6366 | 2092060.1318 | 37.725285925529 | -122.387541555629 | (37.725285925529, -122.387541555629) | ||
| 13552 | 13552 | 29439 | DPW Maintained 3 | Tristania conferta :: 79 | 2303X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6015640.8979 | 2091772.6846 | 37.7244879141293 | -122.38806679762199 | (37.7244879141293, -122.388066797622) | ||
| 13571 | 13571 | 29433 | DPW Maintained 3 | Tristania conferta :: 79 | 2401X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2011 12:00:00 AM | 3 | 3x3 | 6015500.9632 | 2091579.7516 | 37.7239504043026 | -122.388537076537 | (37.7239504043026, -122.388537076537) |
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");