Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
22764 | 22764 | 23385 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006030.41853 | 2115547.69719 | 37.7892314313446 | -122.42297798933599 | (37.7892314313446, -122.422977989336) | |||
19863 | 19863 | 27655 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006765.6884 | 2108667.1143 | 37.770380480168704 | -122.419945578015 | (37.7703804801687, -122.419945578015) | |||
113966 | 113966 | 77633 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 8 | 3x3 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) | |
12092 | 12092 | 77648 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.147419999 | 2093142.9824700002 | 37.727757638780204 | -122.418666516263 | (37.7277576387802, -122.418666516263) | |
86463 | 86463 | 96884 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
131687 | 131687 | 98655 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 6 | 5x5 | 6002650.75991 | 2119226.56813 | 37.799141375727295 | -122.434934390513 | (37.7991413757273, -122.434934390513) | ||
80701 | 80701 | 99678 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1250X Shrader St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 4x4 | Permit Number 770537 | 5997882.0 | 2106337.7 | 37.7634800016896 | -122.450506162624 | (37.7634800016896, -122.450506162624) | |
101167 | 101167 | 102154 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x4 | 6008490.5 | 2096648.5 | 37.7374771037155 | -122.413129459512 | (37.7374771037155, -122.413129459512) | ||
122481 | 122481 | 102195 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
77610 | 77610 | 109992 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 501X Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
159062 | 159062 | 122138 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.47453486398899 | (37.7868169072323, -122.474534863989) | ||||
122326 | 122326 | 122412 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
164318 | 164318 | 129564 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2399 North Point St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5999360.9422 | 2120457.57627 | 37.802334054437104 | -122.446406844005 | (37.8023340544371, -122.446406844005) | |||
4614 | 4614 | 129652 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009798.02273 | 2121850.3999900003 | 37.80674898193529 | -122.41038769114401 | (37.8067489819353, -122.410387691144) | |||
60959 | 60959 | 129661 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009779.91781 | 2121666.56674 | 37.8062432068281 | -122.41043735801 | (37.8062432068281, -122.41043735801) | |||
187414 | 187414 | 129671 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009327.569680001 | 2121786.16938 | 37.8065462369833 | -122.41201124983101 | (37.8065462369833, -122.412011249831) | |||
97569 | 97569 | 177058 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998964.8504 | 2090194.5720900001 | 37.7192167629302 | -122.44560001362801 | (37.7192167629302, -122.445600013628) | |||
44444 | 44444 | 177130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6006962.9694300005 | 2093340.1251400001 | 37.7283071587297 | -122.41817637676 | (37.7283071587297, -122.41817637676) | |||
51641 | 51641 | 191459 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6014515.877119999 | 2115897.3284299998 | 37.790666595532606 | -122.393643582697 | (37.7906665955326, -122.393643582697) | |||
167259 | 167259 | 207824 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Staples Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998157.01661 | 2093811.48705 | 37.7291018131794 | -122.44865273895901 | (37.7291018131794, -122.448652738959) | |||
52361 | 52361 | 207866 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 374 Irving St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5995689.6925099995 | 2106690.80313 | 37.7643238106111 | -122.458114159946 | (37.7643238106111, -122.458114159946) | |||
41097 | 41097 | 207871 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5992427.77388 | 2104765.5037700003 | 37.7588494808325 | -122.46925597679399 | (37.7588494808325, -122.469255976794) | |||
66231 | 66231 | 207904 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991482.67128 | 2097068.4954400002 | 37.737660831087496 | -122.47196355577299 | (37.7376608310875, -122.471963555773) | |||
27197 | 27197 | 207942 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992674.85425 | 2100498.92504 | 37.7471488342516 | -122.468091108325 | (37.7471488342516, -122.468091108325) | |||
151233 | 151233 | 208000 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999487.481380001 | 2094942.52217 | 37.732283359186894 | -122.444134470345 | (37.7322833591869, -122.444134470345) | |||
41229 | 41229 | 227220 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Shotwell St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007878.47133 | 2104829.72546 | 37.7599065331661 | -122.41582468195601 | (37.7599065331661, -122.415824681956) | |||
46512 | 46512 | 227338 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3915 Folsom St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008438.44095 | 2096875.5776400003 | 37.738097686665895 | -122.41332550648998 | (37.7380976866659, -122.41332550649) | |||
49010 | 49010 | 227460 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 198 Corbin Pl | 9 | Side Yard : Yard 17 | Tree 1 | Private 1 | 13 | Width 3ft | 6000080.81195 | 2105721.26672 | 37.7619130330842 | -122.442856931222 | (37.7619130330842, -122.442856931222) | |||
169755 | 169755 | 250116 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006001.66865 | 2115410.83979 | 37.7888540326289 | -122.42306772909299 | (37.7888540326289, -122.423067729093) |
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");