Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1371 | 1371 | 251505 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 360 Clementina St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011658.68026 | 2112523.0235200003 | 37.781242368680296 | -122.403291911611 | (37.7812423686803, -122.403291911611) | ||||
| 1452 | 1452 | 251537 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 25 Essex St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.0 | 2114247.0 | 37.7861081097809 | -122.395212511502 | (37.7861081097809, -122.395212511502) | ||||
| 1475 | 1475 | 187957 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 81 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014291.0 | 2114089.0 | 37.78568884516871 | -122.39429498812099 | (37.7856888451687, -122.394294988121) | |||
| 2536 | 2536 | 141924 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 900 MCALLISTER ST | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004374.9759 | 2111902.445 | 37.7791289269844 | -122.428445694629 | (37.7791289269844, -122.428445694629) | |||
| 6537 | 6537 | 22773 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1741 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001679.7734 | 2112097.4839 | 37.7795115699514 | -122.43778345572599 | (37.7795115699514, -122.437783455726) | |||
| 9126 | 9126 | 2365 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | 6009712.991769 | 2102766.5035063997 | 37.7543443518018 | -122.409334337085 | (37.7543443518018, -122.409334337085) | |||
| 9207 | 9207 | 84924 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 2320 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6009655.0 | 2103828.0 | 37.7572557336683 | -122.409609804431 | (37.7572557336683, -122.409609804431) | |||
| 14125 | 14125 | 27452 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6X6 | 6015192.769090001 | 2100696.5145099997 | 37.7489660934285 | -122.390239101956 | (37.7489660934285, -122.390239101956) | |||
| 14383 | 14383 | 118374 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 4x6 | 6014693.17098 | 2114681.8097099997 | 37.787338911495 | -122.392945071183 | (37.787338911495, -122.392945071183) | |||
| 14664 | 14664 | 27459 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1601 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 6X6 | 6015175.2959199995 | 2101002.60795 | 37.749805592554104 | -122.39032090789 | (37.7498055925541, -122.39032090789) | |||
| 14698 | 14698 | 27453 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6X6 | 6015188.65813 | 2100719.92865 | 37.7490301557222 | -122.390254953405 | (37.7490301557222, -122.390254953405) | |||
| 15322 | 15322 | 27454 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | 6015187.13368 | 2100745.31925 | 37.7490997884263 | -122.390261998696 | (37.7490997884263, -122.390261998696) | |||
| 15617 | 15617 | 27455 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1635 Indiana St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 6X6 | 6015186.58653 | 2100768.66108 | 37.7491638498456 | -122.390265521335 | (37.7491638498456, -122.390265521335) | |||
| 18035 | 18035 | 101991 | Permitted Site 1 | Acer rubrum :: Red Maple 6 | 25 Essex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014029.63843 | 2114247.91899 | 37.7861106686205 | -122.395210367086 | (37.7861106686205, -122.395210367086) | ||||
| 21317 | 21317 | 862 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400X Alemany Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 4x4 | 6008011.36344 | 2095005.6880599998 | 37.732939390338004 | -122.414669840947 | (37.732939390338, -122.414669840947) | |||
| 22267 | 22267 | 2366 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2500 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6009707.81579 | 2102741.7783 | 37.754276171914704 | -122.40935049224501 | (37.7542761719147, -122.409350492245) | |||
| 23108 | 23108 | 2426 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2855 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 3X3 | 6009874.246230001 | 2100776.83629 | 37.748890200541 | -122.408636324408 | (37.748890200541, -122.408636324408) | |||
| 23161 | 23161 | 2363 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2478 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009688.22905 | 2102936.69302 | 37.754810266704794 | -122.409431983418 | (37.7548102667048, -122.409431983418) | ||||
| 24181 | 24181 | 125409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6005915.1308699995 | 2112115.06535 | 37.7797997643918 | -122.42313277978 | (37.7797997643918, -122.42313277978) | |||
| 24244 | 24244 | 187915 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 5 Natoma St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6013761.85881 | 2115378.38602 | 37.7891997734024 | -122.396216078116 | (37.7891997734024, -122.396216078116) | |||
| 25016 | 25016 | 220501 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 14 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.49952 | 2108178.20652 | 37.768832473561794 | -122.432491682542 | (37.7688324735618, -122.432491682542) | |||
| 25058 | 25058 | 141590 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001558.8965 | 2111018.1096 | 37.776541006446706 | -122.438124278141 | (37.7765410064467, -122.438124278141) | |||
| 25823 | 25823 | 187931 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 111 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6015237.31948 | 2115756.16147 | 37.790319045339 | -122.391137539076 | (37.790319045339, -122.391137539076) | |||
| 26030 | 26030 | 118375 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 340 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 4x6 | 6014712.487269999 | 2114662.02755 | 37.7872856671566 | -122.392876855803 | (37.7872856671566, -122.392876855803) | |||
| 26254 | 26254 | 116994 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 600M Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6001630.0135 | 2110553.7073 | 37.775269918649705 | -122.43784499428999 | (37.7752699186497, -122.43784499429) | ||||
| 26724 | 26724 | 220414 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009485.691930001 | 2106956.65454 | 37.76583681834921 | -122.410416250032 | (37.7658368183492, -122.410416250032) | |||
| 27237 | 27237 | 141321 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 600x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001606.879 | 2110711.3642 | 37.7757014893927 | -122.437936316665 | (37.7757014893927, -122.437936316665) | |||
| 27763 | 27763 | 187876 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 12 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015130.16483 | 2100787.65085 | 37.749212862006296 | -122.39046195666701 | (37.7492128620063, -122.390461956667) | |||
| 28198 | 28198 | 220487 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 416 Hoffman Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6000636.08004 | 2101486.04738 | 37.7503157923525 | -122.44063269105499 | (37.7503157923525, -122.440632691055) | |||
| 28247 | 28247 | 187919 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013100.51395 | 2115046.75094 | 37.7882523600964 | -122.398480985606 | (37.7882523600964, -122.398480985606) | |||
| 28374 | 28374 | 175143 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 6009125.76929 | 2093634.7983 | 37.729237769091505 | -122.41072025595 | (37.7292377690915, -122.41072025595) | |||
| 28822 | 28822 | 220469 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2320 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009645.3794 | 2103705.18616 | 37.756917975403205 | -122.40963440819701 | (37.7569179754032, -122.409634408197) | |||
| 29247 | 29247 | 125411 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 680 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005845.66481 | 2112104.7354 | 37.7797674805156 | -122.423372359172 | (37.7797674805156, -122.423372359172) | |||
| 29587 | 29587 | 139865 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 752 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6005530.836 | 2112064.5728 | 37.7796394301742 | -122.42445863354601 | (37.7796394301742, -122.424458633546) | |||
| 29636 | 29636 | 189067 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013772.20207 | 2112425.8554700003 | 37.781093380699296 | -122.395973304322 | (37.7810933806993, -122.395973304322) | |||
| 29792 | 29792 | 112595 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1200X Divisadero St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 3x3 | 6001326.7981 | 2112711.2386 | 37.781176707308504 | -122.43904854399099 | (37.7811767073085, -122.439048543991) | |||
| 30082 | 30082 | 141368 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001677.0206 | 2110226.585 | 37.774374395633394 | -122.43765895363701 | (37.7743743956334, -122.437658953637) | |||
| 30101 | 30101 | 189093 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1444 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6016095.6448 | 2097530.53643 | 37.74032300780279 | -122.38689615645399 | (37.7403230078028, -122.386896156454) | |||
| 30483 | 30483 | 187888 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1799 Indiana St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 5ft | 6015216.20725 | 2100273.8122 | 37.747806741405 | -122.390128525805 | (37.747806741405, -122.390128525805) | |||
| 30804 | 30804 | 141336 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001660.0118 | 2110350.0832 | 37.7747125236659 | -122.437726636856 | (37.7747125236659, -122.437726636856) | |||
| 30838 | 30838 | 187949 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015269.3196 | 2115112.5908 | 37.7885537238177 | -122.390981820563 | (37.7885537238177, -122.390981820563) | ||||
| 31078 | 31078 | 141345 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001662.4769 | 2110310.1497 | 37.7746030164406 | -122.437715248986 | (37.7746030164406, -122.437715248986) | |||
| 31263 | 31263 | 137681 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001487.0408 | 2111552.8208 | 37.7780051017696 | -122.438411165508 | (37.7780051017696, -122.438411165508) | |||
| 31410 | 31410 | 203402 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 20 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 6ft | 5993459.6533 | 2097164.40162 | 37.738038365583 | -122.465135202222 | (37.738038365583, -122.465135202222) | |||
| 31777 | 31777 | 247369 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001726.9821 | 2109863.6289 | 37.773380649478504 | -122.437460131244 | (37.7733806494785, -122.437460131244) | |||
| 31984 | 31984 | 137765 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001461.6592 | 2111740.6449 | 37.7785193755481 | -122.438512430085 | (37.7785193755481, -122.438512430085) | |||
| 32027 | 32027 | 187962 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 787 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011933.30583 | 2110670.66458 | 37.7761715530167 | -122.402211564127 | (37.7761715530167, -122.402211564127) | |||
| 32037 | 32037 | 187942 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 300 Main St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | 6015080.74918 | 2115307.92538 | 37.789079602378294 | -122.391647913344 | (37.7890796023783, -122.391647913344) | ||||
| 32188 | 32188 | 141618 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001576.0331 | 2110923.0014 | 37.77628083782329 | -122.438058183449 | (37.7762808378233, -122.438058183449) | |||
| 32405 | 32405 | 203412 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 5993816.05949 | 2102205.88495 | 37.7519015516321 | -122.464268849347 | (37.7519015516321, -122.464268849347) | |||
| 32646 | 32646 | 203423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 10 Yerba Buena Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993355.35449 | 2097236.83517 | 37.7382312350687 | -122.465501072513 | (37.7382312350687, -122.465501072513) | |||
| 32664 | 32664 | 247514 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001758.7748 | 2109713.6816 | 37.7729707390414 | -122.43733941693701 | (37.7729707390414, -122.437339416937) | |||
| 32741 | 32741 | 220423 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1525 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009450.02537 | 2107605.87811 | 37.7676174373262 | -122.41058546376699 | (37.7676174373262, -122.410585463767) | |||
| 33159 | 33159 | 220430 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1401 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009429.13636 | 2107984.68576 | 37.7686563845084 | -122.410684471035 | (37.7686563845084, -122.410684471035) | |||
| 33887 | 33887 | 187873 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 9 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015126.80958 | 2100859.52415 | 37.7494100248665 | -122.390478580644 | (37.7494100248665, -122.390478580644) | |||
| 34402 | 34402 | 203409 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1945 08th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 6ft | 5993779.2225 | 2102246.7483099997 | 37.7520116286371 | -122.46439920245399 | (37.7520116286371, -122.464399202454) | |||
| 34428 | 34428 | 187860 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1000 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6014887.824680001 | 2103924.74261 | 37.7578132028277 | -122.391519270711 | (37.7578132028277, -122.391519270711) | |||
| 34534 | 34534 | 220499 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 12 Walter St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003128.23781 | 2108216.38247 | 37.768937280547796 | -122.432495314901 | (37.7689372805478, -122.432495314901) | |||
| 35251 | 35251 | 121502 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 4 | 10x4 | 6014428.99687 | 2115060.94265 | 37.7883652457059 | -122.393885614549 | (37.7883652457059, -122.393885614549) | |||
| 35323 | 35323 | 187923 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6013066.988580001 | 2115014.97781 | 37.7881632507911 | -122.398594748068 | (37.7881632507911, -122.398594748068) | |||
| 35436 | 35436 | 220439 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2865 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009873.7476699995 | 2100752.39413 | 37.7488230598385 | -122.408636324412 | (37.7488230598385, -122.408636324412) | |||
| 35502 | 35502 | 203417 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 57 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993769.4905900005 | 2096990.17002 | 37.7375778308529 | -122.46405130512 | (37.7375778308529, -122.46405130512) | |||
| 35513 | 35513 | 220479 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 211 Prentiss St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008820.53272 | 2097501.66791 | 37.7398382390396 | -122.41204865353501 | (37.7398382390396, -122.412048653535) | |||
| 35576 | 35576 | 175135 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 144 Santa Ynez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000350.62933 | 2092307.6786599997 | 37.7250978911274 | -122.440961425642 | (37.7250978911274, -122.440961425642) | |||
| 36136 | 36136 | 125413 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 677 McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6005987.46942 | 2112075.6403900003 | 37.7796955950146 | -122.42287972583999 | (37.7796955950146, -122.42287972584) | |||
| 36568 | 36568 | 125406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2650 Pierce St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6001656.15712 | 2117548.20785 | 37.794476515841495 | -122.43825574691799 | (37.7944765158415, -122.438255746918) | |||
| 36889 | 36889 | 220442 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2601 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009796.152509999 | 2102134.77376 | 37.752614421718505 | -122.40900217402799 | (37.7526144217185, -122.409002174028) | |||
| 37536 | 37536 | 220503 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 203 States St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6001063.95053 | 2106312.4258 | 37.7635922112288 | -122.43949902816799 | (37.7635922112288, -122.439499028168) | |||
| 37847 | 37847 | 187948 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6015252.9594 | 2115128.97629 | 37.788597806797796 | -122.391039570534 | (37.7885978067978, -122.391039570534) | ||||
| 38131 | 38131 | 140748 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 1300x DIVISADERO ST | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001272.3122 | 2113103.8079 | 37.782251502236704 | -122.439265184087 | (37.7822515022367, -122.439265184087) | |||
| 38160 | 38160 | 121504 | Planning Code 138.1 required 4 | Acer rubrum :: Red Maple 6 | 299 Fremont St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5 | 10x4 | 6014396.4001 | 2115093.29031 | 37.7884522533286 | -122.39400066032499 | (37.7884522533286, -122.394000660325) | |||
| 38184 | 38184 | 187958 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 43 Lansing St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014361.38404 | 2114182.65198 | 37.7859499041048 | -122.394058036143 | (37.7859499041048, -122.394058036143) | |||
| 38232 | 38232 | 175141 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 199 Hamilton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6009144.52669 | 2093573.47642 | 37.7290704439367 | -122.410651080984 | (37.7290704439367, -122.410651080984) | |||
| 38296 | 38296 | 220467 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2104 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6009541.05061 | 2104932.28838 | 37.7602814740251 | -122.41008184609699 | (37.7602814740251, -122.410081846097) | |||
| 38415 | 38415 | 187922 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 48 Minna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013074.697930001 | 2115022.06537 | 37.7881831410762 | -122.398568572402 | (37.7881831410762, -122.398568572402) | |||
| 38969 | 38969 | 203414 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 95 Yerba Buena Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993945.5640199995 | 2096868.34313 | 37.7372534705646 | -122.463433702031 | (37.7372534705646, -122.463433702031) | |||
| 39100 | 39100 | 189065 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 521 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6013721.13353 | 2112372.28155 | 37.78094343761921 | -122.396146221471 | (37.7809434376192, -122.396146221471) | |||
| 39146 | 39146 | 199868 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016299.0692 | 2093761.868 | 37.729986262675396 | -122.385930158914 | (37.7299862626754, -122.385930158914) | |||
| 39249 | 39249 | 175137 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1802 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001243.74865 | 2091600.63197 | 37.7232073291514 | -122.437823395139 | (37.7232073291514, -122.437823395139) | |||
| 39657 | 39657 | 187951 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 302 Main St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | 6015307.966030001 | 2115072.7119299998 | 37.7884463699393 | -122.390845320574 | (37.7884463699393, -122.390845320574) | ||||
| 39772 | 39772 | 187904 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011967.30497 | 2114536.3793599997 | 37.7867878051538 | -122.402365823018 | (37.7867878051538, -122.402365823018) | |||
| 40080 | 40080 | 175138 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 67 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6004374.522580001 | 2093135.8569099999 | 37.7276002475407 | -122.427110209575 | (37.7276002475407, -122.427110209575) | |||
| 40227 | 40227 | 203406 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 155 Yerba Buena Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 8ft | 5994466.0383 | 2096440.3744299999 | 37.736108347605295 | -122.461603176966 | (37.7361083476053, -122.461603176966) | |||
| 41056 | 41056 | 138174 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001486.0255 | 2111568.0498 | 37.778046859007894 | -122.438415769146 | (37.7780468590079, -122.438415769146) | |||
| 41174 | 41174 | 189076 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1047 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010179.59918 | 2108995.88933 | 37.7714749641405 | -122.408159994002 | (37.7714749641405, -122.408159994002) | |||
| 41437 | 41437 | 189071 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1157 Bryant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009822.97122 | 2108648.63961 | 37.7705015217488 | -122.40936908392 | (37.7705015217488, -122.40936908392) | |||
| 41500 | 41500 | 220419 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1601 Bryant St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009469.46402 | 2107213.1866900004 | 37.76654028692471 | -122.41049049535299 | (37.7665402869247, -122.410490495353) | |||
| 41565 | 41565 | 244890 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 300x Divisadero St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001780.4834 | 2109546.7964 | 37.772513747957 | -122.43725237282601 | (37.772513747957, -122.437252372826) | |||
| 41685 | 41685 | 187956 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 390 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6014829.80215 | 2114536.3127599997 | 37.78694699864871 | -122.392462171218 | (37.7869469986487, -122.392462171218) | |||
| 42109 | 42109 | 247508 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 400x Divisadero St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001724.0539 | 2109895.2534 | 37.7734673159842 | -122.43747252535401 | (37.7734673159842, -122.437472525354) | |||
| 42234 | 42234 | 187869 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 7ft | 6015103.96021 | 2100930.78351 | 37.749604420516896 | -122.390562573713 | (37.7496044205169, -122.390562573713) | |||
| 42445 | 42445 | 138175 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 900x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001483.6566 | 2111580.5714 | 37.778081105415396 | -122.438424861346 | (37.7780811054154, -122.438424861346) | |||
| 42570 | 42570 | 141373 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 500x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001678.0066 | 2110208.8368 | 37.7743257195795 | -122.437654271553 | (37.7743257195795, -122.437654271553) | |||
| 42641 | 42641 | 220445 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 2501 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6009766.24645 | 2102672.6598 | 37.7540896615292 | -122.409143546541 | (37.7540896615292, -122.409143546541) | |||
| 43028 | 43028 | 141617 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 2 | Width 0ft | 6001580.3173 | 2110897.2965 | 37.776210502271105 | -122.43804152155 | (37.7762105022711, -122.43804152155) | |||
| 43311 | 43311 | 137723 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 800x DIVISADERO ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001529.3435 | 2111250.6101 | 37.7771777134961 | -122.438243170212 | (37.7771777134961, -122.438243170212) | |||
| 43633 | 43633 | 203422 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 9 Yerba Buena Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5993354.866669999 | 2097295.22775 | 37.738391538344004 | -122.465506999949 | (37.738391538344, -122.465506999949) | |||
| 43821 | 43821 | 141616 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 700x DIVISADERO ST | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 6001582.0309 | 2110873.3052 | 37.7761447256429 | -122.43803387483601 | (37.7761447256429, -122.438033874836) | |||
| 43888 | 43888 | 187906 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 167 Jessie St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011990.7752 | 2114556.67649 | 37.7868448464448 | -122.402286048678 | (37.7868448464448, -122.402286048678) | |||
| 44777 | 44777 | 187875 | Undocumented 2 | Acer rubrum :: Red Maple 6 | 1600 Indiana St | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6015128.62493 | 2100811.61735 | 37.7492785835592 | -122.390468956103 | (37.7492785835592, -122.390468956103) |
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");