Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
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) | |||
27078 | 27078 | 188288 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6010227.812000001 | 2110667.04277 | 37.7760662630739 | -122.40811110056299 | (37.7760662630739, -122.408111100563) | |||
28372 | 28372 | 204655 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 452 Victoria St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 5993265.60688 | 2090192.2995 | 37.7188834957636 | -122.46529981143298 | (37.7188834957636, -122.465299811433) | |||
28539 | 28539 | 188302 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008239.71976 | 2109507.11568 | 37.7727698610843 | -122.414906347362 | (37.7727698610843, -122.414906347362) | |||
30747 | 30747 | 188322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.75696789675921 | -122.39901232755399 | (37.7569678967592, -122.399012327554) | |||
34214 | 34214 | 188320 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.93717 | 2103702.00953 | 37.7570807814757 | -122.399018435778 | (37.7570807814757, -122.399018435778) | |||
34236 | 34236 | 188300 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008269.7706 | 2109537.20803 | 37.7728541761188 | -122.41480452791001 | (37.7728541761188, -122.41480452791) | |||
35460 | 35460 | 188321 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012714.29279 | 2103681.1367599997 | 37.757023433506 | -122.399019199302 | (37.757023433506, -122.399019199302) | |||
38034 | 38034 | 188335 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6013335.43042 | 2105239.42727 | 37.761336752 | -122.396980309397 | (37.761336752, -122.396980309397) | |||
38900 | 38900 | 222499 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 301 Webster St | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004137.32896 | 2109855.92191 | 37.7734962273111 | -122.429121852705 | (37.7734962273111, -122.429121852705) | |||
41982 | 41982 | 188330 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 214 Texas St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6013707.236830001 | 2106019.4851599997 | 37.763499309471506 | -122.395749036807 | (37.7634993094715, -122.395749036807) | |||
43337 | 43337 | 204651 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 27 Majestic Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997399.75585 | 2089775.82239 | 37.7179774953307 | -122.45097974552401 | (37.7179774953307, -122.450979745524) | |||
44147 | 44147 | 188289 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009413.38466 | 2109546.86827 | 37.772944891630104 | -122.41084930056101 | (37.7729448916301, -122.410849300561) | |||
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) | |||
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) | |||
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) | |||
53807 | 53807 | 188319 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012713.14067 | 2103722.27252 | 37.7571363191045 | -122.39902607101001 | (37.7571363191045, -122.39902607101) | |||
54041 | 54041 | 188299 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1022 Minna St | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6007530.7890099995 | 2109693.3141 | 37.7732412569071 | -122.41737182255501 | (37.7732412569071, -122.417371822555) | |||
60381 | 60381 | 188345 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 8 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6012515.97712 | 2096106.6824400001 | 37.73621455036071 | -122.399173381754 | (37.7362145503607, -122.399173381754) | |||
61563 | 61563 | 247044 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6002079.830030001 | 2099170.11996 | 37.74403891207071 | -122.43547446040199 | (37.7440389120707, -122.435474460402) | |||
62206 | 62206 | 188301 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6008261.50029 | 2109526.90873 | 37.772825431974894 | -122.41483240691002 | (37.7728254319749, -122.41483240691) | |||
64408 | 64408 | 188294 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6008162.78535 | 2108877.84718 | 37.771037714636705 | -122.415127922313 | (37.7710377146367, -122.415127922313) | |||
65817 | 65817 | 188323 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012718.59247 | 2103642.7954599997 | 37.7569183962771 | -122.399001638237 | (37.7569183962771, -122.399001638237) | |||
68007 | 68007 | 188285 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010183.94442 | 2110713.51419 | 37.776191406445705 | -122.40826612929199 | (37.7761914064457, -122.408266129292) | |||
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) | |||
68710 | 68710 | 188336 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1490 19th St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 5ft | 6013315.97127 | 2105238.81397 | 37.7613339848017 | -122.39704756789101 | (37.7613339848017, -122.397047567891) | |||
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) | |||
74635 | 74635 | 188296 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6008131.8967699995 | 2108889.4185900004 | 37.7710677511061 | -122.41523558646601 | (37.7710677511061, -122.415235586466) | |||
129616 | 129616 | 188290 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6009398.69382 | 2109531.26602 | 37.7729012277415 | -122.410899015985 | (37.7729012277415, -122.410899015985) | |||
131404 | 131404 | 247045 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 596 Valley St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6002079.02681 | 2099155.53035 | 37.7439988068049 | -122.435476194275 | (37.7439988068049, -122.435476194275) | |||
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) | |||
136161 | 136161 | 188344 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 7 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6012532.5163 | 2096115.8290099998 | 37.7362405866356 | -122.39911684046301 | (37.7362405866356, -122.399116840463) | |||
136815 | 136815 | 188343 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2055 Silver Ave | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012604.8118 | 2096159.0938799998 | 37.736363411533496 | -122.398869919026 | (37.7363634115335, -122.398869919026) | |||
149455 | 149455 | 188292 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 4 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 6009353.5292 | 2109489.65006 | 37.772784427403 | -122.411052306329 | (37.772784427403, -122.411052306329) | |||
150539 | 150539 | 188297 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6008118.01492 | 2108896.99552 | 37.771087775398705 | -122.415284140848 | (37.7710877753987, -122.415284140848) | |||
152265 | 152265 | 188341 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2351 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6013156.07372 | 2096444.5663599998 | 37.737177960788706 | -122.396983972339 | (37.7371779607887, -122.396983972339) | |||
154732 | 154732 | 204656 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 5993464.3561 | 2089166.2811200002 | 37.716077755750206 | -122.464538359982 | (37.7160777557502, -122.464538359982) | |||
155718 | 155718 | 188291 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 40 Sheridan St | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6009385.19996 | 2109515.63966 | 37.772857564751206 | -122.410944589137 | (37.7728575647512, -122.410944589137) | |||
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) | |||
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) | |||
164398 | 164398 | 188287 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010207.19158 | 2110684.55446 | 37.776113191502496 | -122.408183667747 | (37.7761131915025, -122.408183667747) | |||
164795 | 164795 | 188303 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 90 Kissling St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6008234.3659 | 2109502.33979 | 37.772756446777294 | -122.414924528938 | (37.7727564467773, -122.414924528938) | |||
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) | |||
174395 | 174395 | 188293 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 1 | : 4 | Tree 1 | Private 1 | 19 | Width 5ft | 6008175.899180001 | 2108871.2472900003 | 37.771020329842294 | -122.415082093787 | (37.7710203298423, -122.415082093787) | |||
175317 | 175317 | 188295 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 3 | : 4 | Tree 1 | Private 1 | 26 | Width 5ft | 6008148.21893 | 2108881.79172 | 37.771047726812604 | -122.41517858743799 | (37.7710477268126, -122.415178587438) | |||
175531 | 175531 | 188286 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 106 Langton St | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6010191.871780001 | 2110704.80693 | 37.776167942238295 | -122.408238092013 | (37.7761679422383, -122.408238092013) | |||
175761 | 175761 | 204654 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 222 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5992216.41936 | 2089361.24223 | 37.7165410523041 | -122.46886596240299 | (37.7165410523041, -122.468865962403) | |||
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) | |||
180781 | 180781 | 188349 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1764 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6014694.72418 | 2096821.3256 | 37.738297993561396 | -122.391690447682 | (37.7382979935614, -122.391690447682) | |||
181555 | 181555 | 204650 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 254 Howth St | 1 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 5997292.004269999 | 2090577.4247599998 | 37.720172339354704 | -122.451409977591 | (37.7201723393547, -122.451409977591) | |||
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) | |||
186252 | 186252 | 188346 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1716 Revere Ave | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6014499.65662 | 2094860.17735 | 37.7329022519179 | -122.39222777999399 | (37.7329022519179, -122.392227779994) |
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");