trees
2,365 rows where qSpecies_id = 31 sorted by PlotSize descending
This data as json, CSV (advanced)
rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize ▲ | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
128168 | 98270 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | witin landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
118194 | 98271 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
119476 | 98272 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | ||
164216 | 98273 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 990X York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/20/2012 12:00:00 AM | within landscaping plot | Permit Number 768491 | 6009943.7 | 2103445.2 | 37.7562208239384 | -122.408584359698 | (37.7562208239384, -122.408584359698) | 2 | 4 | 7 | 28859 | 19 | |
11086 | 242374 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x McCoppin St | 2 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 6006546.0037 | 2109148.19709 | 37.7716890396519 | -122.420739627149 | (37.7716890396519, -122.420739627149) | 8 | 2 | 9 | 28853 | 19 | |||
85837 | 242780 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 95 McCoppin St | 1 | : | Tree | Private 2 | 3 | Width 9ft | 6006179.77173 | 2109125.10938 | 37.7716049979898 | -122.422004807797 | (37.7716049979898, -122.422004807797) | 8 | 2 | 9 | 28853 | 19 | |||
134543 | 242778 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1 McCoppin St | 1 | : | Tree | Private 2 | 4 | Width 9ft | 6006595.78841 | 2109152.55753 | 37.7717038182152 | -122.420567728011 | (37.7717038182152, -122.420567728011) | 8 | 2 | 9 | 28853 | 19 | |||
138201 | 242373 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2x McCoppin St | 1 | Median : Yard | Tree | DPW 1 | 5 | Width 9ft | 6006573.34583 | 2109150.3275 | 37.771696430266 | -122.420645200112 | (37.771696430266, -122.420645200112) | 8 | 2 | 9 | 28853 | 19 | |||
163843 | 242781 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 95x McCoppin St | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 9ft | 6006152.38517 | 2109124.27435 | 37.771601160584 | -122.422099480311 | (37.771601160584, -122.422099480311) | 8 | 2 | 9 | 28853 | 19 | |||
178645 | 242779 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x McCoppin St | 2 | Median : Yard | Tree | DPW 1 | 4 | Width 9ft | 6006556.42632 | 2109149.52189 | 37.7716932646698 | -122.420703668659 | (37.7716932646698, -122.420703668659) | 8 | 2 | 9 | 28853 | 19 | |||
16029 | 198662 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013921.99886 | 2107418.77263 | 37.7673533891782 | -122.395104256175 | (37.7673533891782, -122.395104256175) | 14 | 3 | 9 | 310 | 20 | |||
16709 | 215479 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 85 Santa Ana Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 8ft | 5992627.2877 | 2096233.38868 | 37.7354340044744 | -122.467945378584 | (37.7354340044744, -122.467945378584) | 1 | 8 | 4 | 59 | 40 | |||
22011 | 198661 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013934.2668 | 2107404.04412 | 37.7673136301584 | -122.39506079103 | (37.7673136301584, -122.39506079103) | 14 | 3 | 9 | 310 | 20 | |||
26836 | 198657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013998.08453 | 2107337.5024 | 37.7671344699085 | -122.394835392165 | (37.7671344699085, -122.394835392165) | 14 | 3 | 9 | 310 | 20 | |||
43824 | 246542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 8ft | 6005675.49099 | 2109463.50167 | 37.772505687922 | -122.42377321126 | (37.772505687922, -122.42377321126) | 7 | 9 | 11 | 28852 | 10 | |||
45948 | 198666 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013864.8595 | 2107478.20715 | 37.7675134055349 | -122.395306058649 | (37.7675134055349, -122.395306058649) | 14 | 3 | 9 | 310 | 20 | |||
46084 | 198654 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014045.10244 | 2107292.39517 | 37.7670132295924 | -122.394669603922 | (37.7670132295924, -122.394669603922) | 14 | 3 | 9 | 310 | 20 | |||
50705 | 246545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005664.26886 | 2109539.08097 | 37.7727125769595 | -122.423817404855 | (37.7727125769595, -122.423817404855) | 7 | 9 | 11 | 28852 | 10 | |||
56148 | 246538 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005690.17012 | 2109380.36656 | 37.7722782475712 | -122.423716522495 | (37.7722782475712, -122.423716522495) | 7 | 9 | 11 | 28852 | 10 | |||
58392 | 215480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 55 Santa Ana Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 5992620.87783 | 2096424.47164 | 37.7359583002413 | -122.467981434219 | (37.7359583002413, -122.467981434219) | 1 | 8 | 4 | 59 | 40 | |||
70024 | 246553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 6005726.46493 | 2109532.06592 | 37.7726968262309 | -122.423601762727 | (37.7726968262309, -122.423601762727) | 7 | 9 | 11 | 28852 | 10 | |||
72725 | 198658 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013985.93072 | 2107349.0106 | 37.7671653930992 | -122.39487823676 | (37.7671653930992, -122.39487823676) | 14 | 3 | 9 | 310 | 20 | |||
93406 | 198655 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6014030.31136 | 2107306.63823 | 37.7670515155374 | -122.3947217619 | (37.7670515155374, -122.3947217619) | 14 | 3 | 9 | 310 | 20 | |||
100699 | 246540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 8 | Width 8ft | 6005683.44933 | 2109420.77798 | 37.7723888282128 | -122.423742644211 | (37.7723888282128, -122.423742644211) | 7 | 9 | 11 | 28852 | 10 | |||
103899 | 246541 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005680.0153 | 2109440.15852 | 37.7724418486558 | -122.423755901126 | (37.7724418486558, -122.423755901126) | 7 | 9 | 11 | 28852 | 10 | |||
111607 | 198659 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013968.57822 | 2107369.74118 | 37.7672213498189 | -122.39493970902 | (37.7672213498189, -122.39493970902) | 14 | 3 | 9 | 310 | 20 | |||
119514 | 246544 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 11 | Median : Yard | Tree | DPW 1 | 4 | Width 8ft | 6005666.89387 | 2109521.55091 | 37.7726645918273 | -122.42380707794 | (37.7726645918273, -122.42380707794) | 7 | 9 | 11 | 28852 | 10 | |||
124048 | 246554 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6005723.73891 | 2109547.7321 | 37.7727396879137 | -122.423612306376 | (37.7727396879137, -122.423612306376) | 7 | 9 | 11 | 28852 | 10 | |||
126507 | 180540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2134 San Jose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 8ft | 5998917.8755 | 2091146.49396 | 37.7218278392563 | -122.445830812055 | (37.7218278392563, -122.445830812055) | 9 | 7 | 6 | 28861 | 25 | |||
129288 | 180561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1134 Naples St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 8ft | 6001348.51244 | 2087850.78247 | 37.7129170389625 | -122.437192888562 | (37.7129170389625, -122.437192888562) | 9 | 7 | 6 | 28861 | 5 | |||
131307 | 198663 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 8ft | 6013906.85624 | 2107433.38054 | 37.7673926571763 | -122.395157656112 | (37.7673926571763, -122.395157656112) | 14 | 3 | 9 | 310 | 20 | |||
138929 | 246537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005694.1719 | 2109365.05441 | 37.7722364299905 | -122.423701591057 | (37.7722364299905, -122.423701591057) | 7 | 9 | 11 | 28852 | 10 | |||
155122 | 198665 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6013878.81115 | 2107466.84131 | 37.7674829733764 | -122.395257005115 | (37.7674829733764, -122.395257005115) | 14 | 3 | 9 | 310 | 20 | |||
155428 | 198656 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6014014.86759 | 2107324.11249 | 37.7670986373305 | -122.394776403817 | (37.7670986373305, -122.394776403817) | 14 | 3 | 9 | 310 | 20 | |||
161873 | 246555 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 9 | Median : Yard | Tree | DPW 1 | 7 | Width 8ft | 6005721.04041 | 2109575.32182 | 37.7728152903163 | -122.423623602744 | (37.7728152903163, -122.423623602744) | 7 | 9 | 11 | 28852 | 10 | |||
169869 | 180560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1134 Naples St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 8ft | 6001363.50733 | 2087875.35573 | 37.7129853640648 | -122.437142819708 | (37.7129853640648, -122.437142819708) | 9 | 7 | 6 | 28861 | 5 | |||
171104 | 246539 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1x Octavia St | 5 | Median : Yard | Tree | DPW 1 | 6 | Width 8ft | 6005686.56992 | 2109401.16217 | 37.7723351440794 | -122.423730454802 | (37.7723351440794, -122.423730454802) | 7 | 9 | 11 | 28852 | 10 | |||
171503 | 246549 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 3 | Width 8ft | 6005737.248 | 2109452.92689 | 37.7724801381679 | -122.423558835368 | (37.7724801381679, -122.423558835368) | 7 | 9 | 11 | 28852 | 10 | |||
175198 | 198664 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013893.51882 | 2107448.48806 | 37.7674333973606 | -122.39520484712 | (37.7674333973606, -122.39520484712) | 14 | 3 | 9 | 310 | 20 | |||
183611 | 246552 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 5 | Width 8ft | 6005729.77249 | 2109512.91923 | 37.77264444073 | -122.423588959979 | (37.77264444073, -122.423588959979) | 7 | 9 | 11 | 28852 | 10 | |||
185910 | 198653 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 8ft | 6014062.16151 | 2107274.88823 | 37.7669661078202 | -122.394609372737 | (37.7669661078202, -122.394609372737) | 14 | 3 | 9 | 310 | 20 | |||
192802 | 198660 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013952.39137 | 2107385.97936 | 37.7672650361872 | -122.394996834841 | (37.7672650361872, -122.394996834841) | 14 | 3 | 9 | 310 | 20 | |||
4812 | 198517 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1763 Newcomb Ave | 2 | : | Tree | Private 2 | 5 | Width 7ft | 6014346.73951 | 2096322.78373 | 37.7369097775472 | -122.392858747949 | (37.7369097775472, -122.392858747949) | 10 | 3 | 8 | 58 | 1 | |||
35787 | 198528 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1712 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 7ft | 6014599.09575 | 2096195.70079 | 37.7365748475583 | -122.391977349386 | (37.7365748475583, -122.391977349386) | 10 | 3 | 8 | 58 | 1 | |||
41088 | 198525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014663.37225 | 2096146.01075 | 37.736441977204 | -122.391751642923 | (37.736441977204, -122.391751642923) | 10 | 3 | 8 | 58 | 1 | |||
41378 | 198530 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1748 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014455.10696 | 2096302.51395 | 37.7368601394856 | -122.392482653249 | (37.7368601394856, -122.392482653249) | 10 | 3 | 8 | 58 | 1 | |||
41660 | 198529 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1722 Newcomb Ave | 2 | : | Tree | Private 2 | 7 | Width 7ft | 6014569.28946 | 2096208.90311 | 37.73660944358 | -122.392081326305 | (37.73660944358, -122.392081326305) | 10 | 3 | 8 | 58 | 1 | |||
75492 | 198515 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1799 Newcomb Ave | 1 | : | Tree | Private 2 | 6 | Width 7ft | 6014195.4851 | 2096428.16661 | 37.7371907347515 | -122.39338907817 | (37.7371907347515, -122.39338907817) | 10 | 3 | 8 | 58 | 1 | |||
91124 | 198531 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1750 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014434.12864 | 2096316.99865 | 37.7368987464799 | -122.392556198035 | (37.7368987464799, -122.392556198035) | 10 | 3 | 8 | 58 | 1 | |||
94744 | 198518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1759 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6014349.89775 | 2096310.64458 | 37.7368766213595 | -122.392846979413 | (37.7368766213595, -122.392846979413) | 10 | 3 | 8 | 58 | 1 | |||
108431 | 198532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 1 | : | Tree | Private 2 | 4 | Width 7ft | 6014372.17182 | 2096354.40755 | 37.7369980226381 | -122.392773028173 | (37.7369980226381, -122.392773028173) | 10 | 3 | 8 | 58 | 1 | |||
117224 | 198523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1721 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014565.58066 | 2096150.99697 | 37.7364502392755 | -122.392090100993 | (37.7364502392755, -122.392090100993) | 10 | 3 | 8 | 58 | 1 | |||
125460 | 198527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014634.66691 | 2096168.32121 | 37.7365016436308 | -122.391852449756 | (37.7365016436308, -122.391852449756) | 10 | 3 | 8 | 58 | 1 | |||
132082 | 198520 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1737 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 7ft | 6014468.3432 | 2096223.93289 | 37.7366451070745 | -122.392431394602 | (37.7366451070745, -122.392431394602) | 10 | 3 | 8 | 58 | 1 | |||
138460 | 198535 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1770 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014325.04496 | 2096399.73326 | 37.7371198600908 | -122.392939138341 | (37.7371198600908, -122.392939138341) | 10 | 3 | 8 | 58 | 1 | |||
140459 | 198536 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1782 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 7ft | 6014278.07437 | 2096434.64774 | 37.7372131188949 | -122.393103980488 | (37.7372131188949, -122.393103980488) | 10 | 3 | 8 | 58 | 1 | |||
141460 | 198524 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1709 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014591.36063 | 2096131.83286 | 37.7363990498707 | -122.391999628307 | (37.7363990498707, -122.391999628307) | 10 | 3 | 8 | 58 | 1 | |||
153183 | 198533 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1762 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014374.32844 | 2096361.30259 | 37.7370170747819 | -122.392766053934 | (37.7370170747819, -122.392766053934) | 10 | 3 | 8 | 58 | 1 | |||
155130 | 198516 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1763 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 7ft | 6014335.02638 | 2096322.17337 | 37.7369074510206 | -122.392899203062 | (37.7369074510206, -122.392899203062) | 10 | 3 | 8 | 58 | 1 | |||
160465 | 198522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1725 Newcomb Ave | 2 | : | Tree | Private 2 | 3 | Width 7ft | 6014552.77288 | 2096169.89847 | 37.7365014278009 | -122.392135704718 | (37.7365014278009, -122.392135704718) | 10 | 3 | 8 | 58 | 1 | |||
162884 | 198521 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1737 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 7ft | 6014485.10287 | 2096211.09486 | 37.7366107871579 | -122.392372551071 | (37.7366107871579, -122.392372551071) | 10 | 3 | 8 | 58 | 1 | |||
172207 | 198534 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1766 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 7ft | 6014341.63524 | 2096385.88519 | 37.7370827576597 | -122.392880809218 | (37.7370827576597, -122.392880809218) | 10 | 3 | 8 | 58 | 1 | |||
172901 | 198526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700 Newcomb Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 7ft | 6014646.0524 | 2096160.05646 | 37.736479582376 | -122.391812507248 | (37.736479582376, -122.391812507248) | 10 | 3 | 8 | 58 | 1 | |||
174948 | 198519 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1743 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 7ft | 6014430.37923 | 2096250.75811 | 37.7367166553422 | -122.392564529327 | (37.7367166553422, -122.392564529327) | 10 | 3 | 8 | 58 | 1 | |||
395 | 246548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.7724235852138 | -122.423543772638 | (37.7724235852138, -122.423543772638) | 7 | 9 | 11 | 28852 | 10 | |||
6913 | 215496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 69 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993975.72153 | 2097357.94979 | 37.7385995461283 | -122.463364953343 | (37.7385995461283, -122.463364953343) | 1 | 8 | 4 | 59 | 40 | |||
7095 | 198444 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015385.26433 | 2106283.84094 | 37.7643183769187 | -122.389963693588 | (37.7643183769187, -122.389963693588) | 14 | 3 | 9 | 310 | 29 | |||
10327 | 198443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015407.0439 | 2106284.70526 | 37.7643219580036 | -122.389888423915 | (37.7643219580036, -122.389888423915) | 14 | 3 | 9 | 310 | 29 | |||
11128 | 198446 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015345.15707 | 2106282.18607 | 37.7643116086136 | -122.390102298884 | (37.7643116086136, -122.390102298884) | 14 | 3 | 9 | 310 | 29 | |||
17062 | 198453 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015012.52649 | 2106269.21439 | 37.7642575368696 | -122.391251877095 | (37.7642575368696, -122.391251877095) | 14 | 3 | 9 | 310 | 29 | |||
19733 | 215491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 45 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993998.37881 | 2097545.6525 | 37.7391162363258 | -122.463300232728 | (37.7391162363258, -122.463300232728) | 1 | 8 | 4 | 59 | 40 | |||
21138 | 198434 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015605.2539 | 2106298.94966 | 37.7643720601453 | -122.389203859978 | (37.7643720601453, -122.389203859978) | 14 | 3 | 9 | 310 | 29 | |||
21307 | 215486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 25 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 5994053.65956 | 2097702.19422 | 37.7395492454888 | -122.463120453749 | (37.7395492454888, -122.463120453749) | 1 | 8 | 4 | 59 | 40 | |||
23988 | 198459 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014889.29769 | 2106275.30651 | 37.7642674249283 | -122.391678519967 | (37.7642674249283, -122.391678519967) | 14 | 3 | 9 | 310 | 29 | |||
24769 | 198491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 907 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015266.77203 | 2104421.22514 | 37.7591974636091 | -122.390243388116 | (37.7591974636091, -122.390243388116) | 10 | 3 | 8 | 28856 | 29 | |||
28443 | 198576 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014783.08484 | 2114165.12178 | 37.7859251988423 | -122.392597828542 | (37.7859251988423, -122.392597828542) | 6 | 2 | 9 | 28855 | 6 | |||
31708 | 198480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015199.5579 | 2104656.07032 | 37.7598385696177 | -122.390492258425 | (37.7598385696177, -122.390492258425) | 10 | 3 | 8 | 28856 | 29 | |||
31801 | 242443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1331 Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 6ft | 6003922.38967 | 2100509.16496 | 37.7478200945407 | -122.429198764536 | (37.7478200945407, -122.429198764536) | 2 | 4 | 5 | 63 | 22 | |||
32856 | 198447 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015324.46824 | 2106281.29518 | 37.7643080149349 | -122.390173794086 | (37.7643080149349, -122.390173794086) | 14 | 3 | 9 | 310 | 29 | |||
36117 | 198433 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 6ft | 6015623.39252 | 2106299.43011 | 37.764374384886 | -122.38914115655 | (37.764374384886, -122.38914115655) | 14 | 3 | 9 | 310 | 29 | |||
38442 | 198473 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015189.15616 | 2104818.6313 | 37.7602843500682 | -122.39053959244 | (37.7602843500682, -122.39053959244) | 10 | 3 | 8 | 28856 | 29 | |||
40087 | 215483 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 15 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994103.6572 | 2097790.09327 | 37.7397934743851 | -122.462953960472 | (37.7397934743851, -122.462953960472) | 1 | 8 | 4 | 59 | 40 | |||
40473 | 215488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 33 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994033.38086 | 2097656.16741 | 37.7394216991581 | -122.463187229312 | (37.7394216991581, -122.463187229312) | 1 | 8 | 4 | 59 | 40 | |||
43335 | 215497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 73 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993976.24019 | 2097340.186 | 37.738550801067 | -122.46336187137 | (37.738550801067, -122.46336187137) | 1 | 8 | 4 | 59 | 40 | |||
44552 | 198462 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014805.14744 | 2106272.79418 | 37.7642558551341 | -122.391969398478 | (37.7642558551341, -122.391969398478) | 14 | 3 | 9 | 310 | 29 | |||
45264 | 198574 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 6ft | 6014815.04425 | 2114132.68239 | 37.7858379025473 | -122.392484987011 | (37.7858379025473, -122.392484987011) | 6 | 2 | 9 | 28855 | 6 | |||
46213 | 215494 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 61 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5993979.60004 | 2097443.67302 | 37.7388351442124 | -122.463357762357 | (37.7388351442124, -122.463357762357) | 1 | 8 | 4 | 59 | 40 | |||
47528 | 198442 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015430.62355 | 2106285.94365 | 37.7643266659781 | -122.389806954341 | (37.7643266659781, -122.389806954341) | 14 | 3 | 9 | 310 | 29 | |||
51789 | 198487 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6015204.943 | 2104516.59795 | 37.7594559071887 | -122.390463888397 | (37.7594559071887, -122.390463888397) | 10 | 3 | 8 | 28856 | 29 | |||
52805 | 198449 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 17 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015277.30133 | 2106281.40363 | 37.7643056964809 | -122.390336940096 | (37.7643056964809, -122.390336940096) | 14 | 3 | 9 | 310 | 29 | |||
53253 | 198452 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 500 Mariposa St | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 6ft | 6015213.79848 | 2106277.63642 | 37.7642918298343 | -122.390556317147 | (37.7642918298343, -122.390556317147) | 14 | 3 | 9 | 310 | 29 | |||
54459 | 198563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014720.16797 | 2114187.47554 | 37.7859830827904 | -122.392817069764 | (37.7859830827904, -122.392817069764) | 6 | 2 | 9 | 28855 | 6 | |||
57450 | 215485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 21 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994064.51337 | 2097723.86139 | 37.7396093633696 | -122.463084497953 | (37.7396093633696, -122.463084497953) | 1 | 8 | 4 | 59 | 40 | |||
63563 | 215484 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 21 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994076.92667 | 2097749.04597 | 37.7396792290015 | -122.46304340523 | (37.7396792290015, -122.46304340523) | 1 | 8 | 4 | 59 | 40 | |||
69780 | 198573 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 425 01st St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6014828.40077 | 2114123.03475 | 37.7858121540501 | -122.392438101754 | (37.7858121540501, -122.392438101754) | 6 | 2 | 9 | 28855 | 6 | |||
70618 | 198478 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015196.41735 | 2104702.38206 | 37.7599655574783 | -122.390506356185 | (37.7599655574783, -122.390506356185) | 10 | 3 | 8 | 28856 | 29 | |||
74815 | 198475 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 6ft | 6015192.04095 | 2104775.13196 | 37.7601650702756 | -122.390526575643 | (37.7601650702756, -122.390526575643) | 10 | 3 | 8 | 28856 | 29 | |||
76275 | 198486 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015201.9775 | 2104548.15133 | 37.7595423814855 | -122.390476349396 | (37.7595423814855, -122.390476349396) | 10 | 3 | 8 | 28856 | 29 | |||
76364 | 198457 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014932.72283 | 2106269.38668 | 37.7642535807685 | -122.391527909594 | (37.7642535807685, -122.391527909594) | 14 | 3 | 9 | 310 | 29 | |||
76571 | 198567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 400 01st St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 6ft | 6014762.73223 | 2114145.20399 | 37.7858693788244 | -122.392666849695 | (37.7858693788244, -122.392666849695) | 6 | 2 | 9 | 28855 | 6 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );