Data source: data.sfgov.org
This data as json, CSV (advanced)
PermitNotes ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
495 | 495 | 248613 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | |||
3855 | 3855 | 248614 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 845 Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5997650.5459 | 2107506.4452 | 37.7666758289672 | -122.451390984496 | (37.7666758289672, -122.451390984496) | |||
4763 | 4763 | 220524 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 110 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1974 12:00:00 AM | 38 | Width 3ft | Permit Number 14125 | 6003373.13767 | 2108706.4584 | 37.770296793780396 | -122.431683217203 | (37.7702967937804, -122.431683217203) | |
5897 | 5897 | 19904 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY34 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | ||||||||
6788 | 6788 | 19903 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY34 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | ||||||||
7574 | 7574 | 19781 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY19 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 50ST | ||||||||
13863 | 13863 | 19841 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY25 | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60X | ||||||||
16741 | 16741 | 20051 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 STAIRWAY52 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | ||||||||
18395 | 18395 | 6096 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | |||
23464 | 23464 | 121867 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 382 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990303.78145 | 2112825.7530799997 | 37.7808577673116 | -122.477190674715 | (37.7808577673116, -122.477190674715) | |||
26304 | 26304 | 140079 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 100 Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000729.2298 | 2112451.4153 | 37.780429279749605 | -122.44109718195499 | (37.7804292797496, -122.441097181955) | |||
44122 | 44122 | 212849 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1201 Ulloa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5992374.69215 | 2098410.70315 | 37.7413977704887 | -122.468977090726 | (37.7413977704887, -122.468977090726) | |||
46771 | 46771 | 140080 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 102 Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6000726.8608 | 2112462.5832 | 37.7804598090154 | -122.441106178881 | (37.7804598090154, -122.441106178881) | |||
51312 | 51312 | 96980 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) | ||||
78042 | 78042 | 6095 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2015 12:00:00 AM | 12 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | ||
87484 | 87484 | 96979 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) | ||||
89334 | 89334 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
91724 | 91724 | 103067 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 255 Broadway | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2014 12:00:00 AM | 3 | 6x6 | Permit Number 769997 | 6012256.1 | 2118721.6 | 37.7982955442476 | -122.401660929382 | (37.7982955442476, -122.401660929382) | |
92450 | 92450 | 116095 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
95683 | 95683 | 91056 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 750 FOLSOM ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x4 | 6012569.0 | 2113092.0 | 37.7828554456154 | -122.400182606689 | (37.7828554456154, -122.400182606689) | ||||
106073 | 106073 | 96984 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) | ||||
106195 | 106195 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | |||
108312 | 108312 | 6094 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | |||
110210 | 110210 | 91057 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 750 FOLSOM ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 6x4 | 6012569.0 | 2113092.0 | 37.7828554456154 | -122.400182606689 | (37.7828554456154, -122.400182606689) | |||
112632 | 112632 | 6098 | DPW Maintained 3 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 106X Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.780385944611204 | -122.44108008458001 | (37.7803859446112, -122.44108008458) | |||
114742 | 114742 | 116093 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
118020 | 118020 | 116097 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
119705 | 119705 | 116096 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
139286 | 139286 | 96978 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) | ||||
141279 | 141279 | 96981 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 2090@Buchanan Vallejo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 25529 | 6003561.0 | 2117963.0 | 37.7957235834131 | -122.43169438827101 | (37.7957235834131, -122.431694388271) | ||||
144536 | 144536 | 116092 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 300x EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014482.0 | 2086919.0 | 37.7110963749119 | -122.39173377323799 | (37.7110963749119, -122.391733773238) | ||||
164715 | 164715 | 139060 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1455 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 0ft | 5999670.4186 | 2113895.7324 | 37.7843346353185 | -122.444863945857 | (37.7843346353185, -122.444863945857) | |||
169265 | 169265 | 140081 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 104 Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000726.183999999 | 2112472.3974 | 37.7804867177527 | -122.441109224562 | (37.7804867177527, -122.441109224562) | |||
175227 | 175227 | 140083 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 108 Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 6000722.7998 | 2112497.1022 | 37.7805543580623 | -122.441122705034 | (37.7805543580623, -122.441122705034) | |||
177775 | 177775 | 53540 | Permitted Site 1 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 308 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/1969 12:00:00 AM | 24 | Permit Number 6452 | 5994656.440219999 | 2113376.70713 | 37.782622110333904 | -122.462172779062 | (37.7826221103339, -122.462172779062) | ||
188309 | 188309 | 234896 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 1 | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 10ft | 6007240.7393 | 2101963.9408299997 | 37.7520018736867 | -122.41782715109501 | (37.7520018736867, -122.417827151095) |
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");