Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2932 | 2932 | 142166 | Permitted Site 1 | Acacia longifolia :: Golden Wattle 140 | 1477 GROVE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000715.4928 | 2110652.1954 | 37.7754882965725 | -122.44101558938699 | (37.7754882965725, -122.441015589387) | |||
8239 | 8239 | 19878 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY33 | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
10529 | 10529 | 20302 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 50X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
11626 | 11626 | 19961 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY41 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
13663 | 13663 | 19874 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY33 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 25ST | ||||||||
15605 | 15605 | 19771 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY17 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
15986 | 15986 | 19773 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 100 STAIRWAY17 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 20ST | ||||||||
16025 | 16025 | 6425 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1100X Evans Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/04/2003 12:00:00 AM | 12 | 3x3 | 6018217.31109 | 2096647.32337 | 37.7380151271058 | -122.379498860299 | (37.7380151271058, -122.379498860299) | ||
16877 | 16877 | 6427 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1100X Evans Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6018163.14059 | 2096688.19053 | 37.738124352445396 | -122.379688994958 | (37.7381243524454, -122.379688994958) | |||
22468 | 22468 | 6157 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1000X Ellis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005895.06272 | 2113497.5002099997 | 37.7835944591715 | -122.423300504237 | (37.7835944591715, -122.423300504237) | |||
88406 | 88406 | 1916 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 11 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016651.815200901 | 2095266.4928856997 | 37.734137178639 | -122.384815438972 | (37.734137178639, -122.384815438972) | |||
89051 | 89051 | 23661 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 308 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006889.9376932 | 2098288.2721448997 | 37.741889569517795 | -122.418779625482 | (37.7418895695178, -122.418779625482) | |||
90632 | 90632 | 19347 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 600 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5992459.1729484005 | 2089876.0608299 | 37.7179686413438 | -122.46806431972901 | (37.7179686413438, -122.468064319729) | |||
92132 | 92132 | 1711 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 5 Bass Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016572.54474 | 2095129.81679 | 37.7337575087508 | -122.38507998492099 | (37.7337575087508, -122.385079984921) | |||
104236 | 104236 | 18906 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 2603 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 1X1 | 6002313.43773 | 2115715.13601 | 37.7894807345857 | -122.435850259079 | (37.7894807345857, -122.435850259079) | |||
108741 | 108741 | 1912 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 8 Bell Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016615.0158522995 | 2095214.1533182 | 37.7339914292631 | -122.384939021898 | (37.7339914292631, -122.384939021898) | |||
111524 | 111524 | 6728 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 1200X Fairfax Ave | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | |||
115416 | 115416 | 23685 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 330 Virginia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006867.213435099 | 2098039.8280465 | 37.741206118003504 | -122.418840582769 | (37.7412061180035, -122.418840582769) | |||
137956 | 137956 | 72077 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 140 20th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/14/1984 12:00:00 AM | 12 | 5989623.30395 | 2114484.58501 | 37.785372951377894 | -122.479666163956 | (37.7853729513779, -122.479666163956) | ||
140509 | 140509 | 114146 | Significant Tree 6 | Acacia longifolia :: Golden Wattle 140 | 1200x JUNIPERO SERRA BLVD | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
140917 | 140917 | 22125 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 3795X 03rd St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015845.491830001 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | |||
144493 | 144493 | 22130 | DPW Maintained 3 | Acacia longifolia :: Golden Wattle 140 | 3795X 03rd St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015845.491830001 | 2098416.12541 | 37.7427407998196 | -122.387822870352 | (37.7427407998196, -122.387822870352) | |||
147482 | 147482 | 120027 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 5250 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5987077.12189 | 2109838.60933 | 37.7724681813772 | -122.488133553564 | (37.7724681813772, -122.488133553564) | |||
155811 | 155811 | 220118 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1000 San Jose Ave | 42 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6005108.5209099995 | 2097145.57569 | 37.738651520647295 | -122.424857914163 | (37.7386515206473, -122.424857914163) | ||||
170858 | 170858 | 188558 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1790 23rd St | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6013273.06711 | 2102892.5718 | 37.7548893269913 | -122.397031443052 | (37.7548893269913, -122.397031443052) | ||||
172611 | 172611 | 188562 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 3601 03rd St | 11 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6015968.542719999 | 2098749.82191 | 37.7436638776954 | -122.387420665355 | (37.7436638776954, -122.387420665355) | |||
179106 | 179106 | 188544 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1501 22nd St | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6013369.71631 | 2103799.38115 | 37.757384608426 | -122.396760769601 | (37.757384608426, -122.396760769601) | ||||
180800 | 180800 | 181699 | Undocumented 2 | Acacia longifolia :: Golden Wattle 140 | 1807 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5990039.1294 | 2107177.6156 | 37.765334173056104 | -122.477693245166 | (37.7653341730561, -122.477693245166) |
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");