trees
1,650 rows where qSpecies_id = 64 sorted by DBH 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
105209 | 5712 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1617 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 6005334.50752 | 2098914.22042 | 37.743520580615 | -122.424202310195 | (37.743520580615, -122.424202310195) | 2 | 7 | 5 | 28859 | 22 | |||
186738 | 5699 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1569 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 90 | 6 | 6005313.38344 | 2099208.61144 | 37.7443277185515 | -122.424296285742 | (37.7443277185515, -122.424296285742) | 2 | 7 | 5 | 28859 | 22 | |||
3547 | 71714 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3725 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 9 | 3x6 | Permit Number 771233 | 5984016.25098 | 2111031.53375 | 37.7755645644081 | -122.498809386612 | (37.7755645644081, -122.498809386612) | 11 | 6 | 2 | 55 | 26 | |
12456 | 205316 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 112 Marston Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5998697.99683 | 2093223.72686 | 37.7275188804882 | -122.44674026046 | (37.7275188804882, -122.44674026046) | 9 | 7 | 4 | 28861 | 40 | ||||
27884 | 205266 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1050 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991581.77291 | 2105244.99033 | 37.760117101335 | -122.472216764416 | (37.760117101335, -122.472216764416) | 1 | 8 | 4 | 56 | 12 | |||
30547 | 175971 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 74 Stoneybrook Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 6005811.68143 | 2093853.17046 | 37.7296509985962 | -122.422192869528 | (37.7296509985962, -122.422192869528) | 9 | 7 | 6 | 28861 | 5 | |||
45288 | 205291 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5999811.4073 | 2095793.29434 | 37.7346378544461 | -122.44307566613 | (37.7346378544461, -122.44307566613) | 9 | 7 | 4 | 63 | 40 | ||||
49043 | 205353 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Vicente St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992492.62378 | 2097923.30759 | 37.7400663188064 | -122.468533874239 | (37.7400663188064, -122.468533874239) | 1 | 8 | 4 | 59 | 40 | |||
51828 | 248187 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 216 Esmeralda Ave | 6 | Side Yard : Yard | Tree | Private 2 | 9 | 6007416.25597 | 2098719.21061 | 37.7431024507267 | -122.416990309471 | (37.7431024507267, -122.416990309471) | 2 | 7 | 7 | 28859 | 2 | ||||
56055 | 126088 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2601 Chestnut St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5999349.76539 | 2119404.92874 | 37.7994431288643 | -122.446369750576 | (37.7994431288643, -122.446369750576) | 13 | 9 | 1 | 57 | 17 | |||
59321 | 175910 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 256 Peninsula Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6012412.28873 | 2087359.88016 | 37.7121918346656 | -122.398918168549 | (37.7121918346656, -122.398918168549) | 10 | 3 | 8 | 309 | 1 | |||
59658 | 126122 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2833 Larkin St | 1 | Side Yard : Yard | Tree | Private 2 | 9 | 6006473.28428 | 2120942.81763 | 37.804070054442 | -122.421829107228 | (37.804070054442, -122.421829107228) | 5 | 9 | 1 | 28858 | 32 | ||||
61444 | 249419 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 730 Eddy St | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6006909.7842 | 2113298.36761 | 37.7831049051094 | -122.419775815624 | (37.7831049051094, -122.419775815624) | 7 | 9 | 9 | 28858 | 36 | |||
71269 | 245521 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5 Parnassus Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 5998664.3758 | 2106893.76883 | 37.7650515752896 | -122.447840222145 | (37.7650515752896, -122.447840222145) | 15 | 5 | 11 | 29492 | 9 | |||
73551 | 182816 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1800 29th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 0ft | 5987230.5033 | 2102980.2551 | 37.7536459762525 | -122.48709920227 | (37.7536459762525, -122.48709920227) | 1 | 8 | 3 | 56 | 35 | |||
75895 | 217790 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 151 Sloat Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 5990892.29341 | 2095922.4867 | 37.7344800027407 | -122.473921168543 | (37.7344800027407, -122.473921168543) | 1 | 8 | 4 | 64 | 40 | ||||
80864 | 245565 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 15 Murray St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6004723.23157 | 2095347.44333 | 37.7336924844034 | -122.426062091108 | (37.7336924844034, -122.426062091108) | 2 | 7 | 7 | 28861 | 2 | |||
87273 | 201492 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018741.78505 | 2094936.24141 | 37.7333457436025 | -122.377566764894 | (37.7333457436025, -122.377566764894) | 10 | 3 | 8 | 58 | 1 | ||||
87290 | 245535 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008270.02595 | 2099337.89362 | 37.7448492066234 | -122.414081952318 | (37.7448492066234, -122.414081952318) | 2 | 7 | 7 | 28859 | 2 | |||
99917 | 205259 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1472 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 5ft | 5991180.19803 | 2105388.78437 | 37.7604886733293 | -122.473616096004 | (37.7604886733293, -122.473616096004) | 1 | 8 | 4 | 56 | 12 | |||
103277 | 245721 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2423 Market St | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 8ft | 6002202.22378 | 2105838.07423 | 37.762354473414 | -122.435528168796 | (37.762354473414, -122.435528168796) | 15 | 4 | 5 | 28862 | 3 | |||
105972 | 201491 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 410 Hawes St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6018753.58694 | 2094959.04146 | 37.7334089983181 | -122.377527543687 | (37.7334089983181, -122.377527543687) | 10 | 3 | 8 | 58 | 1 | ||||
108639 | 126114 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 20 Reed St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6008207.05335 | 2117051.51427 | 37.7934831255889 | -122.415553587621 | (37.7934831255889, -122.415553587621) | 5 | 1 | 10 | 28858 | 21 | ||||
109625 | 205378 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Castenada Ave | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5994410.61101 | 2101779.2239 | 37.7507643004336 | -122.462181881694 | (37.7507643004336, -122.462181881694) | 1 | 8 | 4 | 29491 | 40 | |||
111564 | 245492 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 922 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 6ft | 6008565.63001 | 2103125.24366 | 37.7552650205921 | -122.413327587511 | (37.7552650205921, -122.413327587511) | 2 | 4 | 7 | 28859 | 19 | |||
113601 | 245508 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 107 Valley St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6005190.34695 | 2099296.24369 | 37.7445613885 | -122.424727953147 | (37.7445613885, -122.424727953147) | 2 | 7 | 5 | 63 | 22 | |||
116520 | 245633 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008270.76383 | 2099345.47262 | 37.7448700583192 | -122.414079936938 | (37.7448700583192, -122.414079936938) | 2 | 7 | 7 | 28859 | 2 | |||
117821 | 249697 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2400 Baker St | 29 | Front Yard : Yard | Tree | Private 2 | 9 | 5999686.57454 | 2117300.49372 | 37.79368414027 | -122.445052904783 | (37.79368414027, -122.445052904783) | 13 | 9 | 1 | 57 | 27 | ||||
119417 | 245531 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 561 Prentiss St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008731.63346 | 2096177.96743 | 37.7361986575318 | -122.412262497924 | (37.7361986575318, -122.412262497924) | 10 | 7 | 7 | 28859 | 2 | |||
121784 | 245654 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 466 Bartlett St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006770.65509 | 2101089.65511 | 37.7495748184278 | -122.419390756498 | (37.7495748184278, -122.419390756498) | 2 | 4 | 7 | 28859 | 19 | |||
130247 | 245627 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 322 Elsie St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006278.45651 | 2096857.75908 | 37.7379272525447 | -122.420792398467 | (37.7379272525447, -122.420792398467) | 2 | 7 | 7 | 28859 | 2 | |||
130884 | 245620 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 44 Elsie St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007418.13405 | 2099030.98221 | 37.7439586116173 | -122.417005901024 | (37.7439586116173, -122.417005901024) | 2 | 7 | 7 | 28859 | 2 | |||
135317 | 245634 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008270.22088 | 2099337.26438 | 37.7448474898186 | -122.414081233777 | (37.7448474898186, -122.414081233777) | 2 | 7 | 7 | 28859 | 2 | |||
142117 | 205480 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 442 Circular Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 1ft | 5999757.99559 | 2093711.04925 | 37.7289174503599 | -122.443110833204 | (37.7289174503599, -122.443110833204) | 9 | 7 | 4 | 63 | 40 | |||
142920 | 245503 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 285 Mullen Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6010388.7733 | 2100014.55379 | 37.7468259434762 | -122.406803364903 | (37.7468259434762, -122.406803364903) | 2 | 7 | 7 | 28859 | 2 | |||
143136 | 245600 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 91 Saint Germain Ave | 1 | Front Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 5998015.01802 | 2104129.80159 | 37.75742527938 | -122.449886967616 | (37.75742527938, -122.449886967616) | 15 | 5 | 4 | 28862 | 38 | |||
146135 | 205251 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1469 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5991133.79898 | 2105423.31404 | 37.7605807953918 | -122.473779086452 | (37.7605807953918, -122.473779086452) | 1 | 8 | 4 | 56 | 12 | |||
148449 | 205326 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 15 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995597.57429 | 2090027.5624 | 37.718565374973 | -122.45722726115 | (37.718565374973, -122.45722726115) | 9 | 8 | 6 | 28861 | 24 | |||
151077 | 205270 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1224 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 5995838.93768 | 2107071.40007 | 37.7653774059583 | -122.457625506123 | (37.7653774059583, -122.457625506123) | 15 | 5 | 11 | 29492 | 12 | |||
152814 | 187559 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 136 Alpha St | 1 | Front Yard : Yard | Tree | Private 2 | 9 | 6010948.12811 | 2088162.00128 | 37.7143126024269 | -122.404035178792 | (37.7143126024269, -122.404035178792) | 9 | 7 | 8 | 309 | 39 | ||||
153138 | 245624 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 322 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006476.77935 | 2097220.02712 | 37.7389331361416 | -122.420132400386 | (37.7389331361416, -122.420132400386) | 2 | 7 | 7 | 28859 | 2 | |||
153808 | 175949 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Naples St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004492.29305 | 2092899.66081 | 37.7269583645208 | -122.426686262865 | (37.7269583645208, -122.426686262865) | 9 | 7 | 6 | 28861 | 5 | |||
154475 | 205396 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5 Sequoia Way | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5998207.87044 | 2097837.56069 | 37.7401593599583 | -122.448766805339 | (37.7401593599583, -122.448766805339) | 9 | 7 | 4 | 59 | 40 | |||
155360 | 245734 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 709 Duboce Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6002113.96054 | 2108250.94378 | 37.7689746087188 | -122.436006100894 | (37.7689746087188, -122.436006100894) | 15 | 5 | 5 | 29492 | 3 | |||
155956 | 245483 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 336 Elsie St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6006453.4188 | 2097193.43229 | 37.7388587964037 | -122.420211283534 | (37.7388587964037, -122.420211283534) | 2 | 7 | 7 | 28859 | 2 | |||
160356 | 175879 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 2 | : | Tree | Private 2 | 9 | Width 3ft | 6008041.81725 | 2086229.374 | 37.708843197325 | -122.413943929787 | (37.708843197325, -122.413943929787) | 9 | 7 | 8 | 309 | 39 | |||
160821 | 124510 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2833 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5996037.9669 | 2111039.4536 | 37.7762840787929 | -122.457224188317 | (37.7762840787929, -122.457224188317) | 11 | 6 | 2 | 54 | 16 | |||
161134 | 249996 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 41 Darrell Pl | 2 | Back Yard : Yard | Tree | Private 2 | 9 | Width 0ft | 6011497.53106 | 2120284.14207 | 37.8025435461134 | -122.404395862681 | (37.8025435461134, -122.404395862681) | 3 | 1 | 10 | 308 | 23 | |||
171618 | 118115 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3521 Balboa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5984646.98456 | 2111057.4205 | 37.7756726158346 | -122.496629470062 | (37.7756726158346, -122.496629470062) | 11 | 6 | 2 | 55 | 26 | |||
173517 | 205343 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Junipero Serra Blvd | 33 | : | Tree | Private 2 | 9 | Width 0ft | 5991382.87064 | 2094419.86575 | 37.7303825871646 | -122.472115606868 | (37.7303825871646, -122.472115606868) | 9 | 8 | 4 | 64 | 40 | |||
176142 | 245548 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1187 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007688.25506 | 2102766.23628 | 37.7542299692468 | -122.41633639261 | (37.7542299692468, -122.41633639261) | 2 | 4 | 7 | 28859 | 19 | |||
178736 | 126065 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1920 Beach St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6000989.06632 | 2121021.48883 | 37.8039752632199 | -122.440813227268 | (37.8039752632199, -122.440813227268) | 13 | 9 | 1 | 57 | 17 | |||
179058 | 175878 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6008044.64173 | 2086236.91355 | 37.7088640580086 | -122.413934700952 | (37.7088640580086, -122.413934700952) | 9 | 7 | 8 | 309 | 39 | |||
182312 | 205352 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Vicente St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5992480.14485 | 2097920.47821 | 37.7400578291978 | -122.468576815073 | (37.7400578291978, -122.468576815073) | 1 | 8 | 4 | 59 | 40 | |||
182764 | 126092 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 245 Marina Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 6002282.48289 | 2121873.98014 | 37.8063895543934 | -122.436398331234 | (37.8063895543934, -122.436398331234) | 13 | 9 | 1 | 57 | 17 | |||
183505 | 205330 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1x Minerva St | 26 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 5996263.21296 | 2089001.74294 | 37.715786922213 | -122.45485235667 | (37.715786922213, -122.45485235667) | 9 | 8 | 6 | 28861 | 24 | |||
189090 | 205403 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 920 Monterey Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 5995980.66539 | 2094683.17632 | 37.7313705751845 | -122.456239515042 | (37.7313705751845, -122.456239515042) | 9 | 7 | 4 | 59 | 40 | |||
191910 | 205360 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 501 Dewey Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 5994524.66456 | 2099765.70717 | 37.7452422580339 | -122.461641506945 | (37.7452422580339, -122.461641506945) | 1 | 8 | 4 | 59 | 40 | |||
3918 | 71637 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3735 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 8 | 5983967.42692 | 2111030.60647 | 37.7755591545959 | -122.498978209698 | (37.7755591545959, -122.498978209698) | 11 | 6 | 2 | 55 | 26 | |||
5542 | 117796 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3739 Balboa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5983953.06795 | 2111029.92822 | 37.7755564500477 | -122.49902782995 | (37.7755564500477, -122.49902782995) | 11 | 6 | 2 | 55 | 26 | |||
19369 | 62036 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/01/1985 12:00:00 AM | 8 | Permit Number 22111 | 6004501.59533 | 2092915.26272 | 37.7270017298275 | -122.426655215587 | (37.7270017298275, -122.426655215587) | 9 | 7 | 6 | 28861 | 5 | |
21115 | 245718 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2423 Market St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6002179.10375 | 2105823.91705 | 37.7623142880908 | -122.435607119382 | (37.7623142880908, -122.435607119382) | 15 | 4 | 5 | 28862 | 3 | |||
22325 | 205391 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1110 Teresita Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998274.92773 | 2095667.87912 | 37.7342057679854 | -122.448378743402 | (37.7342057679854, -122.448378743402) | 9 | 7 | 4 | 59 | 40 | |||
22806 | 175944 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1764 Cayuga Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 5997944.4131 | 2088561.35887 | 37.7146740246601 | -122.449009674469 | (37.7146740246601, -122.449009674469) | 9 | 7 | 6 | 28861 | 25 | |||
23629 | 118111 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3501 Balboa St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5984683.93077 | 2111059.4403 | 37.7756803261768 | -122.496501814988 | (37.7756803261768, -122.496501814988) | 11 | 6 | 2 | 55 | 26 | |||
30072 | 117795 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3755 Balboa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5983918.45231 | 2111030.33934 | 37.7755555482917 | -122.499147602329 | (37.7755555482917, -122.499147602329) | 11 | 6 | 2 | 55 | 26 | |||
32156 | 117793 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3785 Balboa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5983889.9027 | 2111029.14325 | 37.7755505893464 | -122.499246272383 | (37.7755505893464, -122.499246272383) | 11 | 6 | 2 | 55 | 26 | |||
35483 | 175955 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 73 Mansfield St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 6005301.14037 | 2091779.76908 | 37.7239290836463 | -122.423810494468 | (37.7239290836463, -122.423810494468) | 9 | 7 | 6 | 309 | 5 | ||||
36563 | 205253 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1976 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991298.99836 | 2101963.32187 | 37.7510901338258 | -122.472955429763 | (37.7510901338258, -122.472955429763) | 1 | 8 | 4 | 29491 | 12 | |||
36640 | 205260 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1454 16th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 5ft | 5991177.69029 | 2105494.2165 | 37.7607780167142 | -122.473632460088 | (37.7607780167142, -122.473632460088) | 1 | 8 | 4 | 56 | 12 | |||
41150 | 126123 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2836 Larkin St | 6 | Side Yard : Yard | Tree | Private 2 | 8 | 6006504.36606 | 2120972.74597 | 37.8041539827815 | -122.42172367341 | (37.8041539827815, -122.42172367341) | 5 | 9 | 1 | 28858 | 32 | ||||
45145 | 245537 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008269.43017 | 2099349.5308 | 37.744881126273 | -122.414084835546 | (37.744881126273, -122.414084835546) | 2 | 7 | 7 | 28859 | 2 | |||
47817 | 247687 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 2 | : | Tree | Private 2 | 8 | Width 4ft | 6000002.20037 | 2108368.10077 | 37.7691760973366 | -122.443318936326 | (37.7691760973366, -122.443318936326) | 15 | 5 | 11 | 29492 | 9 | |||
48128 | 205293 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 146 Stillings Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999807.52736 | 2095794.02146 | 37.7346396297213 | -122.443089132554 | (37.7346396297213, -122.443089132554) | 9 | 7 | 4 | 63 | 40 | ||||
50335 | 126077 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3099 Baker St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 5999388.2562 | 2119380.27509 | 37.7993776348198 | -122.446234784823 | (37.7993776348198, -122.446234784823) | 13 | 9 | 1 | 57 | 17 | |||
52266 | 175915 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 350x Winding Way | 10 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6000968.48443 | 2086648.88049 | 37.7095952724697 | -122.438420330043 | (37.7095952724697, -122.438420330043) | 9 | 7 | 6 | 28861 | 5 | |||
54827 | 205439 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 378 Joost Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | 5999592.52385 | 2094994.83149 | 37.7324329803013 | -122.44377507246 | (37.7324329803013, -122.44377507246) | 9 | 7 | 4 | 63 | 40 | ||||
56606 | 205284 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Pacheco St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 6ft | 5994513.21392 | 2100320.50636 | 37.7467649379646 | -122.46172131999 | (37.7467649379646, -122.46172131999) | 1 | 8 | 4 | 29491 | 40 | |||
58329 | 205394 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1110 Teresita Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5998276.11211 | 2095665.07011 | 37.7341981228269 | -122.448374446424 | (37.7341981228269, -122.448374446424) | 9 | 7 | 4 | 59 | 40 | |||
60422 | 118094 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3639 Balboa St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5984267.41827 | 2111042.24708 | 37.775608708488 | -122.497941342782 | (37.775608708488, -122.497941342782) | 11 | 6 | 2 | 55 | 26 | |||
63248 | 250666 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 632 El Camino Del Mar | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5986516.4549 | 2114931.99978 | 37.7864204545769 | -122.490447706689 | (37.7864204545769, -122.490447706689) | 11 | 6 | 1 | 55 | 33 | |||
63823 | 175961 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 275 Madison St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 7ft | 6005728.67215 | 2092432.15133 | 37.725744509099 | -122.42237891495 | (37.725744509099, -122.42237891495) | 9 | 7 | 7 | 309 | 5 | |||
64737 | 101784 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1017 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6012216.2726 | 2103633.66044 | 37.7568653093127 | -122.400738217399 | (37.7568653093127, -122.400738217399) | 10 | 3 | 8 | 28856 | 29 | |||
68759 | 245528 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 670 Ellsworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007943.4161 | 2095774.09425 | 37.7350454487732 | -122.414959120479 | (37.7350454487732, -122.414959120479) | 2 | 7 | 7 | 28859 | 2 | |||
69795 | 245589 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3922 22nd St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 6002322.93677 | 2102981.40225 | 37.7545175958308 | -122.434906363151 | (37.7545175958308, -122.434906363151) | 2 | 4 | 5 | 28862 | 22 | |||
82571 | 245770 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 50 Digby St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 6002871.37625 | 2097642.58356 | 37.7398895750355 | -122.43262838222 | (37.7398895750355, -122.43262838222) | 2 | 7 | 5 | 63 | 7 | |||
84276 | 181604 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1334 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5981230.183 | 2105961.3297 | 37.7614794563055 | -122.508070510307 | (37.7614794563055, -122.508070510307) | 1 | 8 | 3 | 56 | 35 | |||
85143 | 245490 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1001 Treat Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008635.00283 | 2102667.8072 | 37.7540128980984 | -122.413055332141 | (37.7540128980984, -122.413055332141) | 2 | 4 | 7 | 28859 | 19 | |||
85495 | 245788 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 59 Poppy Ln | 1 | Back Yard : Yard | Tree | Private 2 | 8 | Width 2ft | 6002650.36065 | 2096519.59952 | 37.7367935833586 | -122.433312337306 | (37.7367935833586, -122.433312337306) | 2 | 7 | 5 | 63 | 7 | |||
86538 | 205388 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 413 Los Palmos Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5997508.41793 | 2095710.93078 | 37.7342801239184 | -122.451031901713 | (37.7342801239184, -122.451031901713) | 9 | 7 | 4 | 59 | 40 | |||
88630 | 182536 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1580 36th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5985005.5058 | 2104460.0097 | 37.7575789846205 | -122.494902722195 | (37.7575789846205, -122.494902722195) | 1 | 8 | 3 | 56 | 35 | |||
91193 | 245529 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 670 Ellsworth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007943.1219 | 2095759.71849 | 37.7350059595386 | -122.414959120475 | (37.7350059595386, -122.414959120475) | 2 | 7 | 7 | 28859 | 2 | |||
96797 | 245621 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 44 Elsie St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007421.61476 | 2099036.4016 | 37.7439736878503 | -122.416994249397 | (37.7439736878503, -122.416994249397) | 2 | 7 | 7 | 28859 | 2 | |||
98468 | 218113 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 80 Lopez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5993942.20666 | 2100464.82872 | 37.7471283243225 | -122.46370626495 | (37.7471283243225, -122.46370626495) | 1 | 8 | 4 | 29491 | 40 | |||
98807 | 118853 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 522 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5981329.7531 | 2112134.55312 | 37.7784351943449 | -122.508184356759 | (37.7784351943449, -122.508184356759) | 11 | 6 | 2 | 55 | 26 | |||
106221 | 205334 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 73 Margaret Ave | 1 | : | Tree | Private 2 | 8 | Width 3ft | 5997009.74626 | 2089680.74953 | 37.7176941117806 | -122.452320974643 | (37.7176941117806, -122.452320974643) | 9 | 8 | 6 | 28861 | 24 | |||
106533 | 245561 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2895 Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009019.06036 | 2101672.04835 | 37.7513003197582 | -122.411656812604 | (37.7513003197582, -122.411656812604) | 2 | 4 | 7 | 28859 | 19 | |||
109694 | 245519 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 5 Parnassus Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 5998639.42536 | 2106890.36045 | 37.7650407906107 | -122.447926273781 | (37.7650407906107, -122.447926273781) | 15 | 5 | 11 | 29492 | 9 | |||
112208 | 175951 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 326 Avalon Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 6003639.90512 | 2092696.00259 | 37.7263509363424 | -122.429618432255 | (37.7263509363424, -122.429618432255) | 9 | 7 | 6 | 28861 | 5 | |||
114825 | 245659 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2862 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009008.88417 | 2103936.03473 | 37.7575161459615 | -122.41185196732 | (37.7575161459615, -122.41185196732) | 2 | 4 | 7 | 28859 | 19 |
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) );