trees
1,650 rows where qSpecies_id = 64 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1454 | 247689 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 4 | : | Tree | Private 2 | 24 | Width 4ft | 5999999.2126 | 2108392.11953 | 37.7692418764422 | -122.443330996248 | (37.7692418764422, -122.443330996248) | 15 | 5 | 11 | 29492 | 9 | |||
15183 | 189306 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 499 Texas St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6013832.17688 | 2104822.60916 | 37.7602198992576 | -122.395233060671 | (37.7602198992576, -122.395233060671) | 10 | 3 | 8 | 28856 | 29 | |||
20241 | 247240 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 921 Buena Vista Ave West | 1 | : | Tree | Private 2 | 17 | Width 3ft | 6000040.78347 | 2108630.81284 | 37.7698996387736 | -122.443204350999 | (37.7698996387736, -122.443204350999) | 15 | 5 | 11 | 29492 | 9 | |||
21169 | 247802 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 464 30th St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6003596.41299 | 2098374.599 | 37.7419406120734 | -122.43017371776 | (37.7419406120734, -122.43017371776) | 2 | 7 | 5 | 63 | 22 | |||
21297 | 126095 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3630 Webster St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6002627.04146 | 2121100.74155 | 37.8042860176436 | -122.435150585742 | (37.8042860176436, -122.435150585742) | 13 | 9 | 1 | 57 | 17 | |||
39472 | 247680 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 7 | : | Tree | Private 2 | 20 | Width 4ft | 6000003.68623 | 2108741.82746 | 37.7702023415965 | -122.443340644169 | (37.7702023415965, -122.443340644169) | 15 | 5 | 11 | 29492 | 9 | |||
40859 | 126087 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3747 Divisadero St | 3 | : | Tree | Private 2 | 2 | Width 3ft | 6000117.09871 | 2121156.78395 | 37.8042970496339 | -122.443840445091 | (37.8042970496339, -122.443840445091) | 13 | 9 | 1 | 57 | 17 | |||
45875 | 202071 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Gould St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6012673.40671 | 2090736.38979 | 37.7214776018863 | -122.398252411218 | (37.7214776018863, -122.398252411218) | 10 | 3 | 8 | 58 | 1 | |||
47270 | 126098 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1639 Beach St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6002372.64115 | 2121214.12462 | 37.8045828883414 | -122.436039075449 | (37.8045828883414, -122.436039075449) | 13 | 9 | 1 | 57 | 17 | |||
47644 | 246733 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Ripley St | 1 | : | Tree | Private 2 | 3 | Width 2ft | 6008547.21994 | 2099053.14495 | 37.7440829149855 | -122.413103333461 | (37.7440829149855, -122.413103333461) | 2 | 7 | 7 | 28859 | 2 | |||
47743 | 254574 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2343 42nd Ave | : | Tree | Private 2 | FUF | 03/02/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781480 | 5983281.30564 | 2099193.73405 | 37.7430181719151 | -122.500476236571 | (37.7430181719151, -122.500476236571) | 1 | 8 | 3 | 29491 | 35 | |
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 | |||
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 | |||
53117 | 247686 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 935 Buena Vista Ave West | 4 | : | Tree | Private 2 | 22 | Width 4ft | 6000019.72764 | 2108674.83291 | 37.7700193061664 | -122.443280344631 | (37.7700193061664, -122.443280344631) | 15 | 5 | 11 | 29492 | 9 | |||
59295 | 246506 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 251 Duncan St | 2 | : | Tree | Private 2 | 4 | Width 5ft | 6004876.60593 | 2099863.49377 | 37.7461012023225 | -122.425853176806 | (37.7461012023225, -122.425853176806) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
62801 | 247683 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 935 Buena Vista Ave West | 1 | : | Tree | Private 2 | 18 | Width 3ft | 6000009.45593 | 2108709.0713 | 37.7701127304395 | -122.443318333778 | (37.7701127304395, -122.443318333778) | 15 | 5 | 11 | 29492 | 9 | |||
63814 | 175880 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 3 | : | Tree | Private 2 | 11 | Width 3ft | 6008040.57237 | 2086224.46134 | 37.7088296382554 | -122.413947884988 | (37.7088296382554, -122.413947884988) | 9 | 7 | 8 | 309 | 39 | |||
66227 | 247684 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 935 Buena Vista Ave West | 2 | : | Tree | Private 2 | 22 | Width 3ft | 6000012.39067 | 2108699.28919 | 37.7700860385779 | -122.443307479866 | (37.7700860385779, -122.443307479866) | 15 | 5 | 11 | 29492 | 9 | |||
67423 | 247681 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 8 | : | Tree | Private 2 | 20 | Width 4ft | 5999993.42938 | 2108726.41685 | 37.7701594430376 | -122.443375015343 | (37.7701594430376, -122.443375015343) | 15 | 5 | 11 | 29492 | 9 | |||
73154 | 189297 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1458 Rhode Island St | 1 | : | Tree | Private 2 | 17 | Width 4ft | 6011987.51457 | 2101577.28204 | 37.7512061823217 | -122.401384841636 | (37.7512061823217, -122.401384841636) | 10 | 3 | 8 | 28856 | 29 | |||
82177 | 245599 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 193 Saint Germain Ave | 1 | : | Tree | Private 2 | 16 | Width 8ft | 5997474.2586 | 2104104.13255 | 37.7573238430432 | -122.451755267793 | (37.7573238430432, -122.451755267793) | 15 | 5 | 4 | 28862 | 38 | |||
82323 | 247676 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 3 | : | Tree | Private 2 | 10 | Width 4ft | 5999996.82032 | 2108772.17609 | 37.7702852797644 | -122.443366573435 | (37.7702852797644, -122.443366573435) | 15 | 5 | 11 | 29492 | 9 | |||
82403 | 205333 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 10 Caine Ave | 15 | : | Tree | Private 2 | 1 | Width 0ft | 5997549.34328 | 2089570.25288 | 37.7174216118035 | -122.45044787838 | (37.7174216118035, -122.45044787838) | 9 | 8 | 6 | 28861 | 24 | |||
86494 | 202072 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Gould St | 2 | : | Tree | Private 2 | 11 | Width 3ft | 6012663.72375 | 2090703.30788 | 37.7213862262721 | -122.398283562861 | (37.7213862262721, -122.398283562861) | 10 | 3 | 8 | 58 | 1 | |||
87282 | 247688 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 3 | : | Tree | Private 2 | 10 | Width 4ft | 6000001.52357 | 2108377.48913 | 37.769201836821 | -122.443321951756 | (37.769201836821, -122.443321951756) | 15 | 5 | 11 | 29492 | 9 | |||
92837 | 245487 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 326 San Jose Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 6006168.86774 | 2101142.03108 | 37.7496847182974 | -122.42147547943 | (37.7496847182974, -122.42147547943) | 2 | 4 | 5 | 28859 | 19 | |||
96035 | 247682 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 9 | : | Tree | Private 2 | 22 | Width 4ft | 6000006.57165 | 2108721.28332 | 37.7701460970988 | -122.443329187717 | (37.7701460970988, -122.443329187717) | 15 | 5 | 11 | 29492 | 9 | |||
98556 | 126076 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3099 Baker St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5999384.46531 | 2119405.91146 | 37.7994478089264 | -122.446249747728 | (37.7994478089264, -122.446249747728) | 13 | 9 | 1 | 57 | 17 | |||
103559 | 247691 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 6 | : | Tree | Private 2 | 22 | Width 4ft | 5999995.4075 | 2108418.75948 | 37.7693148060665 | -122.443346071586 | (37.7693148060665, -122.443346071586) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
106249 | 247692 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 7 | : | Tree | Private 2 | 14 | Width 4ft | 5999993.89921 | 2108430.07463 | 37.7693457886147 | -122.443352101522 | (37.7693457886147, -122.443352101522) | 15 | 5 | 11 | 29492 | 9 | |||
106898 | 175882 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 5 | : | Tree | Private 2 | 6 | Width 3ft | 6008037.77895 | 2086218.44055 | 37.7088129495174 | -122.413957113834 | (37.7088129495174, -122.413957113834) | 9 | 7 | 8 | 309 | 39 | |||
109221 | 247675 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 2 | : | Tree | Private 2 | 21 | Width 4ft | 5999994.72677 | 2108788.88509 | 37.7703310390855 | -122.443375015355 | (37.7703310390855, -122.443375015355) | 15 | 5 | 11 | 29492 | 9 | |||
112179 | 246927 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 357 Frederick St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 5998272.3562 | 2107533.69147 | 37.7667862263357 | -122.449242222052 | (37.7667862263357, -122.449242222052) | 15 | 5 | 11 | 29492 | 9 | |||
114082 | 126085 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3747 Divisadero St | 1 | : | Tree | Private 2 | 2 | Width 3ft | 6000116.56752 | 2121160.52429 | 37.8043072893028 | -122.443842552202 | (37.8043072893028, -122.443842552202) | 13 | 9 | 1 | 57 | 17 | |||
114553 | 247693 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 8 | : | Tree | Private 2 | 13 | Width 4ft | 5999992.61936 | 2108443.98924 | 37.7693839216533 | -122.443357528041 | (37.7693839216533, -122.443357528041) | 15 | 5 | 11 | 29492 | 9 | |||
123682 | 247668 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Divisadero St | 2 | : | Tree | Private 2 | 16 | Width 3ft | 6001938.07018 | 2108499.86475 | 37.7696480903062 | -122.436632313225 | (37.7696480903062, -122.436632313225) | 15 | 5 | 5 | 29492 | 9 | |||
125522 | 205339 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 331 Vernon St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 5992450.82232 | 2090054.78249 | 37.7184588853561 | -122.468106177376 | (37.7184588853561, -122.468106177376) | 9 | 8 | 6 | 64 | 24 | |||
127486 | 126099 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1639 Beach St | 3 | : | Tree | Private 2 | 15 | Width 6ft | 6002384.27567 | 2121216.19236 | 37.8045892267643 | -122.435998961207 | (37.8045892267643, -122.435998961207) | 13 | 9 | 1 | 57 | 17 | |||
128306 | 202036 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 74 Crane St | 1 | : | Tree | Private 2 | 12 | Width 4ft | 6012239.5705 | 2090921.68995 | 37.7219622231619 | -122.399765078106 | (37.7219622231619, -122.399765078106) | 10 | 3 | 8 | 58 | 1 | |||
128534 | 247690 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 5 | : | Tree | Private 2 | 21 | Width 4ft | 5999997.25349 | 2108406.91621 | 37.7692823926903 | -122.443338835633 | (37.7692823926903, -122.443338835633) | 15 | 5 | 11 | 29492 | 9 | |||
129431 | 205342 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 300 Junipero Serra Blvd | 16 | : | Tree | Private 2 | 3 | Width 0ft | 5991388.30508 | 2094512.69184 | 37.7306377788136 | -122.47210358291 | (37.7306377788136, -122.47210358291) | 9 | 8 | 4 | 64 | 40 | |||
131907 | 175881 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 140 Kelloch Ave | 4 | : | Tree | Private 2 | 12 | Width 3ft | 6008040.46364 | 2086219.1455 | 37.7088150359462 | -122.413947884982 | (37.7088150359462, -122.413947884982) | 9 | 7 | 8 | 309 | 39 | |||
136212 | 245493 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1306 York St | 5 | : | Tree | Private 2 | 12 | Width 3ft | 6010040.7656 | 2101553.84202 | 37.7510330115737 | -122.408115288704 | (37.7510330115737, -122.408115288704) | 2 | 4 | 7 | 28859 | 19 | |||
136818 | 247685 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 935 Buena Vista Ave West | 3 | : | Tree | Private 2 | 13 | Width 3ft | 6000015.91456 | 2108684.28641 | 37.7700450456643 | -122.443294213074 | (37.7700450456643, -122.443294213074) | 15 | 5 | 11 | 29492 | 9 | |||
145033 | 247679 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 6 | : | Tree | Private 2 | 16 | Width 4ft | 6000001.9279 | 2108749.50236 | 37.7702233146713 | -122.443347277551 | (37.7702233146713, -122.443347277551) | 15 | 5 | 11 | 29492 | 9 | |||
145298 | 247674 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 1 | : | Tree | Private 2 | 21 | Width 4ft | 5999993.18967 | 2108798.81177 | 37.7703582075947 | -122.443381045292 | (37.7703582075947, -122.443381045292) | 15 | 5 | 11 | 29492 | 9 | |||
145400 | 246735 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Ripley St | 3 | : | Tree | Private 2 | 3 | Width 2ft | 6008576.96579 | 2099053.87477 | 37.7440865887414 | -122.413000530175 | (37.7440865887414, -122.413000530175) | 2 | 7 | 7 | 28859 | 2 | |||
146216 | 247558 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2 Central Ave | 1 | : | Tree | Private 2 | 6 | Width 4ft | 6000004.98799 | 2108349.41741 | 37.7691249564843 | -122.443307952002 | (37.7691249564843, -122.443307952002) | 15 | 5 | 11 | 29492 | 9 | |||
150718 | 189311 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1763 Revere Ave | 2 | : | Tree | Private 2 | 19 | Width 3ft | 6014243.98109 | 2094996.62918 | 37.7332627209035 | -122.393121267238 | (37.7332627209035, -122.393121267238) | 10 | 3 | 8 | 58 | 1 | |||
153969 | 189298 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1470 Rhode Island St | 1 | : | Tree | Private 2 | 15 | Width 4ft | 6011992.06191 | 2101527.33948 | 37.7510693046196 | -122.401365606962 | (37.7510693046196, -122.401365606962) | 10 | 3 | 8 | 28856 | 29 | |||
155406 | 247237 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 923 Buena Vista Ave West | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6000029.91762 | 2108654.05945 | 37.7699628485306 | -122.44324360552 | (37.7699628485306, -122.44324360552) | 15 | 5 | 11 | 29492 | 9 | |||
156859 | 247238 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 923 Buena Vista Ave West | 2 | : | Tree | Private 2 | 14 | Width 3ft | 6000033.92777 | 2108644.76792 | 37.7699375649926 | -122.443229067086 | (37.7699375649926, -122.443229067086) | 15 | 5 | 11 | 29492 | 9 | |||
157254 | 189312 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1784 Revere Ave | 2 | : | Tree | Private 2 | 3 | Width 5ft | 6014126.96822 | 2095142.52205 | 37.733656811898 | -122.393536022869 | (37.733656811898, -122.393536022869) | 10 | 3 | 8 | 58 | 1 | |||
157471 | 205341 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1400 Holloway Ave | 5 | : | Tree | Private 2 | 3 | Width 0ft | 5990799.69787 | 2091134.9811 | 37.7213293495637 | -122.47389213663 | (37.7213293495637, -122.47389213663) | 9 | 8 | 4 | 64 | 40 | |||
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 | |||
161533 | 247241 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 921 Buena Vista Ave West | 2 | : | Tree | Private 2 | 27 | Width 3ft | 6000047.51607 | 2108621.04619 | 37.7698732059058 | -122.443180361598 | (37.7698732059058, -122.443180361598) | 15 | 5 | 11 | 29492 | 9 | |||
169430 | 246734 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Ripley St | 2 | : | Tree | Private 2 | 3 | Width 2ft | 6008557.46884 | 2099053.26982 | 37.7440838331996 | -122.413067903753 | (37.7440838331996, -122.413067903753) | 2 | 7 | 7 | 28859 | 2 | |||
171963 | 245486 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 326 San Jose Ave | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6006168.67075 | 2101144.6213 | 37.7496918193421 | -122.421476344562 | (37.7496918193421, -122.421476344562) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
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 | |||
180374 | 247678 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 5 | : | Tree | Private 2 | 13 | Width 4ft | 6000000.32593 | 2108756.30606 | 37.7702419045662 | -122.443353307504 | (37.7702419045662, -122.443353307504) | 15 | 5 | 11 | 29492 | 9 | |||
182002 | 189310 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1763 Revere Ave | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6014232.27573 | 2095006.13828 | 37.7332881806876 | -122.393162401334 | (37.7332881806876, -122.393162401334) | 10 | 3 | 8 | 58 | 1 | |||
182409 | 126086 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3747 Divisadero St | 2 | : | Tree | Private 2 | 2 | Width 3ft | 6000116.67456 | 2121159.09697 | 37.8043033763715 | -122.443842079173 | (37.8043033763715, -122.443842079173) | 13 | 9 | 1 | 57 | 17 | |||
183000 | 126096 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3630 Webster St | 3 | : | Tree | Private 2 | 3 | Width 3ft | 6002623.69745 | 2121110.92365 | 37.8043137851175 | -122.435162886659 | (37.8043137851175, -122.435162886659) | 13 | 9 | 1 | 57 | 17 | |||
183225 | 189281 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 975 Minna St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6008056.3994 | 2110189.2113 | 37.7746324316857 | -122.415588777222 | (37.7746324316857, -122.415588777222) | 8 | 2 | 9 | 28853 | 34 | |||
188266 | 247677 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 969 Buena Vista Ave West | 4 | : | Tree | Private 2 | 24 | Width 4ft | 5999999.41375 | 2108762.74792 | 37.7702595402749 | -122.443356925493 | (37.7702595402749, -122.443356925493) | 15 | 5 | 11 | 29492 | 9 | |||
192553 | 189296 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 621 Rhode Island St | 1 | : | Tree | Private 2 | 2 | Width 2ft | 6011838.19125 | 2105389.54808 | 37.7616654928887 | -122.402169215947 | (37.7616654928887, -122.402169215947) | 10 | 3 | 8 | 28856 | 29 | |||
3380 | 261217 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3400 Vicente St | : Cutout | Tree | Private 2 | FUF | 3x3 | 5982420.06104 | 2097439.60235 | 37.738151214353 | -122.503324281602 | (37.738151214353, -122.503324281602) | 1 | 8 | 3 | 29491 | 35 | ||||
13735 | 189282 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1310 Indiana St | 17 | : Yard | Tree | Private 2 | 2 | 6015006.25242 | 2102364.64044 | 37.753536067647 | -122.39100065687 | (37.753536067647, -122.39100065687) | 10 | 3 | 8 | 28856 | 29 | ||||
30031 | 205447 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 321 Melrose Ave | 2 | : Yard | Tree | Private 2 | 2 | 5997960.43745 | 2095528.68593 | 37.7338055912481 | -122.4494560053 | (37.7338055912481, -122.4494560053) | 9 | 7 | 4 | 59 | 40 | ||||
33728 | 245707 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4001 20th St | 4 | : Yard | Tree | Private 2 | 16 | Width 3ft | 6003651.76342 | 2104178.89616 | 37.7578809883279 | -122.430396367393 | (37.7578809883279, -122.430396367393) | 2 | 4 | 5 | 28862 | 3 | |||
42440 | 245705 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4001 20th St | 1 | : Yard | Tree | Private 2 | 16 | Width 3ft | 6003616.02573 | 2104184.50188 | 37.7578943558614 | -122.430520363245 | (37.7578943558614, -122.430520363245) | 2 | 4 | 5 | 28862 | 3 | |||
42720 | 245706 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 4001 20th St | 3 | : Yard | Tree | Private 2 | 16 | Width 3ft | 6003635.70774 | 2104190.58748 | 37.7579121804175 | -122.430452728819 | (37.7579121804175, -122.430452728819) | 2 | 4 | 5 | 28862 | 3 | |||
50934 | 189291 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 31 | : Yard | Tree | Private 2 | 5 | 6014386.77773 | 2105894.38958 | 37.7631936029157 | -122.39338994869 | (37.7631936029157, -122.39338994869) | 14 | 3 | 8 | 28856 | 29 | ||||
76388 | 189289 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 20 | : Yard | Tree | Private 2 | 10 | 6014461.84726 | 2105889.9963 | 37.7631857104708 | -122.393129998769 | (37.7631857104708, -122.393129998769) | 14 | 3 | 8 | 28856 | 29 | ||||
79813 | 189290 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 23 | : Yard | Tree | Private 2 | 5 | 6014424.75736 | 2105899.25329 | 37.7632090676603 | -122.393258929155 | (37.7632090676603, -122.393258929155) | 14 | 3 | 8 | 28856 | 29 | ||||
94508 | 189283 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1310 Indiana St | 16 | : Yard | Tree | Private 2 | 4 | 6015000.28938 | 2102358.87265 | 37.7535198996319 | -122.391020875425 | (37.7535198996319, -122.391020875425) | 10 | 3 | 8 | 28856 | 29 | ||||
118735 | 189293 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 35 | : Yard | Tree | Private 2 | 8 | 6014389.36638 | 2105866.30731 | 37.7631166389548 | -122.393379030018 | (37.7631166389548, -122.393379030018) | 14 | 3 | 8 | 28856 | 29 | ||||
163412 | 189292 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 01st St | 33 | : Yard | Tree | Private 2 | 5 | 6014376.22928 | 2105886.6133 | 37.7631716648753 | -122.393425888311 | (37.7631716648753, -122.393425888311) | 14 | 3 | 8 | 28856 | 29 | ||||
18575 | 245781 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 6 | Back Yard : Yard | Tree | Private 2 | 17 | Width 8ft | 6003587.5616 | 2096850.22083 | 37.7377545179491 | -122.430095602638 | (37.7377545179491, -122.430095602638) | 2 | 7 | 5 | 63 | 7 | |||
26166 | 245779 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 4 | Back Yard : Yard | Tree | Private 2 | 4 | Width 8ft | 6003578.06847 | 2096849.22804 | 37.73775125431 | -122.430128354157 | (37.73775125431, -122.430128354157) | 2 | 7 | 5 | 63 | 7 | |||
44149 | 245786 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 13 | Back Yard : Yard | Tree | Private 2 | 2 | Width 3ft | 6003641.81586 | 2096850.294 | 37.7377577914922 | -122.429908024732 | (37.7377577914922, -122.429908024732) | 2 | 7 | 5 | 63 | 7 | |||
55718 | 245784 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 11 | Back Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6003626.79774 | 2096849.74169 | 37.7377554244689 | -122.429959910226 | (37.7377554244689, -122.429959910226) | 2 | 7 | 5 | 63 | 7 | |||
56221 | 245789 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 13 Penny Ln | 1 | Back Yard : Yard | Tree | Private 2 | 23 | Width 2ft | 6002510.68516 | 2096313.64967 | 37.7362201675144 | -122.433780540537 | (37.7362201675144, -122.433780540537) | 2 | 7 | 5 | 63 | 7 | |||
74512 | 245780 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 5 | Back Yard : Yard | Tree | Private 2 | 2 | Width 8ft | 6003583.61188 | 2096848.84807 | 37.7377505249636 | -122.430109160821 | (37.7377505249636, -122.430109160821) | 2 | 7 | 5 | 63 | 7 | |||
82783 | 245785 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 12 | Back Yard : Yard | Tree | Private 2 | 2 | Width 4ft | 6003634.59217 | 2096849.86817 | 37.7377562131711 | -122.429932970144 | (37.7377562131711, -122.429932970144) | 2 | 7 | 5 | 63 | 7 | |||
84971 | 245778 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 1 | Back Yard : Yard | Tree | Private 2 | 11 | Width 8ft | 6003567.00592 | 2096851.64348 | 37.7377572599929 | -122.430166774989 | (37.7377572599929, -122.430166774989) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
91271 | 245783 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 10 | Back Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 6003607.92987 | 2096849.51084 | 37.73775372205 | -122.430025129081 | (37.73775372205, -122.430025129081) | 2 | 7 | 5 | 63 | 7 | |||
148098 | 245782 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 21 Addison St | 8 | Back Yard : Yard | Tree | Private 2 | 6 | Width 8ft | 6003599.48806 | 2096849.28505 | 37.7377526239794 | -122.430054300383 | (37.7377526239794, -122.430054300383) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
29379 | 254551 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 1433 Cayuga Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 6x6 | 5999129 | 2089595 | 37.7175798453783 | -122.444989533853 | (37.7175798453783, -122.444989533853) | 9 | 7 | 6 | 28861 | 25 | ||||
68010 | 112569 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 162 GRAND VIEW AVE | 1 | Front Yard : Cutout | Tree | Private 2 | 7 | 3x3 | 6000754 | 2103380 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | 2 | 4 | 5 | 63 | 38 | |||
69856 | 112572 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 162 GRAND VIEW AVE | 4 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000754 | 2103380 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | 2 | 4 | 5 | 63 | 38 | ||||
96146 | 112571 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 162 GRAND VIEW AVE | 3 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000754 | 2103380 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | 2 | 4 | 5 | 63 | 38 | ||||
111048 | 113744 | Significant Tree 6 | Cordyline australis :: Dracena Palm 64 | 909 ASHBURY ST | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5999156 | 2107025 | 37.7654399906909 | -122.44614926226 | (37.7654399906909, -122.44614926226) | 15 | 5 | 11 | 29492 | 9 | ||||
163015 | 112570 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 162 GRAND VIEW AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6000754 | 2103380 | 37.7555228430156 | -122.440360729392 | (37.7555228430156, -122.440360729392) | 2 | 4 | 5 | 63 | 38 | ||||
184104 | 254588 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 2014 47th Ave | Front Yard : Cutout | Tree | Private 2 | FUF | 03/06/2018 12:00:00 AM | 3 | 3x3 | Permit Number 781514 | 5981693.27527 | 2101363.93313 | 37.7488835852013 | -122.50612799747 | (37.7488835852013, -122.50612799747) | 1 | 8 | 3 | 29491 | 35 |
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) );