Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
49638 | 49638 | 25447 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1261X La Salle Ave | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
50131 | 50131 | 199404 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 24 | Median : Yard 3 | Tree 1 | DPW 2 | 31 | 6016629.65755 | 2096008.94769 | 37.7361745853726 | -122.38494375437 | (37.7361745853726, -122.38494375437) | ||||
50324 | 50324 | 224208 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 66 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 8ft | 6005339.07699 | 2097371.10972 | 37.7392838060945 | -122.424076794516 | (37.7392838060945, -122.424076794516) | |||
53330 | 53330 | 186974 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1600x Sloat Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 0ft | 5986249.0864 | 2095869.2083 | 37.7340636742344 | -122.489970132524 | (37.7340636742344, -122.489970132524) | |||
53591 | 53591 | 113159 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005146.0 | 2111243.0 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | ||||
55441 | 55441 | 199405 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 301x Cashmere St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 25 | 6016273.90453 | 2096214.7321400002 | 37.736719944173004 | -122.386188091409 | (37.736719944173, -122.386188091409) | ||||
56266 | 56266 | 9287 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 13X George Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017208.549763201 | 2094048.0250586998 | 37.7308222832509 | -122.38280584856301 | (37.7308222832509, -122.382805848563) | |||
57509 | 57509 | 224451 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 56 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6003260.74151 | 2095484.4937599998 | 37.73398602761579 | -122.431128125086 | (37.7339860276158, -122.431128125086) | ||||
58693 | 58693 | 218793 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 616 Joost Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 10ft | 5998053.08406 | 2095010.8668400003 | 37.7323890825862 | -122.449098408785 | (37.7323890825862, -122.449098408785) | |||
58856 | 58856 | 185127 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Sloat Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 5989015.4133 | 2095969.6432 | 37.734500589899504 | -122.480413539116 | (37.7345005898995, -122.480413539116) | |||
61013 | 61013 | 199410 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 822 Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6015932.24155 | 2096672.73443 | 37.7379586091972 | -122.387401320018 | (37.7379586091972, -122.387401320018) | |||
62350 | 62350 | 176309 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 21 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6010760.4946 | 2090426.07331 | 37.720518796898 | -122.404843021812 | (37.720518796898, -122.404843021812) | |||
62541 | 62541 | 224210 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1001 San Jose Ave | 72 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005362.146369999 | 2097481.1402 | 37.739587227456205 | -122.42400485326401 | (37.7395872274562, -122.424004853264) | ||||
62801 | 62801 | 176326 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 26 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009300.414580001 | 2090007.1642099998 | 37.719286839006706 | -122.40986051846701 | (37.7192868390067, -122.409860518467) | |||
62903 | 62903 | 224203 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 34 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 6003487.067319999 | 2095623.9761599998 | 37.734381837255505 | -122.430355595758 | (37.7343818372555, -122.430355595758) | ||||
63643 | 63643 | 224453 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 35 | 6003249.48151 | 2095473.62453 | 37.733955545103505 | -122.43116627879499 | (37.7339555451035, -122.431166278795) | ||||
64522 | 64522 | 176312 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 0ft | 6010340.9019 | 2090322.69069 | 37.720211467072296 | -122.406286146812 | (37.7202114670723, -122.406286146812) | |||
64735 | 64735 | 176318 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | Width 0ft | 6009900.75619 | 2090162.07565 | 37.71974582058 | -122.40779627129 | (37.71974582058, -122.40779627129) | |||
66989 | 66989 | 176322 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6009482.932019999 | 2090051.6391099999 | 37.7194191850237 | -122.40923275838699 | (37.7194191850237, -122.409232758387) | |||
67534 | 67534 | 121262 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 505 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6005321.0 | 2111256.0 | 37.7774074352434 | -122.42512699851002 | (37.7774074352434, -122.42512699851) | |||
68584 | 68584 | 139748 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1330 Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004640.4611 | 2113601.4606 | 37.783809022804206 | -122.427648355277 | (37.7838090228042, -122.427648355277) | |||
69429 | 69429 | 224202 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 27 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6003508.627309999 | 2095617.8291 | 37.7343661800531 | -122.430280617458 | (37.7343661800531, -122.430280617458) | ||||
70430 | 70430 | 176306 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 300x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | Width 0ft | 6010916.0273400005 | 2090472.38873 | 37.7206546619672 | -122.40430865004299 | (37.7206546619672, -122.404308650043) | |||
71049 | 71049 | 224216 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 23 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6005148.6559 | 2097255.3705700003 | 37.73895525948029 | -122.424726954897 | (37.7389552594803, -122.424726954897) | ||||
71073 | 71073 | 199399 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 299x Cashmere St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016725.29246 | 2095937.31293 | 37.7359831799735 | -122.38460811386999 | (37.7359831799735, -122.38460811387) | ||||
72098 | 72098 | 187038 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 2501 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984961.8902 | 2097789.6624 | 37.7392614795793 | -122.494561832752 | (37.7392614795793, -122.494561832752) | |||
72173 | 72173 | 176321 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6009491.13352 | 2090035.22052 | 37.7193745624679 | -122.409203250746 | (37.7193745624679, -122.409203250746) | |||
72865 | 72865 | 224450 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 55 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | 6003275.39086 | 2095494.7434599998 | 37.7340150010873 | -122.431078209119 | (37.7340150010873, -122.431078209119) | ||||
73572 | 73572 | 176297 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 10x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 22 | Width 0ft | 6011769.33402 | 2090739.1089 | 37.7214346673524 | -122.401377752274 | (37.7214346673524, -122.401377752274) | |||
73620 | 73620 | 176316 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 600x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 20 | Width 0ft | 6009975.17316 | 2090196.6271099998 | 37.7198448575227 | -122.40754147176001 | (37.7198448575227, -122.40754147176) | |||
75997 | 75997 | 176325 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 700x Mansell St | 25 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6009306.38792 | 2090008.2878700001 | 37.7192902591068 | -122.40983995006701 | (37.7192902591068, -122.409839950067) | |||
76398 | 76398 | 17253 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 15 Osceola Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6017345.102761 | 2094248.0837328997 | 37.7313791485056 | -122.382347671583 | (37.7313791485056, -122.382347671583) | |||
77295 | 77295 | 113498 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | 3x3 | 6011210.15679 | 2090562.2005 | 37.7209176983622 | -122.403298245537 | (37.7209176983622, -122.403298245537) | |||
77566 | 77566 | 106463 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 28 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
77748 | 77748 | 11361 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1350X Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6017253.696644001 | 2093959.2156363998 | 37.7305809242894 | -122.382643589629 | (37.7305809242894, -122.382643589629) | |||
77867 | 77867 | 12494 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
78038 | 78038 | 11356 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1339 Ingalls St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017292.9099838 | 2093920.0801467 | 37.7304756321775 | -122.382505299944 | (37.7304756321775, -122.382505299944) | |||
78081 | 78081 | 12493 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 18 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
78083 | 78083 | 113326 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 237 Fairmount St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004215.8 | 2097159.4 | 37.7386390150291 | -122.427945503988 | (37.7386390150291, -122.427945503988) | ||||
78473 | 78473 | 105080 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3770 24TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x4 | 6004633.1 | 2101955.7 | 37.7518321521274 | -122.426844164794 | (37.7518321521274, -122.426844164794) | |||
79586 | 79586 | 94645 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 30 Middle Point Rd | 34 | : 4 | Tree 1 | Private 1 | 6018215.0 | 2095138.0 | 37.733870695497295 | -122.37940203679399 | (37.7338706954973, -122.379402036794) | |||||
79746 | 79746 | 23414 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1800X VAN NESS AVE | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006192.0 | 2116736.0 | 37.7925033310543 | -122.422503407712 | (37.7925033310543, -122.422503407712) | |||
80454 | 80454 | 12087 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1261X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
80713 | 80713 | 12013 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
80719 | 80719 | 116576 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2500x OCEAN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | MTA 6 | DPW 4 | 30 | 10X10 | 5991377.0 | 2094742.0 | 37.7312667472315 | -122.472159374256 | (37.7312667472315, -122.472159374256) | ||
81197 | 81197 | 11295 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1199X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.730508696225705 | -122.38140247160801 | (37.7305086962257, -122.381402471608) | |||
81240 | 81240 | 9288 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 13X George Ct | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017208.549763201 | 2094048.0250586998 | 37.7308222832509 | -122.38280584856301 | (37.7308222832509, -122.382805848563) | |||
81453 | 81453 | 114249 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 499x 24TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5988415.0 | 2112957.0 | 37.78110836988721 | -122.483734439284 | (37.7811083698872, -122.483734439284) | ||||
81628 | 81628 | 6104 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
81643 | 81643 | 11276 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
81756 | 81756 | 97781 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 249 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | strip | 5992441.6 | 2097612.4 | 37.7392096976829 | -122.468687674985 | (37.7392096976829, -122.468687674985) | |||
81860 | 81860 | 107385 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 2518X Diamond St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/26/2015 05:45:00 AM | 3 | 3x3 | 6002277.0 | 2097180.0 | 37.738585702213996 | -122.434650415337 | (37.738585702214, -122.434650415337) | ||
82160 | 82160 | 12018 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
82194 | 82194 | 109085 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 370 09TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5993248.4 | 2113128.2 | 37.781858605411294 | -122.467025880438 | (37.7818586054113, -122.467025880438) | |||
82770 | 82770 | 25448 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1261X La Salle Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | |||
82835 | 82835 | 113195 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 699X Noe St | 2 | Median : Yard 3 | Tree 1 | Private 1 | 6003039.779709999 | 2104315.51778 | 37.7582214335608 | -122.432522620301 | (37.7582214335608, -122.432522620301) | |||||
82877 | 82877 | 12490 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 35 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) | |||
83291 | 83291 | 12008 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
84076 | 84076 | 6103 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
84752 | 84752 | 106462 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 3500X MISSION ST | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 36 | 6005565.6 | 2097823.9 | 37.7405398531137 | -122.42332575716001 | (37.7405398531137, -122.42332575716) | ||||
85051 | 85051 | 107853 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 150 APTOS AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x2 | 5992855.9 | 2093940.6 | 37.7291517756313 | -122.466988351985 | (37.7291517756313, -122.466988351985) | ||||
85272 | 85272 | 9290 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 22 George Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017267.4584317 | 2094080.8187147 | 37.7309155826614 | -122.38260447080299 | (37.7309155826614, -122.382604470803) | |||
85292 | 85292 | 106578 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 24 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
85734 | 85734 | 24064 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 21X Whitfield Ct | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6017547.749564401 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | |||
86597 | 86597 | 102294 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1500 Michigan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6016449.0 | 2101073.5 | 37.7500708170088 | -122.38592128356701 | (37.7500708170088, -122.385921283567) | ||||
87121 | 87121 | 109844 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 535 CLAY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 5x5 | 6012019.0 | 2117742.0 | 37.7955925645 | -122.402412455116 | (37.7955925645, -122.402412455116) | |||
87198 | 87198 | 11271 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 60 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
87247 | 87247 | 95380 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
87873 | 87873 | 12038 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1250X La Salle Ave | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | |||
88326 | 88326 | 109852 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 3250x 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6006518.0 | 2103190.0 | 37.7553276504831 | -122.420413510616 | (37.7553276504831, -122.420413510616) | |||
88340 | 88340 | 11272 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
88594 | 88594 | 112580 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 274X SAN MARCOS AVE | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x20 | 5993121.0 | 2100271.0 | 37.7465487656332 | -122.46653182115801 | (37.7465487656332, -122.466531821158) | ||||
88629 | 88629 | 117549 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 24X KEMPTON AVE | 3 | Side Yard : Yard 17 | Tree 1 | DPW 2 | 30x30 | 5992274.0 | 2087683.0 | 37.7119363308651 | -122.46854490041599 | (37.7119363308651, -122.468544900416) | ||||
89065 | 89065 | 95379 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 20 Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 6003883.1 | 2108496.4 | 37.7697489175502 | -122.42990427345501 | (37.7697489175502, -122.429904273455) | ||||
91133 | 91133 | 11969 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 960X Mendell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6015772.64696 | 2096469.87167 | 37.7373927489725 | -122.387938970322 | (37.7373927489725, -122.387938970322) | |||
91437 | 91437 | 224213 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1000 San Jose Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6005183.176969999 | 2097360.09127 | 37.7392447485499 | -122.42461504414801 | (37.7392447485499, -122.424615044148) | ||||
91579 | 91579 | 109086 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 370 09TH AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 32 | 3x3 | 5993248.4 | 2113128.2 | 37.781858605411294 | -122.467025880438 | (37.7818586054113, -122.467025880438) | |||
91878 | 91878 | 109496 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 342 HILL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004048.2 | 2103384.6 | 37.755722487303295 | -122.428968694341 | (37.7557224873033, -122.428968694341) | ||||
92365 | 92365 | 11339 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1279 Ingalls St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6017412.9471167 | 2093950.7223454 | 37.7305663998171 | -122.38209244081101 | (37.7305663998171, -122.382092440811) | |||
92405 | 92405 | 17264 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 35 Osceola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017206.9997371 | 2094294.0023377 | 37.73149760272761 | -122.38282831855 | (37.7314976027276, -122.38282831855) | |||
92462 | 92462 | 110177 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 321 Fair Oaks St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6005492.60818902 | 2101839.04635751 | 37.7515604083348 | -122.423863569693 | (37.7515604083348, -122.423863569693) | ||||
92760 | 92760 | 12019 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1250X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/09/1992 12:00:00 AM | 12 | 3X3 | 6017218.4556902 | 2094518.6413490002 | 37.7321150500381 | -122.38280433953301 | (37.7321150500381, -122.382804339533) | ||
92881 | 92881 | 11274 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1176X Ingalls St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3x3 | 6017716.362196 | 2093961.1645628002 | 37.7306118245585 | -122.381044204671 | (37.7306118245585, -122.381044204671) | |||
92976 | 92976 | 17269 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 47 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017166.42434 | 2094311.14519 | 37.731542431743 | -122.382969789508 | (37.731542431743, -122.382969789508) | |||
93127 | 93127 | 26775 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 800X Junipero Serra Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4X4 | 5991258.8213354 | 2092171.434032 | 37.7242017753849 | -122.472380610595 | (37.7242017753849, -122.472380610595) | |||
93222 | 93222 | 6106 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
94353 | 94353 | 6101 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 500X 08th St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 18 | 6010526.812454099 | 2109340.6023904 | 37.772440902057795 | -122.406983260044 | (37.7724409020578, -122.406983260044) | |||
94436 | 94436 | 24061 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 21X Whitfield Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6017547.749564401 | 2094131.2536992 | 37.7310695474783 | -122.381638954529 | (37.7310695474783, -122.381638954529) | |||
94515 | 94515 | 107708 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1798X 31st Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5986575.46002 | 2103344.33269 | 37.7546074174257 | -122.489391225039 | (37.7546074174257, -122.489391225039) | ||||
94524 | 94524 | 112418 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 268X Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2.5x3 | 6005334.87738 | 2110100.0463 | 37.7742342515583 | -122.42499672664302 | (37.7742342515583, -122.424996726643) | ||||
94623 | 94623 | 11320 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1216X Ingalls St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/1999 12:00:00 AM | 3 | 3X3 | 6017561.7867095005 | 2093983.7658262001 | 37.7306653497809 | -122.38158017208 | (37.7306653497809, -122.38158017208) | ||
95293 | 95293 | 104649 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 200 Wheeler Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6012242.2 | 2087732.7 | 37.7132060446128 | -122.399532207425 | (37.7132060446128, -122.399532207425) | |||||
95658 | 95658 | 17262 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 30 Osceola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017260.6217082 | 2094327.801916 | 37.7315933721704 | -122.382645286292 | (37.7315933721704, -122.382645286292) | |||
95732 | 95732 | 106583 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1001X SAN JOSE AVE | 5 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6004855.0 | 2096548.0 | 37.7369963898236 | -122.42569194885799 | (37.7369963898236, -122.425691948858) | ||||
95843 | 95843 | 101217 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 444 De Haro St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011994.2 | 2106304.5 | 37.764186453503605 | -122.401693953948 | (37.7641864535036, -122.401693953948) | ||||
96019 | 96019 | 17259 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 25 Osceola Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6017276.1591118 | 2094269.688168 | 37.7314346616221 | -122.38258752773001 | (37.7314346616221, -122.38258752773) | |||
96237 | 96237 | 11349 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1300X Ingalls St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6017347.6886145 | 2093992.5867035 | 37.730677746775605 | -122.382320962891 | (37.7306777467756, -122.382320962891) | |||
96390 | 96390 | 11261 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1145X Ingalls St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3x4 | 6017856.860905 | 2093896.4273305 | 37.7304418229718 | -122.380553976439 | (37.7304418229718, -122.380553976439) | |||
96443 | 96443 | 12011 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 1230X La Salle Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017323.1168478 | 2094452.6646717 | 37.7319396729967 | -122.382437910438 | (37.7319396729967, -122.382437910438) | |||
96574 | 96574 | 12496 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 307 Lake Merced Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 24 | 90M | 5985224.7663097 | 2094165.6248746999 | 37.7293262181041 | -122.49338600271003 | (37.7293262181041, -122.49338600271) |
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");