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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | ||
| 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) | |
| 13604 | 13604 | 28836 | Permitted Site 1 | Tristania conferta :: 79 | 1501 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016976.7304 | 2093554.8023 | 37.729455180200794 | -122.383572968876 | (37.7294551802008, -122.383572968876) | ||
| 13617 | 13617 | 29430 | Permitted Site 1 | Tristania conferta :: 79 | 2401X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 5 | 3X3 | 6015434.0318 | 2091490.2952 | 37.7237010652846 | -122.388762207738 | (37.7237010652846, -122.388762207738) | ||
| 13647 | 13647 | 30096 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2011 12:00:00 AM | 6 | 3x3 | 6013417.4786 | 2091122.0564 | 37.722577983662504 | -122.395707348923 | (37.7225779836625, -122.395707348923) | ||
| 13659 | 13659 | 22470 | Permitted Site 1 | Tristania conferta :: 79 | 6227 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/1995 12:00:00 AM | 5 | 3x3 | 6013423.3351 | 2090899.6727 | 37.7219676884588 | -122.39567153040701 | (37.7219676884588, -122.395671530407) | ||
| 13702 | 13702 | 22191 | Permitted Site 1 | Tristania conferta :: 79 | 4011 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 6015646.0862 | 2097696.0967 | 37.7407527004376 | -122.38846211797701 | (37.7407527004376, -122.388462117977) | |||
| 13708 | 13708 | 22353 | Permitted Site 1 | Tristania conferta :: 79 | 5279 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2011 12:00:00 AM | 6 | 3X3 | 6014427.3526 | 2093617.3879 | 37.72948578919 | -122.392390860293 | (37.72948578919, -122.392390860293) | ||
| 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) | ||
| 13890 | 13890 | 29426 | Permitted Site 1 | Tristania conferta :: 79 | 2501X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6015353.5854 | 2091384.7495 | 37.723406798628 | -122.389032933904 | (37.723406798628, -122.389032933904) | ||
| 13938 | 13938 | 29486 | Permitted Site 1 | Tristania conferta :: 79 | 1616 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016775.5724 | 2093362.9876 | 37.7289173744178 | -122.384255044958 | (37.7289173744178, -122.384255044958) | ||
| 14024 | 14024 | 29547 | Permitted Site 1 | Tristania conferta :: 79 | 2920 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014582.5436 | 2090417.5505 | 37.720708291367 | -122.391630714392 | (37.720708291367, -122.391630714392) | ||
| 14035 | 14035 | 87473 | Permitted Site 1 | Tristania conferta :: 79 | 5176 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 3x3 | 6014507.8856 | 2094193.7018 | 37.7310727023064 | -122.39215273626499 | (37.7310727023064, -122.392152736265) | ||
| 14045 | 14045 | 29406 | Permitted Site 1 | Tristania conferta :: 79 | 2845X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3X3 | 6014746.9934 | 2090564.9462 | 37.7211221378179 | -122.39107255471599 | (37.7211221378179, -122.391072554716) | ||
| 14076 | 14076 | 22397 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1995 12:00:00 AM | 6 | 3X3 | 6013870.7534 | 2092308.3783 | 37.7258605897355 | -122.39422348311399 | (37.7258605897355, -122.394223483114) | ||
| 14096 | 14096 | 29566 | Permitted Site 1 | Tristania conferta :: 79 | 3224 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3x3 | 6014068.4858 | 2089729.2978 | 37.718789938046605 | -122.39335952751999 | (37.7187899380466, -122.39335952752) | ||
| 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) | ||
| 14144 | 14144 | 28832 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016972.3335 | 2093632.2976 | 37.7296677240114 | -122.383593562534 | (37.7296677240114, -122.383593562534) | ||
| 14182 | 14182 | 22366 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6014240.2849 | 2093075.8071 | 37.7279883280139 | -122.39299969922199 | (37.7279883280139, -122.392999699222) | |||
| 14284 | 14284 | 22410 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/30/2010 12:00:00 AM | 4 | 3x3 | Permit Number 53565 | 6013752.9164 | 2092008.8459 | 37.7250315835443 | -122.39460987462401 | (37.7250315835443, -122.394609874624) | |
| 14414 | 14414 | 22224 | Permitted Site 1 | Tristania conferta :: 79 | 4346 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1995 12:00:00 AM | 12 | 3X3 | 6015286.1359 | 2096781.1052 | 37.73822036804471 | -122.38964281112601 | (37.7382203680447, -122.389642811126) | ||
| 14449 | 14449 | 29495 | Permitted Site 1 | Tristania conferta :: 79 | 1700X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016616.3583 | 2093144.917 | 37.7283097910179 | -122.384790279442 | (37.7283097910179, -122.384790279442) | ||
| 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) | |||
| 14553 | 14553 | 29440 | Permitted Site 1 | Tristania conferta :: 79 | 2301X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 3 | 3X3 | 6015660.6839 | 2091799.6156 | 37.7245629575419 | -122.38800027789101 | (37.7245629575419, -122.388000277891) | ||
| 14590 | 14590 | 22425 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 7 | 3x3 | 6013846.5269 | 2092016.8466 | 37.725058755754 | -122.394286830799 | (37.725058755754, -122.394286830799) | ||
| 14713 | 14713 | 29485 | Permitted Site 1 | Tristania conferta :: 79 | 1608 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016787.6638 | 2093383.8729 | 37.7289753898862 | -122.38421469762 | (37.7289753898862, -122.38421469762) | ||
| 14721 | 14721 | 22365 | Permitted Site 1 | Tristania conferta :: 79 | 5411 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | 6014237.0145 | 2093039.8325 | 37.7278893673534 | -122.39300848919399 | (37.7278893673534, -122.393008489194) | |||
| 14785 | 14785 | 29469 | Permitted Site 1 | Tristania conferta :: 79 | 1609 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 8 | 3X3 | 6016821.7398 | 2093350.8961 | 37.7288867261126 | -122.38409459771098 | (37.7288867261126, -122.384094597711) | ||
| 14809 | 14809 | 22396 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1995 12:00:00 AM | 6 | 3X3 | 6013879.4285 | 2092330.5481 | 37.725921945734704 | -122.394195045111 | (37.7259219457347, -122.394195045111) | ||
| 14819 | 14819 | 29402 | Permitted Site 1 | Tristania conferta :: 79 | 2919 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 2x2 | 6014617.8699 | 2090399.8874 | 37.720661752825706 | -122.391507367115 | (37.7206617528257, -122.391507367115) | |||
| 14830 | 14830 | 29396 | Permitted Site 1 | Tristania conferta :: 79 | 3001 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014489.3554 | 2090228.1287 | 37.720183003403704 | -122.39193960073999 | (37.7201830034037, -122.39193960074) | ||
| 14948 | 14948 | 29394 | Permitted Site 1 | Tristania conferta :: 79 | 3019 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 5 | 3x3 | 6014458.2927 | 2090182.4482 | 37.720055849211604 | -122.392043782138 | (37.7200558492116, -122.392043782138) | ||
| 15081 | 15081 | 22487 | Permitted Site 1 | Tristania conferta :: 79 | 6275 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/12/1995 12:00:00 AM | 12 | 3x3 | 6013315.0844 | 2090629.8634 | 37.7212208240298 | -122.39602683012698 | (37.7212208240298, -122.396026830127) | ||
| 15085 | 15085 | 29384 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014251.8169 | 2089910.1925 | 37.7192968231465 | -122.39273846811199 | (37.7192968231465, -122.392738468112) | ||
| 15165 | 15165 | 87518 | Permitted Site 1 | Tristania conferta :: 79 | 5275 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6014437.818 | 2093660.5574 | 37.729604905058 | -122.39235769828998 | (37.729604905058, -122.39235769829) | |||
| 15225 | 15225 | 22440 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/11/2001 12:00:00 AM | 3 | 3X3 | 6013624.7927 | 2091445.832 | 37.723478536743 | -122.395013371509 | (37.723478536743, -122.395013371509) | ||
| 15257 | 15257 | 22392 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1997 12:00:00 AM | 6 | 3X3 | 6013914.6109 | 2092416.3353 | 37.7261594555974 | -122.394079424 | (37.7261594555974, -122.394079424) | ||
| 15369 | 15369 | 22443 | Permitted Site 1 | Tristania conferta :: 79 | 6025 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6013664.0377 | 2091536.7496 | 37.7237303604467 | -122.39488407213601 | (37.7237303604467, -122.394884072136) | |||
| 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) | |||
| 15437 | 15437 | 28833 | Permitted Site 1 | Tristania conferta :: 79 | 1500 Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/2005 12:00:00 AM | 12 | 4x4 | 6016963.5397 | 2093616.3588 | 37.729623473146894 | -122.383622854715 | (37.7296234731469, -122.383622854715) | ||
| 15472 | 15472 | 22489 | Permitted Site 1 | Tristania conferta :: 79 | 6283 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/21/2008 12:00:00 AM | 6 | 3x3 | 6013301.3486 | 2090589.3102 | 37.7211087088425 | -122.396071470667 | (37.7211087088425, -122.396071470667) | ||
| 15499 | 15499 | 29379 | Permitted Site 1 | Tristania conferta :: 79 | 3225 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 10 | 3x3 | 6014101.9849 | 2089704.3258 | 37.718723230996105 | -122.39324198712299 | (37.7187232309961, -122.393241987123) | ||
| 15503 | 15503 | 29385 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014260.3439 | 2089918.7195 | 37.7193207101956 | -122.39270958943999 | (37.7193207101956, -122.39270958944) | ||
| 15567 | 15567 | 22419 | Permitted Site 1 | Tristania conferta :: 79 | 5815 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12/19/2000 12:00:00 AM | 3 | 3x3 | 6013854.3759 | 2092034.5068 | 37.7251076834032 | -122.394260933329 | (37.7251076834032, -122.394260933329) | ||
| 15576 | 15576 | 95306 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6013860.6324 | 2092285.2447 | 37.7257965069575 | -122.39425685203001 | (37.7257965069575, -122.39425685203) | |||
| 15601 | 15601 | 22384 | Permitted Site 1 | Tristania conferta :: 79 | 5600 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/17/1995 12:00:00 AM | 6 | 3X3 | 6014013.8928 | 2092684.7819 | 37.72690207345929 | -122.39375499094999 | (37.7269020734593, -122.39375499095) | ||
| 15696 | 15696 | 29409 | Permitted Site 1 | Tristania conferta :: 79 | 2715X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 6 | 3x3 | 6014989.3241 | 2090898.8532 | 37.7220524249966 | -122.39025819753901 | (37.7220524249966, -122.390258197539) | ||
| 15709 | 15709 | 29381 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014224.4086 | 2089865.1211 | 37.7191715436771 | -122.392830057526 | (37.7191715436771, -122.392830057526) | ||
| 15886 | 15886 | 30095 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013424.226 | 2091142.2984 | 37.7226339394685 | -122.395685442076 | (37.7226339394685, -122.395685442076) | |||
| 15923 | 15923 | 29386 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014271.9163 | 2089934.5554 | 37.719364835170396 | -122.392670694873 | (37.7193648351704, -122.392670694873) | ||
| 15952 | 15952 | 87520 | Permitted Site 1 | Tristania conferta :: 79 | 5299 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6014418.8496 | 2093596.4572 | 37.7294278455371 | -122.39241879281201 | (37.7294278455371, -122.392418792812) | |||
| 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) | ||
| 15995 | 15995 | 22344 | Permitted Site 1 | Tristania conferta :: 79 | 5251 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/20/2007 12:00:00 AM | 3 | 3X3 | 6014461.365 | 2093739.0473 | 37.729821729988 | -122.392281780639 | (37.729821729988, -122.392281780639) | ||
| 16048 | 16048 | 29395 | Permitted Site 1 | Tristania conferta :: 79 | 3001 Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014475.9558 | 2090207.4202 | 37.7201253980359 | -122.39198447167699 | (37.7201253980359, -122.391984471677) | ||
| 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) | ||
| 16179 | 16179 | 30024 | Permitted Site 1 | Tristania conferta :: 79 | 6190X 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6013452.1791 | 2091216.0368 | 37.7228379652128 | -122.39559397744 | (37.7228379652128, -122.39559397744) | |||
| 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) | ||
| 16334 | 16334 | 22388 | Permitted Site 1 | Tristania conferta :: 79 | 5600 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/2010 12:00:00 AM | 9 | 3X3 | Permit Number 53445 | 6014004.2537 | 2092658.7566 | 37.7268300775798 | -122.393786492489 | (37.7268300775798, -122.393786492489) | |
| 16346 | 16346 | 29504 | Permitted Site 1 | Tristania conferta :: 79 | 1800X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016442.8409 | 2092919.0689 | 37.7276800583286 | -122.38537441062401 | (37.7276800583286, -122.385374410624) | ||
| 16375 | 16375 | 22415 | Permitted Site 1 | Tristania conferta :: 79 | 5800 03rd St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53653 | 6013701.5886 | 2091876.0685 | 37.7246641498069 | -122.39477801609101 | (37.7246641498069, -122.394778016091) | |
| 16413 | 16413 | 29503 | Permitted Site 1 | Tristania conferta :: 79 | 1800X Ingalls St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3x3 | 6016452.7561 | 2092931.7384 | 37.727715394829296 | -122.38534101579599 | (37.7277153948293, -122.385341015796) | ||
| 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) | ||
| 16494 | 16494 | 22329 | Permitted Site 1 | Tristania conferta :: 79 | 5166 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/13/2001 12:00:00 AM | 3 | 3X3 | 6014522.2059 | 2094241.4361 | 37.7312045661254 | -122.39210656510599 | (37.7312045661254, -122.392106565106) | ||
| 16601 | 16601 | 22174 | Permitted Site 1 | Tristania conferta :: 79 | 3900 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1995 12:00:00 AM | 3 | 3X3 | 6015675.1373 | 2098078.9572 | 37.7418055667015 | -122.388388385005 | (37.7418055667015, -122.388388385005) | ||
| 16654 | 16654 | 22374 | Permitted Site 1 | Tristania conferta :: 79 | 5518 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/18/2008 12:00:00 AM | 3 | 3X3 | 6014092.4507 | 2092899.7319999998 | 37.7274966482783 | -122.393498452721 | (37.7274966482783, -122.393498452721) | ||
| 16656 | 16656 | 22177 | Permitted Site 1 | Tristania conferta :: 79 | 3950X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6015646.3224 | 2097987.7887 | 37.741553639953 | -122.388481656276 | (37.741553639953, -122.388481656276) | |||
| 16740 | 16740 | 29382 | Permitted Site 1 | Tristania conferta :: 79 | 3199X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 4 | 3x3 | 6014237.1991 | 2089885.2205 | 37.7192274430768 | -122.39278725067498 | (37.7192274430768, -122.392787250675) | ||
| 16769 | 16769 | 29493 | Permitted Site 1 | Tristania conferta :: 79 | 1700X Ingalls St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2006 12:00:00 AM | 12 | 3X3 | 6016630.1295 | 2093166.4001 | 37.728369541019894 | -122.384744167276 | (37.7283695410199, -122.384744167276) | ||
| 16817 | 16817 | 22393 | Permitted Site 1 | Tristania conferta :: 79 | 5700 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2000 12:00:00 AM | 3 | 3X3 | 6013906.4177 | 2092399.467 | 37.726112683263295 | -122.39410656725799 | (37.7261126832633, -122.394106567258) |
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");