trees
390 rows where qSpecies_id = 126 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76368 | 104212 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1117 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 6012239.80468 | 2103199.03133 | 37.7556732255654 | -122.400626303066 | (37.7556732255654, -122.400626303066) | 10 | 3 | 8 | 28856 | 29 | ||||
86485 | 108262 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Gould St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 6012679.64923 | 2090646.14976 | 37.7212301687063 | -122.398224504378 | (37.7212301687063, -122.398224504378) | 10 | 3 | 8 | 58 | 1 | ||||
134991 | 113714 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 498x 21st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5989413.63244 | 2111977.09724 | 37.7784759101897 | -122.480207969324 | (37.7784759101897, -122.480207969324) | 11 | 6 | 2 | 55 | 26 | |||
110384 | 113843 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1709 Revere Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 5x5 | 6014550.22753 | 2094753.99244 | 37.7326134976031 | -122.392045518911 | (37.7326134976031, -122.392045518911) | 10 | 3 | 8 | 58 | 1 | |||
25689 | 117694 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 400 42nd Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 4ft | 5982857.55848 | 2113059.74766 | 37.7810654184436 | -122.502967701532 | (37.7810654184436, -122.502967701532) | 11 | 6 | 2 | 55 | 26 | |||
149299 | 117696 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4049 Clement St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 5982902.7944 | 2113073.38383 | 37.7811055179679 | -122.502812220234 | (37.7811055179679, -122.502812220234) | 11 | 6 | 2 | 55 | 26 | |||
49620 | 117722 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 475 40th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5983440.15975 | 2112634.89847 | 37.7799331315357 | -122.500920796748 | (37.7799331315357, -122.500920796748) | 11 | 6 | 2 | 55 | 26 | |||
89693 | 117777 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 7414 Geary Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 41 | Width 3ft | 5983996.52894 | 2112514.84276 | 37.7796361445772 | -122.498987225205 | (37.7796361445772, -122.498987225205) | 11 | 6 | 2 | 55 | 26 | |||
155705 | 117778 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 7414 Geary Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5983986.79106 | 2112513.36972 | 37.7796315288324 | -122.499020803345 | (37.7796315288324, -122.499020803345) | 11 | 6 | 2 | 55 | 26 | |||
161849 | 117833 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 822 39th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5983882.02568 | 2110188.1448 | 37.7732409879174 | -122.499211363837 | (37.7732409879174, -122.499211363837) | 11 | 6 | 2 | 55 | 26 | |||
19956 | 117834 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 822 39th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5983882.02948 | 2110196.57614 | 37.7732641381745 | -122.499211973818 | (37.7732641381745, -122.499211973818) | 11 | 6 | 2 | 55 | 26 | |||
146799 | 117950 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4045 Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5983004.75382 | 2110316.66923 | 37.7735423752614 | -122.50225542827 | (37.7735423752614, -122.50225542827) | 11 | 6 | 2 | 55 | 26 | |||
156813 | 117951 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4101 Cabrillo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5982854.39017 | 2110311.68646 | 37.7735198584795 | -122.502775180908 | (37.7735198584795, -122.502775180908) | 11 | 6 | 2 | 55 | 26 | |||
154776 | 118206 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5985063.76803 | 2111840.93131 | 37.7778483216089 | -122.495245527349 | (37.7778483216089, -122.495245527349) | 11 | 6 | 2 | 55 | 26 | |||
95673 | 118436 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5301 Anza St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 5982204.13343 | 2111649.99569 | 37.7771562281008 | -122.505123677977 | (37.7771562281008, -122.505123677977) | 11 | 6 | 2 | 55 | 26 | |||
130254 | 118618 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 498 47th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5981320.9946 | 2112426.20878 | 37.7792354783169 | -122.508236309028 | (37.7792354783169, -122.508236309028) | 11 | 6 | 2 | 55 | 26 | |||
160457 | 118619 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 498 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5981321.44116 | 2112409.25336 | 37.7791889500721 | -122.508233505359 | (37.7791889500721, -122.508233505359) | 11 | 6 | 2 | 55 | 26 | |||
68169 | 118620 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 498 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5981322.23843 | 2112396.05597 | 37.7791527609309 | -122.508229767482 | (37.7791527609309, -122.508229767482) | 11 | 6 | 2 | 55 | 26 | |||
176359 | 118684 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 684 48th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 2ft | 5981039.03921 | 2111092.68807 | 37.7755574057413 | -122.509112640728 | (37.7755574057413, -122.509112640728) | 11 | 6 | 2 | 55 | 26 | |||
20757 | 119005 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599 43rd Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5982538.33316 | 2111759.97199 | 37.7774778486886 | -122.503975742455 | (37.7774778486886, -122.503975742455) | 11 | 6 | 2 | 55 | 26 | |||
104929 | 119131 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 543 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 34 | Width 3ft | 5981597.43697 | 2112021.89729 | 37.778141644974 | -122.507249993863 | (37.778141644974, -122.507249993863) | 11 | 6 | 2 | 55 | 26 | |||
133750 | 119144 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 637 47th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 2ft | 5981304.90801 | 2111421.80977 | 37.7764767475665 | -122.508217386884 | (37.7764767475665, -122.508217386884) | 11 | 6 | 2 | 55 | 26 | |||
60024 | 119216 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 771 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5981035.7876 | 2110451.80706 | 37.7737975435869 | -122.509076288613 | (37.7737975435869, -122.509076288613) | 11 | 6 | 2 | 55 | 26 | |||
177151 | 119238 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4701 Cabrillo St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 3ft | 5980953.58736 | 2110230.22563 | 37.7731842998171 | -122.509344168 | (37.7731842998171, -122.509344168) | 11 | 6 | 2 | 55 | 26 | |||
49460 | 119593 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3145 Cabrillo St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 5985832.00278 | 2110410.03586 | 37.7739644387456 | -122.492482570938 | (37.7739644387456, -122.492482570938) | 11 | 6 | 2 | 55 | 26 | |||
175137 | 119670 | Undocumented 4 | Yucca gloriosa :: Spanish Dagger 126 | 699x Missouri St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
105896 | 119968 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 540 28th Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 5987220.74694 | 2112250.93523 | 37.7791001265755 | -122.487814013837 | (37.7791001265755, -122.487814013837) | 11 | 6 | 2 | 55 | 26 | |||
104511 | 119969 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 540 28th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 15 | Width 3ft | 5987222.62788 | 2112233.92491 | 37.7790535307721 | -122.487806256895 | (37.7790535307721, -122.487806256895) | 11 | 6 | 2 | 55 | 26 | |||
22901 | 119970 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 542 28th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 20 | Width 3ft | 5987221.67588 | 2112220.77085 | 37.7790173579212 | -122.487808583512 | (37.7790173579212, -122.487808583512) | 11 | 6 | 2 | 55 | 26 | |||
104903 | 119971 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 552 28th Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 20 | Width 3ft | 5987224.33596 | 2112187.66675 | 37.7789266186033 | -122.487796948534 | (37.7789266186033, -122.487796948534) | 11 | 6 | 2 | 55 | 26 | |||
152558 | 120084 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 401 26th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5987761.35278 | 2113240.07553 | 37.7818475445369 | -122.486016488538 | (37.7818475445369, -122.486016488538) | 11 | 6 | 2 | 55 | 26 | |||
22624 | 120087 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 401 26th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 5987764.76806 | 2113165.69787 | 37.7816435236065 | -122.485999212153 | (37.7816435236065, -122.485999212153) | 11 | 6 | 2 | 55 | 26 | |||
55086 | 120767 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4544 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5989217.26728 | 2109917.39654 | 37.772809131283 | -122.480736434763 | (37.772809131283, -122.480736434763) | 11 | 6 | 2 | 55 | 26 | |||
181126 | 121634 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 349 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5990532 | 2113054 | 37.7814977082044 | -122.476417841695 | (37.7814977082044, -122.476417841695) | 11 | 6 | 2 | 55 | 26 | |||
145566 | 122074 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 347 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5990561.10649 | 2113058.51415 | 37.7815117908068 | -122.476317478147 | (37.7815117908068, -122.476317478147) | 11 | 6 | 2 | 55 | 26 | |||
154627 | 137507 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1920 Beach St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 6ft | 6001011.39316 | 2121024.38101 | 37.8039844758743 | -122.440736171548 | (37.8039844758743, -122.440736171548) | 13 | 9 | 1 | 57 | 17 | |||
39249 | 137508 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 41 Retiro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001758.83711 | 2121302.73589 | 37.8047913017375 | -122.43816954959 | (37.8047913017375, -122.43816954959) | 13 | 9 | 1 | 57 | 17 | |||
157080 | 137509 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 85 Toledo Way | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6001461.48208 | 2119936.52079 | 37.8010231216701 | -122.439100597914 | (37.8010231216701, -122.439100597914) | 13 | 9 | 1 | 57 | 17 | |||
155221 | 137510 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 85 Toledo Way | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6001467.72221 | 2119937.03312 | 37.8010248834562 | -122.439079041178 | (37.8010248834562, -122.439079041178) | 13 | 9 | 1 | 57 | 17 | |||
118908 | 137511 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2700 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | Width 3ft | 5999352.14411 | 2119120.73554 | 37.7986629462994 | -122.446341064008 | (37.7986629462994, -122.446341064008) | 13 | 9 | 1 | 57 | 17 | |||
30414 | 137512 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3801 Webster St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 6ft | 6002485.01335 | 2121661.73834 | 37.8058183005296 | -122.435682245137 | (37.8058183005296, -122.435682245137) | 13 | 9 | 1 | 57 | 17 | |||
100739 | 137513 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3801 Webster St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 6002487.07577 | 2121653.72776 | 37.8057964227428 | -122.435674534362 | (37.8057964227428, -122.435674534362) | 13 | 9 | 1 | 57 | 17 | |||
109756 | 137514 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3633 Webster St | 1 | : | Tree | Private 2 | 6 | Width 3ft | 6002566.08313 | 2121090.50651 | 37.8042544532535 | -122.435360804076 | (37.8042544532535, -122.435360804076) | 13 | 9 | 1 | 57 | 17 | |||
73840 | 137515 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1695 North Point St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 3ft | 6002752.50077 | 2120921.11086 | 37.8037999223881 | -122.434703571417 | (37.8037999223881, -122.434703571417) | 13 | 9 | 1 | 57 | 17 | |||
103227 | 137516 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8 Kimball Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6007999.84688 | 2116492.3826 | 37.7919362386146 | -122.41623092104 | (37.7919362386146, -122.41623092104) | 5 | 1 | 10 | 28858 | 21 | |||
128514 | 138257 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2600 GEARY BLVD | 2 | unknown : Yard | Tree | Private 2 | 4 | Width 0ft | 5999359.7213 | 2113228.3471 | 37.7824844323354 | -122.445890830511 | (37.7824844323354, -122.445890830511) | 15 | 5 | 1 | 54 | 16 | |||
169978 | 141021 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 160 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998570.6909 | 2112701.5936 | 37.7809930194286 | -122.448582571297 | (37.7809930194286, -122.448582571297) | 15 | 6 | 2 | 54 | 16 | |||
91495 | 141022 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 170 Anza St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5998548.3551 | 2112697.1941 | 37.7809796623886 | -122.448659524594 | (37.7809796623886, -122.448659524594) | 15 | 6 | 2 | 54 | 16 | |||
140504 | 141108 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 241 COLLINS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998156.9703 | 2112901.0932 | 37.7815171285351 | -122.450028212116 | (37.7815171285351, -122.450028212116) | 15 | 6 | 2 | 54 | 16 | |||
105503 | 142406 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 10 MAYFAIR DR | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5997813.4721 | 2114548.5306 | 37.7860208967808 | -122.451335398225 | (37.7860208967808, -122.451335398225) | 11 | 6 | 1 | 54 | 31 | |||
99890 | 181289 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1705 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 4ft | 5998212.96577 | 2088739.68043 | 37.715179010179 | -122.448094282435 | (37.715179010179, -122.448094282435) | 9 | 7 | 6 | 28861 | 25 | |||
66178 | 181290 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1705 Cayuga Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 46 | Width 4ft | 5998217.57045 | 2088741.68567 | 37.7151847793339 | -122.448078511032 | (37.7151847793339, -122.448078511032) | 9 | 7 | 6 | 28861 | 25 | |||
177002 | 181291 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Foote Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 4ft | 5998263.62341 | 2088768.79624 | 37.7152618512359 | -122.447921283438 | (37.7152618512359, -122.447921283438) | 9 | 7 | 6 | 28861 | 25 | |||
68816 | 181292 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Foote Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 4ft | 5998258.97729 | 2088773.03687 | 37.7152732294609 | -122.447937647522 | (37.7152732294609, -122.447937647522) | 9 | 7 | 6 | 28861 | 25 | |||
108866 | 181293 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 184 Mount Vernon Ave | 1 | Side Yard : Yard | Tree | Private 2 | 25 | 5998992.13606 | 2089349.93081 | 37.7168991290824 | -122.44544499659 | (37.7168991290824, -122.44544499659) | 9 | 7 | 6 | 28861 | 25 | ||||
19978 | 181294 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 286 Foote Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5998287.94469 | 2088745.65468 | 37.7151996999876 | -122.447835553775 | (37.7151996999876, -122.447835553775) | 9 | 7 | 6 | 28861 | 25 | |||
85442 | 181295 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 286 Foote Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 5ft | 5998268.1836 | 2088765.30253 | 37.7152525189681 | -122.447905270113 | (37.7152525189681, -122.447905270113) | 9 | 7 | 6 | 28861 | 25 | |||
63025 | 181296 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 286 Foote Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 5ft | 5998263.46817 | 2088770.77578 | 37.7152672777256 | -122.447921962449 | (37.7152672777256, -122.447921962449) | 9 | 7 | 6 | 28861 | 25 | |||
168539 | 181297 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 271 Prague St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6004070.03607 | 2089576.37759 | 37.7178094785893 | -122.427909293206 | (37.7178094785893, -122.427909293206) | 9 | 7 | 6 | 28861 | 5 | |||
126034 | 181298 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 538 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6002983.65718 | 2090496.16604 | 37.7202734951152 | -122.43173005392 | (37.7202734951152, -122.43173005392) | 9 | 7 | 6 | 28861 | 5 | |||
145450 | 181299 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 57 Cross St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 51 | Width 2ft | 5999982.25069 | 2088153.56575 | 37.7136706537558 | -122.44193684201 | (37.7136706537558, -122.44193684201) | 9 | 7 | 6 | 28861 | 5 | |||
91673 | 181300 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 3 | Front Yard : Yard | Tree | Private 2 | 48 | Width 4ft | 6013063.40285 | 2087533.07945 | 37.7127036658128 | -122.396679845022 | (37.7127036658128, -122.396679845022) | 10 | 3 | 8 | 58 | 1 | |||
92728 | 181301 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 4 | Front Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6013065.73831 | 2087544.18077 | 37.7127342778318 | -122.396672550617 | (37.7127342778318, -122.396672550617) | 10 | 3 | 8 | 58 | 1 | |||
93876 | 181302 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 5 | Front Yard : Yard | Tree | Private 2 | 4 | Width 4ft | 6013064.24149 | 2087553.26 | 37.7127591242993 | -122.396678360222 | (37.7127591242993, -122.396678360222) | 10 | 3 | 8 | 58 | 1 | |||
180454 | 181303 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Nueva Ave | 6 | Front Yard : Yard | Tree | Private 2 | 15 | Width 4ft | 6013062.58437 | 2087561.0422 | 37.712780400456 | -122.396684633014 | (37.712780400456, -122.396684633014) | 10 | 3 | 8 | 58 | 1 | |||
157049 | 181304 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 700 Brussels St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6010994.40429 | 2091467.52457 | 37.7233914797163 | -122.404107722615 | (37.7233914797163, -122.404107722615) | 10 | 3 | 7 | 309 | 28 | |||
121168 | 181305 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 700 Brussels St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 6010997.70015 | 2091457.10077 | 37.7233630422655 | -122.404095596135 | (37.7233630422655, -122.404095596135) | 10 | 3 | 7 | 309 | 28 | |||
17148 | 181306 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 469 Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010294.74093 | 2089615.03342 | 37.7182658036088 | -122.406395873996 | (37.7182658036088, -122.406395873996) | 10 | 7 | 8 | 309 | 39 | |||
144286 | 181307 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 36 Ramsell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5992982.17561 | 2087469.81954 | 37.7113918706115 | -122.466081784562 | (37.7113918706115, -122.466081784562) | 9 | 8 | 4 | 64 | 24 | |||
163845 | 181308 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 36 Ramsell St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 6ft | 5992982.57261 | 2087488.714 | 37.7114437731934 | -122.466081784571 | (37.7114437731934, -122.466081784571) | 9 | 8 | 4 | 64 | 24 | |||
137633 | 181309 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3001 Ocean Ave | 2 | : | Tree | Private 2 | 4 | Width 3ft | 5989502.80382 | 2095226.84947 | 37.732489380377 | -122.478674182688 | (37.732489380377, -122.478674182688) | 1 | 8 | 4 | 64 | 35 | |||
144904 | 181310 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3001 Ocean Ave | 3 | : | Tree | Private 2 | 3 | Width 3ft | 5989516.32728 | 2095227.01255 | 37.7324906133438 | -122.478627441312 | (37.7324906133438, -122.478627441312) | 1 | 8 | 4 | 64 | 35 | |||
59495 | 181821 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2318 25th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5988590.0864 | 2099524.6468 | 37.7442369757948 | -122.482144374813 | (37.7442369757948, -122.482144374813) | 1 | 8 | 3 | 29491 | 35 | |||
165586 | 182104 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2434 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987687.8918 | 2098712.0823 | 37.7419533724178 | -122.485204320572 | (37.7419533724178, -122.485204320572) | 1 | 8 | 3 | 29491 | 35 | |||
179874 | 182636 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1634 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5988875.299 | 2102432.4985 | 37.7522377520489 | -122.481371089356 | (37.7522377520489, -122.481371089356) | 1 | 8 | 3 | 56 | 35 | |||
130067 | 182687 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1706 36th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985038.8153 | 2103544.8846 | 37.7550682542085 | -122.494720059194 | (37.7550682542085, -122.494720059194) | 1 | 8 | 3 | 56 | 35 | |||
172744 | 182688 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1706 36th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985037.7029 | 2103552.115 | 37.7550880417782 | -122.494724439177 | (37.7550880417782, -122.494724439177) | 1 | 8 | 3 | 56 | 35 | |||
118935 | 183106 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3634 Santiago St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5981552.8121 | 2099457.4563 | 37.7436406629553 | -122.50647234563 | (37.7436406629553, -122.50647234563) | 1 | 8 | 3 | 29491 | 35 | |||
75056 | 183314 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1298 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5981216.5568 | 2106353.9637 | 37.7625567133131 | -122.508146779871 | (37.7625567133131, -122.508146779871) | 1 | 8 | 3 | 56 | 35 | |||
173339 | 183491 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2526 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986467.9493 | 2098039.2717 | 37.7400348721869 | -122.48937297276 | (37.7400348721869, -122.48937297276) | 1 | 8 | 3 | 29491 | 35 | |||
59788 | 183492 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2526 32nd Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5986467.5023 | 2098045.3062 | 37.7400514152255 | -122.489374961874 | (37.7400514152255, -122.489374961874) | 1 | 8 | 3 | 29491 | 35 | |||
34464 | 183750 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2275 28th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 0ft | 5987604.2183 | 2099806.9382 | 37.7449546819052 | -122.485573963469 | (37.7449546819052, -122.485573963469) | 1 | 8 | 3 | 29491 | 35 | |||
105586 | 184417 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3719 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5981894.6182 | 2100773.2403 | 37.7472735583342 | -122.505387989325 | (37.7472735583342, -122.505387989325) | 1 | 8 | 3 | 29491 | 35 | |||
154400 | 184419 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3715 Quintara St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5981926.4298 | 2100773.5787 | 37.7472763594104 | -122.505278014143 | (37.7472763594104, -122.505278014143) | 1 | 8 | 3 | 29491 | 35 | |||
127689 | 184420 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3713 Quintara St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5981946.7351 | 2100775.6093 | 37.7472831296643 | -122.505207951598 | (37.7472831296643, -122.505207951598) | 1 | 8 | 3 | 29491 | 35 | |||
124585 | 184630 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1811 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5982223.7334 | 2102787.8653 | 37.7528245162985 | -122.504399179455 | (37.7528245162985, -122.504399179455) | 1 | 8 | 3 | 56 | 35 | |||
52886 | 185259 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2101 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986433.9654 | 2097526.8372 | 37.7386258792535 | -122.489452803287 | (37.7386258792535, -122.489452803287) | 1 | 8 | 3 | 29491 | 35 | |||
185776 | 185260 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2101 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5986447.7621 | 2097526.8372 | 37.738626684671 | -122.489405101522 | (37.738626684671, -122.489405101522) | 1 | 8 | 3 | 29491 | 35 | |||
19542 | 185509 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2211 40th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5983864.8947 | 2100088.8725 | 37.7455102176181 | -122.498524482427 | (37.7455102176181, -122.498524482427) | 1 | 8 | 3 | 29491 | 35 | |||
124807 | 186078 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1901 Sunset Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984848.2409 | 2102021.6754 | 37.7508747848324 | -122.495266786117 | (37.7508747848324, -122.495266786117) | 1 | 8 | 3 | 29491 | 35 | |||
97008 | 186195 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1701 Sunset Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5984791.7238 | 2103544.8431 | 37.7550536742495 | -122.49557455702 | (37.7550536742495, -122.49557455702) | 1 | 8 | 3 | 56 | 35 | |||
186119 | 199519 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 575 San Bruno Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6010977.45969 | 2105690.75221 | 37.7624444505698 | -122.405167364075 | (37.7624444505698, -122.405167364075) | 8 | 3 | 8 | 28856 | 29 | |||
72509 | 199520 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 900 Cesar Chavez St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6016073.01766 | 2101191.4647 | 37.7503739092406 | -122.387229690715 | (37.7503739092406, -122.387229690715) | 10 | 3 | 8 | 28856 | 1 | |||
181626 | 199521 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1112 Tennessee St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 58 | Width 6ft | 6015518.58105 | 2103812.19357 | 37.7575391569355 | -122.389329974622 | (37.7575391569355, -122.389329974622) | 10 | 3 | 8 | 28856 | 29 | |||
59861 | 199522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1150x Tennessee St | 3 | Median : Cutout | Tree | DPW 1 | 3 | Width 3ft | 6015555.37035 | 2103675.62885 | 37.7571662188511 | -122.389193205711 | (37.7571662188511, -122.389193205711) | 10 | 3 | 8 | 28856 | 29 | |||
174323 | 199523 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1150x Tennessee St | 4 | Median : Cutout | Tree | DPW 1 | 9 | Width 4ft | 6015556.62319 | 2103663.95863 | 37.7571342443646 | -122.389188058008 | (37.7571342443646, -122.389188058008) | 10 | 3 | 8 | 28856 | 29 | |||
64013 | 199524 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1350 Indiana St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 6015069.09228 | 2102280.3688 | 37.7533081623518 | -122.390777452343 | (37.7533081623518, -122.390777452343) | 10 | 3 | 8 | 28856 | 29 | ||||
16924 | 199525 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1301 Minnesota St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6015396.88376 | 2102219.87285 | 37.7531602346611 | -122.389639647178 | (37.7531602346611, -122.389639647178) | 10 | 3 | 8 | 28856 | 29 | ||||
24752 | 199526 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599 Indiana St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 8ft | 6014906.74898 | 2105806.13827 | 37.7629801596351 | -122.391585356499 | (37.7629801596351, -122.391585356499) | 14 | 3 | 8 | 28856 | 29 | |||
133552 | 199527 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 18th St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 2ft | 6014914.45801 | 2105734.69881 | 37.7627844302812 | -122.391553698568 | (37.7627844302812, -122.391553698568) | 10 | 3 | 8 | 28856 | 29 |
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) );