Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
40 | 40 | 222540 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002573.08856 | 2099992.67614 | 37.74632546084511 | -122.433827665916 | (37.7463254608451, -122.433827665916) | |||
43 | 43 | 222539 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002564.39948 | 2099984.1142599997 | 37.7463014588556 | -122.433857099823 | (37.7463014588556, -122.433857099823) | |||
66 | 66 | 222538 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002556.19825 | 2099973.42317 | 37.746271638232 | -122.43388469462201 | (37.746271638232, -122.433884694622) | |||
25360 | 25360 | 188327 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012968.79067 | 2102886.92272 | 37.754856873149706 | -122.398083326981 | (37.7548568731497, -122.398083326981) | |||
26245 | 26245 | 204609 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1382 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5990541.2449199995 | 2105988.9613 | 37.7620995740555 | -122.475869749413 | (37.7620995740555, -122.475869749413) | |||
28171 | 28171 | 221347 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 115 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6009327.08226 | 2096770.42354 | 37.7378588087266 | -122.41024559558001 | (37.7378588087266, -122.41024559558) | |||
31367 | 31367 | 204614 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1255 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5990910.22691 | 2105165.14407 | 37.7598589779192 | -122.474533471065 | (37.7598589779192, -122.474533471065) | |||
32795 | 32795 | 204648 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 733 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5995892.41562 | 2089491.7886299998 | 37.71711119551271 | -122.456169405709 | (37.7171111955127, -122.456169405709) | |||
41865 | 41865 | 204668 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5997569.23018 | 2095279.46651 | 37.7330989075946 | -122.45079055604499 | (37.7330989075946, -122.450790556045) | |||
42503 | 42503 | 204633 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998410.37704 | 2094369.2089900002 | 37.7306476704498 | -122.447816990888 | (37.7306476704498, -122.447816990888) | |||
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) | |||
47579 | 47579 | 204671 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Monterey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5999561.20485 | 2094716.8073599997 | 37.7316678047194 | -122.443863381386 | (37.7316678047194, -122.443863381386) | |||
47824 | 47824 | 204629 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 223 Molimo Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 2ft | 5997855.18506 | 2096638.3314 | 37.7368463906537 | -122.449899836933 | (37.7368463906537, -122.449899836933) | |||
50641 | 50641 | 246815 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 182 Brewster St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6010185.45324 | 2098877.40442 | 37.74369220094071 | -122.407426274006 | (37.7436922009407, -122.407426274006) | |||
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) | |||
58559 | 58559 | 221337 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 26 Hidalgo Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6004997.11684 | 2107512.5522 | 37.7671105326404 | -122.425980872425 | (37.7671105326404, -122.425980872425) | |||
60064 | 60064 | 221336 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 385 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6005546.153 | 2106769.6455599996 | 37.765101701713704 | -122.42402900095 | (37.7651017017137, -122.42402900095) | |||
60191 | 60191 | 188333 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 300 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6013450.6432300005 | 2105637.1609900002 | 37.7624352541126 | -122.396609715869 | (37.7624352541126, -122.396609715869) | |||
63204 | 63204 | 204667 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997581.48097 | 2095279.2111 | 37.7330989075759 | -122.45074818359899 | (37.7330989075759, -122.450748183599) | |||
63668 | 63668 | 175754 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 12 Farragut Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5997730.99268 | 2086963.4604 | 37.7102743532383 | -122.449632264321 | (37.7102743532383, -122.449632264321) | |||
67938 | 67938 | 204649 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 508 Orizaba Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5994044.084530001 | 2090032.62859 | 37.7184899416364 | -122.46259736577 | (37.7184899416364, -122.46259736577) | |||
70295 | 70295 | 221361 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 118 College Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6004573.07294 | 2095957.02532 | 37.7353577716318 | -122.426624626942 | (37.7353577716318, -122.426624626942) | |||
71326 | 71326 | 221346 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 163 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6009130.79742 | 2096601.09316 | 37.737382859639794 | -122.41091229448601 | (37.7373828596398, -122.410912294486) | |||
71944 | 71944 | 204615 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1255 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5990928.50457 | 2105165.0384299997 | 37.7598597468563 | -122.474470250504 | (37.7598597468563, -122.474470250504) | |||
72610 | 72610 | 204630 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 304 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5997471.23605 | 2094490.2943 | 37.7309264189197 | -122.45107245665501 | (37.7309264189197, -122.451072456655) | |||
72824 | 72824 | 221349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Ellert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6007249.14169 | 2097018.19512 | 37.7384224381557 | -122.41744762190399 | (37.7384224381557, -122.417447621904) | |||
73514 | 73514 | 188348 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 135 Bridgeview Dr | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 2ft | 6013321.68612 | 2095651.6396700002 | 37.7350099660289 | -122.396355810291 | (37.7350099660289, -122.396355810291) | |||
130006 | 130006 | 204640 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 25 Edna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5998733.11218 | 2093060.00406 | 37.7270713418516 | -122.446607092452 | (37.7270713418516, -122.446607092452) | |||
130229 | 130229 | 204666 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 535 Mangels Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997878.67086 | 2095246.42281 | 37.7330258862214 | -122.449718361808 | (37.7330258862214, -122.449718361808) | |||
131290 | 131290 | 204620 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1440 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993064.41106 | 2105672.78897 | 37.7613774166458 | -122.467120173251 | (37.7613774166458, -122.467120173251) | |||
131647 | 131647 | 175755 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 10 Ruth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6001686.67815 | 2091578.8653 | 37.7231727394058 | -122.43629071923401 | (37.7231727394058, -122.436290719234) | |||
132718 | 132718 | 188329 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1850 23rd St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6012894.83022 | 2102885.3269599997 | 37.7548483718617 | -122.398338992565 | (37.7548483718617, -122.398338992565) | |||
134307 | 134307 | 204647 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 64 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5996124.76777 | 2089322.40375 | 37.716659439069794 | -122.455354045254 | (37.7166594390698, -122.455354045254) | |||
136620 | 136620 | 188304 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 601 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6015659.791809999 | 2105320.44232 | 37.7616883131784 | -122.38894690567801 | (37.7616883131784, -122.388946905678) | |||
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) | |||
146446 | 146446 | 204634 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998426.7778900005 | 2094369.13977 | 37.7306484177936 | -122.44776028591002 | (37.7306484177936, -122.44776028591) | |||
147889 | 147889 | 204616 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 621 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5993775.2241 | 2107303.2691599997 | 37.7658952931499 | -122.46478019575198 | (37.7658952931499, -122.464780195752) | |||
149380 | 149380 | 204617 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 621 Lincoln Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5993792.5560800005 | 2107303.5698 | 37.7658971178728 | -122.464720270343 | (37.7658971178728, -122.464720270343) | |||
150799 | 150799 | 175784 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6006219.087180001 | 2093598.2968400002 | 37.7289741427237 | -122.420766335217 | (37.7289741427237, -122.420766335217) | |||
158419 | 158419 | 204619 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1367 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5994238.00536 | 2106214.43805 | 37.762932317501004 | -122.463100533768 | (37.762932317501, -122.463100533768) | |||
159939 | 159939 | 188347 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 83 Scotia Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011997.83069 | 2095044.25145 | 37.7332684477844 | -122.400890216316 | (37.7332684477844, -122.400890216316) | |||
165867 | 165867 | 188339 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6011007.54195 | 2094765.98142 | 37.7324490889606 | -122.40429435530301 | (37.7324490889606, -122.404294355303) | |||
167180 | 167180 | 188340 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2080 Silver Ave | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 2ft | 6012583.4784699995 | 2096093.4959599997 | 37.7361821046275 | -122.39893907508801 | (37.7361821046275, -122.398939075088) | |||
169960 | 169960 | 188332 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 288 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013443.0879999995 | 2105758.2954 | 37.7627674420819 | -122.396644338879 | (37.7627674420819, -122.396644338879) | |||
170117 | 170117 | 204631 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998374.865180001 | 2094370.4925900002 | 37.7306491651061 | -122.447939852652 | (37.7306491651061, -122.447939852652) | |||
175059 | 175059 | 204610 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1410 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5990554.31015 | 2105766.55939 | 37.7614896754309 | -122.47580832029499 | (37.7614896754309, -122.475808320295) | |||
176762 | 176762 | 175785 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 741 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6006201.21806 | 2093598.82119 | 37.7289745752989 | -122.420828147413 | (37.7289745752989, -122.420828147413) | |||
178908 | 178908 | 204632 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 451 Hearst Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998393.17334 | 2094370.1114700001 | 37.7306491651244 | -122.447876531394 | (37.7306491651244, -122.447876531394) | |||
182374 | 182374 | 188342 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2335 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 21 | Width 2ft | 6013082.28487 | 2096418.14951 | 37.7371013178729 | -122.397237243906 | (37.7371013178729, -122.397237243906) | |||
185934 | 185934 | 188326 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1810 23rd St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 2ft | 6012985.7528099995 | 2102888.64274 | 37.7548625406828 | -122.39802478743799 | (37.7548625406828, -122.398024787438) | |||
187499 | 187499 | 204621 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1481 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993335.30038 | 2105432.94132 | 37.7607344904344 | -122.466165857685 | (37.7607344904344, -122.466165857685) | |||
188602 | 188602 | 204669 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5997556.3797699995 | 2095278.95948 | 37.7330967797945 | -122.45083494657 | (37.7330967797945, -122.45083494657) |
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");