Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5229 | 5229 | 253834 | Permitted Site 1 | :: 54 | 747 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006860.78535 | 2113242.76542 | 37.7829494746502 | -122.419941385136 | (37.7829494746502, -122.419941385136) | |||
| 5236 | 5236 | 253833 | Permitted Site 1 | :: 54 | 607 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5226 | 5226 | 253832 | Permitted Site 1 | :: 54 | 665 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007254.7956 | 2113297.42725 | 37.783121752773 | -122.41858214693501 | (37.783121752773, -122.418582146935) | |||
| 5216 | 5216 | 253831 | Permitted Site 1 | :: 54 | 651X Polk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5239 | 5239 | 253830 | Permitted Site 1 | :: 54 | 651X Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5211 | 5211 | 253829 | Permitted Site 1 | :: 54 | 869 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6006713.1749 | 2113568.2957099997 | 37.7838349840749 | -122.420475171434 | (37.7838349840749, -122.420475171434) | |||
| 5228 | 5228 | 253828 | Permitted Site 1 | :: 54 | 825 Polk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 5224 | 5224 | 253827 | Permitted Site 1 | :: 54 | 825 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007000.12586 | 2113749.24795 | 37.7843480014325 | -122.419495267967 | (37.7843480014325, -122.419495267967) | |||
| 5230 | 5230 | 253826 | Permitted Site 1 | :: 54 | 701 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | ||||||||
| 5222 | 5222 | 253825 | Permitted Site 1 | :: 54 | 725 Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 3x3 | 6007393.727109999 | 2113660.9435900003 | 37.784127700976896 | -122.418127279043 | (37.7841277009769, -122.418127279043) | |||
| 5050 | 5050 | 253762 | Planning Code 138.1 required 4 | :: 54 | 520 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993490.0 | 2111935.0 | 37.778596343165496 | -122.46610332918101 | (37.7785963431655, -122.466103329181) | ||||
| 4723 | 4723 | 253676 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 6 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x3.75 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 4726 | 4726 | 253675 | Permitted Site 1 | :: 54 | 2975 Van Ness Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 10/24/2017 12:00:00 AM | 3 | 3.2x14.2 | 6005536.30746 | 2120557.52588 | 37.8029592583559 | -122.42504415389 | (37.8029592583559, -122.42504415389) | ||
| 3650 | 3650 | 253518 | Permitted Site 1 | :: 54 | 559 24th Ave | 3 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x1 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3639 | 3639 | 253517 | Permitted Site 1 | :: 54 | 559 24th Ave | 2 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x4.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3660 | 3660 | 253516 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 2x2 | 5988392.0 | 2112177.0 | 37.778965370493495 | -122.483756799769 | (37.7789653704935, -122.483756799769) | ||
| 3643 | 3643 | 253515 | Permitted Site 1 | :: 54 | 559 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 09/15/2017 12:00:00 AM | 3 | 7x9.5 | 5988391.0 | 2112180.0 | 37.7789735494402 | -122.483760479148 | (37.7789735494402, -122.483760479148) | ||
| 3345 | 3345 | 253419 | Planning Code 138.1 required 4 | :: 54 | 3499 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5997570.0 | 2115996.0 | 37.78998131889129 | -122.452282225129 | (37.7899813188913, -122.452282225129) | ||||
| 3275 | 3275 | 253378 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 3255 | 3255 | 253377 | Planning Code 138.1 required 4 | :: 54 | 2 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001556.0 | 2108661.0 | 37.7700688079313 | -122.43796542225 | (37.7700688079313, -122.43796542225) | ||||
| 2865 | 2865 | 253261 | Permitted Site 1 | :: 54 | 339 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5990256.0 | 2113097.0 | 37.78159976365421 | -122.477375802178 | (37.7815997636542, -122.477375802178) | ||||
| 2881 | 2881 | 253260 | Permitted Site 1 | :: 54 | 734 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993234.0 | 2110465.0 | 37.7745453462497 | -122.46688203122801 | (37.7745453462497, -122.466882031228) | ||||
| 2270 | 2270 | 253008 | Permitted Site 1 | :: 54 | 1201 Tennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 07/10/2017 12:00:00 AM | 3 | 11x477 | 6015595.17459 | 2103370.35297 | 37.756330202721 | -122.389034232236 | (37.756330202721, -122.389034232236) | ||
| 1988 | 1988 | 252845 | DPW Maintained 3 | :: 54 | 544 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/29/2014 12:00:00 AM | 3x3 | 5993963.0 | 2110797.0 | 37.7754989773977 | -122.46438440768401 | (37.7754989773977, -122.464384407684) | |||
| 1824 | 1824 | 251724 | Permitted Site 1 | :: 54 | 1630 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2017 12:00:00 AM | 3 | 3x3 | 6006933.88533 | 2116748.92044 | 37.792580631742204 | -122.419937373279 | (37.7925806317422, -122.419937373279) | ||
| 1800 | 1800 | 251700 | Permitted Site 1 | :: 54 | 1560 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 06/05/2017 12:00:00 AM | 3 | 410x11 | Permit Number 780193 | 6003924.0 | 2099150.0 | 37.7440882334859 | -122.429096301435 | (37.7440882334859, -122.429096301435) | |
| 1389 | 1389 | 251532 | Permitted Site 1 | :: 54 | 2100X 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 1391 | 1391 | 251531 | Permitted Site 1 | :: 54 | 2100X 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Landscaping 2 | Private 1 | 05/15/2017 12:00:00 AM | 3 | 4x11 | |||||||
| 667 | 667 | 251356 | Undocumented 2 | :: 54 | 519 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989039.0 | 2111772.0 | 37.777890994652296 | -122.481488924787 | (37.7778909946523, -122.481488924787) | ||||
| 518 | 518 | 251314 | Planning Code 138.1 required 4 | :: 54 | 1108 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6001901.0 | 2100825.0 | 37.7485726639367 | -122.43621121860001 | (37.7485726639367, -122.4362112186) | ||||
| 533 | 533 | 251313 | Planning Code 138.1 required 4 | :: 54 | 390 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 514 | 514 | 251312 | Undocumented 2 | :: 54 | 1499 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003369.0 | 2099547.0 | 37.7451468706327 | -122.431043696183 | (37.7451468706327, -122.431043696183) | ||||
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 443 | 443 | 251293 | Undocumented 2 | :: 54 | 3789 Market St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6000208.0 | 2102740.0 | 37.753734455764 | -122.44220302061701 | (37.753734455764, -122.442203020617) | ||||
| 32195 | 32195 | 248555 | Undocumented 2 | :: 54 | 129 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5997396.7751 | 2107759.6103 | 37.767356421121995 | -122.452286999337 | (37.767356421122, -122.452286999337) | |||
| 160080 | 160080 | 248532 | Undocumented 2 | :: 54 | 780 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998628.6838 | 2107761.1245 | 37.7674310747458 | -122.448026126243 | (37.7674310747458, -122.448026126243) | |||
| 54716 | 54716 | 248525 | Undocumented 2 | :: 54 | 216 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998893.6593 | 2107664.8248 | 37.7671818031991 | -122.44710268466999 | (37.7671818031991, -122.44710268467) | |||
| 32221 | 32221 | 248518 | Undocumented 2 | :: 54 | 214 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998913.7974 | 2107668.6102 | 37.767193347530295 | -122.447033302678 | (37.7671933475303, -122.447033302678) | |||
| 163706 | 163706 | 248457 | Undocumented 2 | :: 54 | 141 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998243.6366 | 2107963.8685 | 37.767965740451395 | -122.44937255538 | (37.7679657404514, -122.44937255538) | |||
| 67019 | 67019 | 248388 | Undocumented 2 | :: 54 | 729 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999022.2102 | 2108122.8538 | 37.7684467791283 | -122.446691007031 | (37.7684467791283, -122.446691007031) | |||
| 64371 | 64371 | 248338 | Undocumented 2 | :: 54 | 101 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998210.6283 | 2108198.2582 | 37.7686074267176 | -122.44950361782 | (37.7686074267176, -122.44950361782) | |||
| 60956 | 60956 | 248334 | Undocumented 2 | :: 54 | 1569 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5998104.0324 | 2108202.8007 | 37.7686138007777 | -122.449872650062 | (37.7686138007777, -122.449872650062) | |||
| 53766 | 53766 | 248316 | Undocumented 2 | :: 54 | 1415 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998917.5828 | 2108317.7243 | 37.7689758669537 | -122.44706692803001 | (37.7689758669537, -122.44706692803) | |||
| 77255 | 77255 | 248311 | Undocumented 2 | :: 54 | 1359 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999222.9859 | 2108359.6661 | 37.7691084728164 | -122.44601357942699 | (37.7691084728164, -122.446013579427) | |||
| 185918 | 185918 | 248310 | Undocumented 2 | :: 54 | 1361 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999210.5699 | 2108358.152 | 37.7691036064762 | -122.446056416567 | (37.7691036064762, -122.446056416567) | |||
| 24104 | 24104 | 248307 | Undocumented 2 | :: 54 | 1323 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999369.7066 | 2108379.5015 | 37.7691713129844 | -122.44550750940901 | (37.7691713129844, -122.445507509409) | |||
| 159425 | 159425 | 247892 | Undocumented 2 | :: 54 | 1283 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000447.0072 | 2109223.9761 | 37.771551471121896 | -122.441841814274 | (37.7715514711219, -122.441841814274) | |||
| 25062 | 25062 | 247418 | Undocumented 2 | :: 54 | 1001 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002608.194 | 2110213.5869 | 37.7743916070028 | -122.43443692499599 | (37.7743916070028, -122.434436924996) | |||
| 164210 | 164210 | 247384 | Undocumented 2 | :: 54 | 1021 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002057.9469 | 2109793.0538 | 37.7732056784261 | -122.436310227416 | (37.7732056784261, -122.436310227416) | |||
| 153937 | 153937 | 247379 | Undocumented 2 | :: 54 | 1015 Oak St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002146.8166 | 2109803.9081 | 37.7732405306973 | -122.436003592649 | (37.7732405306973, -122.436003592649) | |||
| 187871 | 187871 | 247375 | Undocumented 2 | :: 54 | 465 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002165.262999999 | 2110077.3982 | 37.7739925143767 | -122.43595935728901 | (37.7739925143767, -122.435959357289) | |||
| 18412 | 18412 | 247322 | Undocumented 2 | :: 54 | 218 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Width 0ft | 6002795.6845 | 2109344.9924 | 37.7720173021936 | -122.433726268045 | (37.7720173021936, -122.433726268045) | ||||
| 51961 | 51961 | 247308 | Undocumented 2 | :: 54 | 244 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6002304.3117 | 2109415.4914 | 37.7721829807963 | -122.435431006138 | (37.7721829807963, -122.435431006138) | |||
| 52776 | 52776 | 247289 | Undocumented 2 | :: 54 | 636 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997016.0452 | 2108877.8212 | 37.7704049220759 | -122.45368463790199 | (37.7704049220759, -122.453684637902) | |||
| 50533 | 50533 | 247288 | Undocumented 2 | :: 54 | 638 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997017.3270000005 | 2108860.304 | 37.770356897849105 | -122.453678939083 | (37.7703568978491, -122.453678939083) | |||
| 36634 | 36634 | 247287 | Undocumented 2 | :: 54 | 640 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997019.8905 | 2108844.4958 | 37.770313639572 | -122.453668930321 | (37.770313639572, -122.453668930321) | |||
| 134084 | 134084 | 246372 | Undocumented 2 | :: 54 | 1999 Mission St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6006820.4847 | 2107009.8327 | 37.7658330635794 | -122.41963843327801 | (37.7658330635794, -122.419638433278) | |||
| 73891 | 73891 | 246215 | Undocumented 2 | :: 54 | 725 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999843.1798 | 2107896.3377 | 37.767871685104105 | -122.443835079351 | (37.7678716851041, -122.443835079351) | |||
| 54373 | 54373 | 246202 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999863.7722 | 2107959.3261 | 37.7680458100097 | -122.443768378658 | (37.7680458100097, -122.443768378658) | |||
| 170361 | 170361 | 246200 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999871.6458 | 2107989.0034 | 37.7681277455177 | -122.443743277143 | (37.7681277455177, -122.443743277143) | |||
| 159456 | 159456 | 246199 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999875.5825 | 2108001.7222 | 37.7681628926873 | -122.443730574399 | (37.7681628926873, -122.443730574399) | |||
| 173941 | 173941 | 246198 | Undocumented 2 | :: 54 | 737 Buena Vista Ave West | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999879.5193 | 2108013.2297 | 37.7681947139353 | -122.443717784266 | (37.7681947139353, -122.443717784266) | |||
| 55239 | 55239 | 246194 | Undocumented 2 | :: 54 | 1349 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999511.7334 | 2108091.2082 | 37.7683878393229 | -122.44499552058399 | (37.7683878393229, -122.444995520584) | |||
| 181915 | 181915 | 246180 | Undocumented 2 | :: 54 | 1588 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997959.8858 | 2108225.8157 | 37.768668745448295 | -122.450372898384 | (37.7686687454483, -122.450372898384) | |||
| 45274 | 45274 | 246179 | Undocumented 2 | :: 54 | 1588 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997977.1471 | 2108227.9355 | 37.768675553750796 | -122.45031334601101 | (37.7686755537508, -122.450313346011) | |||
| 75195 | 75195 | 246178 | Undocumented 2 | :: 54 | 1588 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997994.7111 | 2108230.9638 | 37.76868487385529 | -122.45025281211201 | (37.7686848738553, -122.450252812112) | |||
| 54387 | 54387 | 246177 | Undocumented 2 | :: 54 | 1588 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998014.6979 | 2108233.0836 | 37.7686918380665 | -122.450183832466 | (37.7686918380665, -122.450183832466) | |||
| 133477 | 133477 | 246176 | Undocumented 2 | :: 54 | 1588 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998032.5648 | 2108236.7175 | 37.7687028382608 | -122.45012229449 | (37.7687028382608, -122.45012229449) | |||
| 74231 | 74231 | 246137 | Undocumented 2 | :: 54 | 636 Shrader St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5997583.3178 | 2108295.6178 | 37.7688388454445 | -122.451680446787 | (37.7688388454445, -122.451680446787) | |||
| 75313 | 75313 | 246042 | Undocumented 2 | :: 54 | 1257 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999431.9379 | 2108484.7346 | 37.7694638090143 | -122.445299822785 | (37.7694638090143, -122.445299822785) | |||
| 188653 | 188653 | 246020 | Undocumented 2 | :: 54 | 1629 Haight St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5998306.6251 | 2108576.7946 | 37.7696522823625 | -122.449198848796 | (37.7696522823625, -122.449198848796) | |||
| 129766 | 129766 | 246016 | Undocumented 2 | :: 54 | 1605 Haight St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5998345.69 | 2108581.6399 | 37.7696678206354 | -122.449064074288 | (37.7696678206354, -122.449064074288) | |||
| 123748 | 123748 | 246002 | Undocumented 2 | :: 54 | 79 Central Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999916.7673 | 2108675.5169 | 37.7700153125584 | -122.44363653081801 | (37.7700153125584, -122.443636530818) | |||
| 26862 | 26862 | 245988 | Undocumented 2 | :: 54 | 1250 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999884.6674 | 2108495.9392 | 37.76952040656629 | -122.44373466044901 | (37.7695204065663, -122.443734660449) | |||
| 75781 | 75781 | 245986 | Undocumented 2 | :: 54 | 1317 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 5999797.1498 | 2108783.9297 | 37.7703061638219 | -122.444058075462 | (37.7703061638219, -122.444058075462) | |||
| 130962 | 130962 | 245976 | Undocumented 2 | :: 54 | 2853 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6007108.2 | 2101741.6294 | 37.7513839973612 | -122.41826973186501 | (37.7513839973612, -122.418269731865) | |||
| 149942 | 149942 | 245941 | Undocumented 2 | :: 54 | 142 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998288.6068 | 2107942.2163 | 37.7679088612974 | -122.44921544906 | (37.7679088612974, -122.44921544906) | |||
| 30926 | 30926 | 245835 | Undocumented 2 | :: 54 | 451 Fell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005269.6444 | 2110584.5711 | 37.7755609539167 | -122.42525686469999 | (37.7755609539167, -122.4252568647) | |||
| 177066 | 177066 | 245469 | Undocumented 2 | :: 54 | 3290 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6006288.2664 | 2099127.398 | 37.744159724830105 | -122.42091957583901 | (37.7441597248301, -122.420919575839) | |||
| 73932 | 73932 | 245458 | Undocumented 2 | :: 54 | 2800 16th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6007840.6133 | 2106809.0367 | 37.765339135235706 | -122.416095791627 | (37.7653391352357, -122.416095791627) | |||
| 61664 | 61664 | 245454 | Undocumented 2 | :: 54 | 2700 16th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6008487.3357 | 2106844.226 | 37.765472098116796 | -122.41386141193001 | (37.7654720981168, -122.41386141193) | |||
| 73182 | 73182 | 245418 | Undocumented 2 | :: 54 | 2761 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6010213.0571 | 2102206.4482 | 37.7528345690624 | -122.407565491585 | (37.7528345690624, -122.407565491585) | |||
| 155025 | 155025 | 245380 | Undocumented 2 | :: 54 | 3620 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005334.5439 | 2097112.3285 | 37.7385729952273 | -122.424074069598 | (37.7385729952273, -122.424074069598) | |||
| 157391 | 157391 | 245377 | Undocumented 2 | :: 54 | 3484 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005669.5792 | 2097980.5479 | 37.7409758407669 | -122.42297736783001 | (37.7409758407669, -122.42297736783) | |||
| 30889 | 30889 | 245370 | Undocumented 2 | :: 54 | 3943 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005173.0525 | 2095986.3930000002 | 37.7354723102432 | -122.42455236124201 | (37.7354723102432, -122.424552361242) | |||
| 171847 | 171847 | 245199 | Undocumented 2 | :: 54 | 101 Broderick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001311.3344 | 2109146.8192 | 37.771388829884 | -122.43884653486 | (37.771388829884, -122.43884653486) | |||
| 46705 | 46705 | 244976 | Undocumented 2 | :: 54 | 201 Rose St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005594.1388 | 2109777.4773 | 37.773363196496895 | -122.42407694938998 | (37.7733631964969, -122.42407694939) | |||
| 184510 | 184510 | 244966 | Undocumented 2 | :: 54 | 250 Lily St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005265.6412 | 2110100.505 | 37.7742315998648 | -122.42523625993401 | (37.7742315998648, -122.425236259934) | |||
| 157124 | 157124 | 244963 | Undocumented 2 | :: 54 | 250 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005299.6761 | 2110107.1904 | 37.7742518790539 | -122.42511900276199 | (37.7742518790539, -122.425119002762) | |||
| 183643 | 183643 | 244942 | Undocumented 2 | :: 54 | 200 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005544.3019 | 2109980.4712 | 37.7739177547615 | -122.42426378250299 | (37.7739177547615, -122.424263782503) | |||
| 150125 | 150125 | 244876 | Undocumented 2 | :: 54 | 1337 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6000144.5037 | 2109183.4156 | 37.7714228606032 | -122.442885274342 | (37.7714228606032, -122.442885274342) | |||
| 76283 | 76283 | 244483 | Undocumented 2 | :: 54 | 1124 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6001145.6174 | 2109366.8236 | 37.7719834774065 | -122.439435529733 | (37.7719834774065, -122.439435529733) | |||
| 186311 | 186311 | 244447 | Undocumented 2 | :: 54 | 418 Rose St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004438.1156 | 2109646.5981 | 37.772938497462 | -122.428066467687 | (37.772938497462, -122.428066467687) | |||
| 153352 | 153352 | 244386 | Undocumented 2 | :: 54 | 887 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003218.6187 | 2110296.9095 | 37.7746550213638 | -122.432331304978 | (37.7746550213638, -122.432331304978) | |||
| 164079 | 164079 | 244369 | Undocumented 2 | :: 54 | 301 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005524.5535 | 2110345.3319 | 37.774918458756396 | -122.424358051661 | (37.7749184587564, -122.424358051661) | |||
| 169590 | 169590 | 244368 | Undocumented 2 | :: 54 | 301 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005522.1928 | 2110360.9128 | 37.7749611068256 | -122.424367326274 | (37.7749611068256, -122.424367326274) | |||
| 28842 | 28842 | 244343 | Undocumented 2 | :: 54 | 462 Steiner St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003204.9743 | 2109911.1218 | 37.7735949699184 | -122.432350944562 | (37.7735949699184, -122.432350944562) | |||
| 58859 | 58859 | 244341 | Undocumented 2 | :: 54 | 442 Steiner St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6003210.2759 | 2109856.6606 | 37.7734457335057 | -122.432328715157 | (37.7734457335057, -122.432328715157) | |||
| 33830 | 33830 | 244279 | Undocumented 2 | :: 54 | 585 Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6004230.7823 | 2110095.8419999997 | 37.7741602789386 | -122.42881569121799 | (37.7741602789386, -122.428815691218) | |||
| 25160 | 25160 | 244247 | Undocumented 2 | :: 54 | 200 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | Width 0ft | 6005673.0642 | 2110022.6890000002 | 37.7740409443959 | -122.423821374378 | (37.7740409443959, -122.423821374378) |
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");