Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, DBH, PlotSize, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8317 | 8317 | 106949 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2401 Broadway | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 4x4 | 6002070.184169999 | 2117343.17856 | 37.7939370979581 | -122.43680848054599 | (37.7939370979581, -122.436808480546) | |||
13403 | 13403 | 96770 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/08/2012 12:00:00 AM | 3 | 3x3 | 6015623.8599 | 2095148.9526 | 37.7337575287133 | -122.388361234061 | (37.7337575287133, -122.388361234061) | |
15999 | 15999 | 94036 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1300X Lane St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/08/2012 12:00:00 AM | 3 | 5x5 | 6015673.325 | 2095216.0053 | 37.7339443827642 | -122.388194894968 | (37.7339443827642, -122.388194894968) | |
24209 | 24209 | 98762 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 3x3 | 6003216.22786 | 2121048.1502900003 | 37.8041750548072 | -122.433107900734 | (37.8041750548072, -122.433107900734) | |||
39526 | 39526 | 117057 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 214 Spruce St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 5997141.29465 | 2115479.91986 | 37.7885397321741 | -122.4537282185 | (37.7885397321741, -122.4537282185) | |||
47886 | 47886 | 98764 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 6003256.03634 | 2121052.73189 | 37.804189892713 | -122.432970468136 | (37.804189892713, -122.432970468136) | |||
56785 | 56785 | 98766 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6003296.85169 | 2121058.27535 | 37.804207428580106 | -122.43282961988999 | (37.8042074285801, -122.43282961989) | |||
58430 | 58430 | 98765 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 17 | 3x3 | 6003279.0227 | 2121054.95921 | 37.804197312118895 | -122.432891081376 | (37.8041973121189, -122.432891081376) | |||
59786 | 59786 | 117058 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 214 Spruce St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 3x3 | 5997144.06323 | 2115469.32724 | 37.788510806389 | -122.45371787448799 | (37.788510806389, -122.453717874488) | |||
60569 | 60569 | 98774 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 13 | 3x3 | 6003476.9646 | 2121084.27758 | 37.804289037584205 | -122.432208183857 | (37.8042890375842, -122.432208183857) | |||
60591 | 60591 | 98772 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6003427.71574 | 2121076.45183 | 37.804264757687 | -122.432378054112 | (37.804264757687, -122.432378054112) | |||
64709 | 64709 | 98775 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 9 | 3x3 | 6003497.24376 | 2121086.80663 | 37.8042971314615 | -122.432138186954 | (37.8042971314615, -122.432138186954) | |||
68935 | 68935 | 98770 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 3x3 | 6003379.21654 | 2121069.1016599997 | 37.8042418258748 | -122.432545363992 | (37.8042418258748, -122.432545363992) | |||
73067 | 73067 | 98771 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 3x3 | 6003408.14062 | 2121072.18905 | 37.8042519432217 | -122.432445490669 | (37.8042519432217, -122.432445490669) | |||
79840 | 79840 | 97855 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
81293 | 81293 | 97871 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
82859 | 82859 | 97868 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
83719 | 83719 | 97864 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
91467 | 91467 | 97869 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
92675 | 92675 | 97866 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
94634 | 94634 | 97865 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 12 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
97516 | 97516 | 97859 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
98288 | 98288 | 97861 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
99796 | 99796 | 97867 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
101895 | 101895 | 97870 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
104531 | 104531 | 98773 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6003452.6 | 2121222.8 | 37.804668002399396 | -122.432302398634 | (37.8046680023994, -122.432302398634) | ||||
112922 | 112922 | 97862 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
113458 | 113458 | 103544 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 905X Phelps St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x12 | 6014832.8 | 2097357.7 | 37.7397784309436 | -122.39125052869 | (37.7397784309436, -122.39125052869) | |||
118986 | 118986 | 113148 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 470X BEACON ST | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 8 | 3x3 | 6002259.0 | 2098542.0 | 37.7423244157255 | -122.43481002285499 | (37.7423244157255, -122.434810022855) | ||||
129715 | 129715 | 98763 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6003235.74698 | 2121049.71225 | 37.8041804507317 | -122.43304046507299 | (37.8041804507317, -122.433040465073) | |||
142238 | 142238 | 97863 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
142400 | 142400 | 97858 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
143955 | 143955 | 103545 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 905X Phelps St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 10 | 6x12 | 6014832.8 | 2097357.7 | 37.7397784309436 | -122.39125052869 | (37.7397784309436, -122.39125052869) | |||
145994 | 145994 | 97860 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 895 Indiana St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6014975.4 | 2104402.3 | 37.7591293333254 | -122.391249777978 | (37.7591293333254, -122.391249777978) | |||||
154176 | 154176 | 117059 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 214 Spruce St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 17 | 3x3 | 5997147.32541 | 2115449.33488 | 37.788456099723895 | -122.453705143689 | (37.7884560997239, -122.453705143689) | |||
154297 | 154297 | 98768 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 14 | 3x3 | 6003334.441219999 | 2121062.9029099997 | 37.8042222665138 | -122.432699869304 | (37.8042222665138, -122.432699869304) | |||
161413 | 161413 | 98761 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 16 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 11 | 3x3 | 6003198.92766 | 2121046.5425 | 37.8041696588781 | -122.43316765437599 | (37.8041696588781, -122.433167654376) | |||
173136 | 173136 | 98776 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 14 | 3x3 | 6003515.54038 | 2121088.88501 | 37.804303875477096 | -122.43207501857 | (37.8043038754771, -122.43207501857) | |||
173675 | 173675 | 117056 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 214 Spruce St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 3x3 | 5997140.09186 | 2115499.411 | 37.788593180684096 | -122.453733787982 | (37.7885931806841, -122.453733787982) | |||
173812 | 173812 | 98769 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 20 | 3x3 | 6003355.72677 | 2121066.39367 | 37.8042330583593 | -122.43262645856701 | (37.8042330583593, -122.432626458567) | |||
181092 | 181092 | 98760 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 19 | 3x3 | 6003175.67956 | 2121043.58403 | 37.8041602168919 | -122.433247894574 | (37.8041602168919, -122.433247894574) | |||
187726 | 187726 | 98767 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1500X North Point St | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 16 | 3x3 | 6003313.437419999 | 2121061.12622 | 37.8042161969888 | -122.432772427524 | (37.8042161969888, -122.432772427524) |
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");