Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
17503 | 17503 | 15320 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2004 12:00:00 AM | 3 | 3X3 | 6006776.8374 | 2108697.9883 | 37.770465880950496 | -122.419909204722 | (37.7704658809505, -122.419909204722) | ||
22389 | 22389 | 23387 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1661 Pine St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6006004.3296300005 | 2115544.61706 | 37.7892215019103 | -122.423068034874 | (37.7892215019103, -122.423068034874) | |||
28423 | 28423 | 227193 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 434 Banks St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008555.86345 | 2096552.67511 | 37.7372176586621 | -122.412896693524 | (37.7372176586621, -122.412896693524) | |||
28430 | 28430 | 207999 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5999487.38528 | 2094945.2711599998 | 37.732290901786605 | -122.444135000045 | (37.7322909017866, -122.444135000045) | |||
29591 | 29591 | 207870 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1541 12th Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5992427.188159999 | 2104766.73387 | 37.7588528245185 | -122.469258092 | (37.7588528245185, -122.469258092) | |||
34184 | 34184 | 129681 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6012011.03614 | 2116789.35281 | 37.7929763782966 | -122.402372995143 | (37.7929763782966, -122.402372995143) | |||
34937 | 34937 | 250115 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6006022.685330001 | 2115414.2324599996 | 37.788864534007296 | -122.422995255427 | (37.7888645340073, -122.422995255427) | |||
41598 | 41598 | 227339 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3915 Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008435.918269999 | 2096862.8615 | 37.738062629287796 | -122.41333332967501 | (37.7380626292878, -122.413333329675) | |||
56238 | 56238 | 207903 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991490.36095 | 2097069.60585 | 37.7376643249521 | -122.471937050068 | (37.7376643249521, -122.471937050068) | |||
56715 | 56715 | 207986 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 714 Detroit St | 8 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 5999466.52885 | 2095410.65053 | 37.733567534417794 | -122.444240535497 | (37.7335675344178, -122.444240535497) | ||||
79176 | 79176 | 103608 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | |||
84624 | 84624 | 96883 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2200X San Jose Ave | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5998886.2 | 2091075.7 | 37.7216316467069 | -122.445935216513 | (37.7216316467069, -122.445935216513) | |||||
91870 | 91870 | 122411 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 499x Ocean Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998874.0 | 2091543.0 | 37.722914047867604 | -122.446010982458 | (37.7229140478676, -122.446010982458) | ||||
103689 | 103689 | 42990 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2X Yale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/05/2000 12:00:00 AM | 10 | 5x4 | Permit Number 42867 | 6006665.25419982 | 2093600.88939651 | 37.7290063985797 | -122.41922408324301 | (37.7290063985797, -122.419224083243) |
107003 | 107003 | 102193 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 18 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
117184 | 117184 | 98682 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
126306 | 126306 | 70470 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
128257 | 128257 | 113967 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 RHODE ISLAND ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011658.0 | 2107333.0 | 37.7669917162652 | -122.40292912289699 | (37.7669917162652, -122.402929122897) | ||||
154493 | 154493 | 227258 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 191 Park St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 2ft | 6005985.64044 | 2096389.9035099999 | 37.7366261169846 | -122.421771586598 | (37.7366261169846, -122.421771586598) | |||
155134 | 155134 | 207943 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992681.5782 | 2100498.78362 | 37.747148834263896 | -122.46806784736201 | (37.7471488342639, -122.468067847362) | |||
155190 | 155190 | 129670 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6009329.84162 | 2121764.6853 | 37.8064873745564 | -122.412001868104 | (37.8064873745564, -122.412001868104) | |||
156675 | 156675 | 177064 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 102 France Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 1ft | 6001373.70465 | 2090220.37665 | 37.7194248480604 | -122.437275380676 | (37.7194248480604, -122.437275380676) | |||
158501 | 158501 | 129660 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009777.616330001 | 2121686.62202 | 37.8062981445983 | -122.410446739741 | (37.8062981445983, -122.410446739741) | |||
161734 | 161734 | 207823 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Staples Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998174.84145 | 2093811.63794 | 37.7291032467189 | -122.448591128189 | (37.7291032467189, -122.448591128189) | |||
166567 | 166567 | 227271 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001729.3164800005 | 2099973.25035 | 37.7462242052805 | -122.436743934384 | (37.7462242052805, -122.436743934384) | |||
169954 | 169954 | 177129 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006955.53979 | 2093363.24603 | 37.7283702254814 | -122.418203699955 | (37.7283702254814, -122.418203699955) | |||
176396 | 176396 | 226687 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 22nd St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6011241.492219999 | 2103724.7897099997 | 37.757061113294704 | -122.40411580209499 | (37.7570611132947, -122.404115802095) | ||||
177642 | 177642 | 177057 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998963.193390001 | 2090191.18353 | 37.7192073641203 | -122.44560549771799 | (37.7192073641203, -122.445605497718) | |||
179227 | 179227 | 191458 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 3ft | 6014482.2077 | 2115927.0882900003 | 37.790746438249 | -122.393762161888 | (37.790746438249, -122.393762161888) | |||
181331 | 181331 | 191432 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 18th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6010899.91125 | 2105517.41089 | 37.761964158640396 | -122.405423368691 | (37.7619641586404, -122.405423368691) | ||||
182203 | 182203 | 122137 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991115.84231 | 2114982.60549 | 37.786826966306 | -122.47453884083001 | (37.786826966306, -122.47453884083) | ||||
185708 | 185708 | 120477 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 5988623.03819 | 2114641.82381 | 37.785746527658 | -122.483138270198 | (37.785746527658, -122.483138270198) |
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");