Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, DBH, PlotSize
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
131206 | 131206 | 179380 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 77 Santa Cruz Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 3ft | 5993077.06779 | 2086425.7469099998 | 37.7085305695939 | -122.46567800964199 | (37.7085305695939, -122.465678009642) | |||
135936 | 135936 | 214037 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 510 Ramsell St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 5ft | 5993017.248790001 | 2090566.81293 | 37.719897493047704 | -122.466185481793 | (37.7198974930477, -122.466185481793) | |||
47685 | 47685 | 214042 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 22 Gennessee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 5997465.40478 | 2093699.4723200002 | 37.728754675784394 | -122.451035610522 | (37.7287546757844, -122.451035610522) | |||
64497 | 64497 | 214035 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 142 Staples Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 5999120.59989 | 2093807.09624 | 37.72914480888021 | -122.445321250796 | (37.7291448088802, -122.445321250796) | ||||
97449 | 97449 | 102592 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | FUF 1 | 04/17/2010 12:00:00 AM | 3 | 6x6 | 6000765.0 | 2094428.0 | 37.7309433983829 | -122.439680933747 | (37.7309433983829, -122.439680933747) | |
48717 | 48717 | 214026 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 124 Baden St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000776.43659 | 2094502.29985 | 37.7311480595383 | -122.43964672023199 | (37.7311480595383, -122.439646720232) | |||
137888 | 137888 | 214039 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 57 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6000414.26094 | 2095519.5651200002 | 37.7339206127394 | -122.440971772322 | (37.7339206127394, -122.440971772322) | |||
175014 | 175014 | 240397 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1636 Diamond St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6001997.9354 | 2099211.95257 | 37.744149123094104 | -122.43576062557301 | (37.7441491230941, -122.435760625573) | |||
182820 | 182820 | 240398 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1636 Diamond St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6002001.74432 | 2099212.54095 | 37.74415095500439 | -122.43574749727301 | (37.7441509550044, -122.435747497273) | |||
168253 | 168253 | 240399 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1636 Diamond St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6002005.77197 | 2099212.90242 | 37.7441521762959 | -122.43573359642201 | (37.7441521762959, -122.435733596422) | |||
66165 | 66165 | 186237 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984808.8655 | 2103347.0431 | 37.7545115739121 | -122.495500689099 | (37.7545115739121, -122.495500689099) | |||
37930 | 37930 | 186236 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984809.6691 | 2103350.7929 | 37.75452191688171 | -122.495498186629 | (37.7545219168817, -122.495498186629) | |||
175663 | 175663 | 186234 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984803.2409 | 2103355.3462 | 37.7545340425765 | -122.495520752512 | (37.7545340425765, -122.495520752512) | |||
145225 | 145225 | 186232 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1701 Sunset Blvd | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984802.7052 | 2103358.5602 | 37.754542835963505 | -122.49552284211201 | (37.7545428359635, -122.495522842112) | |||
158949 | 158949 | 197336 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 651 Missouri St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 6013643.57223 | 2103811.4939599996 | 37.757433106182 | -122.39581450923201 | (37.757433106182, -122.395814509232) | ||||
137254 | 137254 | 124092 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 601 Funston Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5991890.07496 | 2111196.5227799998 | 37.776476251963295 | -122.47158420369101 | (37.7764762519633, -122.471584203691) | ||||
44795 | 44795 | 122290 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990062.61204 | 2111318.0216900003 | 37.7767039596239 | -122.47791473389799 | (37.7767039596239, -122.477914733898) | |||
129693 | 129693 | 122288 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990072.179690001 | 2111319.40231 | 37.776708305720796 | -122.477881737882 | (37.7767083057208, -122.477881737882) | |||
36999 | 36999 | 122289 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990067.41245 | 2111319.5030799997 | 37.7767083057233 | -122.477898236364 | (37.7767083057233, -122.477898236364) | |||
46494 | 46494 | 122286 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990082.62166 | 2111319.5038 | 37.7767091904138 | -122.477845623834 | (37.7767091904138, -122.477845623834) | |||
58619 | 58619 | 122287 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990077.48759 | 2111319.8179099998 | 37.776709754904104 | -122.477863406875 | (37.7767097549041, -122.477863406875) | |||
187748 | 187748 | 122285 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990089.24883 | 2111319.7381700003 | 37.7767102185501 | -122.477822715879 | (37.7767102185501, -122.477822715879) | |||
65759 | 65759 | 122284 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990094.44484 | 2111319.9709799998 | 37.776711159339705 | -122.47780475856199 | (37.7767111593397, -122.477804758562) | |||
30089 | 30089 | 122281 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990111.6262 | 2111320.57885 | 37.7767138255075 | -122.477745368245 | (37.7767138255075, -122.477745368245) | |||
36460 | 36460 | 122283 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990098.96698 | 2111321.01529 | 37.7767142891731 | -122.477789191669 | (37.7767142891731, -122.477789191669) | |||
50462 | 50462 | 122282 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990106.33926 | 2111321.3026900003 | 37.7767155061466 | -122.477763710061 | (37.7767155061466, -122.477763710061) | |||
135749 | 135749 | 122280 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990124.518680001 | 2111321.36168 | 37.776716723141206 | -122.477700827061 | (37.7767167231412, -122.477700827061) | |||
39998 | 39998 | 122277 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990139.99053 | 2111321.69927 | 37.7767185479371 | -122.477647330613 | (37.7767185479371, -122.477647330613) | |||
72433 | 72433 | 122278 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990134.53204 | 2111321.8992 | 37.776718780123794 | -122.477666227559 | (37.7767187801238, -122.477666227559) | |||
137258 | 137258 | 122279 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1750 Balboa St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 5990130.41151 | 2111322.13937 | 37.7767192004406 | -122.477680499098 | (37.7767192004406, -122.477680499098) | |||
167275 | 167275 | 136317 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 954 Vallejo St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 6008931.36114 | 2118725.70113 | 37.798120717152294 | -122.413165857925 | (37.7981207171523, -122.413165857925) | |||
56127 | 56127 | 136318 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2431 Jones St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6007955.59027 | 2120758.45752 | 37.803647329033105 | -122.416686400679 | (37.8036473290331, -122.416686400679) | |||
165341 | 165341 | 136319 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 North Point St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6010537.589980001 | 2122003.14861 | 37.8072098224406 | -122.40783904035901 | (37.8072098224406, -122.407839040359) | |||
149725 | 149725 | 136320 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 North Point St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6010568.43745 | 2122006.8054400003 | 37.8072215900736 | -122.40773254351801 | (37.8072215900736, -122.407732543518) |
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");