Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111961 | 111961 | 1 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 10 10th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.46898271049601 | (37.7866097734767, -122.468982710496) | |||
| 93529 | 93529 | 2 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 850X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/25/2009 12:00:00 AM | 3 | 3X3 | 5992872.52482 | 2114854.21479 | 37.78657606668221 | -122.468451837381 | (37.7865760666822, -122.468451837381) | ||
| 124086 | 124086 | 3 | DPW Maintained 3 | Podocarpus macrophyllus :: Yew Pine 168 | 2X 12th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992095.57585 | 2114853.19204 | 37.7865283500331 | -122.471139790973 | (37.7865283500331, -122.471139790973) | |||
| 144529 | 144529 | 4 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1101X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5992046.40751 | 2114771.53879 | 37.7863013087655 | -122.471303948198 | (37.7863013087655, -122.471303948198) | |||
| 76128 | 76128 | 10 | DPW Maintained 3 | Palm (unknown Genus) :: Palm Spp 161 | 97 12th St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
| 118070 | 118070 | 11 | DPW Maintained 3 | Palm (unknown Genus) :: Palm Spp 161 | 97 12th St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
| 107073 | 107073 | 12 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 97 12th St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3X3 | 6007166.5822125 | 2109668.7679164 | 37.7731533608049 | -122.418629924651 | (37.7731533608049, -122.418629924651) | |||
| 110072 | 110072 | 18 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2801X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 5992314.354430901 | 2097139.1969018 | 37.737903049839396 | -122.469093199098 | (37.7379030498394, -122.469093199098) | |||
| 114915 | 114915 | 19 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2801X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 5992314.354430901 | 2097139.1969018 | 37.737903049839396 | -122.469093199098 | (37.7379030498394, -122.469093199098) | |||
| 128627 | 128627 | 20 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2810X 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5992369.501524299 | 2097155.3271501 | 37.7379505257286 | -122.468903703785 | (37.7379505257286, -122.468903703785) | |||
| 83534 | 83534 | 21 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2810X 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5992369.501524299 | 2097155.3271501 | 37.7379505257286 | -122.468903703785 | (37.7379505257286, -122.468903703785) | |||
| 21370 | 21370 | 22 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 725 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2017 08:22:00 AM | 3 | 3X3 | 6003898.66598 | 2107719.95316 | 37.7676178644975 | -122.429795042015 | (37.7676178644975, -122.429795042015) | ||
| 19020 | 19020 | 25 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 736 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/17/1995 12:00:00 AM | 0 | 6003903.525084401 | 2107767.6234363 | 37.7677490306877 | -122.429781635515 | (37.7677490306877, -122.429781635515) | |||
| 21692 | 21692 | 26 | DPW Maintained 3 | Prunus cerasifera :: Cherry Plum 16 | 736 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/12/1992 12:00:00 AM | 12 | 3X3 | 6003885.725319999 | 2107769.72577 | 37.7677537952191 | -122.4298433527 | (37.7677537952191, -122.4298433527) | ||
| 23088 | 23088 | 29 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 742 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6003854.77769 | 2107764.13441 | 37.7677366901162 | -122.42994999788799 | (37.7677366901162, -122.429949997888) | |||
| 19634 | 19634 | 31 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 753 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 06:04:00 AM | 3 | 3X3 | 6003785.60824 | 2107710.67637 | 37.7675859898405 | -122.430185432325 | (37.7675859898405, -122.430185432325) | ||
| 97182 | 97182 | 32 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 753 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/2016 06:10:00 AM | 3 | 3X3 | 6003820.6216400005 | 2107707.01694 | 37.7675779249973 | -122.43006406443999 | (37.7675779249973, -122.43006406444) | ||
| 20666 | 20666 | 33 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 755 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/17/1998 12:00:00 AM | 3 | 3X3 | 6003762.7674 | 2107707.98129 | 37.7675772960935 | -122.43026424352199 | (37.7675772960935, -122.430264243522) | ||
| 18331 | 18331 | 34 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 759 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003742.09963 | 2107707.8799900003 | 37.767575847275204 | -122.430335723414 | (37.7675758472752, -122.430335723414) | |||
| 21403 | 21403 | 38 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 775 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6003673.2104 | 2107707.71827 | 37.767571500863795 | -122.430573990716 | (37.7675715008638, -122.430573990716) | |||
| 18465 | 18465 | 45 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 810 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/05/1990 12:00:00 AM | 12 | 3X3 | 6003436.52432 | 2107742.06145 | 37.7676523876611 | -122.431395108624 | (37.7676523876611, -122.431395108624) | ||
| 3771 | 3771 | 47 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 810 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1998 12:00:00 AM | 6 | 3X3 | 6003389.5525400005 | 2107739.47109 | 37.7676426129451 | -122.431557393053 | (37.7676426129451, -122.431557393053) | ||
| 753 | 753 | 48 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 810 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 6003376.13457 | 2107738.85817 | 37.767640169485105 | -122.43160376032499 | (37.7676401694851, -122.431603760325) | |||
| 19936 | 19936 | 50 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 811 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6003361.68382 | 2107697.25864 | 37.767525128208 | -122.431650773269 | (37.767525128208, -122.431650773269) | |||
| 17351 | 17351 | 52 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 814 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | 3X3 | 6003333.6015 | 2107734.84158 | 37.767626730010704 | -122.43175058993201 | (37.7676267300107, -122.431750589932) | |||
| 18204 | 18204 | 53 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 819 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4X4 | 6003339.25774 | 2107690.1864099996 | 37.7675044384029 | -122.431727837076 | (37.7675044384029, -122.431727837076) | |||
| 20057 | 20057 | 54 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 820 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003308.16067 | 2107736.25671 | 37.7676291734667 | -122.431838687528 | (37.7676291734667, -122.431838687528) | |||
| 97615 | 97615 | 55 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 825 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6003336.0552036 | 2107686.2210378996 | 37.7674933689218 | -122.431738631065 | (37.7674933689218, -122.431738631065) | |||
| 110229 | 110229 | 56 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 828 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003308.2753875 | 2107734.7636253997 | 37.7676250803229 | -122.431838184113 | (37.7676250803229, -122.431838184113) | |||
| 21020 | 21020 | 57 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 829 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003284.96574 | 2107687.1211099997 | 37.7674929441796 | -122.43191540687 | (37.7674929441796, -122.43191540687) | |||
| 19565 | 19565 | 58 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 831 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6003255.09688 | 2107686.06346 | 37.767488346823896 | -122.432018643671 | (37.7674883468239, -122.432018643671) | |||
| 20961 | 20961 | 59 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 839 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003236.18776 | 2107686.4539 | 37.7674883468466 | -122.432084075632 | (37.7674883468466, -122.432084075632) | |||
| 81661 | 81661 | 61 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 843 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4x4 | 6003222.9956732 | 2107679.9797688 | 37.7674698225277 | -122.43212924287901 | (37.7674698225277, -122.432129242879) | |||
| 20459 | 20459 | 62 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 848 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003213.61389 | 2107723.52495 | 37.7675888550728 | -122.43216480327101 | (37.7675888550728, -122.432164803271) | |||
| 116627 | 116627 | 63 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 847 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2015 12:00:00 AM | 3 | 3X3 | 6003197.9718305 | 2107678.5983679 | 37.7674646107508 | -122.43221569826001 | (37.7674646107508, -122.43221569826) | ||
| 81768 | 81768 | 69 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 865 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6003077.949911701 | 2107671.9727494 | 37.7674396126058 | -122.43263036424999 | (37.7674396126058, -122.43263036425) | |||
| 17374 | 17374 | 70 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 877 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003041.605930001 | 2107668.70427 | 37.7674285769945 | -122.432755839529 | (37.7674285769945, -122.432755839529) | |||
| 17083 | 17083 | 71 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 878 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2015 07:54:00 AM | 3 | 3X3 | 6003035.3624 | 2107711.09825 | 37.767544626421106 | -122.43278046386001 | (37.7675446264211, -122.43278046386) | ||
| 17177 | 17177 | 72 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 878 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/03/2016 12:34:00 PM | 3 | 3X3 | 6003020.08721 | 2107708.79941 | 37.7675374480197 | -122.432833134452 | (37.7675374480197, -122.432833134452) | ||
| 17699 | 17699 | 73 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 880 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6002985.89482 | 2107705.84522 | 37.767527397193795 | -122.432951190257 | (37.7675273971938, -122.432951190257) | |||
| 19702 | 19702 | 86 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002711.6629800005 | 2107699.4849 | 37.7674943750014 | -122.433899266359 | (37.7674943750014, -122.433899266359) | |||
| 21984 | 21984 | 87 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002676.805380001 | 2107689.7475799997 | 37.767465660541 | -122.43401913788999 | (37.767465660541, -122.43401913789) | |||
| 20448 | 20448 | 88 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002652.7260300005 | 2107693.38271 | 37.767474275148004 | -122.434102684915 | (37.767474275148, -122.434102684915) | |||
| 21910 | 21910 | 94 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6002488.782240001 | 2107687.88267 | 37.7674498675536 | -122.434669350436 | (37.7674498675536, -122.434669350436) | |||
| 20760 | 20760 | 97 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1997 12:00:00 AM | 12 | 3X3 | 6002378.86758 | 2107679.69737 | 37.767421152188604 | -122.435048944375 | (37.7674211521886, -122.435048944375) | ||
| 102626 | 102626 | 102 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 923 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002700.4016261 | 2107651.1308054 | 37.767360967419705 | -122.43393476112301 | (37.7673609674197, -122.433934761123) | |||
| 125395 | 125395 | 103 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 905 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002810.7304432 | 2107657.2213263 | 37.76738395094429 | -122.433553584829 | (37.7673839509443, -122.433553584829) | |||
| 19112 | 19112 | 104 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 903 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002728.05745 | 2107652.23665 | 37.7673655732026 | -122.433839182638 | (37.7673655732026, -122.433839182638) | |||
| 19313 | 19313 | 106 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 927 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002652.29309 | 2107649.54302 | 37.7673538775163 | -122.434101048134 | (37.7673538775163, -122.434101048134) | |||
| 22155 | 22155 | 107 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 935 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002622.320669999 | 2107648.0329400003 | 37.767348030106795 | -122.434204610458 | (37.7673480301068, -122.434204610458) | |||
| 19208 | 19208 | 108 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 939 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002600.95184 | 2107648.90078 | 37.7673492001289 | -122.434278584211 | (37.7673492001289, -122.434278584211) | |||
| 17007 | 17007 | 110 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 945 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6002532.89226 | 2107646.47434 | 37.767338674478104 | -122.43451381896799 | (37.7673386744781, -122.434513818968) | |||
| 1581 | 1581 | 111 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 955 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002518.0 | 2107623.0 | 37.767273374303706 | -122.43456365047399 | (37.7672733743037, -122.434563650474) | |||
| 20713 | 20713 | 112 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 955 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6002510.55394 | 2107641.82471 | 37.7673246396489 | -122.43459075148 | (37.7673246396489, -122.43459075148) | |||
| 20178 | 20178 | 113 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 959 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 6002493.042169999 | 2107643.0386799998 | 37.767326978783395 | -122.43465140896002 | (37.7673269787834, -122.43465140896) | |||
| 20050 | 20050 | 114 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 963 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6002475.041 | 2107641.28126 | 37.76732113139371 | -122.434713546705 | (37.7673211313937, -122.434713546705) | |||
| 17754 | 17754 | 115 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 967 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3X3 | 6002439.93798 | 2107639.87747 | 37.7673152840014 | -122.434834862532 | (37.7673152840014, -122.434834862532) | |||
| 18942 | 18942 | 117 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 975 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6002386.388619999 | 2107635.87333 | 37.767301249177606 | -122.435019795532 | (37.7673012491776, -122.435019795532) | |||
| 17513 | 17513 | 119 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 983 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6002320.92055 | 2107634.67153 | 37.7672942317745 | -122.43524615398701 | (37.7672942317745, -122.435246153987) | |||
| 20717 | 20717 | 121 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1010 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3x3 | 6002120.21923 | 2107665.1776900003 | 37.767366594808 | -122.435942533236 | (37.767366594808, -122.435942533236) | |||
| 19166 | 19166 | 122 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1012 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002100.28496 | 2107666.1128700003 | 37.767368030136204 | -122.436011549918 | (37.7673680301362, -122.436011549918) | |||
| 18669 | 18669 | 123 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1032 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3.5 | 6002070.82706 | 2107663.58495 | 37.7673594155415 | -122.436113259617 | (37.7673594155415, -122.436113259617) | |||
| 21344 | 21344 | 124 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1032 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002037.12702 | 2107659.05322 | 37.767345057867395 | -122.436229498819 | (37.7673450578674, -122.436229498819) | |||
| 19032 | 19032 | 127 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1034 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2003 12:00:00 AM | 6 | 3X3 | 6001910.06449 | 2107659.59146 | 37.7673393156847 | -122.436669028078 | (37.7673393156847, -122.436669028078) | ||
| 21520 | 21520 | 128 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1037 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001838.59138 | 2107604.25584 | 37.767183315676796 | -122.436912281202 | (37.7671833156768, -122.436912281202) | |||
| 17467 | 17467 | 131 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001863.23078 | 2107602.69281 | 37.7671804243666 | -122.43682694540199 | (37.7671804243666, -122.436826945402) | |||
| 17874 | 17874 | 132 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3x3 | 6001881.94625 | 2107604.4114599996 | 37.7671862070127 | -122.43676233451099 | (37.7671862070127, -122.436762334511) | |||
| 18051 | 18051 | 133 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001899.56867 | 2107604.3975 | 37.7671871701845 | -122.436701380267 | (37.7671871701845, -122.436701380267) | |||
| 19532 | 19532 | 134 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6001934.13073 | 2107605.43709 | 37.767191988753204 | -122.43658190982201 | (37.7671919887532, -122.436581909822) | |||
| 19437 | 19437 | 135 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6001952.83166 | 2107606.45386 | 37.7671958432489 | -122.436517298951 | (37.7671958432489, -122.436517298951) | |||
| 21415 | 21415 | 136 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1025X 14th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 6001971.14414 | 2107605.72409 | 37.767194880067294 | -122.436453906645 | (37.7671948800673, -122.436453906645) | |||
| 18350 | 18350 | 137 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6001997.64675 | 2107609.03625 | 37.7672054803662 | -122.436362475243 | (37.7672054803662, -122.436362475243) | |||
| 20276 | 20276 | 138 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/1990 12:00:00 AM | 8 | 3x3 | 6002019.503880001 | 2107609.28585 | 37.7672074076113 | -122.436286892624 | (37.7672074076113, -122.436286892624) | ||
| 19566 | 19566 | 139 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1993 12:00:00 AM | 16 | 3x3 | 6002038.50641 | 2107607.83995 | 37.7672045171948 | -122.43622106227899 | (37.7672045171948, -122.436221062279) | ||
| 16972 | 16972 | 140 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/1997 12:00:00 AM | 7 | 3x3 | 6002065.74261 | 2107612.5408 | 37.7672189719923 | -122.436127192841 | (37.7672189719923, -122.436127192841) | ||
| 20724 | 20724 | 141 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/1997 12:00:00 AM | 5 | 3x3 | 6002093.67612 | 2107616.87647 | 37.767232463635004 | -122.436030885343 | (37.767232463635, -122.436030885343) | ||
| 20010 | 20010 | 142 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3x3 | 6002114.14587 | 2107618.20787 | 37.7672372822096 | -122.435960178842 | (37.7672372822096, -122.435960178842) | |||
| 19949 | 19949 | 143 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3x3 | 6002137.11079 | 2107620.89146 | 37.7672459552646 | -122.435880938676 | (37.7672459552646, -122.435880938676) | |||
| 13261 | 13261 | 144 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1025X 14th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | SFUSD 6 | 18 | 3x3 | 6002159.27678 | 2107619.02908 | 37.7672421007673 | -122.435804136578 | (37.7672421007673, -122.435804136578) | ||
| 21808 | 21808 | 146 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1068 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6001685.884319999 | 2107635.99575 | 37.767261785130295 | -122.437442744485 | (37.7672617851303, -122.437442744485) | |||
| 20171 | 20171 | 148 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1069 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2011 12:00:00 AM | 3 | 3x3 | 6001678.29307 | 2107593.03203 | 37.7671433857715 | -122.43746592450701 | (37.7671433857715, -122.437465924507) | ||
| 17533 | 17533 | 150 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1075 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6001650.88239 | 2107592.64256 | 37.76714075797379 | -122.437560705874 | (37.7671407579738, -122.437560705874) | |||
| 83027 | 83027 | 152 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1083 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001573.9456807 | 2107585.1760068 | 37.767115882088 | -122.437826283074 | (37.767115882088, -122.437826283074) | |||
| 21992 | 21992 | 153 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1087-1089 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/28/2015 06:27:00 AM | 3 | 3X3 | 6001581.86052 | 2107592.08996 | 37.7671353161574 | -122.43779940213899 | (37.7671353161574, -122.437799402139) | ||
| 18388 | 18388 | 154 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1090X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001569.28658 | 2107634.7500400003 | 37.767251735211794 | -122.437845949243 | (37.7672517352118, -122.437845949243) | |||
| 17301 | 17301 | 158 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1095 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6001530.2126 | 2107592.17995 | 37.7671326262835 | -122.437978050639 | (37.7671326262835, -122.437978050639) | |||
| 19695 | 19695 | 162 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5119X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/16/1994 12:00:00 AM | 3 | 3X3 | 5991169.13123 | 2112654.48309 | 37.780437675056206 | -122.47418453611401 | (37.7804376750562, -122.474184536114) | ||
| 127245 | 127245 | 165 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | |||
| 146128 | 146128 | 166 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 185X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/01/1990 12:00:00 AM | 12 | 3X3 | 6002923.96517 | 2107137.15069 | 37.7659623878091 | -122.43312475898998 | (37.7659623878091, -122.43312475899) | ||
| 78824 | 78824 | 167 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | ||||
| 129349 | 129349 | 169 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6X6 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | |||
| 104075 | 104075 | 171 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6X6 | 6002921.63124 | 2107202.49362 | 37.7661416711925 | -122.433137500753 | (37.7661416711925, -122.433137500753) | |||
| 20220 | 20220 | 172 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 195X Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6002270.84899 | 2107104.55604 | 37.7658358209965 | -122.43538141922899 | (37.7658358209965, -122.435381419229) | |||
| 104572 | 104572 | 178 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2900X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6007426.6373058 | 2106784.9094001 | 37.7652496025139 | -122.41752593136002 | (37.7652496025139, -122.41752593136) | |||
| 110930 | 110930 | 179 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2900X 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 6007426.6373058 | 2106784.9094001 | 37.7652496025139 | -122.41752593136002 | (37.7652496025139, -122.41752593136) | |||
| 105956 | 105956 | 181 | DPW Maintained 3 | Washingtonia filifera :: California Fan Palm 189 | 2900X 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6007426.6373058 | 2106784.9094001 | 37.7652496025139 | -122.41752593136002 | (37.7652496025139, -122.41752593136) | |||
| 77322 | 77322 | 182 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2999X 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6006815.633084299 | 2106700.9319629 | 37.764984621460705 | -122.419633295239 | (37.7649846214607, -122.419633295239) | |||
| 102799 | 102799 | 183 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2999X 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 6006815.633084299 | 2106700.9319629 | 37.764984621460705 | -122.419633295239 | (37.7649846214607, -122.419633295239) | |||
| 121328 | 121328 | 184 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2999X 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3x3 | 6006815.633084299 | 2106700.9319629 | 37.764984621460705 | -122.419633295239 | (37.7649846214607, -122.419633295239) | |||
| 17968 | 17968 | 186 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3000 16th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 6006757.0691 | 2106751.32667 | 37.765119694430794 | -122.41983943004 | (37.7651196944308, -122.41983943004) |
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");