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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 176363 | 176363 | 135114 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1403 The Embarcadero | 14 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 6ft | 6009988.36934 | 2122413.52121 | 37.808305840604206 | -122.409768730958 | (37.8083058406042, -122.409768730958) | |||
| 66137 | 66137 | 134959 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2571 Powell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009188.56229 | 2122429.4929 | 37.808304841455104 | -122.41253781726601 | (37.8083048414551, -122.412537817266) | |||
| 185306 | 185306 | 134951 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 145 Jefferson St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008585.64556 | 2122440.14481 | 37.8083002342206 | -122.41462513296301 | (37.8083002342206, -122.414625132963) | |||
| 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) | |||
| 54062 | 54062 | 136578 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008572.42572 | 2122428.93464 | 37.808268711206004 | -122.41467009005899 | (37.808268711206, -122.414670090059) | |||
| 177333 | 177333 | 131691 | Undocumented 2 | Musa spp :: Banana 371 | 145 Jefferson St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6008568.16914 | 2122427.24291 | 37.8082638269937 | -122.414684701334 | (37.8082638269937, -122.414684701334) | |||
| 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) | ||||
| 48390 | 48390 | 136577 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6008571.571 | 2122426.8500200002 | 37.8082629393464 | -122.414672900433 | (37.8082629393464, -122.414672900433) | |||
| 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) | |||
| 40975 | 40975 | 136575 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6008547.84348 | 2122425.8799900003 | 37.8082589427652 | -122.414754947386 | (37.8082589427652, -122.414754947386) | |||
| 57031 | 57031 | 136576 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008548.79083 | 2122424.56718 | 37.8082553913493 | -122.41475157584999 | (37.8082553913493, -122.41475157585) | |||
| 153682 | 153682 | 136574 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 145 Jefferson St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008546.664059999 | 2122423.8020200003 | 37.8082531709192 | -122.414758881938 | (37.8082531709192, -122.414758881938) | |||
| 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) | ||||
| 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) | |||
| 159791 | 159791 | 131624 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008272.4589599995 | 2122375.57657 | 37.8081053457565 | -122.41570442733601 | (37.8081053457565, -122.415704427336) | |||
| 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) | |||
| 40275 | 40275 | 131623 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008274.82732 | 2122360.1153700002 | 37.808063026360294 | -122.41569513553101 | (37.8080630263603, -122.415695135531) | |||
| 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) | ||||
| 40133 | 40133 | 131622 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008277.02166 | 2122343.87132 | 37.8080185476734 | -122.41568639051201 | (37.8080185476734, -122.415686390512) | |||
| 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) | |||
| 74429 | 74429 | 117416 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6010137.827269999 | 2122299.49705 | 37.8080011332052 | -122.409243437841 | (37.8080011332052, -122.409243437841) | |||
| 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) | ||||
| 31174 | 31174 | 117415 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6010118.81969 | 2122297.52404 | 37.80799465090929 | -122.409309079351 | (37.8079946509093, -122.409309079351) | |||
| 47922 | 47922 | 117414 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010099.515980001 | 2122295.55675 | 37.807988167691 | -122.409375746091 | (37.807988167691, -122.409375746091) | |||
| 166608 | 166608 | 117413 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6010079.003190001 | 2122292.43405 | 37.8079784442232 | -122.409446515568 | (37.8079784442232, -122.409446515568) | |||
| 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) | ||||
| 75046 | 75046 | 117412 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6010061.45891 | 2122289.54556 | 37.8079695301268 | -122.409507028246 | (37.8079695301268, -122.409507028246) | |||
| 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) | |||
| 67943 | 67943 | 133166 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010237.48446 | 2122281.28865 | 37.8079567202001 | -122.40889726181001 | (37.8079567202001, -122.40889726181) | |||
| 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) | |||
| 177294 | 177294 | 117411 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6010025.48749 | 2122284.08208 | 37.807952513162 | -122.409631131072 | (37.807952513162, -122.409631131072) | |||
| 29401 | 29401 | 133165 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010207.21606 | 2122279.33076 | 37.8079496488199 | -122.409001875447 | (37.8079496488199, -122.409001875447) | |||
| 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) | ||||
| 188715 | 188715 | 117410 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6010007.96728 | 2122282.37389 | 37.8079468411282 | -122.40969164376999 | (37.8079468411282, -122.40969164377) | |||
| 23382 | 23382 | 117409 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009993.98375 | 2122279.70822 | 37.8079387382549 | -122.40973984921101 | (37.8079387382549, -122.409739849211) | |||
| 137041 | 137041 | 117408 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009980.0242800005 | 2122278.22216 | 37.807933875624 | -122.409788054695 | (37.807933875624, -122.409788054695) | |||
| 170063 | 170063 | 133167 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6010256.39489 | 2122271.9772900003 | 37.8079322127625 | -122.40883115985399 | (37.8079322127625, -122.408831159854) | |||
| 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) | |||
| 64853 | 64853 | 128093 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2021 Grant Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 3ft | 6010177.720869999 | 2122272.32263 | 37.807928753964894 | -122.409103456576 | (37.8079287539649, -122.409103456576) | |||
| 57393 | 57393 | 117407 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009960.43045 | 2122276.55632 | 37.8079282035823 | -122.40985574666901 | (37.8079282035823, -122.409855746669) | |||
| 187672 | 187672 | 133164 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2020 Grant Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6010207.81759 | 2122270.0679900004 | 37.8079242492629 | -122.40899913969999 | (37.8079242492629, -122.4089991397) | |||
| 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) | ||||
| 181152 | 181152 | 117406 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009939.615230001 | 2122273.14447 | 37.8079176689433 | -122.40992754223998 | (37.8079176689433, -122.40992754224) | |||
| 76893 | 76893 | 130269 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007707.20145 | 2122317.4963 | 37.807914080648395 | -122.41765653263501 | (37.8079140806484, -122.417656532635) | |||
| 68484 | 68484 | 131621 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2740 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6008283.03118 | 2122305.68799 | 37.807914043752 | -122.415662887656 | (37.807914043752, -122.415662887656) | |||
| 158668 | 158668 | 117405 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6009914.43975 | 2122269.2474599998 | 37.8079055577548 | -122.410014393348 | (37.8079055577548, -122.410014393348) | |||
| 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) | |||
| 177446 | 177446 | 130268 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6007672.5640199995 | 2122314.32327 | 37.80790341917061 | -122.417776179344 | (37.8079034191706, -122.417776179344) | |||
| 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) | ||||
| 135811 | 135811 | 133168 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6010279.11077 | 2122259.53245 | 37.807899314677 | -122.40875166696699 | (37.807899314677, -122.408751666967) | |||
| 172790 | 172790 | 117404 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009897.70698 | 2122267.2121200003 | 37.807899031387294 | -122.410072157724 | (37.8078990313873, -122.410072157724) | |||
| 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) | |||
| 49747 | 49747 | 128198 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 149 Beach St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6009875.274619999 | 2122264.42386 | 37.8078901181966 | -122.410149593828 | (37.8078901181966, -122.410149593828) | |||
| 158197 | 158197 | 130267 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 503 Jefferson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6007643.34611 | 2122309.22762 | 37.80788778354621 | -122.41787693399901 | (37.8078877835462, -122.417876933999) | |||
| 62027 | 62027 | 128197 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 149 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009847.94542 | 2122261.29277 | 37.8078799891455 | -122.41024395249201 | (37.8078799891455, -122.410243952492) | |||
| 183816 | 183816 | 128094 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2021 Grant Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6010179.348569999 | 2122253.91388 | 37.807878299319704 | -122.409096523684 | (37.8078782993197, -122.409096523684) | |||
| 187693 | 187693 | 128196 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 149 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009829.55437 | 2122260.48779 | 37.8078767479704 | -122.41030754266899 | (37.8078767479704, -122.410307542669) | |||
| 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) | ||||
| 28484 | 28484 | 128195 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 149 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009814.56122 | 2122259.17064 | 37.8078722909471 | -122.410359337331 | (37.8078722909471, -122.410359337331) | |||
| 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) |
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");