Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantDate, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15543 | 15543 | 106166 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1051 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 6012226.18355 | 2103510.5202200003 | 37.7565277460814 | -122.400695290961 | (37.7565277460814, -122.400695290961) | ||||
31195 | 31195 | 35348 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1142 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38811 | 6012185.95108 | 2103089.25023 | 37.7553687870439 | -122.40080483467301 | (37.7553687870439, -122.400804834673) | |
35292 | 35292 | 105896 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013869.96834 | 2104118.28699 | 37.758288085340794 | -122.39505302359301 | (37.7582880853408, -122.395053023593) | |||
35695 | 35695 | 35366 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1034 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/23/1998 12:00:00 AM | 10 | Permit Number 38826 | 6011879.44293 | 2103561.1446700003 | 37.756647404478 | -122.40189800918999 | (37.756647404478, -122.40189800919) | |
41014 | 41014 | 226360 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 91 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6005779.63458 | 2103420.31022 | 37.7559183924354 | -122.422983371787 | (37.7559183924354, -122.422983371787) | |||
43450 | 43450 | 226442 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3246 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008090.25065 | 2101545.29399 | 37.750900134931605 | -122.41485978137199 | (37.7509001349316, -122.414859781372) | |||
47888 | 47888 | 229858 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 115 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6005418.6936800005 | 2103014.66569 | 37.754784213323205 | -122.42420277693199 | (37.7547842133232, -122.424202776932) | |||
54167 | 54167 | 226370 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 929 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6001946.0113 | 2101316.44103 | 37.7499246016413 | -122.43609073251899 | (37.7499246016413, -122.436090732519) | |||
61684 | 61684 | 69888 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1094 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/2000 12:00:00 AM | 10 | 6012175.72633 | 2103309.76161 | 37.755973692659396 | -122.40085568686101 | (37.7559736926594, -122.400855686861) | ||
64203 | 64203 | 226438 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 205 Bartlett St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006736.74676 | 2102507.29113 | 37.7534654133023 | -122.419608581296 | (37.7534654133023, -122.419608581296) | |||
74424 | 74424 | 226764 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 18 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004212.35359 | 2095476.2158400002 | 37.7340171774496 | -122.42783751920099 | (37.7340171774496, -122.427837519201) | |||
78078 | 78078 | 94188 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 456 Belvedere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/2014 12:00:00 AM | 10 | 3x4 | Permit Number 772961 | 5998552.0 | 2106546.0 | 37.7640902659836 | -122.448203856901 | (37.7640902659836, -122.448203856901) | |
103488 | 103488 | 117199 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 383 LEXINGTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6006585.0 | 2103883.0 | 37.7572342437784 | -122.42023098586999 | (37.7572342437784, -122.42023098587) | |||
118394 | 118394 | 229868 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 248 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6004337.80093 | 2099585.8632799997 | 37.7453084292413 | -122.427696518086 | (37.7453084292413, -122.427696518086) | |||
128618 | 128618 | 37730 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 1466X Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/01/1998 12:00:00 AM | 10 | 3x3 | Permit Number 40094 | 6009550.0 | 2100728.0 | 37.7487379414946 | -122.409754126164 | (37.7487379414946, -122.409754126164) | |
130132 | 130132 | 70665 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 550 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 10 | 6010647.04803 | 2105639.57925 | 37.7622854639243 | -122.406306536234 | (37.7622854639243, -122.406306536234) | ||
146448 | 146448 | 229811 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2753 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 6ft | 6009624.46016 | 2103341.89532 | 37.755919288155205 | -122.409681113601 | (37.7559192881552, -122.409681113601) | |||
148815 | 148815 | 105898 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013868.87409 | 2104163.4691 | 37.758412084762995 | -122.39505997266501 | (37.758412084763, -122.395059972665) | |||
157997 | 157997 | 70661 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 460 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/17/1994 12:00:00 AM | 10 | 6010614.613 | 2106160.28585 | 37.7637133921776 | -122.40645540998999 | (37.7637133921776, -122.40645540999) | ||
159550 | 159550 | 105895 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013871.69882 | 2104104.53276 | 37.7582504154377 | -122.395046075423 | (37.7582504154377, -122.395046075423) | |||
161712 | 161712 | 226810 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 85 Sharon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003888.711069999 | 2106689.1208200003 | 37.7647868841307 | -122.42975594218099 | (37.7647868841307, -122.429755942181) | |||
161745 | 161745 | 229815 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 990 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6008578.507569999 | 2102937.64163 | 37.75475063086 | -122.41326978718399 | (37.75475063086, -122.413269787184) | |||
164391 | 164391 | 105897 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 635 Texas St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6013869.92675 | 2104144.58378 | 37.7583602883087 | -122.395055009307 | (37.7583602883087, -122.395055009307) | |||
165297 | 165297 | 226367 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 706 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6001215.62025 | 2102209.80088 | 37.752336031192705 | -122.43868046073601 | (37.7523360311927, -122.438680460736) | |||
166642 | 166642 | 226333 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 383 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006558.03164 | 2103902.48298 | 37.7572862199038 | -122.42032563593 | (37.7572862199038, -122.42032563593) | |||
169729 | 169729 | 138814 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 456 IVY ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005154.2758 | 2111127.9762 | 37.777046493419 | -122.42569463833901 | (37.777046493419, -122.425694638339) | |||
170053 | 170053 | 226322 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1153 Shotwell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008078.2472 | 2101222.93823 | 37.750014344096606 | -122.414878478273 | (37.7500143440966, -122.414878478273) | |||
172687 | 172687 | 226453 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3070 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008553.18177 | 2102742.64498 | 37.754213792241 | -122.41334358196 | (37.754213792241, -122.41334358196) | |||
174365 | 174365 | 226443 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 3190 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008436.7771 | 2101566.08648 | 37.7509766915292 | -122.413662926703 | (37.7509766915292, -122.413662926703) | |||
175116 | 175116 | 226306 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 92 Santa Marina St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006186.62899 | 2097537.37358 | 37.7397881459032 | -122.421158135656 | (37.7397881459032, -122.421158135656) | |||
175571 | 175571 | 229878 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 402 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003817.08439 | 2100142.49851 | 37.746807351775 | -122.429536759424 | (37.746807351775, -122.429536759424) | |||
176056 | 176056 | 228529 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1718 Bryant St | 2 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6009444.29412 | 2106686.02886 | 37.7650914215521 | -122.41054032498 | (37.7650914215521, -122.41054032498) | |||
180855 | 180855 | 229814 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 2851 26th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010203.85183 | 2101034.69033 | 37.749616665695896 | -122.40751471964799 | (37.7496166656959, -122.407514719648) | |||
180989 | 180989 | 229786 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1254 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010820.80874 | 2102463.77247 | 37.7535751252085 | -122.405481884883 | (37.7535751252085, -122.405481884883) | |||
181284 | 181284 | 228530 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1736 Bryant St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 6ft | 6009448.1788099995 | 2106596.433 | 37.7648456296528 | -122.410520561485 | (37.7648456296528, -122.410520561485) | |||
183138 | 183138 | 226388 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 88 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006749.9144 | 2099207.7220900003 | 37.7444062878286 | -122.41932899196001 | (37.7444062878286, -122.41932899196) | |||
185514 | 185514 | 226765 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 10 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004241.0492 | 2095563.86697 | 37.7342594709862 | -122.427744552687 | (37.7342594709862, -122.427744552687) | |||
185529 | 185529 | 226416 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1118 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008031.51023 | 2101373.79083 | 37.7504259251155 | -122.415050773974 | (37.7504259251155, -122.415050773974) | |||
186299 | 186299 | 226314 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 1357 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6007744.38877 | 2101777.28879 | 37.751517700281404 | -122.416072235664 | (37.7515177002814, -122.416072235664) | |||
188531 | 188531 | 67581 | Permitted Site 1 | Jacaranda mimosifolia :: Jacaranda 52 | 321 Connecticut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/05/1992 12:00:00 AM | 10 | Permit Number 31145 | 6013230.15205 | 2105558.3695799997 | 37.7622066365616 | -122.39736679306999 | (37.7622066365616, -122.39736679307) |
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");