trees
1,650 rows where qSpecies_id = 64 sorted by SiteOrder 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
101014 | 184093 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1600 Sunset Blvd | 96 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984922.9495 | 2104229.3007 | 37.7569406887046 | -122.495171218388 | (37.7569406887046, -122.495171218388) | 1 | 8 | 3 | 56 | 35 | |||
44735 | 186828 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1200 Sunset Blvd | 95 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984824.2272 | 2106601.6272 | 37.76344865476 | -122.495687613477 | (37.76344865476, -122.495687613477) | 1 | 8 | 3 | 56 | 35 | |||
41770 | 186831 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1200 Sunset Blvd | 90 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 0ft | 5984823.4905 | 2106576.2092 | 37.763378820926 | -122.495688286465 | (37.763378820926, -122.495688286465) | 1 | 8 | 3 | 56 | 35 | |||
512 | 126120 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 6006458.53093 | 2121044.25925 | 37.8043477551992 | -122.421887372509 | (37.8043477551992, -122.421887372509) | 5 | 9 | 1 | 28858 | 32 | |||
40884 | 175945 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 901 Delano Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5998663.60507 | 2089603.57639 | 37.7175768212865 | -122.446598802501 | (37.7175768212865, -122.446598802501) | 9 | 7 | 6 | 28861 | 25 | |||
52331 | 29994 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 9 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005883.22983 | 2099389.42314 | 37.7448563472359 | -122.422338718883 | (37.7448563472359, -122.422338718883) | 2 | 7 | 5 | 28859 | 2 | ||
55309 | 30017 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 9 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005697.924 | 2098794.21109 | 37.743211575362 | -122.422937177222 | (37.743211575362, -122.422937177222) | 2 | 7 | 7 | 28859 | 2 | ||
83872 | 187503 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 9 | Front Yard : Yard | Tree | Private 2 | 2 | 6005106.37943 | 2086503.45631 | 37.7094304690223 | -122.424108697959 | (37.7094304690223, -122.424108697959) | 9 | 7 | 6 | 309 | 5 | ||||
90126 | 245632 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 105 Manchester St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008270.17422 | 2099353.33031 | 37.7448916006749 | -122.414082531499 | (37.7448916006749, -122.414082531499) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
107771 | 189347 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017789.20409 | 2096498.15859 | 37.7375819299621 | -122.380968686163 | (37.7375819299621, -122.380968686163) | 10 | 3 | 8 | 58 | 1 | |||
108102 | 205477 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999454.95195 | 2093530.05196 | 37.7284031901334 | -122.444145472637 | (37.7284031901334, -122.444145472637) | 9 | 7 | 4 | 63 | 40 | ||||
110521 | 118492 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5981407.0833 | 2112311.43925 | 37.7789254278995 | -122.507929978094 | (37.7789254278995, -122.507929978094) | 11 | 6 | 2 | 55 | 26 | ||||
123843 | 205427 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 90 Melrose Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 25 | Width 8ft | 5999502.43609 | 2095532.0272 | 37.7339028547262 | -122.444125112901 | (37.7339028547262, -122.444125112901) | 9 | 7 | 4 | 63 | 40 | |||
139773 | 118499 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5981338.20461 | 2112298.18891 | 37.7788849878192 | -122.508167268986 | (37.7788849878192, -122.508167268986) | 11 | 6 | 2 | 55 | 26 | ||||
150574 | 205299 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 Malta Dr | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 6ft | 5999812.60862 | 2095804.2587 | 37.7346680284999 | -122.443072299944 | (37.7346680284999, -122.443072299944) | 9 | 7 | 4 | 63 | 40 | |||
151882 | 122589 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2500X Lyon St | 9 | Median : Cutout | Tree | Private 2 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | ||||
159687 | 189364 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017803.09649 | 2096176.66908 | 37.7366999504426 | -122.380898309728 | (37.7366999504426, -122.380898309728) | 10 | 3 | 8 | 58 | 1 | |||
170545 | 126074 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 280 Euclid Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 9ft | 5997931.91034 | 2113961.13951 | 37.7844148567016 | -122.450883266276 | (37.7844148567016, -122.450883266276) | 15 | 6 | 1 | 54 | 31 | |||
177575 | 245484 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 336 Elsie St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6006438.81302 | 2097168.74842 | 37.7387901970012 | -122.420260032173 | (37.7387901970012, -122.420260032173) | 2 | 7 | 7 | 28859 | 2 | |||
180244 | 245673 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594x Guerrero St | 9 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005908.33244 | 2099840.79063 | 37.7460971157901 | -122.422283981647 | (37.7460971157901, -122.422283981647) | 2 | 7 | 5 | 28859 | 22 | |||
182551 | 189318 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1121 Jamestown Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013359.03533 | 2090071.72065 | 37.7196907209338 | -122.395835813273 | (37.7196907209338, -122.395835813273) | 10 | 3 | 8 | 58 | 1 | ||||
189853 | 245777 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 339 Addison St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6002255.95749 | 2097701.24015 | 37.7400157121687 | -122.434760433759 | (37.7400157121687, -122.434760433759) | 2 | 7 | 5 | 63 | 7 | |||
119810 | 184083 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1600 Sunset Blvd | 84 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984945.8447 | 2104060.7868 | 37.7564793366363 | -122.495079613663 | (37.7564793366363, -122.495079613663) | 1 | 8 | 3 | 56 | 35 | |||
2492 | 205476 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5999461.7393 | 2093534.48294 | 37.7284157437829 | -122.444122326784 | (37.7284157437829, -122.444122326784) | 9 | 7 | 4 | 63 | 40 | ||||
10994 | 189372 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1190 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017835.15635 | 2096405.7352 | 37.7373306899522 | -122.380803382685 | (37.7373306899522, -122.380803382685) | 10 | 3 | 8 | 58 | 1 | |||
20085 | 30016 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750X San Jose Ave | 8 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005691.52892 | 2098774.02454 | 37.7431557868143 | -122.422957855325 | (37.7431557868143, -122.422957855325) | 2 | 7 | 7 | 28859 | 2 | ||
39801 | 205459 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 616 Joost Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 41 | Width 3ft | 5997994.33697 | 2095021.01353 | 37.7324135828103 | -122.449302241032 | (37.7324135828103, -122.449302241032) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
65170 | 205312 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 181 Flood Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5999534.41289 | 2094056.98006 | 37.7298545448397 | -122.443908616415 | (37.7298545448397, -122.443908616415) | 9 | 7 | 4 | 63 | 40 | |||
65450 | 122588 | Undocumented 4 | Cordyline australis :: Dracena Palm 64 | 2500X Lyon St | 8 | Median : Cutout | Tree | Private 2 | 13 | 10x20 | 5999276 | 2117538 | 37.7943128273924 | -122.446490617691 | (37.7943128273924, -122.446490617691) | 13 | 9 | 1 | 57 | 27 | |||
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 | |||
72772 | 245712 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 841 Church St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 6004375.24201 | 2104127.67886 | 37.757781312886 | -122.427890625065 | (37.757781312886, -122.427890625065) | 2 | 4 | 5 | 28862 | 3 | |||
75297 | 205298 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1 Malta Dr | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5999812.06698 | 2095809.44133 | 37.7346822279016 | -122.443074544651 | (37.7346822279016, -122.443074544651) | 9 | 7 | 4 | 63 | 40 | |||
79053 | 15065 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1X Minerva St | 8 | Median : Cutout | Tree | DPW 1 | 3 | 11 | 5996005.0253 | 2089004.00266 | 37.7157783129984 | -122.455744930195 | (37.7157783129984, -122.455744930195) | 9 | 8 | 6 | 28861 | 24 | |||
80647 | 245776 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 339 Addison St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6002249.41782 | 2097701.04161 | 37.7400147957413 | -122.434783031019 | (37.7400147957413, -122.434783031019) | 2 | 7 | 5 | 63 | 7 | |||
97762 | 189357 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1101 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017772.7039 | 2096095.52292 | 37.736475461683 | -122.380997751349 | (37.736475461683, -122.380997751349) | 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 | ||||
108959 | 118498 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5981347.00286 | 2112298.64035 | 37.7788867457895 | -122.508136866402 | (37.7788867457895, -122.508136866402) | 11 | 6 | 2 | 55 | 26 | ||||
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 | |||
117858 | 126073 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 280 Euclid Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 21 | Width 9ft | 5997937.77739 | 2113961.77772 | 37.7844169449227 | -122.450863014442 | (37.7844169449227, -122.450863014442) | 15 | 6 | 1 | 54 | 31 | |||
131322 | 189340 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1195 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017708.86017 | 2096602.39431 | 37.7378637055476 | -122.381253721795 | (37.7378637055476, -122.381253721795) | 10 | 3 | 8 | 58 | 1 | |||
144372 | 29713 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594X Guerrero St | 8 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 6005909.20012 | 2099831.66519 | 37.7460721083515 | -122.422280333079 | (37.7460721083515, -122.422280333079) | 2 | 7 | 5 | 28859 | 22 | |||
146943 | 118103 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3619 Balboa St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5984341.79141 | 2111045.5392 | 37.7756221076896 | -122.497684314994 | (37.7756221076896, -122.497684314994) | 11 | 6 | 2 | 55 | 26 | |||
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 | |||
153114 | 189368 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1188 Fairfax Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017798.12742 | 2096332.7671 | 37.737128290339 | -122.380926338881 | (37.737128290339, -122.380926338881) | 10 | 3 | 8 | 58 | 1 | |||
163857 | 118590 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 101 Point Lobos Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5982474.39956 | 2112527.89974 | 37.7795825932214 | -122.504253806958 | (37.7795825932214, -122.504253806958) | 11 | 6 | 2 | 55 | 26 | ||||
171002 | 245618 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 319 Virginia Ave | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 6006920.58968 | 2098190.13218 | 37.7416218248949 | -122.418666682626 | (37.7416218248949, -122.418666682626) | 2 | 7 | 7 | 28859 | 2 | |||
174461 | 187502 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 8 | Front Yard : Yard | Tree | Private 2 | 4 | 6005111.53197 | 2086501.51554 | 37.7094254309976 | -122.424090751982 | (37.7094254309976, -122.424090751982) | 9 | 7 | 6 | 309 | 5 | ||||
180733 | 27694 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 600X El Camino Del Mar | 8 | Median : Cutout | Tree | DPW 1 | 3 | 15-HOA | 5986691.267885 | 2115146.1691739 | 37.787018710699 | -122.489858663161 | (37.787018710699, -122.489858663161) | 11 | 6 | 1 | 55 | 33 | |||
187240 | 118493 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 8245 Geary Blvd | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5981395.17159 | 2112311.03986 | 37.7789236294482 | -122.507971155072 | (37.7789236294482, -122.507971155072) | 11 | 6 | 2 | 55 | 26 | ||||
190062 | 29993 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 8 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005880.60295 | 2099381.42021 | 37.7448342248263 | -122.422347233647 | (37.7448342248263, -122.422347233647) | 2 | 7 | 5 | 28859 | 2 | ||
56412 | 184073 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1600 Sunset Blvd | 74 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984940.7283 | 2104003.0441 | 37.7563204916476 | -122.495093049951 | (37.7563204916476, -122.495093049951) | 1 | 8 | 3 | 56 | 35 | |||
2481 | 245485 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1300 San Jose Ave | 72 | Front Yard : Yard | Tree | Private 2 | 4 | Width 5ft | 6003516.63487 | 2095667.30987 | 37.7345024965788 | -122.430256461687 | (37.7345024965788, -122.430256461687) | 2 | 7 | 5 | 63 | 7 | |||
13800 | 189286 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Minnesota St | 70 | Front Yard : Yard | Tree | Private 2 | 3 | 6015368.15632 | 2102301.56591 | 37.7533829535663 | -122.389744698757 | (37.7533829535663, -122.389744698757) | 10 | 3 | 8 | 28856 | 29 | ||||
3731 | 175896 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 529 Lisbon St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6002023.9515 | 2090409.71529 | 37.7199816731933 | -122.435041255167 | (37.7199816731933, -122.435041255167) | 9 | 7 | 6 | 28861 | 5 | |||
17008 | 29712 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1594X Guerrero St | 7 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 6 | 6005909.34325 | 2099821.50359 | 37.7460442149832 | -122.422279116311 | (37.7460442149832, -122.422279116311) | 2 | 7 | 5 | 28859 | 22 | |||
22602 | 205411 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 6ft | 6001323.45002 | 2094964.81551 | 37.7324491402005 | -122.43778871637 | (37.7324491402005, -122.43778871637) | 9 | 7 | 5 | 63 | 40 | |||
29556 | 126084 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3651 Baker St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5999114.44303 | 2121365.28612 | 37.8048122981983 | -122.447325218189 | (37.8048122981983, -122.447325218189) | 13 | 9 | 1 | 57 | 17 | |||
30520 | 118591 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 101 Point Lobos Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5982483.31512 | 2112527.9777 | 37.7795833316153 | -122.504222970503 | (37.7795833316153, -122.504222970503) | 11 | 6 | 2 | 55 | 26 | ||||
34073 | 29992 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 681X San Jose Ave | 7 | Median : Cutout | Tree | DPW 1 | 03/24/2007 12:00:00 AM | 3 | 3x3 | 6005877.58141 | 2099371.3233 | 37.7448063305595 | -122.422356964316 | (37.7448063305595, -122.422356964316) | 2 | 7 | 5 | 28859 | 2 | ||
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 | |||
44248 | 205475 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 5999461.68909 | 2093522.86386 | 37.7283838376284 | -122.444121665807 | (37.7283838376284, -122.444121665807) | 9 | 7 | 4 | 63 | 40 | ||||
47516 | 205406 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 32 Malta Dr | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5999669.04162 | 2095969.46691 | 37.735113464498 | -122.443580522123 | (37.735113464498, -122.443580522123) | 9 | 7 | 4 | 63 | 40 | |||
48459 | 245795 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6002841.82377 | 2098354.17483 | 37.7418417639849 | -122.432781382956 | (37.7418417639849, -122.432781382956) | 2 | 7 | 5 | 63 | 7 | ||||
57083 | 187501 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100 Walbridge St | 7 | Front Yard : Yard | Tree | Private 2 | 3 | 6005123.3425 | 2086496.85663 | 37.7094133054443 | -122.424049601701 | (37.7094133054443, -122.424049601701) | 9 | 7 | 6 | 309 | 5 | ||||
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 | |||
68386 | 205375 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 340 Rivera St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5992005.20225 | 2100503.1627 | 37.7471217736707 | -122.470406998394 | (37.7471217736707, -122.470406998394) | 1 | 8 | 4 | 29491 | 40 | |||
79271 | 94199 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 355 Ocean Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 53723 | 5999419.6 | 2091436.9 | 37.7226538624451 | -122.444117342662 | (37.7226538624451, -122.444117342662) | 9 | 7 | 6 | 28861 | 25 | |||
80115 | 205278 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 800 Pacheco St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5991451.76279 | 2101838.07467 | 37.750755080601 | -122.472418029979 | (37.750755080601, -122.472418029979) | 1 | 8 | 4 | 29491 | 12 | |||
86287 | 118104 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 3619 Balboa St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5984338.24739 | 2111045.35497 | 37.7756213940982 | -122.497696560834 | (37.7756213940982, -122.497696560834) | 11 | 6 | 2 | 55 | 26 | |||
87974 | 126072 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 280 Euclid Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 9ft | 5997944.17854 | 2113963.60849 | 37.7844223381708 | -122.450841000831 | (37.7844223381708, -122.450841000831) | 15 | 6 | 1 | 54 | 31 | |||
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 | |||
113392 | 102273 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 100X Casitas Ave | 7 | Median : Cutout | Tree | DPW 1 | 12 | 6x14 | 5995287.9 | 2097019.1 | 37.7377446590015 | -122.458803572065 | (37.7377446590015, -122.458803572065) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
120200 | 189320 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 122 Whitney Young Cir | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6016428.13568 | 2095859.36689 | 37.7357527179215 | -122.385630082783 | (37.7357527179215, -122.385630082783) | 10 | 3 | 8 | 58 | 1 | |||
129872 | 245663 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 750x San Jose Ave | 7 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6005696.33761 | 2098785.48588 | 37.7431875283974 | -122.422942042552 | (37.7431875283974, -122.422942042552) | 2 | 7 | 7 | 28859 | 2 | |||
133400 | 189363 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1100 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017807.80075 | 2096153.39811 | 37.7366363126207 | -122.380880427608 | (37.7366363126207, -122.380880427608) | 10 | 3 | 8 | 58 | 1 | |||
149186 | 126119 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2843 Larkin St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 6006456.64037 | 2121054.20596 | 37.804374959703 | -122.421894621951 | (37.804374959703, -122.421894621951) | 5 | 9 | 1 | 28858 | 32 | |||
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 | |||
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 | |||
177157 | 245579 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2211 Castro St | 7 | Sidewalk: Curb side : Pot | Tree | Private 2 | 34 | Width 10ft | 6002722.73971 | 2099078.10781 | 37.743822760922 | -122.433244852161 | (37.743822760922, -122.433244852161) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
179539 | 189346 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6017783.39859 | 2096513.49577 | 37.7376237223681 | -122.380989824718 | (37.7376237223681, -122.380989824718) | 10 | 3 | 8 | 58 | 1 | |||
181860 | 245509 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 107 Valley St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6005195.41877 | 2099296.09974 | 37.7445612796971 | -122.424710405556 | (37.7445612796971, -122.424710405556) | 2 | 7 | 5 | 63 | 22 | |||
76547 | 189285 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1301 Minnesota St | 64 | Front Yard : Yard | Tree | Private 2 | 3 | 6015362.87396 | 2102344.01113 | 37.7534992062408 | -122.389765930873 | (37.7534992062408, -122.389765930873) | 10 | 3 | 8 | 28856 | 29 | ||||
3410 | 47847 | Permitted Site 7 | Cordyline australis :: Dracena Palm 64 | 8250on Geary 47th Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/2002 12:00:00 AM | Permit Number 45605 | |||||||||||||
11234 | 205417 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 198 Mangels Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6000139.85205 | 2095251.72944 | 37.7331695655238 | -122.441901267552 | (37.7331695655238, -122.441901267552) | 9 | 7 | 5 | 63 | 40 | ||||
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 | |||
20448 | 245794 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 601 30th St | 6 | Front Yard : Yard | Tree | Private 2 | 2 | 6002837.91517 | 2098354.25557 | 37.7418417639992 | -122.432794903371 | (37.7418417639992, -122.432794903371) | 2 | 7 | 5 | 63 | 7 | ||||
20691 | 182914 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 2650 Sloat Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5982494.64 | 2096518.7706 | 37.7356272455922 | -122.502998277506 | (37.7356272455922, -122.502998277506) | 1 | 8 | 3 | 29491 | 35 | |||
21561 | 205277 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 800 Pacheco St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5991460.19521 | 2101837.33618 | 37.7507535409505 | -122.472388816384 | (37.7507535409505, -122.472388816384) | 1 | 8 | 4 | 29491 | 12 | |||
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 | |||
35391 | 205286 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 200 Pacheco St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 6ft | 5994515.58905 | 2100325.72099 | 37.7467793927483 | -122.461713485112 | (37.7467793927483, -122.461713485112) | 1 | 8 | 4 | 29491 | 40 | |||
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 | ||||
47861 | 245714 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 190 Storrie St | 6 | Front Yard : Yard | Tree | Private 2 | 11 | Width 3ft | 6000760.42696 | 2105281.17625 | 37.7607433748224 | -122.440474851044 | (37.7607433748224, -122.440474851044) | 15 | 4 | 5 | 28862 | 3 | |||
51371 | 205474 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 98 Judson Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999468.48436 | 2093527.67559 | 37.7283974371761 | -122.444098519924 | (37.7283974371761, -122.444098519924) | 9 | 7 | 4 | 63 | 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 | ||||
52666 | 189345 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1151 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017780.12141 | 2096521.5523 | 37.7376456631085 | -122.381001715564 | (37.7376456631085, -122.381001715564) | 10 | 3 | 8 | 58 | 1 | |||
57494 | 189367 | DPW Maintained 1 | Cordyline australis :: Dracena Palm 64 | 1188 Fairfax Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6017784.81791 | 2096314.09412 | 37.7370762834315 | -122.380971058572 | (37.7370762834315, -122.380971058572) | 10 | 3 | 8 | 58 | 1 |
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) );