Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28410 | 28410 | 90302 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4301 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982209.19544 | 2110968.11871 | 37.7752842914116 | -122.505055622528 | (37.7752842914116, -122.505055622528) | ||
72157 | 72157 | 90962 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4449X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981706.97988 | 2110951.27348 | 37.775208478371795 | -122.50679162128799 | (37.7752084783718, -122.506791621288) | ||
81139 | 81139 | 90936 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4100X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982849.80185 | 2111047.09005 | 37.7755387934026 | -122.50284550193001 | (37.7755387934026, -122.50284550193) | ||
83050 | 83050 | 90960 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4501X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981602.01998 | 2110947.6937700002 | 37.7751924682496 | -122.507154429295 | (37.7751924682496, -122.507154429295) | ||
83698 | 83698 | 90303 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4245 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982349.2104 | 2110976.0949 | 37.775314428577104 | -122.504571877962 | (37.7753144285771, -122.504571877962) | ||
89759 | 89759 | 90953 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4801 Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980721.4437 | 2110922.404993 | 37.7750711298852 | -122.51019860597499 | (37.7750711298852, -122.510198605975) | |
90374 | 90374 | 90942 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4300X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982230.5488599995 | 2111028.62265 | 37.775451673862705 | -122.50498624204201 | (37.7754516738627, -122.504986242042) | ||
90726 | 90726 | 90955 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4715 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980930.336730001 | 2110922.83667 | 37.7750846348075 | -122.509476044277 | (37.7750846348075, -122.509476044277) | ||
94592 | 94592 | 90289 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4800X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5980602.31718 | 2110965.89815 | 37.775183521648295 | -122.510613916 | (37.7751835216483, -122.510613916) | ||
94905 | 94905 | 90967 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4201X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982528.42581 | 2110981.00259 | 37.775338443745206 | -122.503952304501 | (37.7753384437452, -122.503952304501) | ||
97356 | 97356 | 90969 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4101 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/2008 12:00:00 AM | 3 | 3x3 | 5982841.37806 | 2110990.2516 | 37.7753822364855 | -122.502870432858 | (37.7753822364855, -122.502870432858) | ||
98392 | 98392 | 90963 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4401 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981890.20294 | 2110958.3206700003 | 37.775238615568206 | -122.50615834497299 | (37.7752386155682, -122.506158344973) | ||
98657 | 98657 | 90949 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4722 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5980898.401459999 | 2110978.10011 | 37.7752344887776 | -122.50959061899799 | (37.7752344887776, -122.509590618998) | ||
98931 | 98931 | 90940 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4200 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982543.99778 | 2111038.2195900003 | 37.7754964606088 | -122.50390267706301 | (37.7754964606088, -122.503902677063) | ||
99416 | 99416 | 90308 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4149X Balboa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982646.10209 | 2110983.28462 | 37.7753516285836 | -122.503545410793 | (37.7753516285836, -122.503545410793) | ||
99421 | 99421 | 90959 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4545X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981520.769284 | 2110951.300184 | 37.7751975846267 | -122.50743575643 | (37.7751975846267, -122.50743575643) | |
101073 | 101073 | 90950 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4800X Balboa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5980719.9984720005 | 2110962.3788759997 | 37.775180801106295 | -122.510206575867 | (37.7751808011063, -122.510206575867) | |
104482 | 104482 | 90937 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4100X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982831.60605 | 2111046.13868 | 37.7755351118189 | -122.50290837410401 | (37.7755351118189, -122.502908374104) | ||
107566 | 107566 | 90958 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4605 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5981330.506527999 | 2110944.422301 | 37.775167490626 | -122.508093395898 | (37.775167490626, -122.508093395898) | |
107906 | 107906 | 90947 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4600 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5981278.80363 | 2110991.6072400003 | 37.7752939998625 | -122.508275747758 | (37.7752939998625, -122.508275747758) | ||
109118 | 109118 | 90951 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4899X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5980415.19176 | 2110911.332666 | 37.775022659049704 | -122.51125715579398 | (37.7750226590497, -122.511257155794) | |
109759 | 109759 | 90944 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4400X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5981920.42538 | 2111017.17058 | 37.77540197926729 | -122.50605816485701 | (37.7754019792673, -122.506058164857) | ||
111272 | 111272 | 90945 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4400X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5981901.556969999 | 2111016.23426 | 37.7753982976987 | -122.50612336454701 | (37.7753982976987, -122.506123364547) | ||
112190 | 112190 | 90952 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4801 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980655.2652199995 | 2110913.31037 | 37.775042254876496 | -122.51042685173799 | (37.7750422548765, -122.510426851738) | ||
113393 | 113393 | 98811 | Permitted Site 1 | Dracaena draco :: Dragon Tree 361 | 290 Napoleon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011846.1 | 2099745.4 | 37.746168339590795 | -122.40174512237199 | (37.7461683395908, -122.401745122372) | ||||
115069 | 115069 | 90943 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4300X Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982210.57322 | 2111028.38039 | 37.7754498334281 | -122.505055323382 | (37.7754498334281, -122.505055323382) | ||
124883 | 124883 | 90941 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4248 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982339.24082 | 2111032.77391 | 37.7754694661516 | -122.504610564793 | (37.7754694661516, -122.504610564793) | ||
125607 | 125607 | 90948 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4640 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5981162.97246 | 2110989.4012 | 37.7752811160997 | -122.508676263409 | (37.7752811160997, -122.508676263409) | ||
126506 | 126506 | 90946 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4508 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5981586.89956 | 2111002.64862 | 37.7753424675657 | -122.507210811154 | (37.7753424675657, -122.507210811154) | ||
140044 | 140044 | 90954 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4715 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5980949.82194 | 2110923.96182 | 37.775088873070395 | -122.509408725446 | (37.7750888730704, -122.509408725446) | ||
144806 | 144806 | 90964 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4351 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982021.66913 | 2110961.16187 | 37.7752541549476 | -122.505703792045 | (37.7752541549476, -122.505703792045) | ||
145717 | 145717 | 90938 | DPW Maintained 3 | Dracaena draco :: Dragon Tree 361 | 4100X Balboa St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/11/2008 12:00:00 AM | 3 | 3x3 | 5982813.887730001 | 2111046.51795 | 37.7755351118152 | -122.502969693111 | (37.7755351118152, -122.502969693111) |
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");