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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 153425 | 153425 | 135111 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 6ft | 6010025.476419999 | 2122407.9816 | 37.8082927096198 | -122.409639920168 | (37.8082927096198, -122.409639920168) | |||
| 185518 | 185518 | 135100 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6010152.092130001 | 2122405.39789 | 37.8082927096059 | -122.409201548321 | (37.8082927096059, -122.409201548321) | |||
| 179244 | 179244 | 135108 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 6ft | 6010050.318469999 | 2122404.48556 | 37.8082845023835 | -122.40955370033998 | (37.8082845023835, -122.40955370034) | |||
| 49200 | 49200 | 135105 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6010067.690119999 | 2122402.63653 | 37.8082803987861 | -122.409493450268 | (37.8082803987861, -122.409493450268) | |||
| 132292 | 132292 | 134950 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008530.77029 | 2122432.69748 | 37.808276702577 | -122.414814516693 | (37.808276702577, -122.414814516693) | |||
| 42866 | 42866 | 135103 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 6ft | 6010086.51333 | 2122398.36657 | 37.80826972922029 | -122.40942800570299 | (37.8082697292203, -122.409428005703) | |||
| 63105 | 63105 | 134949 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008502.47143 | 2122430.5276099998 | 37.8082691545757 | -122.414912299066 | (37.8082691545757, -122.414912299066) | |||
| 168355 | 168355 | 135094 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010218.1810800005 | 2122393.28877 | 37.8082631632688 | -122.40897197389401 | (37.8082631632688, -122.408971973894) | ||||
| 182204 | 182204 | 134948 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008484.71937 | 2122427.98044 | 37.80826116317839 | -122.41497355457899 | (37.8082611631784, -122.414973554579) | |||
| 45743 | 45743 | 135093 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010231.518209999 | 2122384.9462900003 | 37.8082410039906 | -122.408925228011 | (37.8082410039906, -122.408925228011) | ||||
| 49085 | 49085 | 134960 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2571 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009191.48002 | 2122404.19262 | 37.8082355370081 | -122.41252593002399 | (37.8082355370081, -122.412525930024) | |||
| 153466 | 153466 | 134965 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2350 Stockton St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6009712.7239 | 2122389.48119 | 37.8082243818107 | -122.410720980795 | (37.8082243818107, -122.410720980795) | ||||
| 147530 | 147530 | 135099 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010189.07255 | 2122378.93733 | 37.8082221272074 | -122.40907169882401 | (37.8082221272074, -122.409071698824) | |||
| 165728 | 165728 | 134967 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6009753.391419999 | 2122386.8985 | 37.8082195704377 | -122.410580057033 | (37.8082195704377, -122.410580057033) | ||||
| 131497 | 131497 | 134966 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2350 Stockton St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6009730.51186 | 2122386.61497 | 37.808217509201704 | -122.41065921807 | (37.8082175092017, -122.41065921807) | ||||
| 151134 | 151134 | 134968 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6009782.97322 | 2122383.0408 | 37.8082106365745 | -122.41047740841101 | (37.8082106365745, -122.410477408411) | ||||
| 26655 | 26655 | 135095 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010206.33452 | 2122371.7105799997 | 37.8082032513446 | -122.409011448713 | (37.8082032513446, -122.409011448713) | |||
| 181018 | 181018 | 134969 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6009807.0374300005 | 2122379.79592 | 37.8082030759684 | -122.410393898262 | (37.8082030759684, -122.410393898262) | ||||
| 154015 | 154015 | 134970 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6009821.57971 | 2122377.9972900003 | 37.8081989525817 | -122.41034344359 | (37.8081989525817, -122.41034344359) | ||||
| 34855 | 34855 | 134971 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6009844.1621199995 | 2122376.03453 | 37.8081948291999 | -122.41026515223 | (37.8081948291999, -122.41026515223) | ||||
| 68508 | 68508 | 135092 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6010225.12119 | 2122365.6479 | 37.808187657103204 | -122.408946004172 | (37.8081876571032, -122.408946004172) | |||
| 130915 | 130915 | 135090 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010270.120709999 | 2122364.4312 | 37.808186836917294 | -122.40879018494199 | (37.8081868369173, -122.408790184942) | ||||
| 181647 | 181647 | 134972 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6009871.42123 | 2122369.22021 | 37.8081776467351 | -122.41017033311199 | (37.8081776467351, -122.410170333112) | ||||
| 65347 | 65347 | 134973 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6009889.50127 | 2122368.35067 | 37.808176272591794 | -122.41010770071001 | (37.8081762725918, -122.41010770071) | ||||
| 81393 | 81393 | 28280 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2799 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6008221.595290001 | 2122402.06867 | 37.8081752269627 | -122.415882331929 | (37.8081752269627, -122.415882331929) | |||
| 137451 | 137451 | 134974 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 8 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6009910.79688 | 2122364.91216 | 37.808168024892 | -122.410033758463 | (37.808168024892, -122.410033758463) | ||||
| 67107 | 67107 | 135091 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6010242.35879 | 2122357.22585 | 37.80816549781579 | -122.40888575407101 | (37.8081654978158, -122.408885754071) | |||
| 46112 | 46112 | 134975 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 9 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6009928.574659999 | 2122361.54548 | 37.808159777214705 | -122.409971995727 | (37.8081597772147, -122.409971995727) | ||||
| 31948 | 31948 | 135088 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010288.509880001 | 2122353.59437 | 37.8081581116658 | -122.40872577909201 | (37.8081581116658, -122.408725779092) | ||||
| 76087 | 76087 | 134976 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 10 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6009945.63465 | 2122359.94576 | 37.808156340907004 | -122.409912841929 | (37.808156340907, -122.409912841929) | ||||
| 175640 | 175640 | 134977 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2100 The Embarcadero | 11 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6009962.1815599995 | 2122357.85605 | 37.808151530425704 | -122.40985542918001 | (37.8081515304257, -122.40985542918) | ||||
| 168373 | 168373 | 135089 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 47 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010261.39064 | 2122348.4681700002 | 37.8081425174406 | -122.40881927081499 | (37.8081425174406, -122.408819270815) | |||
| 38055 | 38055 | 134980 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2350 Stockton St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6009736.585940001 | 2122356.6353700003 | 37.8081355332869 | -122.410636078516 | (37.8081355332869, -122.410636078516) | ||||
| 168722 | 168722 | 135086 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010304.534990001 | 2122344.59902 | 37.808134310218705 | -122.40866968476601 | (37.8081343102187, -122.408669684766) | ||||
| 152361 | 152361 | 134979 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2350 Stockton St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6009717.25232 | 2122356.15564 | 37.808133132108395 | -122.4107029539 | (37.8081331321084, -122.4107029539) | ||||
| 148039 | 148039 | 134947 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 211 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008187.16664 | 2122385.16272 | 37.808126871914 | -122.41600028361 | (37.808126871914, -122.41600028361) | |||
| 29517 | 29517 | 135087 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 45 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010278.59779 | 2122338.55223 | 37.8081162545339 | -122.408759020708 | (37.8081162545339, -122.408759020708) | |||
| 73121 | 73121 | 135085 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 43 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010323.2303 | 2122334.05501 | 37.8081064060573 | -122.408604240196 | (37.8081064060573, -122.408604240196) | ||||
| 22914 | 22914 | 134946 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 211 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008140.23343 | 2122378.4713 | 37.808105860161795 | -122.41616223440501 | (37.8081058601618, -122.416162234405) | |||
| 24412 | 24412 | 134961 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2571 Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009198.8753 | 2122354.69115 | 37.8081000334689 | -122.412496835171 | (37.8081000334689, -122.412496835171) | |||
| 151224 | 151224 | 135083 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010341.3497 | 2122324.71825 | 37.8080817844136 | -122.40854087398701 | (37.8080817844136, -122.408540873987) | ||||
| 34960 | 34960 | 135084 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 42 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010314.2182599995 | 2122318.99449 | 37.8080645489009 | -122.40863436569201 | (37.8080645489009, -122.408634365692) | |||
| 80184 | 80184 | 85053 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 59x Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2007 12:00:00 AM | Permit Number 49392 | 6008980.9 | 2122342.3 | 37.808053775378795 | -122.413250320783 | (37.8080537753788, -122.413250320783) | |||
| 107513 | 107513 | 85054 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 59x Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49392 | 6008980.9 | 2122342.3 | 37.808053775378795 | -122.413250320783 | (37.8080537753788, -122.413250320783) | ||||
| 186776 | 186776 | 135081 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010360.32068 | 2122312.9728200003 | 37.8080505968189 | -122.408474390679 | (37.8080505968189, -122.408474390679) | ||||
| 64424 | 64424 | 135082 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 40 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010330.81932 | 2122308.7922400003 | 37.8080374658197 | -122.408576193042 | (37.8080374658197, -122.408576193042) | |||
| 153265 | 153265 | 134978 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2350 Stockton St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6009731.6479400005 | 2122319.12499 | 37.8080322623412 | -122.41065051712201 | (37.8080322623412, -122.410650517122) | ||||
| 59097 | 59097 | 134962 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2571 Powell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009202.6339 | 2122329.62948 | 37.8080314313671 | -122.412482054823 | (37.8080314313671, -122.412482054823) | |||
| 178398 | 178398 | 135079 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010377.54006 | 2122303.65444 | 37.808025975171105 | -122.40841414062 | (37.8080259751711, -122.40841414062) | ||||
| 133811 | 133811 | 135080 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 38 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010349.21464 | 2122298.25404 | 37.8080095607584 | -122.408511787199 | (37.8080095607584, -122.408511787199) | |||
| 75529 | 75529 | 135077 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010393.83504 | 2122293.15944 | 37.8079980710226 | -122.40835700668998 | (37.8079980710226, -122.40835700669) | ||||
| 73434 | 73434 | 135078 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 36 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010369.3857 | 2122286.4841400003 | 37.80797837316371 | -122.408441149043 | (37.8079783731637, -122.408441149043) | |||
| 130521 | 130521 | 135075 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010411.666669999 | 2122284.4263400002 | 37.8079750906313 | -122.408294679165 | (37.8079750906313, -122.408294679165) | ||||
| 28 | 28 | 21823 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2741 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 4x4 | 6008229.33947 | 2122327.41953 | 37.8079706947476 | -122.415850241604 | (37.8079706947476, -122.415850241604) | ||
| 59815 | 59815 | 134963 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2571 Powell St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009205.86596 | 2122304.93297 | 37.8079638023512 | -122.41246912256099 | (37.8079638023512, -122.412469122561) | |||
| 33678 | 33678 | 135076 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 34 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010384.52328 | 2122278.10501 | 37.807956213866 | -122.408388169972 | (37.807956213866, -122.408388169972) | |||
| 174780 | 174780 | 135073 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010429.76812 | 2122274.19323 | 37.807948006662 | -122.40823131203001 | (37.807948006662, -122.40823131203) | ||||
| 61053 | 61053 | 135074 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 32 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 6010403.22449 | 2122267.85965 | 37.807929129896294 | -122.408322726326 | (37.8079291298963, -122.408322726326) | |||
| 135009 | 135009 | 135071 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6010449.38794 | 2122264.82595 | 37.8079233850293 | -122.408162751324 | (37.8079233850293, -122.408162751324) | ||||
| 62281 | 62281 | 135072 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 30 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6010421.04395 | 2122258.5290599996 | 37.8079045082466 | -122.408260398818 | (37.8079045082466, -122.408260398818) | |||
| 34886 | 34886 | 135069 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010465.71952 | 2122256.12348 | 37.8079004046485 | -122.408105617404 | (37.8079004046485, -122.408105617404) | ||||
| 182896 | 182896 | 134964 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2571 Powell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009209.45725 | 2122280.40631 | 37.807896659857796 | -122.412454959128 | (37.8078966598578, -122.412454959128) | |||
| 42690 | 42690 | 135067 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010487.41512 | 2122245.5184 | 37.8078725004725 | -122.40802978564899 | (37.8078725004725, -122.408029785649) | ||||
| 31717 | 31717 | 135070 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 28 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 6010442.39712 | 2122245.83866 | 37.8078708592274 | -122.4081856049 | (37.8078708592274, -122.4081856049) | |||
| 132184 | 132184 | 134957 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2620 Mason St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008770.82187 | 2122276.5778099997 | 37.8078615224509 | -122.41397269998699 | (37.8078615224509, -122.413972699987) | |||
| 63768 | 63768 | 135068 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 26 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010459.38358 | 2122239.81285 | 37.8078552649664 | -122.408126393527 | (37.8078552649664, -122.408126393527) | |||
| 38390 | 38390 | 133652 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3301 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6005119.938519999 | 2122348.80077 | 37.8078541066547 | -122.42661263717 | (37.8078541066547, -122.42661263717) | |||
| 73550 | 73550 | 135065 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010499.870619999 | 2122238.0904900003 | 37.8078528026406 | -122.407986155943 | (37.8078528026406, -122.407986155943) | ||||
| 41895 | 41895 | 135063 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010521.57842 | 2122228.08294 | 37.807826539739104 | -122.407910324225 | (37.8078265397391, -122.407910324225) | ||||
| 144819 | 144819 | 135066 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 5ft | 6010478.35466 | 2122228.06751 | 37.8078240773895 | -122.408059910256 | (37.8078240773895, -122.408059910256) | |||
| 187860 | 187860 | 135064 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6010496.20464 | 2122220.2308799997 | 37.8078035593512 | -122.407997582726 | (37.8078035593512, -122.407997582726) | |||
| 70100 | 70100 | 135055 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6010623.69108 | 2122216.13712 | 37.8077994557511 | -122.407556093844 | (37.8077994557511, -122.407556093844) | |||
| 46942 | 46942 | 134956 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2620 Mason St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008774.47074 | 2122251.86158 | 37.8077938628593 | -122.413958322524 | (37.8077938628593, -122.413958322524) | |||
| 53299 | 53299 | 135061 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6010544.11345 | 2122214.47173 | 37.807790428346294 | -122.407831375437 | (37.8077904283463, -122.407831375437) | ||||
| 59371 | 59371 | 135051 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6010641.22891 | 2122207.7092 | 37.8077772964393 | -122.407494805035 | (37.8077772964393, -122.407494805035) | |||
| 67452 | 67452 | 135062 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 19 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 5ft | 6010517.55761 | 2122207.54054 | 37.8077699103182 | -122.40792278972602 | (37.8077699103182, -122.407922789726) | |||
| 25269 | 25269 | 135059 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6010565.46035 | 2122201.4821900004 | 37.807755957339396 | -122.40775658241999 | (37.8077559573394, -122.40775658242) | ||||
| 132851 | 132851 | 135054 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6010614.33043 | 2122198.69263 | 37.8077510335579 | -122.407587258067 | (37.8077510335579, -122.407587258067) | |||
| 61438 | 61438 | 135060 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 17 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 5ft | 6010535.39568 | 2122199.10611 | 37.8077477501305 | -122.407860461315 | (37.8077477501305, -122.407860461315) | |||
| 24121 | 24121 | 134955 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2620 Mason St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008776.42806 | 2122232.7555400003 | 37.8077415124283 | -122.413950196253 | (37.8077415124283, -122.413950196253) | |||
| 181550 | 181550 | 135057 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6010582.3923 | 2122192.76755 | 37.807732976953396 | -122.407697370161 | (37.8077329769534, -122.407697370161) | ||||
| 58088 | 58088 | 135050 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6010631.86218 | 2122189.9657900003 | 37.807728053161796 | -122.407525969242 | (37.8077280531618, -122.407525969242) | |||
| 56874 | 56874 | 135058 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 15 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 5ft | 6010554.37876 | 2122187.95865 | 37.8077182047045 | -122.407793978909 | (37.8077182047045, -122.407793978909) | |||
| 174117 | 174117 | 134894 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 603 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007235.3918 | 2122253.39642 | 37.8077115182389 | -122.419284801075 | (37.8077115182389, -122.419284801075) | |||
| 164100 | 164100 | 135053 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 5ft | 6010603.7758 | 2122181.57119 | 37.8077034315359 | -122.40762257711599 | (37.8077034315359, -122.407622577116) | |||
| 35971 | 35971 | 135048 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6010653.2094 | 2122176.97632 | 37.8076935821709 | -122.407451175328 | (37.8076935821709, -122.407451175328) | |||
| 69492 | 69492 | 135056 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 13 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 5ft | 6010573.93776 | 2122175.6033099997 | 37.8076853749428 | -122.407725418214 | (37.8076853749428, -122.407725418214) | |||
| 55500 | 55500 | 135049 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6010621.88321 | 2122171.6367900004 | 37.8076771677211 | -122.40755921090599 | (37.8076771677211, -122.407559210906) | |||
| 28234 | 28234 | 134954 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2620 Mason St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008779.536780001 | 2122208.65367 | 37.8076755093739 | -122.413937731646 | (37.8076755093739, -122.413937731646) | |||
| 153126 | 153126 | 133653 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3301 Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6005134.4607 | 2122281.5650299997 | 37.8076703157932 | -122.426557588766 | (37.8076703157932, -122.426557588766) | |||
| 187064 | 187064 | 135052 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6010594.75169 | 2122165.91308 | 37.807659933118 | -122.407652702611 | (37.807659933118, -122.407652702611) | |||
| 174342 | 174342 | 135047 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6010643.25481 | 2122159.84263 | 37.807645980139604 | -122.407484416982 | (37.8076459801396, -122.407484416982) | |||
| 46053 | 46053 | 135045 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6010657.52878 | 2122153.27483 | 37.807628745535396 | -122.407434554957 | (37.8076287455354, -122.407434554957) | |||
| 129727 | 129727 | 134893 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 601 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007039.85859 | 2122225.30985 | 37.807623385565904 | -122.419959497642 | (37.8076233855659, -122.419959497642) | |||
| 156110 | 156110 | 134892 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 601 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6007026.56979 | 2122223.77061 | 37.8076184105252 | -122.42000537745899 | (37.8076184105252, -122.420005377459) | |||
| 133640 | 133640 | 135046 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6010633.58196 | 2122141.80675 | 37.8075959166791 | -122.407516619912 | (37.8075959166791, -122.407516619912) | |||
| 176600 | 176600 | 135044 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6010653.51415 | 2122133.031 | 37.8075729363076 | -122.40744702046301 | (37.8075729363076, -122.407447020463) | |||
| 87167 | 87167 | 100097 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 90647 | 90647 | 100096 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) | |||||
| 91649 | 91649 | 100098 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 495 Jefferson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006848.2 | 2122207.6 | 37.807563959210206 | -122.42062152066002 | (37.8075639592102, -122.42062152066) |
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");