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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 5258 | 5258 | 7076 | Permitted Site 1 | Tristania conferta :: 79 | 1712 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/11/2008 12:00:00 AM | 3 | 3x3 | 5999133.3592 | 2109779.0297 | 37.7730005664352 | -122.44642571608499 | (37.7730005664352, -122.446425716085) | ||
| 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) | ||
| 2847 | 2847 | 7089 | Permitted Site 1 | Tristania conferta :: 79 | 1874 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2009 12:00:00 AM | 3 | 3x3 | 5998459.5467 | 2109686.5004 | 37.7727079965007 | -122.448749840415 | (37.7727079965007, -122.448749840415) | ||
| 2968 | 2968 | 7092 | Permitted Site 1 | Tristania conferta :: 79 | 1926 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/10/2009 12:00:00 AM | 3 | 3X3 | 5998180.0393 | 2109648.8744 | 37.7725886979314 | -122.449713970747 | (37.7725886979314, -122.449713970747) | ||
| 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) | ||
| 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) | ||
| 3752 | 3752 | 7102 | DPW Maintained 3 | Tristania conferta :: 79 | 2080 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 5997497.5881 | 2109552.6978 | 37.7722855537803 | -122.45206768793001 | (37.7722855537803, -122.45206768793) | |||
| 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) | |||
| 1505 | 1505 | 8187 | DPW Maintained 3 | Tristania conferta :: 79 | 1255 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001743.6158 | 2111134.8252 | 37.7768719817661 | -122.43749364217301 | (37.7768719817661, -122.437493642173) | |||
| 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) | ||
| 22563 | 22563 | 9064 | Permitted Site 1 | Tristania conferta :: 79 | 5530 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2001 12:00:00 AM | 3 | 3X3 | 5989802.812000001 | 2112705.6659 | 37.7804989633648 | -122.478914967756 | (37.7804989633648, -122.478914967756) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 5416 | 5416 | 9589 | DPW Maintained 3 | Tristania conferta :: 79 | 1320 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/11/1997 12:00:00 AM | 6 | 3X3 | 6003248.1509 | 2112093.2525 | 37.779589007656604 | -122.432357471075 | (37.7795890076566, -122.432357471075) | ||
| 23346 | 23346 | 9596 | DPW Maintained 3 | Tristania conferta :: 79 | 1340 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 11 | 3X3 | 6003149.1044 | 2112077.4625 | 37.7795400355594 | -122.432698986969 | (37.7795400355594, -122.432698986969) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 20341 | 20341 | 9651 | DPW Maintained 3 | Tristania conferta :: 79 | 75 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/21/2012 12:00:00 AM | 3 | 3x3 | 6006082.2488 | 2109830.2127 | 37.7735355417257 | -122.422392253849 | (37.7735355417257, -122.422392253849) | ||
| 19870 | 19870 | 9653 | DPW Maintained 3 | Tristania conferta :: 79 | 95 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3x3 | 6006060.8562 | 2109963.4178 | 37.773900084076296 | -122.42247572098499 | (37.7739000840763, -122.422475720985) | ||
| 19294 | 19294 | 9654 | DPW Maintained 3 | Tristania conferta :: 79 | 95 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 3 | 3X3 | 6006063.7461 | 2109945.4115 | 37.7738508061395 | -122.422464444627 | (37.7738508061395, -122.422464444627) | ||
| 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) | ||
| 19569 | 19569 | 9656 | DPW Maintained 3 | Tristania conferta :: 79 | 95 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006068.1921 | 2109906.7312 | 37.773744850157 | -122.422446316196 | (37.773744850157, -122.422446316196) | ||
| 18047 | 18047 | 9657 | DPW Maintained 3 | Tristania conferta :: 79 | 95 Gough St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006069.5259 | 2109884.9457 | 37.7736851076601 | -122.422440154098 | (37.7736851076601, -122.422440154098) | ||
| 20191 | 20191 | 9663 | DPW Maintained 3 | Tristania conferta :: 79 | 115 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006029.8522 | 2110171.1235 | 37.774468644794204 | -122.42259773170099 | (37.7744686447942, -122.422597731701) | ||
| 17108 | 17108 | 9664 | DPW Maintained 3 | Tristania conferta :: 79 | 115 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006036.6387 | 2110130.4049 | 37.7743572242045 | -122.422571361821 | (37.7743572242045, -122.422571361821) | ||
| 18144 | 18144 | 9669 | DPW Maintained 3 | Tristania conferta :: 79 | 203 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/07/1995 12:00:00 AM | 18 | 3X3 | 6006010.5370000005 | 2110311.0286 | 37.7748517007261 | -122.42267449094999 | (37.7748517007261, -122.42267449095) | ||
| 17489 | 17489 | 9671 | Permitted Site 1 | Tristania conferta :: 79 | 207 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/07/1995 12:00:00 AM | 24 | 3X3 | 6005999.0821 | 2110438.7223 | 37.77520167050999 | -122.422723192397 | (37.77520167051, -122.422723192397) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | ||
| 20140 | 20140 | 10246 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | |||
| 20257 | 20257 | 10302 | DPW Maintained 3 | Tristania conferta :: 79 | 596 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/1997 12:00:00 AM | 20 | 3X3 | 6003330.7652 | 2109326.5077 | 37.7719968952641 | -122.431874063617 | (37.7719968952641, -122.431874063617) | ||
| 21406 | 21406 | 10305 | DPW Maintained 3 | Tristania conferta :: 79 | 614 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/1999 12:00:00 AM | 25 | 3x3 | 6003095.7029 | 2109294.636 | 37.7718960552644 | -122.432684884303 | (37.7718960552644, -122.432684884303) | ||
| 19372 | 19372 | 10310 | Permitted Site 1 | Tristania conferta :: 79 | 630 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2004 12:00:00 AM | 8 | 6002998.1704 | 2109278.2038 | 37.771845404706504 | -122.433021081698 | (37.7718454047065, -122.433021081698) | |||
| 17246 | 17246 | 10340 | DPW Maintained 3 | Tristania conferta :: 79 | 914 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X4 | 6001716.4806 | 2109101.7503 | 37.7712881236094 | -122.437441889428 | (37.7712881236094, -122.437441889428) | |||
| 20328 | 20328 | 10344 | DPW Maintained 3 | Tristania conferta :: 79 | 946 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6001573.5571 | 2109081.4751 | 37.7712243264402 | -122.43793481453899 | (37.7712243264402, -122.437934814539) | |||
| 17853 | 17853 | 10365 | DPW Maintained 3 | Tristania conferta :: 79 | 1158 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/01/2001 12:00:00 AM | 20 | 3X3 | 6000552.7964 | 2108940.2901 | 37.7707785679811 | -122.44145552457199 | (37.7707785679811, -122.441455524572) | ||
| 18847 | 18847 | 10366 | Permitted Site 1 | Tristania conferta :: 79 | 1166 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3X4 | 6000501.5622 | 2108932.6998 | 37.7707548079908 | -122.441632199385 | (37.7707548079908, -122.441632199385) | |||
| 19252 | 19252 | 10388 | DPW Maintained 3 | Tristania conferta :: 79 | 1354 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999661.5734 | 2108814.8136 | 37.770383228179895 | -122.44452925228799 | (37.7703832281799, -122.444529252288) | ||
| 17810 | 17810 | 10406 | Permitted Site 1 | Tristania conferta :: 79 | 1386 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2007 12:00:00 AM | 3 | 3x3 | 5999529.6926 | 2108795.3635 | 37.7703222971334 | -122.444984028084 | (37.7703222971334, -122.444984028084) | ||
| 17221 | 17221 | 10407 | Permitted Site 1 | Tristania conferta :: 79 | 1392 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/01/2009 12:00:00 AM | 8 | 3x3 | 5999510.2425 | 2108793.466 | 37.7703159769785 | -122.445051169277 | (37.7703159769785, -122.445051169277) | ||
| 20800 | 20800 | 10428 | Permitted Site 1 | Tristania conferta :: 79 | 1427 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/26/2007 12:00:00 AM | 3 | 3X3 | 5999264.0192 | 2108708.6767 | 37.7700691107077 | -122.44589675291799 | (37.7700691107077, -122.445896752918) | ||
| 17277 | 17277 | 10431 | Permitted Site 1 | Tristania conferta :: 79 | 1430 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 8 | 3X3 | 5999221.0892 | 2108752.9533 | 37.770188231639 | -122.446048431812 | (37.770188231639, -122.446048431812) | ||
| 17441 | 17441 | 10432 | DPW Maintained 3 | Tristania conferta :: 79 | 1441 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/1999 12:00:00 AM | 18 | 3X3 | 5999180.1356 | 2108696.8663 | 37.770031892228495 | -122.44618605438801 | (37.7700318922285, -122.446186054388) | ||
| 18101 | 18101 | 10433 | Permitted Site 1 | Tristania conferta :: 79 | 1449 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2001 12:00:00 AM | 3 | 3x3 | 5999155.0008 | 2108693.838 | 37.7700221418409 | -122.446272777074 | (37.7700221418409, -122.446272777074) | ||
| 23032 | 23032 | 10440 | DPW Maintained 3 | Tristania conferta :: 79 | 1476 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 5999041.0219 | 2108727.6134 | 37.770108370408 | -122.44666945726999 | (37.770108370408, -122.44666945727) | |||
| 19979 | 19979 | 10448 | Permitted Site 1 | Tristania conferta :: 79 | 1525 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1996 12:00:00 AM | 20 | 2X3 | 5998831.2765 | 2108649.625 | 37.7698822506188 | -122.447389347046 | (37.7698822506188, -122.447389347046) | ||
| 19192 | 19192 | 10456 | Permitted Site 1 | Tristania conferta :: 79 | 1556 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5998680.607000001 | 2108678.296 | 37.7699523629106 | -122.447912571831 | (37.7699523629106, -122.447912571831) | |||
| 17480 | 17480 | 10468 | Permitted Site 1 | Tristania conferta :: 79 | 1600 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/1993 12:00:00 AM | 10 | 3x3 | 5998442.2021 | 2108643.6888 | 37.7698437104477 | -122.448734713286 | (37.7698437104477, -122.448734713286) | ||
| 19714 | 19714 | 10469 | DPW Maintained 3 | Tristania conferta :: 79 | 1608 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2011 12:00:00 AM | 3 | 3x3 | 5998376.833 | 2108635.1438 | 37.769816509818796 | -122.44896020681499 | (37.7698165098188, -122.448960206815) | ||
| 21334 | 21334 | 10471 | DPW Maintained 3 | Tristania conferta :: 79 | 1628 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/06/2011 12:00:00 AM | 1 | 3x3 | 5998338.8079 | 2108630.4441 | 37.769801430915706 | -122.44909139548 | (37.7698014309157, -122.44909139548) | ||
| 23333 | 23333 | 10480 | DPW Maintained 3 | Tristania conferta :: 79 | 1665 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/1992 12:00:00 AM | 1 | 3X3 | 5998086.3169 | 2108545.149 | 37.7695527882164 | -122.44995860301701 | (37.7695527882164, -122.449958603017) | ||
| 18673 | 18673 | 10488 | DPW Maintained 3 | Tristania conferta :: 79 | 1679 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5998021.2087 | 2108536.3669 | 37.7695249491594 | -122.45018317568399 | (37.7695249491594, -122.450183175684) | |||
| 22121 | 22121 | 10491 | DPW Maintained 3 | Tristania conferta :: 79 | 1694 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/19/2008 12:00:00 AM | 3 | 3X3 | 5998067.7185 | 2108593.9143 | 37.769685621068895 | -122.45002644909901 | (37.7696856210689, -122.450026449099) | ||
| 23274 | 23274 | 10492 | DPW Maintained 3 | Tristania conferta :: 79 | 1699 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/1992 12:00:00 AM | 10 | 3X3 | 5997918.2468 | 2108523.3453 | 37.7694833025616 | -122.450538376308 | (37.7694833025616, -122.450538376308) | ||
| 23211 | 23211 | 10510 | DPW Maintained 3 | Tristania conferta :: 79 | 1793 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/1992 12:00:00 AM | 1 | 5997601.0333 | 2108476.5582 | 37.7693366759731 | -122.451632224006 | (37.7693366759731, -122.451632224006) | |||
| 21260 | 21260 | 10511 | Permitted Site 1 | Tristania conferta :: 79 | 1800 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2007 12:00:00 AM | 6 | 3X3 | 5997484.5237 | 2108509.319 | 37.7694199557275 | -122.452037587086 | (37.7694199557275, -122.452037587086) | ||
| 16912 | 16912 | 10519 | Permitted Site 1 | Tristania conferta :: 79 | 1840 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/1990 12:00:00 AM | 50 | 5997331.1413 | 2108490.0928 | 37.76935837855329 | -122.45256673963301 | (37.7693583785533, -122.452566739633) | |||
| 5419 | 5419 | 10640 | DPW Maintained 3 | Tristania conferta :: 79 | 879 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/26/1992 12:00:00 AM | 12 | 3X3 | 6003664.2022 | 2110709.9334 | 37.7758143385689 | -122.430819424449 | (37.7758143385689, -122.430819424449) | ||
| 5463 | 5463 | 10657 | DPW Maintained 3 | Tristania conferta :: 79 | 945 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/1990 12:00:00 AM | 6 | 6003325.2554 | 2110665.5174 | 37.7756731734805 | -122.43198875443701 | (37.7756731734805, -122.431988754437) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 1927 | 1927 | 10692 | DPW Maintained 3 | Tristania conferta :: 79 | 1249 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001880.3859 | 2110463.9678 | 37.7750377503654 | -122.43697247440201 | (37.7750377503654, -122.436972474402) | |||
| 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) | |||
| 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) | |||
| 23234 | 23234 | 10697 | DPW Maintained 3 | Tristania conferta :: 79 | 1273 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 6001825.1691 | 2110457.0657 | 37.7750156603511 | -122.437162986716 | (37.7750156603511, -122.437162986716) | |||
| 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) | |||
| 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) | |||
| 1020 | 1020 | 10701 | DPW Maintained 3 | Tristania conferta :: 79 | 1290 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001704.3359 | 2110485.9297 | 37.7750880443133 | -122.43758304169201 | (37.7750880443133, -122.437583041692) | |||
| 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) | ||
| 2481 | 2481 | 12266 | DPW Maintained 3 | Tristania conferta :: 79 | 649 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 16 | 3X3 | 6004915.2268 | 2111219.2684 | 37.7772836485499 | -122.426528085844 | (37.7772836485499, -122.426528085844) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | |||
| 1195 | 1195 | 12282 | DPW Maintained 3 | Tristania conferta :: 79 | 745 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x10 | 6004875.3929 | 2111529.8441 | 37.7781341613075 | -122.42668800624901 | (37.7781341613075, -122.426688006249) | |||
| 3985 | 3985 | 12338 | DPW Maintained 3 | Tristania conferta :: 79 | 1151X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1997 12:00:00 AM | 12 | 3X3 | 6004696.7001 | 2112810.35 | 37.7816400103646 | -122.427397413482 | (37.7816400103646, -122.427397413482) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 3599 | 3599 | 12345 | DPW Maintained 3 | Tristania conferta :: 79 | 1200 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/27/1992 12:00:00 AM | 6 | 4X4 | 6004709.3369 | 2113084.1368 | 37.782392475782 | -122.42737320580099 | (37.782392475782, -122.427373205801) | ||
| 23070 | 23070 | 12346 | DPW Maintained 3 | Tristania conferta :: 79 | 1200X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 6004717.664 | 2113030.0107 | 37.7822443298756 | -122.427340540761 | (37.7822443298756, -122.427340540761) | ||||
| 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) | ||
| 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) | |||
| 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) | ||
| 5369 | 5369 | 12368 | DPW Maintained 3 | Tristania conferta :: 79 | 1325 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1991 12:00:00 AM | 18 | 3X3 | 6004615.632999999 | 2113432.0006 | 37.7833423233744 | -122.42772217323 | (37.7833423233744, -122.42772217323) | ||
| 2361 | 2361 | 12987 | Permitted Site 1 | Tristania conferta :: 79 | 318 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 3X3 | 6010766.7048 | 2120702.1725 | 37.8036504876245 | -122.406954379692 | (37.8036504876245, -122.406954379692) | ||
| 2645 | 2645 | 13092 | Permitted Site 1 | Tristania conferta :: 79 | 1447 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2005 12:00:00 AM | 8 | 3x3 | 6005407.9937 | 2119875.0129 | 37.8010780038521 | -122.42543958631501 | (37.8010780038521, -122.425439586315) |
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");