Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord ▲ | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 136976 | 136976 | 135167 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009297.39065 | 2122561.1634400003 | 37.8086724825285 | -122.41217049819201 | (37.8086724825285, -122.412170498192) | ||||
| 172987 | 172987 | 135165 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009319.750469999 | 2122555.32253 | 37.808657699448105 | -122.41209270231 | (37.8086576994481, -122.41209270231) | ||||
| 46489 | 46489 | 135163 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6009340.6942 | 2122549.79423 | 37.8086436952141 | -122.412019829366 | (37.8086436952141, -122.412019829366) | ||||
| 69245 | 69245 | 135161 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009360.267630001 | 2122546.84411 | 37.808636693089106 | -122.411951881091 | (37.8086366930891, -122.411951881091) | ||||
| 61001 | 61001 | 135157 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009451.25096 | 2122529.40055 | 37.808593901544796 | -122.411635772999 | (37.8085939015448, -122.411635772999) | ||||
| 59638 | 59638 | 135156 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6009480.72759 | 2122523.69804 | 37.808579897317706 | -122.411533357278 | (37.8085798973177, -122.411533357278) | ||||
| 67415 | 67415 | 135155 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1413 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6009496.8532 | 2122519.11823 | 37.808568226806706 | -122.41147722608801 | (37.8085682268067, -122.411477226088) | ||||
| 184904 | 184904 | 135153 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | 6009517.81435 | 2122514.4396599997 | 37.8085565563141 | -122.41140435313 | (37.8085565563141, -122.41140435313) | ||||
| 157993 | 157993 | 135137 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6009675.17252 | 2122510.18452 | 37.8085536973592 | -122.41085946829901 | (37.8085536973592, -122.410859468299) | ||||
| 161852 | 161852 | 135151 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6009534.78747 | 2122509.55925 | 37.8085441079032 | -122.411345267671 | (37.8085441079032, -122.411345267671) | ||||
| 174362 | 174362 | 135149 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009556.32302 | 2122505.1526099998 | 37.808533216194895 | -122.411270426102 | (37.8085332161949, -122.411270426102) | ||||
| 157851 | 157851 | 135147 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009572.95679 | 2122501.76157 | 37.8085248381209 | -122.411212620383 | (37.8085248381209, -122.411212620383) | ||||
| 173340 | 173340 | 135136 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 6009674.61624 | 2122497.64189 | 37.808519227256106 | -122.410860507034 | (37.8085192272561, -122.410860507034) | ||||
| 34258 | 34258 | 135145 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1411 The Embarcadero | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6009594.12763 | 2122497.09351 | 37.808513208082 | -122.411139022559 | (37.808513208082, -122.411139022559) | ||||
| 68996 | 68996 | 135143 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6009614.4871 | 2122492.8917400003 | 37.8085028128125 | -122.41106826569799 | (37.8085028128125, -122.411068265698) | ||||
| 173108 | 173108 | 135141 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6009636.62254 | 2122489.1519 | 37.808493785432795 | -122.410991395247 | (37.8084937854328, -122.410991395247) | ||||
| 53095 | 53095 | 135139 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1405 The Embarcadero | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6009651.5635 | 2122485.8577099997 | 37.808485578225294 | -122.410939454894 | (37.8084855782253, -122.410939454894) | ||||
| 149408 | 149408 | 135098 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6010217.76574 | 2122446.50226 | 37.808409250946 | -122.408977168373 | (37.808409250946, -122.408977168373) | ||||
| 34032 | 34032 | 135097 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 6010211.1601599995 | 2122431.69205 | 37.8083682157885 | -122.408998983212 | (37.8083682157885, -122.408998983212) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 33244 | 33244 | 135096 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 1401 The Embarcadero | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6010210.74566 | 2122411.37483 | 37.808312406561896 | -122.40899898321501 | (37.8083124065619, -122.408998983215) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 63703 | 63703 | 126423 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1401 The Embarcadero | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 47 | 6010525.17738 | 2122242.65614 | 37.8078667556044 | -122.40789889741899 | (37.8078667556044, -122.407898897419) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 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) | ||||
| 71596 | 71596 | 133173 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1900 The Embarcadero | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 6010549.201230001 | 2122094.68608 | 37.8074618115912 | -122.407805315766 | (37.8074618115912, -122.407805315766) | |||
| 47337 | 47337 | 132178 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2449 Mason St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 6008741.74811 | 2122071.6365799997 | 37.807297172691 | -122.41405880917101 | (37.807297172691, -122.414058809171) | ||||
| 167524 | 167524 | 129371 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 415 Beach St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6008483.18114 | 2122068.5506 | 37.8072741734254 | -122.414953421476 | (37.8072741734254, -122.414953421476) | |||
| 146879 | 146879 | 129370 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 415 Beach St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6008475.09899 | 2122066.50156 | 37.8072680931263 | -122.41498124649598 | (37.8072680931263, -122.414981246496) | |||
| 167108 | 167108 | 129369 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 415 Beach St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6008462.41761 | 2122065.39822 | 37.807264351026 | -122.415025055184 | (37.807264351026, -122.415025055184) | |||
| 178261 | 178261 | 129368 | Undocumented 2 | Lagerstroemia indica :: Crape Myrtle 199 | 415 Beach St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 3ft | 6008451.9659400005 | 2122064.5899 | 37.8072615442584 | -122.41506116833901 | (37.8072615442584, -122.415061168339) | |||
| 63390 | 63390 | 125574 | Undocumented 2 | Araucaria columnaris :: Coral reef araucaria 185 | 415 Beach St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 6008427.90807 | 2122059.2905200003 | 37.8072456415422 | -122.415144050765 | (37.8072456415422, -122.415144050765) | |||
| 149725 | 149725 | 136320 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 North Point St | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6010568.43745 | 2122006.8054400003 | 37.8072215900736 | -122.40773254351801 | (37.8072215900736, -122.407732543518) | |||
| 165341 | 165341 | 136319 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 99 North Point St | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6010537.589980001 | 2122003.14861 | 37.8072098224406 | -122.40783904035901 | (37.8072098224406, -122.407839040359) | |||
| 62390 | 62390 | 133156 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 North Point St | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6010460.75882 | 2121992.28603 | 37.8071756949569 | -122.408104165883 | (37.8071756949569, -122.408104165883) | |||
| 48856 | 48856 | 132353 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6010444.3802 | 2121991.1202599998 | 37.8071715769765 | -122.408160765609 | (37.8071715769765, -122.408160765609) | |||
| 150939 | 150939 | 133155 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 99 North Point St | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010424.25918 | 2121988.2428099997 | 37.8071625495686 | -122.408230195965 | (37.8071625495686, -122.408230195965) | |||
| 166935 | 166935 | 132351 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6010391.05696 | 2121984.73538 | 37.807151059840606 | -122.40834485234 | (37.8071510598406, -122.40834485234) | |||
| 44231 | 44231 | 132352 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 4ft | 6010400.48539 | 2121983.74228 | 37.8071488610029 | -122.408312153001 | (37.8071488610029, -122.408312153001) | |||
| 161485 | 161485 | 132350 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 4ft | 6010382.56388 | 2121982.30602 | 37.8071439138247 | -122.40837407312901 | (37.8071439138247, -122.408374073129) | |||
| 57489 | 57489 | 132349 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 6010357.97788 | 2121979.4044 | 37.8071345698829 | -122.408458953812 | (37.8071345698829, -122.408458953812) | |||
| 68687 | 68687 | 132348 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6010354.50875 | 2121976.8725799997 | 37.8071274238595 | -122.40847078082399 | (37.8071274238595, -122.408470780824) | |||
| 61903 | 61903 | 132347 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6010337.00106 | 2121976.0282799997 | 37.8071241251481 | -122.40853131058998 | (37.8071241251481, -122.40853131059) | |||
| 61929 | 61929 | 132346 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 4ft | 6010313.38408 | 2121972.38767 | 37.8071128062815 | -122.408612785551 | (37.8071128062815, -122.408612785551) | |||
| 35648 | 35648 | 132345 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 4ft | 6010293.68664 | 2121970.09812 | 37.807105416557995 | -122.408680791404 | (37.807105416558, -122.408680791404) | |||
| 135225 | 135225 | 132341 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6010253.820780001 | 2121967.79388 | 37.807096856811704 | -122.408818593599 | (37.8070968568117, -122.408818593599) | |||
| 174669 | 174669 | 132342 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6010256.82175 | 2121967.7326599997 | 37.807096856806105 | -122.408808203739 | (37.8070968568061, -122.408808203739) | |||
| 77253 | 77253 | 132344 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 4ft | 6010271.51992 | 2121966.31562 | 37.807093789222705 | -122.408757237352 | (37.8070937892227, -122.408757237352) | |||
| 53010 | 53010 | 132343 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010257.55272 | 2121964.32975 | 37.8070875542059 | -122.40880543381901 | (37.8070875542059, -122.408805433819) | |||
| 60541 | 60541 | 132340 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 99 North Point St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 4ft | 6010250.3347 | 2121963.67978 | 37.807085365256206 | -122.408830367525 | (37.8070853652562, -122.408830367525) | |||
| 29827 | 29827 | 132339 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 101 North Point St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6010219.04571 | 2121961.0594599997 | 37.807076417898 | -122.408938465154 | (37.807076417898, -122.408938465154) | |||
| 187896 | 187896 | 132338 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 101 North Point St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6010209.41477 | 2121960.406 | 37.807074084175 | -122.408971749061 | (37.807074084175, -122.408971749061) | |||
| 46742 | 46742 | 134927 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 4ft | 6008339.114519999 | 2121958.1114 | 37.80696283893221 | -122.41544417341998 | (37.8069628389322, -122.41544417342) | |||
| 166177 | 166177 | 132337 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 101 North Point St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 4ft | 6010181.055930001 | 2121954.11326 | 37.8070552172825 | -122.409069446918 | (37.8070552172825, -122.409069446918) | |||
| 118103 | 118103 | 126613 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 680 Beach St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 2ft | 6006953.4231900005 | 2121924.22216 | 37.8067918058547 | -122.42023724517999 | (37.8067918058547, -122.42023724518) | |||
| 34979 | 34979 | 125394 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 601 Beach St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6007295.97012 | 2121904.70723 | 37.806757518306206 | -122.419050406278 | (37.8067575183062, -122.419050406278) | |||
| 146845 | 146845 | 125395 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 2671 Leavenworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 7ft | 6007309.27771 | 2121901.08627 | 37.8067483254418 | -122.41900409566601 | (37.8067483254418, -122.419004095666) | |||
| 39613 | 39613 | 134925 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 4ft | 6008346.87232 | 2121899.69009 | 37.8068028648324 | -122.415413187278 | (37.8068028648324, -122.415413187278) | |||
| 129498 | 129498 | 132182 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 601 Beach St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 5ft | 6007241.6557599995 | 2121894.78138 | 37.8067272057567 | -122.419237667598 | (37.8067272057567, -122.419237667598) | |||
| 61933 | 61933 | 132181 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1302 Columbus Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | 6007227.55341 | 2121889.28804 | 37.8067113282286 | -122.41928608168699 | (37.8067113282286, -122.419286081687) | ||||
| 168536 | 168536 | 132404 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2671 Leavenworth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6007312.64985 | 2121879.37275 | 37.806688895542294 | -122.418990884623 | (37.8066888955423, -122.418990884623) | ||||
| 150894 | 150894 | 126092 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 245 Marina Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6002282.482890001 | 2121873.98014 | 37.8063895543934 | -122.436398331234 | (37.8063895543934, -122.436398331234) | |||
| 130874 | 130874 | 132180 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1302 Columbus Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | 6007242.786309999 | 2121872.67886 | 37.8066665815484 | -122.419232186229 | (37.8066665815484, -122.419232186229) | ||||
| 63431 | 63431 | 131333 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 265 Marina Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6002225.92805 | 2121872.37078 | 37.806381921855 | -122.43659393376001 | (37.806381921855, -122.43659393376) | |||
| 27303 | 27303 | 129201 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 245 Marina Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 4ft | 6002306.14505 | 2121870.94259 | 37.8063825585658 | -122.43631622670799 | (37.8063825585658, -122.436316226708) | |||
| 75547 | 75547 | 132405 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2671 Leavenworth St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6007317.65081 | 2121868.01026 | 37.8066579786473 | -122.418972771382 | (37.8066579786473, -122.418972771382) | ||||
| 75850 | 75850 | 132406 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2671 Leavenworth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | 6007315.11916 | 2121861.5465700002 | 37.8066400884465 | -122.41898107391701 | (37.8066400884465, -122.418981073917) | ||||
| 46377 | 46377 | 132179 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1302 Columbus Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | 6007259.6989400005 | 2121860.7667900003 | 37.806634826503604 | -122.419172811197 | (37.8066348265036, -122.419172811197) | ||||
| 147297 | 147297 | 126093 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 235 Marina Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 6002352.27621 | 2121852.1528 | 37.8063335877859 | -122.436155236376 | (37.8063335877859, -122.436155236376) | ||||
| 170642 | 170642 | 134924 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 4ft | 6008355.58408 | 2121850.16568 | 37.8066673729735 | -122.41537953014799 | (37.8066673729735, -122.415379530148) | |||
| 149795 | 149795 | 131874 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 295 Marina Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 7ft | 6002038.91196 | 2121849.60525 | 37.806308784479796 | -122.43723950400299 | (37.8063087844798, -122.437239504003) | |||
| 41820 | 41820 | 136433 | Undocumented 2 | Sequoia sempervirens :: Coast Redwood 116 | 2671 Leavenworth St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 6007318.566930001 | 2121838.23641 | 37.8065762788357 | -122.418967487863 | (37.8065762788357, -122.418967487863) | ||||
| 45633 | 45633 | 125435 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 2671 Leavenworth St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6007321.894719999 | 2121819.7071 | 37.8065255894616 | -122.41895465634899 | (37.8065255894616, -122.418954656349) | ||||
| 155115 | 155115 | 125434 | Undocumented 2 | Aesculus x carnea :: Red Horse Chestnut 194 | 1302 Columbus Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6007306.78534 | 2121812.18532 | 37.8065040857636 | -122.419006411423 | (37.8065040857636, -122.419006411423) | ||||
| 29192 | 29192 | 134920 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2618 Taylor St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6008362.41303 | 2121791.60977 | 37.806506977065794 | -122.415351749199 | (37.8065069770658, -122.415351749199) | |||
| 151730 | 151730 | 131873 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 435 Marina Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6001088.519780001 | 2121715.49846 | 37.8058864916338 | -122.44051886926901 | (37.8058864916338, -122.440518869269) | ||||
| 173199 | 173199 | 136030 | Undocumented 2 | Prunus subhirtella 'Pendula' :: Weeping Cherry 370 | 475 Marina Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 5ft | 6000838.224669999 | 2121681.08222 | 37.805777738417795 | -122.441382580867 | (37.8057777384178, -122.441382580867) | |||
| 41970 | 41970 | 137512 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 3801 Webster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6002485.01335 | 2121661.73834 | 37.8058183005296 | -122.435682245137 | (37.8058183005296, -122.435682245137) |
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");