Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9360 | 9360 | 3447 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 26 Cameo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999491.3304257 | 2099768.5267533 | 37.7455346409258 | -122.44446787703998 | (37.7455346409258, -122.44446787704) | |||
13092 | 13092 | 27221 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 385 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 10 | 3x3 | 6003913.32371 | 2093508.9041799998 | 37.7285984608493 | -122.428731161129 | (37.7285984608493, -122.428731161129) | ||
15602 | 15602 | 101156 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013453.7614400005 | 2105247.5910900002 | 37.7613657542352 | -122.39657162148501 | (37.7613657542352, -122.396571621485) | |||
16317 | 16317 | 101158 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490X 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6x5 | 6013408.6905 | 2105245.2503299997 | 37.7613568185891 | -122.396727339995 | (37.7613568185891, -122.396727339995) | |||
17253 | 17253 | 26483 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 148 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/29/2001 12:00:00 AM | 10 | 3X3 | 6001028.50664 | 2098685.10655 | 37.7426474144589 | -122.43907493846001 | (37.7426474144589, -122.43907493846) | ||
25248 | 25248 | 188298 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6007537.97287 | 2109701.89036 | 37.7732652094644 | -122.41734758044 | (37.7732652094644, -122.41734758044) | |||
27115 | 27115 | 175782 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 769 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006531.05237 | 2093633.80708 | 37.729089224484795 | -122.419690364741 | (37.7290892244848, -122.419690364741) | |||
33995 | 33995 | 244917 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1350 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999690.9856 | 2108819.5575 | 37.7703979319451 | -122.444427856782 | (37.7703979319451, -122.444427856782) | |||
41975 | 41975 | 65113 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 363 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | 10 | Permit Number 27082 | 5989323.435380001 | 2112903.08855 | 37.781013182321104 | -122.480587794991 | (37.7810131823211, -122.480587794991) | |
45243 | 45243 | 221339 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002975.42772 | 2099463.08044 | 37.744894137656395 | -122.43239860720699 | (37.7448941376564, -122.432398607207) | |||
46539 | 46539 | 221335 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1641 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010542.34793 | 2100138.1982400003 | 37.7471740359465 | -122.406281026071 | (37.7471740359465, -122.406281026071) | |||
51832 | 51832 | 222565 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 111 Precita Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6007123.52166 | 2100080.2988 | 37.7468232221335 | -122.418098981082 | (37.7468232221335, -122.418098981082) | |||
52367 | 52367 | 175777 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 281 Vienna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004127.09808 | 2091752.9850700002 | 37.7237891931904 | -122.42786706372601 | (37.7237891931904, -122.427867063726) | |||
53234 | 53234 | 188328 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1850 23rd St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 2ft | 6012921.09525 | 2102885.8261700002 | 37.754851205638204 | -122.39824819520099 | (37.7548512056382, -122.398248195201) | |||
67038 | 67038 | 69446 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 443 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/16/1994 12:00:00 AM | 10 | Permit Number 33556 | 5985911.814680001 | 2112907.20872 | 37.7808256288006 | -122.492390419974 | (37.7808256288006, -122.492390419974) | |
68091 | 68091 | 204660 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Vista Verde Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5999210.558230001 | 2096011.88167 | 37.7352037663304 | -122.445168706887 | (37.7352037663304, -122.445168706887) | |||
70818 | 70818 | 244038 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 555 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998455.5537 | 2108692.7156 | 37.769979089028 | -122.44869206228 | (37.769979089028, -122.44869206228) | |||
72565 | 72565 | 116874 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6012413.67241 | 2104134.33813 | 37.7582510683591 | -122.400090692038 | (37.7582510683591, -122.400090692038) | |||
73669 | 73669 | 204638 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 181 Staples Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 1ft | 5998850.558130001 | 2093801.2422 | 37.729113316421106 | -122.44625438283701 | (37.7291133164211, -122.446254382837) | |||
80689 | 80689 | 106706 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 199X BRIGHTON AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5996224.0 | 2090880.0 | 37.7209419254054 | -122.455123542447 | (37.7209419254054, -122.455123542447) | |||
83690 | 83690 | 57741 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/1976 12:00:00 AM | 10 | 3x3 | Permit Number 16659 | 6001762.0 | 2096689.0 | 37.7372082800729 | -122.436395904515 | (37.7372082800729, -122.436395904515) | |
121613 | 121613 | 116354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 10 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | |||
126416 | 126416 | 57436 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4331 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 10 | 3x3 | Permit Number 32868 | 6001612.33019827 | 2105235.34197744 | 37.760665996510895 | -122.437525222221 | (37.7606659965109, -122.437525222221) |
134470 | 134470 | 56725 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1519 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6015793.5491 | 2095580.2933 | 37.734951304754404 | -122.387804649295 | (37.7349513047544, -122.387804649295) | ||||
139274 | 139274 | 222597 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 62 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002444.78145 | 2096589.2048099998 | 37.7369730385666 | -122.434028087935 | (37.7369730385666, -122.434028087935) | |||
140025 | 140025 | 116347 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 10 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | |||
151938 | 151938 | 222546 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2825 Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002452.45425 | 2095510.12485 | 37.734010568315 | -122.433924450977 | (37.734010568315, -122.433924450977) | |||
154132 | 154132 | 123824 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1665 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993487.5757 | 2112056.30859 | 37.7789292839599 | -122.466120533372 | (37.7789292839599, -122.466120533372) | |||
167932 | 167932 | 221364 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1243 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001375.81776 | 2100058.24789 | 37.7464374920934 | -122.437972374152 | (37.7464374920934, -122.437972374152) | |||
174106 | 174106 | 47486 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 165 Capistrano Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/2002 12:00:00 AM | 10 | Permit Number 45383 | 6001387.26681 | 2093436.23595 | 37.7282556401779 | -122.437458665212 | (37.7282556401779, -122.437458665212) | ||
175314 | 175314 | 222507 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1266 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6010033.6534 | 2101840.39608 | 37.7518194273238 | -122.40816009111099 | (37.7518194273238, -122.408160091111) | |||
185052 | 185052 | 32483 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 76 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 10 | Permit Number 36991 | 6001817.389140001 | 2106232.68155 | 37.763416104203 | -122.436887416735 | (37.763416104203, -122.436887416735) | |
185091 | 185091 | 221324 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006261.00789 | 2104075.99736 | 37.7577459083505 | -122.421365183881 | (37.7577459083505, -122.421365183881) | |||
187374 | 187374 | 36805 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1450 Donner Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1998 12:00:00 AM | 10 | Permit Number 39531 | 6014737.8573 | 2091203.2549 | 37.7228743001584 | -122.39114872971001 | (37.7228743001584, -122.39114872971) |
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");