trees
390 rows where qSpecies_id = 126 sorted by YCoord
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
18569 | 74063 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010946.7362 | 2088147.19919 | 37.7142718811123 | -122.404038948741 | (37.7142718811123, -122.404038948741) | 9 | 7 | 8 | 309 | 39 | |||
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 | |||
7873 | 74275 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 130 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010944.70013 | 2088154.7138 | 37.714292400951 | -122.404046514754 | (37.714292400951, -122.404046514754) | 9 | 7 | 8 | 309 | 39 | |||
57203 | 217536 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 374 Head St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 8ft | 5993512.18478 | 2088326.64249 | 37.7137750659299 | -122.464312118436 | (37.7137750659299, -122.464312118436) | 9 | 8 | 6 | 64 | 24 | |||
187151 | 217535 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 385 Head St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 28 | Width 4ft | 5993463.79196 | 2088414.8734 | 37.7140145374208 | -122.464485782892 | (37.7140145374208, -122.464485782892) | 9 | 8 | 6 | 64 | 24 | |||
77896 | 217537 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 89 Ralston St | 1 | Back Yard : Yard | Tree | Private 2 | 18 | 5992163.63598 | 2088434.33055 | 37.7139929276052 | -122.468980989298 | (37.7139929276052, -122.468980989298) | 9 | 8 | 6 | 64 | 24 | ||||
98748 | 217526 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2 Lobos St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5996904.36667 | 2088697.84896 | 37.7149892577353 | -122.452614326309 | (37.7149892577353, -122.452614326309) | 9 | 8 | 6 | 28861 | 24 | ||||
41511 | 217525 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2 Lobos St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 5996931.31529 | 2088711.97504 | 37.7150295887309 | -122.452522199764 | (37.7150295887309, -122.452522199764) | 9 | 8 | 6 | 28861 | 24 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
40142 | 217534 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 167 Vernon St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 10ft | 5992432.86148 | 2088983.12454 | 37.7155153350498 | -122.468090348403 | (37.7155153350498, -122.468090348403) | 9 | 8 | 6 | 64 | 24 | |||
189321 | 217533 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 167 Vernon St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 10ft | 5992432.25049 | 2088990.35814 | 37.7155351614814 | -122.468092986116 | (37.7155351614814, -122.468092986116) | 9 | 8 | 6 | 64 | 24 | |||
22048 | 217531 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 38 | Median : Cutout | Tree | DPW 1 | 4 | Width 0ft | 5996362.99834 | 2088995.98421 | 37.7157768335986 | -122.454507038583 | (37.7157768335986, -122.454507038583) | 9 | 8 | 6 | 28861 | 24 | |||
114317 | 217530 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 28 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 5996285.62534 | 2089001.27472 | 37.7157869222129 | -122.454774855787 | (37.7157869222129, -122.454774855787) | 9 | 8 | 6 | 28861 | 24 | |||
175215 | 217529 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 24 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 5996247.03619 | 2089001.79824 | 37.7157861460877 | -122.454908274716 | (37.7157861460877, -122.454908274716) | 9 | 8 | 6 | 28861 | 24 | |||
4125 | 217527 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 22 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 5996233.42463 | 2089002.36528 | 37.7157869222112 | -122.454955363219 | (37.7157869222112, -122.454955363219) | 9 | 8 | 6 | 28861 | 24 | |||
107922 | 217528 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1x Minerva St | 23 | Median : Cutout | Tree | DPW 1 | 21 | Width 0ft | 5996239.67179 | 2089002.51742 | 37.7157876983267 | -122.454933781265 | (37.7157876983267, -122.454933781265) | 9 | 8 | 6 | 28861 | 24 | |||
61447 | 217523 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 208 Minerva St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 3ft | 5994934.27382 | 2089035.01778 | 37.7158019651696 | -122.459448160326 | (37.7158019651696, -122.459448160326) | 9 | 8 | 6 | 28861 | 24 | |||
89912 | 217524 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 260 Minerva St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5994388.54564 | 2089047.19404 | 37.7158040048294 | -122.461335317482 | (37.7158040048294, -122.461335317482) | 9 | 8 | 6 | 28861 | 24 | |||
10920 | 32743 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 31 Montana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/29/1996 12:00:00 AM | 12 | 3x3 | Permit Number 37126 | 5996349.19889 | 2089288.18101 | 37.7165783462864 | -122.454575832225 | (37.7165783462864, -122.454575832225) | 9 | 8 | 6 | 28861 | 24 |
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 | ||||
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 | |||
90258 | 217532 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 10 Caine Ave | 12 | : | Tree | Private 2 | 4 | Width 0ft | 5997565.18295 | 2089591.75195 | 37.7174815498251 | -122.450394677186 | (37.7174815498251, -122.450394677186) | 9 | 8 | 6 | 28861 | 24 | |||
82713 | 26914 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 10 Caine Ave | 10 | Median : Cutout | Tree | DPW 1 | 12 | 10 | 5997577.15723 | 2089606.82913 | 37.7175236335794 | -122.450354374056 | (37.7175236335794, -122.450354374056) | 9 | 8 | 6 | 28861 | 24 | |||
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 | |||
193936 | 200175 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1022 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 6013884.9652 | 2089743.6718 | 37.7188192082582 | -122.393994895467 | (37.7188192082582, -122.393994895467) | 10 | 3 | 8 | 58 | 1 | |||
73061 | 200489 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1086 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 6013557.4449 | 2089988.7054 | 37.7194738134712 | -122.395144165456 | (37.7194738134712, -122.395144165456) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | ||||
131503 | 202074 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 3 | Front Yard : Yard | Tree | Private 2 | 18 | 6012682.24985 | 2090663.29707 | 37.7212773966172 | -122.398216717151 | (37.7212773966172, -122.398216717151) | 10 | 3 | 8 | 58 | 1 | ||||
114215 | 202075 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 4 | Front Yard : Yard | Tree | Private 2 | 18 | 6012687.55592 | 2090674.96794 | 37.7213097380253 | -122.398199193847 | (37.7213097380253, -122.398199193847) | 10 | 3 | 8 | 58 | 1 | ||||
46515 | 202076 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 5 | Front Yard : Yard | Tree | Private 2 | 18 | 6012694.00092 | 2090696.52405 | 37.7213692857431 | -122.398178426718 | (37.7213692857431, -122.398178426718) | 10 | 3 | 8 | 58 | 1 | ||||
33914 | 202077 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 6 | Front Yard : Yard | Tree | Private 2 | 9 | 6012700.16365 | 2090713.41208 | 37.721416000129 | -122.398158307957 | (37.721416000129, -122.398158307957) | 10 | 3 | 8 | 58 | 1 | ||||
157827 | 202079 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Gould St | 8 | Front Yard : Yard | Tree | Private 2 | 10 | 6012746.01501 | 2090845.03433 | 37.721779962063 | -122.398009040306 | (37.721779962063, -122.398009040306) | 10 | 3 | 8 | 58 | 1 | ||||
122473 | 217522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 143 Miramar Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 5995315.51814 | 2090865.8028 | 37.7208507807174 | -122.458262844852 | (37.7208507807174, -122.458262844852) | 9 | 8 | 6 | 28861 | 24 | |||
71483 | 256066 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2600X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 6015071.7012 | 2091079.6967 | 37.7225535544976 | -122.389986064473 | (37.7225535544976, -122.389986064473) | 10 | 3 | 8 | 58 | 1 | ||||
140704 | 29538 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2600X Ingalls St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6015154.8066584 | 2091194.1931941 | 37.7228725479476 | -122.389706778167 | (37.7228725479476, -122.389706778167) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
174708 | 217520 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 278 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995672.48262 | 2091833.70797 | 37.7235289240095 | -122.457098912596 | (37.7235289240095, -122.457098912596) | 9 | 8 | 4 | 28861 | 24 | |||
39212 | 217521 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Miramar Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5995382.79118 | 2092045.04247 | 37.7240925570105 | -122.458115605177 | (37.7240925570105, -122.458115605177) | 9 | 8 | 4 | 28861 | 24 | |||
7251 | 78261 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 414 Holyoke St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 50 | 6009735.35322 | 2092462.55281 | 37.7260531896995 | -122.408530204426 | (37.7260531896995, -122.408530204426) | 10 | 3 | 7 | 309 | 28 | |||
57688 | 199617 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1670 Armstrong Ave | 2 | Front Yard : Yard | Tree | Private 2 | 24 | 6013996.30242 | 2092813.56299 | 37.7272547028171 | -122.39382481138 | (37.7272547028171, -122.39382481138) | 10 | 3 | 8 | 58 | 1 | ||||
97857 | 199618 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 4 | Side Yard : Yard | Tree | Private 2 | 9 | 6013981.31336 | 2092866.65416 | 37.7273996474538 | -122.393880343621 | (37.7273996474538, -122.393880343621) | 10 | 3 | 8 | 58 | 1 | ||||
186956 | 199619 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 5 | Side Yard : Yard | Tree | Private 2 | 22 | 6013984.3244 | 2092869.9258 | 37.7274087980523 | -122.393870163286 | (37.7274087980523, -122.393870163286) | 10 | 3 | 8 | 58 | 1 | ||||
89610 | 199620 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2399 Lane St | 6 | Side Yard : Yard | Tree | Private 2 | 7 | 6013988.45481 | 2092875.57425 | 37.7274245370974 | -122.393856279557 | (37.7274245370974, -122.393856279557) | 10 | 3 | 8 | 58 | 1 | ||||
122630 | 199621 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2330 Lane St | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6013971.3633 | 2092946.01515 | 37.7276170037228 | -122.393920294208 | (37.7276170037228, -122.393920294208) | 10 | 3 | 8 | 58 | 1 | ||||
122681 | 217519 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 125 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 94 | Width 10ft | 5998618.10798 | 2093180.61105 | 37.7273959305753 | -122.447013334218 | (37.7273959305753, -122.447013334218) | 9 | 7 | 4 | 28861 | 40 | |||
30312 | 217517 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 5998604.94971 | 2093225.36447 | 37.7275180612089 | -122.447062041474 | (37.7275180612089, -122.447062041474) | 9 | 7 | 4 | 28861 | 40 | ||||
172208 | 217518 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998600.75769 | 2093225.60072 | 37.7275184703858 | -122.447076550251 | (37.7275184703858, -122.447076550251) | 9 | 7 | 4 | 28861 | 40 | ||||
131609 | 217516 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 124 Marston Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5998607.55261 | 2093227.99671 | 37.7275254374392 | -122.447053232615 | (37.7275254374392, -122.447053232615) | 9 | 7 | 4 | 28861 | 40 | ||||
163671 | 46635 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1571 Underwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2002 12:00:00 AM | 3 | Permit Number 44756 | 6014716.9997 | 2093587.5042 | 37.7294198145801 | -122.391387425418 | (37.7294198145801, -122.391387425418) | 10 | 3 | 8 | 58 | 1 | |
111623 | 217511 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 212 Staples Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 5998689.47199 | 2093806.9285 | 37.7291197285738 | -122.446811677417 | (37.7291197285738, -122.446811677417) | 9 | 7 | 4 | 28861 | 40 | |||
25876 | 217510 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 212 Staples Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 5998646.23648 | 2093807.30599 | 37.7291182950515 | -122.446961172636 | (37.7291182950515, -122.446961172636) | 9 | 7 | 4 | 28861 | 40 | |||
6509 | 217512 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 180 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998882.8177 | 2093813.39274 | 37.7291485212785 | -122.446143732968 | (37.7291485212785, -122.446143732968) | 9 | 7 | 4 | 28861 | 40 | ||||
6916 | 217513 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 180 Staples Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998878.5265 | 2093813.54586 | 37.7291486966488 | -122.446158578953 | (37.7291486966488, -122.446158578953) | 9 | 7 | 4 | 28861 | 40 | ||||
121475 | 217515 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 181 Staples Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 5998870.21413 | 2093813.74069 | 37.7291487568991 | -122.4461873294 | (37.7291487568991, -122.4461873294) | 9 | 7 | 4 | 28861 | 40 | ||||
50655 | 217514 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 181 Staples Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 5998875.02726 | 2093813.80402 | 37.7291492056601 | -122.44617069463 | (37.7291492056601, -122.44617069463) | 9 | 7 | 4 | 28861 | 40 | ||||
116287 | 217509 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 100 Gennessee St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 1ft | 5997469.91402 | 2093889.34783 | 37.7292762870588 | -122.45103370846 | (37.7292762870588, -122.45103370846) | 9 | 7 | 4 | 28861 | 40 | |||
130695 | 217508 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 419 Flood Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5997977.40544 | 2094065.27654 | 37.7297883871148 | -122.449291943769 | (37.7297883871148, -122.449291943769) | 9 | 7 | 4 | 28861 | 40 | |||
24377 | 217507 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 419 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5997977.15972 | 2094069.19041 | 37.7297991196211 | -122.449293075119 | (37.7297991196211, -122.449293075119) | 9 | 7 | 4 | 28861 | 40 | |||
22966 | 217506 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 427 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 5997927.13531 | 2094070.23257 | 37.7297991196196 | -122.449466089413 | (37.7297991196196, -122.449466089413) | 9 | 7 | 4 | 28861 | 40 | ||||
158481 | 217505 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 427 Flood Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 8ft | 5997901.29894 | 2094070.44496 | 37.7297982247853 | -122.449555423544 | (37.7297982247853, -122.449555423544) | 9 | 7 | 4 | 28861 | 40 | |||
137217 | 201522 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 863 Innes Ave | 2 | : | Tree | Private 2 | 4 | Width 2ft | 6019436.46936 | 2094253.96379 | 37.7315105906351 | -122.375117750879 | (37.7315105906351, -122.375117750879) | 10 | 3 | 8 | 58 | 1 | |||
638 | 217502 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 426 Hearst Ave | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 12 | Width 10ft | 5998544.81231 | 2094412.25403 | 37.7307735449502 | -122.447355326608 | (37.7307735449502, -122.447355326608) | 9 | 7 | 4 | 59 | 40 | |||
133019 | 217503 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 426 Hearst Ave | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 13 | Width 10ft | 5998540.33136 | 2094412.34729 | 37.7307735449633 | -122.447370824607 | (37.7307735449633, -122.447370824607) | 9 | 7 | 4 | 59 | 40 | |||
143971 | 217501 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 502 Edna St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 4ft | 5998794.71399 | 2094416.16661 | 37.7307985649892 | -122.446491661765 | (37.7307985649892, -122.446491661765) | 9 | 7 | 4 | 59 | 40 | |||
72072 | 47490 | Permitted Site 7 | Yucca gloriosa :: Spanish Dagger 126 | 99X LYELL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2002 12:00:00 AM | 2 | 3x3 | Permit Number 45384 | 6003192 | 2094433 | 37.7310949685834 | -122.431290753374 | (37.7310949685834, -122.431290753374) | 9 | 7 | 5 | 28861 | 25 | |
50868 | 217504 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 303 Gennessee St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 2ft | 5997422.28998 | 2094446.058 | 37.7308021541797 | -122.451238481395 | (37.7308021541797, -122.451238481395) | 9 | 7 | 4 | 59 | 40 | |||
95458 | 217499 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 414 Detroit St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 5999453.36521 | 2094474.27973 | 37.7309957287723 | -122.444218781791 | (37.7309957287723, -122.444218781791) | 9 | 7 | 4 | 63 | 40 | ||||
143596 | 217500 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 433 Detroit St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 27 | Width 10ft | 5999422.35392 | 2094544.1981 | 37.7311859389748 | -122.444331015365 | (37.7311859389748, -122.444331015365) | 9 | 7 | 4 | 59 | 40 | |||
163809 | 253980 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 433 Detroit St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | Width 10ft | 5999422.35392 | 2094544.1981 | 37.7311859389748 | -122.444331015365 | (37.7311859389748, -122.444331015365) | 9 | 7 | 4 | 59 | 40 | ||||
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 | |||
138430 | 199622 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1799 Revere Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6014049.74697 | 2095137.71082 | 37.7336393102124 | -122.393802664676 | (37.7336393102124, -122.393802664676) | 10 | 3 | 8 | 58 | 1 | ||||
9749 | 73730 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1799 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 19 | 6014041.4845 | 2095157.58141 | 37.7336934116182 | -122.393832621075 | (37.7336934116182, -122.393832621075) | 10 | 3 | 8 | 58 | 1 | |||
70836 | 244001 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 431 Bosworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 2ft | 6003347.56603 | 2095197.54654 | 37.7332030553792 | -122.430807475403 | (37.7332030553792, -122.430807475403) | 9 | 7 | 5 | 28861 | 25 | |||
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 | |||
86416 | 199615 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 56 | Median : Yard | Tree | DPW 1 | 20 | 6014226.56708 | 2095397.27479 | 37.7343618444247 | -122.393209497917 | (37.7343618444247, -122.393209497917) | 10 | 3 | 8 | 58 | 1 | ||||
77316 | 199614 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1700x Quesada Ave | 53 | Median : Yard | Tree | DPW 1 | 16 | 6014257.65945 | 2095401.98638 | 37.7343765087595 | -122.393102330216 | (37.7343765087595, -122.393102330216) | 10 | 3 | 8 | 58 | 1 | ||||
98470 | 217498 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Malta Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5999813.4338 | 2095843.99657 | 37.7347771864063 | -122.443072299949 | (37.7347771864063, -122.443072299949) | 9 | 7 | 4 | 63 | 40 | |||
142381 | 217497 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 Malta Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 6ft | 5999813.58139 | 2095851.10387 | 37.7347967097977 | -122.44307229994 | (37.7347967097977, -122.44307229994) | 9 | 7 | 4 | 63 | 40 | |||
64145 | 199616 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1999 Revere Ave | 7 | Side Yard : Yard | Tree | Private 2 | 3 | 6013002.21254 | 2095907.198 | 37.7356938932469 | -122.397478268519 | (37.7356938932469, -122.397478268519) | 10 | 3 | 8 | 58 | 1 | ||||
57391 | 243968 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1200 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6004061.61432 | 2095990.9181 | 37.7354219049951 | -122.428395344371 | (37.7354219049951, -122.428395344371) | 2 | 7 | 5 | 63 | 7 | ||||
98598 | 243976 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 70 | Front Yard : Yard | Tree | Private 2 | 18 | 6004556.64322 | 2096143.57753 | 37.7358690730924 | -122.426694711107 | (37.7358690730924, -122.426694711107) | 2 | 7 | 5 | 28861 | 2 | ||||
60644 | 243977 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 74 | Front Yard : Yard | Tree | Private 2 | 21 | 6004578.54944 | 2096162.87225 | 37.7359232905307 | -122.426620346145 | (37.7359232905307, -122.426620346145) | 2 | 7 | 5 | 28861 | 2 | ||||
33081 | 243978 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 76 | Front Yard : Yard | Tree | Private 2 | 4 | 6004588.46206 | 2096170.32088 | 37.7359443031923 | -122.426586604496 | (37.7359443031923, -122.426586604496) | 2 | 7 | 5 | 28861 | 2 | ||||
178235 | 243979 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 78 | Front Yard : Yard | Tree | Private 2 | 13 | 6004594.17707 | 2096179.38026 | 37.735969501297 | -122.426567490311 | (37.735969501297, -122.426567490311) | 2 | 7 | 5 | 28861 | 2 | ||||
91156 | 243980 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1201 San Jose Ave | 79 | Front Yard : Yard | Tree | Private 2 | 6 | 6004603.12758 | 2096184.79771 | 37.7359848823907 | -122.426536930441 | (37.7359848823907, -122.426536930441) | 2 | 7 | 5 | 28861 | 2 |
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) );