Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID ▲ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5055 | 5055 | 253765 | Significant Tree 6 | Acacia baileyana :: Bailey's Acacia 42 | 1366 Guerrero St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3X3 | 6005800.0848900005 | 2101007.6677599996 | 37.7492949871928 | -122.422741198761 | (37.7492949871928, -122.422741198761) | ||||
| 4165 | 4165 | 253615 | Permitted Site 1 | Acacia baileyana :: Bailey's Acacia 42 | 2325 Polk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/17/1998 12:00:00 AM | 3x3 | Permit Number 38749 | 6006221.0 | 2118816.0 | 37.7982161239914 | -122.422550935399 | (37.7982161239914, -122.422550935399) | ||
| 1536 | 1536 | 251472 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Hiliritas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780012 | 6001589.0 | 2096875.0 | 37.7377091611847 | -122.437007355935 | (37.7377091611847, -122.437007355935) | |
| 135843 | 135843 | 250193 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011782.399230001 | 2119949.71509 | 37.8016412059365 | -122.403386530161 | (37.8016412059365, -122.403386530161) | |||
| 24822 | 24822 | 250192 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6011786.88966 | 2119947.0785 | 37.8016342173021 | -122.403370805543 | (37.8016342173021, -122.403370805543) | |||
| 47761 | 47761 | 250191 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 11 Alta St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Width 0ft | 6011795.08799 | 2119945.2148 | 37.8016295579248 | -122.40334230423099 | (37.8016295579248, -122.403342304231) | |||
| 72487 | 72487 | 249768 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 266 Lombard St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 0ft | 6010977.12206 | 2120702.10235 | 37.8036620671076 | -122.406226211476 | (37.8036620671076, -122.406226211476) | |||
| 176295 | 176295 | 249709 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 2901 Broadway | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5999701.30683 | 2117014.48804 | 37.7928996850292 | -122.44498136009899 | (37.7928996850292, -122.444981360099) | ||||
| 22329 | 22329 | 248977 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 748 Central Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999650.0 | 2111146.0 | 37.7767834132689 | -122.444736872581 | (37.7767834132689, -122.444736872581) | ||||
| 154005 | 154005 | 248396 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997671.1383 | 2108143.749 | 37.768426881635605 | -122.45136572862499 | (37.7684268816356, -122.451365728625) | |||
| 64130 | 64130 | 248395 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1655 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997659.0251 | 2108142.2349 | 37.768422030688896 | -122.451407517669 | (37.7684220306889, -122.451407517669) | |||
| 184798 | 184798 | 248081 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6010444.64523 | 2100169.33268 | 37.7472540585408 | -122.40662106962799 | (37.7472540585408, -122.406621069628) | |||
| 183876 | 183876 | 246998 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 33 Clipper St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6004927.947919999 | 2101037.11705 | 37.7493266028416 | -122.42575916347602 | (37.7493266028416, -122.425759163476) | |||
| 41964 | 41964 | 246075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 635 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5998492.5621 | 2108432.0423 | 37.7692654626532 | -122.44854527514299 | (37.7692654626532, -122.448545275143) | |||
| 62430 | 62430 | 246034 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 618 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998524.9649 | 2108501.9958 | 37.7694593898353 | -122.44843823441002 | (37.7694593898353, -122.44843823441) | |||
| 60228 | 60228 | 245868 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 415 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6005026.3603 | 2110433.2652 | 37.775131757595204 | -122.42608767011801 | (37.7751317575952, -122.426087670118) | |||
| 70721 | 70721 | 245867 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 419 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005023.743 | 2110457.4751 | 37.775198084155605 | -122.42609844781799 | (37.7751980841556, -122.426098447818) | |||
| 60577 | 60577 | 245840 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 421 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005021.78 | 2110481.0306 | 37.775262650872 | -122.42610691556601 | (37.775262650872, -122.426106915566) | |||
| 173572 | 173572 | 245839 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 423 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6005015.8911 | 2110507.8578 | 37.775335978986796 | -122.4261291969 | (37.7753359789868, -122.4261291969) | |||
| 69574 | 69574 | 245838 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 423 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6005012.6195 | 2110528.7961 | 37.7753932855436 | -122.426142005084 | (37.7753932855436, -122.426142005084) | |||
| 184019 | 184019 | 245165 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1364 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000037.7937 | 2109212.4329 | 37.7714964504984 | -122.443256472847 | (37.7714964504984, -122.443256472847) | |||
| 50765 | 50765 | 244169 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1752 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998187.9203 | 2108956.9743 | 37.7706893684237 | -122.449636842472 | (37.7706893684237, -122.449636842472) | |||
| 161597 | 161597 | 220697 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 897 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5998695.14565 | 2106960.91022 | 37.7652376872994 | -122.447738631145 | (37.7652376872994, -122.447738631145) | |||
| 157007 | 157007 | 220696 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 407 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 5998482.20862 | 2106820.01065 | 37.764838640103505 | -122.44846497847799 | (37.7648386401035, -122.448464978478) | |||
| 146931 | 146931 | 220695 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3706 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6004965.60953 | 2102543.32238 | 37.7534644213631 | -122.425736121051 | (37.7534644213631, -122.425736121051) | |||
| 162001 | 162001 | 220694 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4054 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6003525.2287099995 | 2100710.43544 | 37.74835024488029 | -122.430586486796 | (37.7483502448803, -122.430586486796) | |||
| 135419 | 135419 | 220693 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3897 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6004694.52758 | 2100732.52355 | 37.7484770663623 | -122.426544650217 | (37.7484770663623, -122.426544650217) | |||
| 177028 | 177028 | 220692 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3951 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004169.986740001 | 2100702.91409 | 37.7483660981244 | -122.42835639293999 | (37.7483660981244, -122.42835639294) | |||
| 54206 | 54206 | 220691 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 455 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6002941.274019999 | 2099459.3166400003 | 37.7448818664203 | -122.432516435499 | (37.7448818664203, -122.432516435499) | |||
| 28541 | 28541 | 220690 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 330 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003721.786040001 | 2099258.64688 | 37.7443751038286 | -122.42980326002 | (37.7443751038286, -122.42980326002) | |||
| 26472 | 26472 | 220689 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 119 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004994.550369999 | 2099284.37518 | 37.744517739909 | -122.42540413451401 | (37.744517739909, -122.425404134514) | |||
| 68651 | 68651 | 220688 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 434 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004866.02058 | 2110397.15298 | 37.7750235387365 | -122.426639749043 | (37.7750235387365, -122.426639749043) | |||
| 53685 | 53685 | 220687 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6004894.475319999 | 2110399.44382 | 37.775031437471704 | -122.426541481018 | (37.7750314374717, -122.426541481018) | |||
| 44479 | 44479 | 220686 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6004903.16789 | 2110400.7033700002 | 37.775035387294295 | -122.426511501216 | (37.7750353872943, -122.426511501216) | |||
| 185398 | 185398 | 220685 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 452 Hickory St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 2ft | 6004772.24556 | 2110355.93232 | 37.774905054848396 | -122.426961200922 | (37.7749050548484, -122.426961200922) | |||
| 130058 | 130058 | 220684 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 452 Hickory St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004755.351530001 | 2110353.8827 | 37.7748984718146 | -122.427019494961 | (37.7748984718146, -122.427019494961) | |||
| 154694 | 154694 | 220683 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 364 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004832.893569999 | 2109879.94078 | 37.7736015271323 | -122.426717502624 | (37.7736015271323, -122.426717502624) | |||
| 183618 | 183618 | 220682 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1624 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009643.101369999 | 2100250.00573 | 37.7474306916674 | -122.40939845218 | (37.7474306916674, -122.40939845218) | |||
| 170817 | 170817 | 220681 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3223 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6009028.25622 | 2099907.20942 | 37.74645498032329 | -122.41150033867201 | (37.7464549803233, -122.411500338672) | |||
| 136911 | 136911 | 220680 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 54 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005359.13512 | 2103393.3623900004 | 37.7558206631137 | -122.424435681558 | (37.7558206631137, -122.424435681558) | |||
| 162378 | 162378 | 220679 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3607 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006165.33609 | 2104321.13003 | 37.758413591125205 | -122.421713467922 | (37.7584135911252, -122.421713467922) | |||
| 33878 | 33878 | 220678 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3607 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006149.55219 | 2104320.61277 | 37.758411280773394 | -122.421768019002 | (37.7584112807734, -122.421768019002) | |||
| 43321 | 43321 | 220677 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3625 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006108.91147 | 2104316.6789599997 | 37.758398187543996 | -122.42190829343399 | (37.758398187544, -122.421908293434) | |||
| 187340 | 187340 | 220676 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3681 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6005782.66085 | 2104298.9799099998 | 37.7583311853523 | -122.423035356192 | (37.7583311853523, -122.423035356192) | |||
| 152597 | 152597 | 220675 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3681 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005766.61271 | 2104299.30973 | 37.758331185361 | -122.423090881238 | (37.758331185361, -122.423090881238) | |||
| 47618 | 47618 | 220674 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3548 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005923.11971 | 2104936.6524900002 | 37.760090010159104 | -122.42259489975201 | (37.7600900101591, -122.422594899752) | |||
| 41095 | 41095 | 220673 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Alemany Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009345.21028 | 2095878.12902 | 37.735409776738294 | -122.410119940478 | (37.7354097767383, -122.410119940478) | |||
| 50057 | 50057 | 220672 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 25 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6005444.88154 | 2104573.79472 | 37.759066695887 | -122.42422309172701 | (37.759066695887, -122.424223091727) | |||
| 156715 | 156715 | 220671 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 100 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009657.24605 | 2096276.1729599999 | 37.7365202047272 | -122.409069188799 | (37.7365202047272, -122.409069188799) | |||
| 188761 | 188761 | 220670 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 948 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009928.95694 | 2103687.06035 | 37.7568840925314 | -122.408652407882 | (37.7568840925314, -122.408652407882) | |||
| 180724 | 180724 | 220669 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 684 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007464.462180001 | 2105680.20341 | 37.7622184653282 | -122.41731681192199 | (37.7622184653282, -122.417316811922) | |||
| 26281 | 26281 | 220668 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 680 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007462.21417 | 2105696.0479 | 37.762261844143296 | -122.417325709834 | (37.7622618441433, -122.417325709834) | |||
| 48265 | 48265 | 220667 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1337 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007176.0273400005 | 2107716.44116 | 37.767793265562894 | -122.41845879174801 | (37.7677932655629, -122.418458791748) | |||
| 45531 | 45531 | 220666 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1 Dorland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6005487.19676 | 2105743.72088 | 37.7622814268651 | -122.42415994852199 | (37.7622814268651, -122.424159948522) | |||
| 175791 | 175791 | 220665 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 215 Webster St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6004174.507619999 | 2109590.46036 | 37.7727694393 | -122.42897431622801 | (37.7727694393, -122.428974316228) | |||
| 159982 | 159982 | 220096 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 2ft | 6002436.28409 | 2096397.8300700001 | 37.736447085360105 | -122.43404379100402 | (37.7364470853601, -122.434043791004) | |||
| 166281 | 166281 | 220095 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 5 Penny Ln | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002427.25103 | 2096406.93673 | 37.7364715774983 | -122.43407567285601 | (37.7364715774983, -122.434075672856) | |||
| 25432 | 25432 | 220094 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 436 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6003910.2005900005 | 2096060.2503799999 | 37.735603706528394 | -122.42892377971 | (37.7356037065284, -122.42892377971) | |||
| 55582 | 55582 | 220093 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1754 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003963.29373 | 2098007.80301 | 37.7409542473406 | -122.428879018678 | (37.7409542473406, -122.428879018678) | |||
| 178198 | 178198 | 220092 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 24 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006394.365680001 | 2110096.52086 | 37.774284361671 | -122.42133150875601 | (37.774284361671, -122.421331508756) | |||
| 186973 | 186973 | 220091 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3076 Merritt St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6000057.55788 | 2105416.72092 | 37.7610754998513 | -122.442915486985 | (37.7610754998513, -122.442915486985) | |||
| 25732 | 25732 | 220090 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Ord Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000882.83826 | 2105748.10477 | 37.7620324153945 | -122.44008496885401 | (37.7620324153945, -122.440084968854) | |||
| 58566 | 58566 | 220089 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Ord Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6000884.7117 | 2105729.84303 | 37.7619823797984 | -122.44007717983101 | (37.7619823797984, -122.440077179831) | |||
| 157166 | 157166 | 220088 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 18 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001975.9163 | 2107746.07495 | 37.767580520153 | -122.43644744680701 | (37.767580520153, -122.436447446807) | |||
| 45390 | 45390 | 220087 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 69 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6001718.50654 | 2105457.8427 | 37.7612829653482 | -122.437173938027 | (37.7612829653482, -122.437173938027) | |||
| 188143 | 188143 | 220086 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 77 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6001721.7342 | 2105412.03314 | 37.761157366929204 | -122.43715949493601 | (37.7611573669292, -122.437159494936) | |||
| 148095 | 148095 | 220085 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 223 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004732.04309 | 2103949.70152 | 37.757312807464 | -122.42664398483299 | (37.757312807464, -122.426643984833) | |||
| 152179 | 152179 | 220084 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3580 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6004538.52309 | 2103691.84305 | 37.7565938462521 | -122.427294885373 | (37.7565938462521, -122.427294885373) | |||
| 34367 | 34367 | 220083 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4133 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002828.79114 | 2104135.9049299997 | 37.7577162927799 | -122.43323947601401 | (37.7577162927799, -122.433239476014) | |||
| 133605 | 133605 | 220082 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 780 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003052.51993 | 2103630.15774 | 37.7563403210743 | -122.43242960863701 | (37.7563403210743, -122.432429608637) | |||
| 40035 | 40035 | 220081 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 780 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6003049.24321 | 2103668.76893 | 37.756446152387795 | -122.432443698342 | (37.7564461523878, -122.432443698342) | |||
| 170794 | 170794 | 220080 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 517 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002959.284990001 | 2103850.36087 | 37.756939658960206 | -122.432767777111 | (37.7569396589602, -122.432767777111) | |||
| 52495 | 52495 | 220079 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4021 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003566.56829 | 2104171.42308 | 37.7578556427516 | -122.43069047448799 | (37.7578556427516, -122.430690474488) | |||
| 183611 | 183611 | 220078 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4021 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003547.22001 | 2104169.9563599997 | 37.7578505193113 | -122.430757284236 | (37.7578505193113, -122.430757284236) | |||
| 67640 | 67640 | 220077 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4160 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6002637.75275 | 2104169.9909900003 | 37.7577990456928 | -122.433902601035 | (37.7577990456928, -122.433902601035) | |||
| 174318 | 174318 | 220076 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4512 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6001006.90228 | 2104666.0365299997 | 37.7590683830131 | -122.43957830609 | (37.7590683830131, -122.43957830609) | |||
| 33288 | 33288 | 220075 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 311 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001146.06945 | 2104525.9934099996 | 37.758691778412704 | -122.43908696419201 | (37.7586917784127, -122.439086964192) | |||
| 45254 | 45254 | 220074 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 148 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002660.22221 | 2105037.36162 | 37.7601819118789 | -122.43388688897 | (37.7601819118789, -122.43388688897) | |||
| 160608 | 160608 | 220073 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 147 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6002697.135559999 | 2105044.08938 | 37.7602024793668 | -122.433759704173 | (37.7602024793668, -122.433759704173) | |||
| 162807 | 162807 | 220072 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 60 Hartford St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002632.838880001 | 2105513.14285 | 37.7614867382526 | -122.434015605341 | (37.7614867382526, -122.434015605341) | |||
| 153239 | 153239 | 220071 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3854 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003950.57262 | 2104825.46317 | 37.7596732292507 | -122.429409067394 | (37.7596732292507, -122.429409067394) | |||
| 75192 | 75192 | 220070 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 410 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003569.73703 | 2105814.1279 | 37.762366296795996 | -122.43079674288 | (37.762366296796, -122.43079674288) | |||
| 59933 | 59933 | 220069 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1047 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003827.33604 | 2102174.6628400004 | 37.7523877808826 | -122.42964622220501 | (37.7523877808826, -122.429646222205) | |||
| 68889 | 68889 | 220068 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3749 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003417.1638 | 2103582.09113 | 37.756229011985 | -122.43116511330601 | (37.756229011985, -122.431165113306) | |||
| 47075 | 47075 | 220067 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3781 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003185.70208 | 2103572.60316 | 37.756189841101296 | -122.431964909158 | (37.7561898411013, -122.431964909158) | |||
| 44341 | 44341 | 220066 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1109 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6002537.114630001 | 2102291.1496200003 | 37.7526344847082 | -122.434116340213 | (37.7526344847082, -122.434116340213) | |||
| 53450 | 53450 | 220065 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 561 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6002722.15364 | 2102085.17478 | 37.7520794267235 | -122.43346172547501 | (37.7520794267235, -122.433461725475) | |||
| 42523 | 42523 | 220064 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 4086 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002590.76073 | 2102413.7777400003 | 37.7529742368948 | -122.43393958746701 | (37.7529742368948, -122.433939587467) | |||
| 63361 | 63361 | 220063 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 930 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003095.90411 | 2102839.48353 | 37.75417177772871 | -122.432223106309 | (37.7541717777287, -122.432223106309) | |||
| 31819 | 31819 | 220062 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 430 College Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 3ft | 6005376.5701 | 2095055.5296099999 | 37.7329278583224 | -122.423782556133 | (37.7329278583224, -122.423782556133) | |||
| 175760 | 175760 | 220061 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 496 Bartlett St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006778.4719 | 2100919.5429 | 37.749108169217294 | -122.41935165935101 | (37.7491081692173, -122.419351659351) | |||
| 147911 | 147911 | 220060 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006048.59787 | 2101976.73727 | 37.751969847944295 | -122.42195066499599 | (37.7519698479443, -122.421950664996) | |||
| 176834 | 176834 | 220059 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 3505 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006111.03304 | 2101975.99077 | 37.75197131922489 | -122.42173470182101 | (37.7519713192249, -122.421734701821) | |||
| 48670 | 48670 | 220058 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 564 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6007852.78726 | 2104670.9495900003 | 37.7594691272161 | -122.415902267384 | (37.7594691272161, -122.415902267384) | |||
| 47068 | 47068 | 220057 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 938 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6007984.69118 | 2102236.05472 | 37.752790875909 | -122.41527371052099 | (37.752790875909, -122.415273710521) | |||
| 57888 | 57888 | 220056 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1424 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6009277.433730001 | 2100868.30065 | 37.7491078976199 | -122.410706569176 | (37.7491078976199, -122.410706569176) | |||
| 171522 | 171522 | 220055 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 32 Elsie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007497.36019 | 2099175.1634299997 | 37.7443589574154 | -122.416742166726 | (37.7443589574154, -122.416742166726) | |||
| 30672 | 30672 | 220054 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 300 Virginia Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 6006920.61613 | 2098340.82095 | 37.742035584087795 | -122.418677274846 | (37.7420355840878, -122.418677274846) | |||
| 50333 | 50333 | 220053 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 50 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006880.915569999 | 2099461.25928 | 37.7451098211639 | -122.418893994368 | (37.7451098211639, -122.418893994368) | |||
| 53857 | 53857 | 220052 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 50 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006851.995619999 | 2099403.94647 | 37.7449508246175 | -122.418989930439 | (37.7449508246175, -122.418989930439) |
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");