Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2864 | 2864 | 209183 | Undocumented 2 | Tree(s) :: 17 | 140 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994862.40668 | 2098482.07156 | 37.741737150351 | -122.460380669142 | (37.741737150351, -122.460380669142) | |
2887 | 2887 | 209188 | Undocumented 2 | Tree(s) :: 17 | 156 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780524 | 5994823.818630001 | 2098534.27999 | 37.7418782818471 | -122.46051787510599 | (37.7418782818471, -122.460517875106) | |
27119 | 27119 | 209185 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 3ft | 5994853.690119999 | 2098493.2474700003 | 37.741767335194105 | -122.460411617495 | (37.7417673351941, -122.460411617495) | |||
27647 | 27647 | 223848 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000598.61266 | 2104296.68505 | 37.758030988052 | -122.44096386459299 | (37.758030988052, -122.440963864593) | |||
28538 | 28538 | 212784 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 739 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5998105.0801800005 | 2095806.61255 | 37.734576984727795 | -122.448975948078 | (37.7345769847278, -122.448975948078) | |||
29662 | 29662 | 223849 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000601.16124 | 2104292.97169 | 37.7580209372281 | -122.440954784152 | (37.7580209372281, -122.440954784152) | |||
36699 | 36699 | 218742 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998867.6092 | 2095887.4020200002 | 37.734842393562104 | -122.44634545 | (37.7348423935621, -122.44634545) | |||
38814 | 38814 | 221775 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 21 Addison St | 14 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 3ft | 6003667.46569 | 2096848.61536 | 37.737754634878 | -122.429819221204 | (37.737754634878, -122.429819221204) | |||
42552 | 42552 | 241129 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 163 Corwin St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000604.9463 | 2104285.57219 | 37.758000835587396 | -122.440941163018 | (37.7580008355874, -122.440941163018) | |||
43628 | 43628 | 218738 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998805.22806 | 2095928.00663 | 37.734950321189 | -122.446564042812 | (37.734950321189, -122.446564042812) | |||
48070 | 48070 | 209184 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 3ft | 5994856.4919300005 | 2098484.57238 | 37.7417436767315 | -122.460401301401 | (37.7417436767315, -122.460401301401) | |||
48281 | 48281 | 209182 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 17 | Width 3ft | 5994867.86795 | 2098472.15279 | 37.7417102300345 | -122.46036106750799 | (37.7417102300345, -122.460361067508) | |||
52362 | 52362 | 237943 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 22 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | Width 3ft | 6002178.91966 | 2096366.0304900003 | 37.7363451615923 | -122.43493133373501 | (37.7363451615923, -122.434931333735) | |||
61847 | 61847 | 218740 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998836.63311 | 2095909.61295 | 37.734901610308704 | -122.446454142063 | (37.7349016103087, -122.446454142063) | |||
68047 | 68047 | 218985 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 735 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5998106.15759 | 2095768.84675 | 37.7344733504624 | -122.448969503563 | (37.7344733504624, -122.448969503563) | |||
68601 | 68601 | 212785 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 743 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5998104.46417 | 2095821.7845 | 37.734618608054795 | -122.448979170379 | (37.7346186080548, -122.448979170379) | |||
132023 | 132023 | 223850 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000602.6654 | 2104289.54137 | 37.758011604077296 | -122.440949336057 | (37.7580116040773, -122.440949336057) | |||
132146 | 132146 | 218741 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998851.10975 | 2095900.2680400002 | 37.73487677824821 | -122.44640341939 | (37.7348767782482, -122.44640341939) | |||
147254 | 147254 | 211258 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 426 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5997445.84853 | 2095752.3652400002 | 37.734390310651605 | -122.451251210378 | (37.7343903106516, -122.451251210378) | |||
149374 | 149374 | 218737 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998790.02414 | 2095935.97535 | 37.7349713329455 | -122.446617181062 | (37.7349713329455, -122.446617181062) | |||
153368 | 153368 | 218739 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 32 Los Palmos Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | Width 3ft | 5998821.443390001 | 2095918.27736 | 37.7349245331257 | -122.446507281187 | (37.7349245331257, -122.446507281187) | |||
158375 | 158375 | 241152 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 3 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 3ft | 6002150.14382 | 2096511.4000799998 | 37.736742679035004 | -122.435041217385 | (37.736742679035, -122.435041217385) | |||
160996 | 160996 | 223847 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000596.08551 | 2104301.4441 | 37.758043911304895 | -122.44097294593901 | (37.7580439113049, -122.440972945939) | |||
162015 | 162015 | 245786 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 21 Addison St | 13 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | Width 3ft | 6003641.8158599995 | 2096850.294 | 37.73775779149221 | -122.429908024732 | (37.7377577914922, -122.429908024732) | |||
163239 | 163239 | 220552 | Undocumented 2 | Aesculus californica :: California Buckeye 338 | 13 Ohlone Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6002169.64489 | 2096371.31931 | 37.736359156858704 | -122.434963778568 | (37.7363591568587, -122.434963778568) | |||
166702 | 166702 | 223846 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000593.0444 | 2104306.7365599996 | 37.7580582698975 | -122.440983843043 | (37.7580582698975, -122.440983843043) | |||
169264 | 169264 | 223845 | Undocumented 2 | Cupressus sempervirens :: Italian Cypress 136 | 163 Corwin St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 3ft | 6000588.980819999 | 2104313.3574 | 37.7580762176596 | -122.440998371578 | (37.7580762176596, -122.440998371578) | |||
174819 | 174819 | 209181 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5994876.85162 | 2098459.48593 | 37.7416759667651 | -122.46032908762699 | (37.7416759667651, -122.460329087627) | |||
177691 | 177691 | 209186 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 140 Kensington Way | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 3ft | 5994849.5459 | 2098494.81966 | 37.741771413634794 | -122.46042606063 | (37.7417714136348, -122.46042606063) | |||
182862 | 182862 | 209187 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994832.7400400005 | 2098518.64338 | 37.7418358608449 | -122.460485895213 | (37.7418358608449, -122.460485895213) | |||
189024 | 189024 | 209189 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 156 Kensington Way | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 3ft | 5994812.38667 | 2098544.02713 | 37.7419043873887 | -122.460558108972 | (37.7419043873887, -122.460558108972) |
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");