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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
44683 | 44683 | 176302 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100x Mansell St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | Width 0ft | 6011513.54745 | 2090660.92357 | 37.721205711656204 | -122.40225644658301 | (37.7212057116562, -122.402256446583) | |||
46601 | 46601 | 84938 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 145 Guerrero St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 49347 | 6005480.0 | 2108218.0 | 37.769074802262395 | -122.42436083172 | (37.7690748022624, -122.42436083172) | ||||
46745 | 46745 | 176303 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 200x Mansell St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 23 | Width 0ft | 6011115.33526 | 2090539.9745900002 | 37.7208513742667 | -122.40362445389799 | (37.7208513742667, -122.403624453898) | |||
47306 | 47306 | 224452 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 1300 San Jose Ave | 57 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6003256.424219999 | 2095477.2065700002 | 37.7339657739995 | -122.43114253132099 | (37.7339657739995, -122.431142531321) | ||||
48344 | 48344 | 191716 | Undocumented 2 | Eucalyptus Spp :: Eucalyptus 40 | 561 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6011818.5901 | 2105765.65198 | 37.7626970962079 | -122.40226345320801 | (37.7626970962079, -122.402263453208) | |||
49634 | 49634 | 112391 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 2201X LYON ST | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x12 | 5999307.0 | 2116423.0 | 37.7912531030346 | -122.446303107227 | (37.7912531030346, -122.446303107227) | ||||
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) | ||||
50313 | 50313 | 69180 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1310 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1994 12:00:00 AM | 8 | Permit Number 33219 | 5982156.72464205 | 2106168.22486515 | 37.7621020835294 | -122.504881372035 | (37.7621020835294, -122.504881372035) | |
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) | ||||
69668 | 69668 | 66337 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1230 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/1990 12:00:00 AM | 12 | Permit Number 29458 | 5986478.94641131 | 2106871.16119587 | 37.7642854833106 | -122.489984375656 | (37.7642854833106, -122.489984375656) | |
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) | |||
72418 | 72418 | 54847 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2056 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 20 | 3x3 | Permit Number 10705 | 5997976.78501928 | 2110316.64994342 | 37.7744106068743 | -122.45046519400199 | (37.7744106068743, -122.450465194002) | |
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) | |||
76630 | 76630 | 54757 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 330 Lathrop Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/1972 12:00:00 AM | 14 | Permit Number 10606 | 6012426.81669 | 2086731.5712700002 | 37.7104674323033 | -122.39882388720801 | (37.7104674323033, -122.398823887208) | ||
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) | |||
77778 | 77778 | 64888 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 2418 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/01/1989 12:00:00 AM | Permit Number 25914 | 5989547.06003251 | 2098884.34921412 | 37.742534500381105 | -122.478788583135 | (37.7425345003811, -122.478788583135) | ||
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) | |||
78735 | 78735 | 94388 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
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) | |||
80436 | 80436 | 87674 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 770 Golden Gate Ave | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 05/22/2008 12:00:00 AM | 3x3 | Permit Number 50396 | 6005860.1 | 2112469.5 | 37.7807698496384 | -122.42334835915399 | (37.7807698496384, -122.423348359154) | ||
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) | |||
81361 | 81361 | 63362 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 401 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30039 | 6006709.37395927 | 2096284.55563078 | 37.7363776416136 | -122.41926185234301 | (37.7363776416136, -122.419261852343) | ||
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) | ||||
81490 | 81490 | 62008 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 3400 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/31/1985 12:00:00 AM | Permit Number 22077 | 6003692.18423041 | 2120397.09224754 | 37.8024144061446 | -122.431414313869 | (37.8024144061446, -122.431414313869) | ||
81491 | 81491 | 63452 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 425 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/20/1991 12:00:00 AM | Permit Number 30038 | 6006658.37862364 | 2096248.30501412 | 37.7362752333103 | -122.419435593969 | (37.7362752333103, -122.419435593969) | ||
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) | |||||
82837 | 82837 | 62309 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 197 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/1985 12:00:00 AM | Permit Number 22447 | 5996603.44612338 | 2111537.89783115 | 37.7776851364685 | -122.45530408152 | (37.7776851364685, -122.45530408152) | ||
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) | |||
82914 | 82914 | 67118 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 35 Carmel St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/29/1992 12:00:00 AM | Permit Number 30538 | 5998791.80760997 | 2105372.50995466 | 37.7608818625197 | -122.44728997041 | (37.7608818625197, -122.44728997041) | ||
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) | |||
83388 | 83388 | 35531 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 90 Bartlett St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/1998 12:00:00 AM | Permit Number 38922 | 6006649.40506175 | 2103262.44015502 | 37.7555339585812 | -122.419964211868 | (37.7555339585812, -122.419964211868) | ||
83515 | 83515 | 94380 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
83877 | 83877 | 67842 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 3854 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/04/1993 12:00:00 AM | Permit Number 31510 | 6004840.52212153 | 2100493.06857021 | 37.7478278305843 | -122.426022759795 | (37.7478278305843, -122.426022759795) | ||
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) | |||
84196 | 84196 | 94383 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
84312 | 84312 | 49473 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1300 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/2003 12:00:00 AM | 3x3 | Permit Number 46398 | 5992038.44394874 | 2098453.2514756 | 37.7414951640526 | -122.47014280690901 | (37.7414951640526, -122.470142806909) | ||
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) | ||||
85476 | 85476 | 112374 | Significant Tree 6 | Eucalyptus Spp :: Eucalyptus 40 | 1247 Bosworth St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20x20 | Permit Number 775819 | 6000424.1100699995 | 2096055.79143 | 37.735393525896704 | -122.44097617665199 | (37.7353935258967, -122.440976176652) | |||
85692 | 85692 | 63202 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 7 Shore View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/18/1986 12:00:00 AM | Permit Number 23744 | 5984650.094069201 | 2112837.90974399 | 37.78056150785579 | -122.496750144554 | (37.7805615078558, -122.496750144554) | ||
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) | |||
85830 | 85830 | 32711 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 920 Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | Permit Number 44986 | 6007431.49416975 | 2114487.39461752 | 37.786399059728396 | -122.41805522728599 | (37.7863990597284, -122.418055227286) | ||
86223 | 86223 | 33221 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 130 Vasquez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/06/1996 12:00:00 AM | Permit Number 37412 | 5995037.97859853 | 2099619.33373801 | 37.7448698872964 | -122.459855964981 | (37.7448698872964, -122.459855964981) | ||
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) | ||||
86863 | 86863 | 61680 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 67 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | Permit Number 21677 | 6013883.88231185 | 2093810.46965069 | 37.7299857582394 | -122.39428321764 | (37.7299857582394, -122.39428321764) | ||
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) | ||||
87477 | 87477 | 91084 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 4055 24th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/22/2009 12:00:00 AM | 3x3 | Permit Number 51980 | 6002824.0 | 2101802.0 | 37.751307673555395 | -122.433089295463 | (37.7513076735554, -122.433089295463) | ||
87589 | 87589 | 94384 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
87626 | 87626 | 94379 | Permitted Site 1 | Eucalyptus Spp :: Eucalyptus 40 | 1001 Potrero Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | Permit Number 53641 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | ||||
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) |
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");