Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28542 | 28542 | 204628 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5992344.57273 | 2095377.42888 | 37.733067423224 | -122.46886055298701 | (37.733067423224, -122.468860552987) | |||
29847 | 29847 | 125882 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2100 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6005138.856380001 | 2116964.61432 | 37.7930715805281 | -122.42616360296302 | (37.7930715805281, -122.426163602963) | |||
30100 | 30100 | 188310 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 189 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012910.658530001 | 2106249.7856099997 | 37.764087318611395 | -122.39852032646499 | (37.7640873186114, -122.398520326465) | |||
32397 | 32397 | 125884 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008808.31826 | 2115292.9035099996 | 37.7886881877568 | -122.413348733254 | (37.7886881877568, -122.413348733254) | |||
33225 | 33225 | 188311 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 189 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012910.01504 | 2106269.57454 | 37.764141618776 | -122.398523940823 | (37.764141618776, -122.398523940823) | |||
40087 | 40087 | 125883 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 786 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008823.04151 | 2115295.3212900003 | 37.7886956530184 | -122.413297963833 | (37.7886956530184, -122.413297963833) | |||
41763 | 41763 | 222502 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2 Camp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6005857.93432 | 2106390.78551 | 37.764079039426704 | -122.42292369548599 | (37.7640790394267, -122.422923695486) | |||
46851 | 46851 | 125887 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 277 Willow St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6006289.37196 | 2113344.7288599997 | 37.7831972322057 | -122.42192548758301 | (37.7831972322057, -122.421925487583) | |||
47450 | 47450 | 125886 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 260 Willow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6006255.845480001 | 2113363.12878 | 37.7832458630397 | -122.42204278345699 | (37.7832458630397, -122.422042783457) | |||
50745 | 50745 | 188325 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012720.87909 | 2103581.41048 | 37.7567499739592 | -122.39898942183201 | (37.7567499739592, -122.398989421832) | |||
53944 | 53944 | 221365 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1190 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6001927.1952 | 2100682.80135 | 37.748183708409 | -122.43611046183099 | (37.748183708409, -122.436110461831) | |||
54861 | 54861 | 204642 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5995680.91746 | 2091957.8181099999 | 37.7238701852543 | -122.457078728228 | (37.7238701852543, -122.457078728228) | |||
56696 | 56696 | 188309 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012912.6135599995 | 2106204.46931 | 37.763962999012996 | -122.398510384468 | (37.763962999013, -122.398510384468) | |||
57424 | 57424 | 125888 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 575 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6008045.66737 | 2113749.49498 | 37.784407514645096 | -122.415878065725 | (37.7844075146451, -122.415878065725) | |||
58207 | 58207 | 204627 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992327.28359 | 2095380.5803 | 37.7330750773552 | -122.46892055484301 | (37.7330750773552, -122.468920554843) | |||
59966 | 59966 | 188338 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1580 Newhall St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6014174.61235 | 2095442.29815 | 37.7344825828894 | -122.39339227343001 | (37.7344825828894, -122.39339227343) | |||
61855 | 61855 | 175792 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009511.22188 | 2093372.0739 | 37.728537987719605 | -122.409369173844 | (37.7285379877196, -122.409369173844) | |||
62010 | 62010 | 188308 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012915.64836 | 2106174.8089400004 | 37.76388172727871 | -122.398497806527 | (37.7638817272787, -122.398497806527) | |||
63601 | 63601 | 125885 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 476 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6008153.2935 | 2113467.57124 | 37.7836394702246 | -122.415485749065 | (37.7836394702246, -122.415485749065) | |||
68293 | 68293 | 188331 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 612 Texas St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 4ft | 6013806.03622 | 2104232.11636 | 37.7585970807056 | -122.39528210428101 | (37.7585970807056, -122.395282104281) | |||
72456 | 72456 | 188317 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2200 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011501.39155 | 2104667.35812 | 37.759663715319704 | -122.403283270917 | (37.7596637153197, -122.403283270917) | |||
137747 | 137747 | 204626 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992297.08253 | 2095382.05199 | 37.7330773733083 | -122.46902507404499 | (37.7330773733083, -122.469025074045) | |||
152106 | 152106 | 204613 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1440 16th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5991174.12963 | 2105607.5581900002 | 37.7610890166517 | -122.47365304285401 | (37.7610890166517, -122.473653042854) | |||
155530 | 155530 | 221343 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 24 Alma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998466.64161 | 2106282.9763 | 37.7633631889881 | -122.448480141942 | (37.7633631889881, -122.448480141942) | |||
158669 | 158669 | 175791 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009517.433730001 | 2093353.53583 | 37.7284874341444 | -122.409346391343 | (37.7284874341444, -122.409346391343) | |||
158902 | 158902 | 188314 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 209 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6012920.39435 | 2106015.17263 | 37.7634436657274 | -122.39847018924999 | (37.7634436657274, -122.39847018925) | |||
159078 | 159078 | 175794 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6009502.30517 | 2093401.60497 | 37.7286185741876 | -122.409402082759 | (37.7286185741876, -122.409402082759) | |||
161577 | 161577 | 188334 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6013355.939119999 | 2105240.17326 | 37.7613399419185 | -122.396909430223 | (37.7613399419185, -122.396909430223) | |||
175592 | 175592 | 125889 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6006091.49195 | 2112832.09387 | 37.781778500422 | -122.42257363436501 | (37.781778500422, -122.422573634365) | |||
176001 | 176001 | 175793 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Holyoke St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009507.12766 | 2093386.74095 | 37.7285780309381 | -122.409384362505 | (37.7285780309381, -122.409384362505) | |||
179966 | 179966 | 188324 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 8 | : 4 | Tree 1 | Private 1 | 3 | Width 4ft | 6012719.06472 | 2103600.79409 | 37.756803096012 | -122.39899705709 | (37.756803096012, -122.39899705709) | |||
182888 | 182888 | 221350 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1050 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6008608.79456 | 2102405.13937 | 37.753290200197895 | -122.413127394812 | (37.7532902001979, -122.413127394812) | |||
185920 | 185920 | 204625 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1901 Monterey Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 5992281.41366 | 2095382.3817200002 | 37.733077373320896 | -122.469079268988 | (37.7330773733209, -122.469079268988) |
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");