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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||
| 5506 | 5506 | 24257 | Permitted Site 1 | Tristania conferta :: 79 | 600X Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/19/2004 12:00:00 AM | 5 | 3X3 | 6004635.8921 | 2113135.7984 | 37.782530171668 | -122.427630974469 | (37.782530171668, -122.427630974469) | ||
| 5517 | 5517 | 10700 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001738.9392 | 2110489.0192 | 37.775098494652795 | -122.437463562764 | (37.7750984946528, -122.437463562764) | |||
| 5527 | 5527 | 23775 | DPW Maintained 3 | Tristania conferta :: 79 | 1000 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 8 | 3X3 | 6003905.7295 | 2112204.2911 | 37.7799311566149 | -122.43009054793801 | (37.7799311566149, -122.430090547938) | ||
| 5606 | 5606 | 7095 | Permitted Site 1 | Tristania conferta :: 79 | 1970 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1994 12:00:00 AM | 18 | 3X3 | 5998027.6156 | 2109626.606 | 37.772518832985504 | -122.45023961224 | (37.7725188329855, -122.45023961224) | ||
| 5607 | 5607 | 6200 | DPW Maintained 3 | Tristania conferta :: 79 | 1135 Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005257.1287 | 2113359.2082 | 37.783178719822295 | -122.42549766781099 | (37.7831787198223, -122.425497667811) | |||
| 5631 | 5631 | 5897 | Permitted Site 1 | Tristania conferta :: 79 | 1168 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6004857.8368 | 2113009.1929 | 37.782195095891396 | -122.42685412216001 | (37.7821950958914, -122.42685412216) | ||
| 5639 | 5639 | 12273 | Permitted Site 1 | Tristania conferta :: 79 | 721 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/1991 12:00:00 AM | 12 | 3X3 | 6004895.7756 | 2111355.1796 | 37.7776557277721 | -122.426605054269 | (37.7776557277721, -122.426605054269) | ||
| 5654 | 5654 | 6078 | DPW Maintained 3 | Tristania conferta :: 79 | 1966 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001057.2451 | 2112477.7276 | 37.7805202046224 | -122.439964313123 | (37.7805202046224, -122.439964313123) | |||
| 5670 | 5670 | 10699 | DPW Maintained 3 | Tristania conferta :: 79 | 1275 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001777.3475 | 2110450.1636 | 37.774993990438205 | -122.43732791737 | (37.7749939904382, -122.43732791737) | |||
| 5716 | 5716 | 7070 | Permitted Site 1 | Tristania conferta :: 79 | 1634 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999592.5889 | 2109848.7666 | 37.7732182646887 | -122.4448422034 | (37.7732182646887, -122.4448422034) | |||
| 5743 | 5743 | 12280 | Permitted Site 1 | Tristania conferta :: 79 | 741 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1997 12:00:00 AM | 3 | 3X3 | 6004879.1558 | 2111501.6218 | 37.7780568825374 | -122.42667297875201 | (37.7780568825374, -122.426672978752) | ||
| 5826 | 5826 | 7045 | Permitted Site 1 | Tristania conferta :: 79 | 1300 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/21/2010 12:00:00 AM | 12 | 3X3 | 6001075.5825 | 2110054.6953 | 37.7738682146278 | -122.43972710968599 | (37.7738682146278, -122.439727109686) | ||
| 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) | ||
| 5872 | 5872 | 24489 | Permitted Site 1 | Tristania conferta :: 79 | 840 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2006 12:00:00 AM | 3 | 3X3 | 6003385.8226 | 2110373.2704 | 37.774874168918 | -122.43175836681499 | (37.774874168918, -122.431758366815) | ||
| 5898 | 5898 | 14455 | DPW Maintained 3 | Tristania conferta :: 79 | 125 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998862.4105 | 2112574.347 | 37.780660309110296 | -122.447564210548 | (37.7806603091103, -122.447564210548) | |||
| 5924 | 5924 | 13114 | Permitted Site 1 | Tristania conferta :: 79 | 1618 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/30/2005 12:00:00 AM | 12 | 3x3 | 6004576.6984 | 2119842.3294 | 37.800941260536 | -122.428313896065 | (37.800941260536, -122.428313896065) | ||
| 5930 | 5930 | 12366 | DPW Maintained 3 | Tristania conferta :: 79 | 1314X Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/1990 12:00:00 AM | 6 | 3X3 | 6004530.405 | 2113308.3501 | 37.782997988422 | -122.42800821421899 | (37.782997988422, -122.428008214219) | ||
| 5939 | 5939 | 10696 | DPW Maintained 3 | Tristania conferta :: 79 | 1257 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001848.8335 | 2110459.5307 | 37.7750237737687 | -122.43708130308998 | (37.7750237737687, -122.43708130309) | |||
| 5940 | 5940 | 6997 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002869.8876 | 2110306.5014 | 37.7746615784305 | -122.433538320063 | (37.7746615784305, -122.433538320063) | ||
| 5943 | 5943 | 9604 | Permitted Site 1 | Tristania conferta :: 79 | 1355 Golden Gate Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003125.8375 | 2112021.5623 | 37.7793852280154 | -122.432775482637 | (37.7793852280154, -122.432775482637) | |||
| 5950 | 5950 | 6955 | DPW Maintained 3 | Tristania conferta :: 79 | 612 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 12 | 3X3 | 6004444.1451 | 2110522.7405 | 37.7753445115637 | -122.428108060089 | (37.7753445115637, -122.428108060089) | ||
| 5954 | 5954 | 13262 | Permitted Site 1 | Tristania conferta :: 79 | 2443 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6000711.0138 | 2119222.9095 | 37.799021004008104 | -122.44164629161301 | (37.7990210040081, -122.441646291613) | |||
| 5959 | 5959 | 23753 | DPW Maintained 3 | Tristania conferta :: 79 | 900X Webster St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1992 12:00:00 AM | 25 | 4x4 | 6003923.4316 | 2112087.5817 | 37.7796117041387 | -122.43002098071501 | (37.7796117041387, -122.430020980715) | ||
| 5987 | 5987 | 28074 | Permitted Site 1 | Tristania conferta :: 79 | 915 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2010 12:00:00 AM | 3 | 3X3 | 6008638.4319 | 2120527.3912 | 37.8030512599832 | -122.414307026238 | (37.8030512599832, -122.414307026238) | ||
| 6001 | 6001 | 5894 | Permitted Site 1 | Tristania conferta :: 79 | 1142 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 3 | 3X3 | 6004948.741 | 2113023.7653 | 37.7822402475105 | -122.42654067221599 | (37.7822402475105, -122.426540672216) | ||
| 6017 | 6017 | 29686 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003340.0203 | 2119674.0794 | 37.800409236193296 | -122.432581299288 | (37.8004092361933, -122.432581299288) | |||
| 6020 | 6020 | 13137 | DPW Maintained 3 | Tristania conferta :: 79 | 1769 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 12 | 3X3 | 6003915.4564 | 2119670.1702 | 37.8004311181643 | -122.430589781889 | (37.8004311181643, -122.430589781889) | ||
| 6025 | 6025 | 9561 | Permitted Site 1 | Tristania conferta :: 79 | 1201 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6003758.3426 | 2112108.0173 | 37.7796584641609 | -122.430593553118 | (37.7796584641609, -122.430593553118) | |||
| 6059 | 6059 | 10683 | Permitted Site 1 | Tristania conferta :: 79 | 1155 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002334.989 | 2110528.6392 | 37.775241150218 | -122.43540453260401 | (37.775241150218, -122.435404532604) | |||
| 6073 | 6073 | 14456 | Permitted Site 1 | Tristania conferta :: 79 | 135 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 50 | 3X3 | 5998867.4868 | 2112526.9679 | 37.7805305084906 | -122.447543237813 | (37.7805305084906, -122.447543237813) | ||
| 6095 | 6095 | 12343 | DPW Maintained 3 | Tristania conferta :: 79 | 1200 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 6 | 4X4 | 6004715.5822 | 2113048.0527 | 37.7822937509983 | -122.42734902850401 | (37.7822937509983, -122.427349028504) | ||
| 6104 | 6104 | 18099 | DPW Maintained 3 | Tristania conferta :: 79 | 3019 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999451.351 | 2114633.9478 | 37.786349077981 | -122.445674946059 | (37.786349077981, -122.445674946059) | |||
| 6125 | 6125 | 6977 | DPW Maintained 3 | Tristania conferta :: 79 | 748 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/30/1990 12:00:00 AM | 12 | 3X3 | 6003831.4789 | 2110436.0515 | 37.775071802393896 | -122.43022122824699 | (37.7750718023939, -122.430221228247) | ||
| 6139 | 6139 | 13094 | Permitted Site 1 | Tristania conferta :: 79 | 1450 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/13/1995 12:00:00 AM | 12 | 3X3 | 6005349.3555 | 2119944.5969 | 37.801265750478 | -122.425647455227 | (37.801265750478, -122.425647455227) | ||
| 6167 | 6167 | 10693 | Permitted Site 1 | Tristania conferta :: 79 | 1250 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6001870.5552 | 2110507.5567 | 37.7751568758154 | -122.43700960221001 | (37.7751568758154, -122.43700960221) | |||
| 6179 | 6179 | 9633 | DPW Maintained 3 | Tristania conferta :: 79 | 1455 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002619.654 | 2111947.8436 | 37.779154093768796 | -122.434521309627 | (37.7791540937688, -122.434521309627) | |||
| 6191 | 6191 | 13159 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003407.2588 | 2119680.3342 | 37.8004302230496 | -122.43234907433599 | (37.8004302230496, -122.432349074336) | |||
| 6193 | 6193 | 5895 | DPW Maintained 3 | Tristania conferta :: 79 | 1148 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3x3 | 6004928.6171 | 2113019.6018 | 37.7822276779046 | -122.426609995389 | (37.7822276779046, -122.426609995389) | ||
| 6225 | 6225 | 13241 | Permitted Site 1 | Tristania conferta :: 79 | 2352 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/1994 12:00:00 AM | 30 | 3X3 | 6001099.421 | 2119356.9831 | 37.7994112565419 | -122.440311896156 | (37.7994112565419, -122.440311896156) | ||
| 6253 | 6253 | 13146 | Permitted Site 1 | Tristania conferta :: 79 | 1801 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/02/1996 12:00:00 AM | 6 | 3x3 | 6003666.0486 | 2119638.1147 | 37.800328969814 | -122.43145054275101 | (37.800328969814, -122.431450542751) | ||
| 6257 | 6257 | 18235 | Permitted Site 1 | Tristania conferta :: 79 | 1790X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1999 12:00:00 AM | 3 | 4X4 | 6003758.3462 | 2114245.8879 | 37.7855285225047 | -122.430746144837 | (37.7855285225047, -122.430746144837) | ||
| 6268 | 6268 | 24416 | Permitted Site 1 | Tristania conferta :: 79 | 1625 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1995 12:00:00 AM | 18 | 3X3 | 6005321.0617 | 2115263.3908 | 37.7884107443518 | -122.425412039373 | (37.7884107443518, -122.425412039373) | ||
| 6333 | 6333 | 6317 | DPW Maintained 3 | Tristania conferta :: 79 | 1830 Ellis St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6002046.2828 | 2112962.5168 | 37.781907565329206 | -122.436577479183 | (37.7819075653292, -122.436577479183) | |||
| 6344 | 6344 | 13283 | Permitted Site 1 | Tristania conferta :: 79 | 2539 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000208.0345 | 2119155.4664 | 37.7988071530908 | -122.44338191608999 | (37.7988071530908, -122.44338191609) | |||
| 6345 | 6345 | 13106 | Permitted Site 1 | Tristania conferta :: 79 | 1557 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1993 12:00:00 AM | 40 | 3x3 | 6004949.0522 | 2119813.2474 | 37.8008824710059 | -122.427023320732 | (37.8008824710059, -122.427023320732) | ||
| 6411 | 6411 | 10687 | Permitted Site 1 | Tristania conferta :: 79 | 1185 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002205.7566 | 2110510.4768 | 37.775183940568496 | -122.435850276383 | (37.7751839405685, -122.435850276383) | |||
| 6425 | 6425 | 17834 | DPW Maintained 3 | Tristania conferta :: 79 | 2005 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2007 12:00:00 AM | 6 | 3X3 | 6004202.6696 | 2115296.0495 | 37.7884371655847 | -122.429283827501 | (37.7884371655847, -122.429283827501) | ||
| 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) | ||
| 6471 | 6471 | 14471 | DPW Maintained 3 | Tristania conferta :: 79 | 227 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5998914.8659 | 2112201.4062 | 37.77963930788229 | -122.447355892513 | (37.7796393078823, -122.447355892513) | |||
| 6482 | 6482 | 6194 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005201.2129999995 | 2113404.3918 | 37.7832996233389 | -122.42569433072799 | (37.7832996233389, -122.425694330728) | |||
| 6500 | 6500 | 7087 | Permitted Site 1 | Tristania conferta :: 79 | 1854 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 5998578.5677 | 2109701.858 | 37.7727569698827 | -122.44833924164101 | (37.7727569698827, -122.448339241641) | ||
| 6506 | 6506 | 9520 | Permitted Site 1 | Tristania conferta :: 79 | 1046 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6004532.0878 | 2112270.4724 | 37.780148328739706 | -122.42792841204799 | (37.7801483287397, -122.427928412048) | ||
| 6525 | 6525 | 6233 | DPW Maintained 3 | Tristania conferta :: 79 | 1250 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/1997 12:00:00 AM | 6 | 3X3 | 6004966.7765 | 2113370.4911 | 37.783193290288 | -122.42650297364901 | (37.783193290288, -122.426502973649) | ||
| 6548 | 6548 | 12281 | Permitted Site 1 | Tristania conferta :: 79 | 739 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6004881.0373 | 2111477.1625 | 37.777989829673096 | -122.426664727755 | (37.7779898296731, -122.426664727755) | |||
| 6570 | 6570 | 5899 | DPW Maintained 3 | Tristania conferta :: 79 | 1180 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6004803.0167 | 2113001.5597 | 37.7821710372677 | -122.42704323134701 | (37.7821710372677, -122.427043231347) | ||
| 6587 | 6587 | 5904 | DPW Maintained 3 | Tristania conferta :: 79 | 1256 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6004447.9733 | 2112952.6596 | 37.782016686789 | -122.428268035802 | (37.782016686789, -122.428268035802) | ||
| 6590 | 6590 | 21597 | DPW Maintained 3 | Tristania conferta :: 79 | 1515 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6005206.9209 | 2114744.2763 | 37.7869789360246 | -122.42576998467301 | (37.7869789360246, -122.425769984673) | |||
| 6593 | 6593 | 7059 | DPW Maintained 3 | Tristania conferta :: 79 | 1516 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/30/2011 12:00:00 AM | 3 | 3x3 | 6000148.3323 | 2109926.5898 | 37.773463647588 | -122.44292540854099 | (37.773463647588, -122.442925408541) | ||
| 6605 | 6605 | 9632 | DPW Maintained 3 | Tristania conferta :: 79 | 1455 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002597.6566 | 2111945.8131 | 37.7791472697919 | -122.434597262323 | (37.7791472697919, -122.434597262323) | |||
| 6633 | 6633 | 17842 | DPW Maintained 3 | Tristania conferta :: 79 | 2031 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004091.8528 | 2115280.5278 | 37.7883882726819 | -122.42966612859699 | (37.7883882726819, -122.429666128597) | |||
| 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) | ||
| 6679 | 6679 | 13098 | Permitted Site 1 | Tristania conferta :: 79 | 1488 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/1997 12:00:00 AM | 30 | 3X3 | 6005248.4978 | 2119934.433 | 37.8012321434749 | -122.42599574351499 | (37.8012321434749, -122.425995743515) | ||
| 6685 | 6685 | 6188 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005406.4851 | 2113431.574 | 37.783385856152 | -122.42498610479299 | (37.783385856152, -122.424986104793) | |||
| 6702 | 6702 | 10686 | DPW Maintained 3 | Tristania conferta :: 79 | 1179 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002229.5074 | 2110511.8739 | 37.775189125797205 | -122.435768217131 | (37.7751891257972, -122.435768217131) | |||
| 6706 | 6706 | 21600 | Permitted Site 1 | Tristania conferta :: 79 | 1515 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6005281.4713 | 2114753.9781 | 37.7870097872628 | -122.42551274764999 | (37.7870097872628, -122.42551274765) | |||
| 6717 | 6717 | 6998 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002824.6489 | 2110299.3044 | 37.774639250423604 | -122.43369429514999 | (37.7746392504236, -122.43369429515) | ||
| 6733 | 6733 | 12339 | DPW Maintained 3 | Tristania conferta :: 79 | 1199 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/1999 12:00:00 AM | 12 | 3X3 | 6004687.2548 | 2112907.9517 | 37.7819074662565 | -122.42743704493999 | (37.7819074662565, -122.42743704494) | ||
| 6776 | 6776 | 14454 | DPW Maintained 3 | Tristania conferta :: 79 | 109 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1994 12:00:00 AM | 60 | 3X3 | 5998851.581 | 2112620.0339 | 37.7807851345871 | -122.447604964541 | (37.7807851345871, -122.447604964541) | ||
| 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) | ||
| 6826 | 6826 | 13243 | Permitted Site 1 | Tristania conferta :: 79 | 2353 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001148.9876 | 2119284.6646 | 37.799215511035705 | -122.440135189953 | (37.7992155110357, -122.440135189953) | |||
| 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) | |||
| 6856 | 6856 | 26449 | DPW Maintained 3 | Tristania conferta :: 79 | 1096 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2004 12:00:00 AM | 3 | 3X3 | 6005161.0819 | 2113052.9102 | 37.7823322739768 | -122.425808142175 | (37.7823322739768, -122.425808142175) | ||
| 6862 | 6862 | 23930 | Permitted Site 1 | Tristania conferta :: 79 | 1715 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003466.7876 | 2114641.1577 | 37.786597310936706 | -122.431783083706 | (37.7865973109367, -122.431783083706) | |||
| 6863 | 6863 | 10685 | Permitted Site 1 | Tristania conferta :: 79 | 1167 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002283.296 | 2110520.9551 | 37.7752171157043 | -122.435582800345 | (37.7752171157043, -122.435582800345) | |||
| 6887 | 6887 | 13251 | Permitted Site 1 | Tristania conferta :: 79 | 2395 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000984.848999999 | 2119261.9127 | 37.7991436944439 | -122.44070153167699 | (37.7991436944439, -122.440701531677) | |||
| 6900 | 6900 | 13253 | Permitted Site 1 | Tristania conferta :: 79 | 2400 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6000858.2681 | 2119325.515 | 37.7993111202698 | -122.44114410922899 | (37.7993111202698, -122.441144109229) | |||
| 6937 | 6937 | 13290 | DPW Maintained 3 | Tristania conferta :: 79 | 2665 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1997 12:00:00 AM | 6 | 3X3 | 5999641.675 | 2119108.3375 | 37.7986454362464 | -122.445338306635 | (37.7986454362464, -122.445338306635) | ||
| 6946 | 6946 | 18103 | DPW Maintained 3 | Tristania conferta :: 79 | 3042 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999290.1369 | 2114664.7113 | 37.7864243409392 | -122.446234917327 | (37.7864243409392, -122.446234917327) | |||
| 6977 | 6977 | 17681 | DPW Maintained 3 | Tristania conferta :: 79 | 1090 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/1990 12:00:00 AM | 12 | 4X4 | 6002407.8372 | 2112172.5118 | 37.779758949887096 | -122.43527014428601 | (37.7797589498871, -122.435270144286) | ||
| 6979 | 6979 | 6191 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005268.6997 | 2113412.8277 | 37.7833265994852 | -122.42546145392201 | (37.7833265994852, -122.425461453922) | |||
| 6988 | 6988 | 7064 | Permitted Site 1 | Tristania conferta :: 79 | 1564 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999951.2096 | 2109897.9532 | 37.7733737782492 | -122.44360522471099 | (37.7733737782492, -122.443605224711) | |||
| 6992 | 6992 | 7000 | DPW Maintained 3 | Tristania conferta :: 79 | 950X Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1992 12:00:00 AM | 12 | 3X3 | 6002725.4323 | 2110284.3962 | 37.77459268596171 | -122.434036438862 | (37.7745926859617, -122.434036438862) | ||
| 7068 | 7068 | 6193 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005219.9593 | 2113402.5172 | 37.783295535433204 | -122.425629342465 | (37.7832955354332, -122.425629342465) | |||
| 7083 | 7083 | 1667 | Permitted Site 1 | Tristania conferta :: 79 | 1400X Fell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/09/2006 12:00:00 AM | 3 | 3X3 | 6000310.2061 | 2109949.902 | 37.773536884549706 | -122.44236713923901 | (37.7735368845497, -122.442367139239) | ||
| 7113 | 7113 | 29685 | Permitted Site 1 | Tristania conferta :: 79 | 1880 Lombard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003360.3482 | 2119674.8613 | 37.800412535842206 | -122.43251101256 | (37.8004125358422, -122.43251101256) | |||
| 7117 | 7117 | 7106 | DPW Maintained 3 | Tristania conferta :: 79 | 2136 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997200.5381 | 2109511.6187 | 37.7721557413798 | -122.453092239143 | (37.7721557413798, -122.453092239143) | |||
| 7125 | 7125 | 18238 | DPW Maintained 3 | Tristania conferta :: 79 | 1790X Post St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/12/2000 12:00:00 AM | 3 | 4X4 | 6003705.6129 | 2114238.8254 | 37.7855061428919 | -122.430928082284 | (37.7855061428919, -122.430928082284) | ||
| 7143 | 7143 | 13163 | DPW Maintained 3 | Tristania conferta :: 79 | 1901 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003225.9808 | 2119572.2163 | 37.8001230789015 | -122.43296863968 | (37.8001230789015, -122.43296863968) | |||
| 7203 | 7203 | 8199 | DPW Maintained 3 | Tristania conferta :: 79 | 1310X Fulton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2011 12:00:00 AM | 3 | 3x3 | 6001414.7162 | 2111141.806 | 37.7768724447291 | -122.438631903562 | (37.7768724447291, -122.438631903562) | ||
| 7208 | 7208 | 5898 | Permitted Site 1 | Tristania conferta :: 79 | 1174 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 3 | 3X3 | 6004835.6312 | 2113008.499 | 37.782191935057504 | -122.42693089417101 | (37.7821919350575, -122.426930894171) | ||
| 7228 | 7228 | 13213 | Permitted Site 1 | Tristania conferta :: 79 | 2199 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001911.9905 | 2119390.9978 | 37.799550882806 | -122.437502561002 | (37.799550882806, -122.437502561002) | |||
| 7255 | 7255 | 9753 | DPW Maintained 3 | Tristania conferta :: 79 | 725 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/1990 12:00:00 AM | 16 | 4x4 | 6005752.1131 | 2112212.6104 | 37.780058398475106 | -122.423703668106 | (37.7800583984751, -122.423703668106) | ||
| 7268 | 7268 | 5883 | Permitted Site 1 | Tristania conferta :: 79 | 1118 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 6 | 3X3 | 6005049.3601 | 2113036.9499 | 37.7822821368488 | -122.426193513801 | (37.7822821368488, -122.426193513801) | ||
| 7361 | 7361 | 5891 | Permitted Site 1 | Tristania conferta :: 79 | 1124 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1992 12:00:00 AM | 12 | 3X3 | 6005026.4605 | 2113033.4803 | 37.7822713158313 | -122.426272489182 | (37.7822713158313, -122.426272489182) | ||
| 7364 | 7364 | 6192 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005245.2668 | 2113409.0784 | 37.7833149808402 | -122.425542255616 | (37.7833149808402, -122.425542255616) | |||
| 7414 | 7414 | 14484 | DPW Maintained 3 | Tristania conferta :: 79 | 281 Masonic Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 5998949.0465 | 2111993.9536 | 37.7790716497834 | -122.447222712917 | (37.7790716497834, -122.447222712917) | |||
| 7430 | 7430 | 6190 | DPW Maintained 3 | Tristania conferta :: 79 | 1100 Ellis St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005292.1326 | 2113413.765 | 37.783330497018 | -122.425380452026 | (37.783330497018, -122.425380452026) | |||
| 7450 | 7450 | 5896 | DPW Maintained 3 | Tristania conferta :: 79 | 1160 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/1998 12:00:00 AM | 3 | 3x3 | 6004888.3695 | 2113012.6625 | 37.7822063488626 | -122.426748739826 | (37.7822063488626, -122.426748739826) |
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");