trees
390 rows where qSpecies_id = 126
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 1584 | 79997 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5981344.9471 | 2112403.21249 | 37.7791737487824 | -122.508151741605 | (37.7791737487824, -122.508151741605) | 11 | 6 | 2 | 55 | 26 | |||
| 3048 | 199537 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 16 | Front Yard : Yard | Tree | Private 2 | 4 | 6014323.98726 | 2106464.8847 | 37.7647565688948 | -122.393647053167 | (37.7647565688948, -122.393647053167) | 14 | 3 | 8 | 310 | 29 | ||||
| 3638 | 72610 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6014116.81236 | 2101967.79317 | 37.7523970151345 | -122.394048777632 | (37.7523970151345, -122.394048777632) | 10 | 3 | 8 | 28856 | 1 | |||
| 3852 | 243986 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 922 Treat Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 6008569.40583 | 2103127.50468 | 37.7552714408323 | -122.413314689443 | (37.7552714408323, -122.413314689443) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 5110 | 79998 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5981347.81694 | 2112377.495 | 37.7791033052806 | -122.508139904514 | (37.7791033052806, -122.508139904514) | 11 | 6 | 2 | 55 | 26 | |||
| 5902 | 98813 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | 3x3 | 6011920.40954 | 2099763.49202 | 37.7462221629395 | -122.401489439087 | (37.7462221629395, -122.401489439087) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 6788 | 89559 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5227 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982413.61439 | 2111658.5087 | 37.7771919254702 | -122.504399660112 | (37.7771919254702, -122.504399660112) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | ||||
| 6982 | 72625 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1501 25th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014103.8148 | 2101960.56144 | 37.7523764359486 | -122.394093219441 | (37.7523764359486, -122.394093219441) | 10 | 3 | 8 | 28856 | 1 | |||
| 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 | |||
| 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 | |||
| 8279 | 199563 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 16 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 6012717.44536 | 2104654.08234 | 37.7596951043532 | -122.399076586828 | (37.7596951043532, -122.399076586828) | 10 | 3 | 8 | 28856 | 29 | |||
| 8435 | 199530 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1091 19th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6014489.75504 | 2105264.07428 | 37.7614686151109 | -122.392989678445 | (37.7614686151109, -122.392989678445) | 10 | 3 | 8 | 28856 | 29 | ||||
| 8542 | 73713 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1265 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 27 | 6012277.51673 | 2102506.08306 | 37.7537726442006 | -122.400447210275 | (37.7537726442006, -122.400447210275) | 10 | 3 | 8 | 28856 | 29 | |||
| 9401 | 244003 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1301 Douglass St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 4ft | 6001394.33325 | 2099880.52449 | 37.7459505586756 | -122.437895622392 | (37.7459505586756, -122.437895622392) | 2 | 4 | 5 | 63 | 22 | |||
| 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 | |||
| 9874 | 199550 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 6 | : Yard | Tree | Private 2 | 15 | 6014401.0054 | 2105922.09622 | 37.7632704697749 | -122.393342678542 | (37.7632704697749, -122.393342678542) | 14 | 3 | 8 | 28856 | 29 | ||||
| 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 |
| 10986 | 199613 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1650 Davidson Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 4ft | 6014432.23191 | 2099824.22542 | 37.7465287570926 | -122.392808046859 | (37.7465287570926, -122.392808046859) | 10 | 3 | 8 | 58 | 1 | |||
| 12016 | 38374 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3805 Noriega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/03/1998 12:00:00 AM | 5 | Permit Number 40433 | 5982188.1991 | 2102815.1083 | 37.7528972278417 | -122.504524079724 | (37.7528972278417, -122.504524079724) | 1 | 8 | 3 | 56 | 35 | |
| 12929 | 79999 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 8250 Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5981389.70051 | 2112378.3 | 37.7791079835189 | -122.50799507452 | (37.7791079835189, -122.50799507452) | 11 | 6 | 2 | 55 | 26 | |||
| 13716 | 243963 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3450 26th St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6006727.57204 | 2100887.26512 | 37.7490166748846 | -122.419525382284 | (37.7490166748846, -122.419525382284) | 2 | 4 | 7 | 28859 | 19 | |||
| 13934 | 199608 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1800 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 7ft | 6016247.68812 | 2100671.01808 | 37.7489545425207 | -122.386589376117 | (37.7489545425207, -122.386589376117) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | ||||
| 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 | |||
| 17458 | 199543 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 38 | Front Yard : Yard | Tree | Private 2 | 5 | 6014244.47574 | 2106692.17431 | 37.7653762377352 | -122.393937976682 | (37.7653762377352, -122.393937976682) | 14 | 3 | 8 | 28856 | 20 | ||||
| 17619 | 61510 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1237 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1984 12:00:00 AM | 23 | Permit Number 21466 | 6012274.20726 | 2102601.29078 | 37.754033879279 | -122.400465342406 | (37.754033879279, -122.400465342406) | 10 | 3 | 8 | 28856 | 29 | |
| 17695 | 61786 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1453 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/24/1985 12:00:00 AM | 5 | Permit Number 21808 | 6012048.53726 | 2101599.7362 | 37.7512712410927 | -122.401175394927 | (37.7512712410927, -122.401175394927) | 10 | 3 | 8 | 28856 | 29 | |
| 17741 | 74618 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2650 Fulton St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 2 | 5995104.27879 | 2110288.95981 | 37.7741697532931 | -122.460399659179 | (37.7741697532931, -122.460399659179) | 11 | 6 | 2 | 54 | 11 | |||
| 17920 | 217539 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2 Castenada Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994385.93266 | 2101818.26452 | 37.7508700750964 | -122.462270052135 | (37.7508700750964, -122.462270052135) | 1 | 8 | 4 | 29491 | 40 | |||
| 18510 | 217540 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994380.23294 | 2101825.97168 | 37.7508909088044 | -122.462290321068 | (37.7508909088044, -122.462290321068) | 1 | 8 | 4 | 29491 | 40 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 21874 | 91012 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4301X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982213.29166 | 2110288.86252 | 37.7734194931658 | -122.504991105508 | (37.7734194931658, -122.504991105508) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 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 | |||
| 22872 | 199568 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 680 De Haro St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6012064.94705 | 2105270.66031 | 37.7613517077453 | -122.401376599377 | (37.7613517077453, -122.401376599377) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 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 | ||||
| 23566 | 243983 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 23 Juri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 1ft | 6005990.8298 | 2101226.6861 | 37.749907121539 | -122.422097155577 | (37.749907121539, -122.422097155577) | 2 | 4 | 5 | 28859 | 19 | |||
| 24332 | 45455 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 258 Parker Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Permit Number 44240 | 5997038.9938 | 2112669.4435 | 37.7808170441833 | -122.453879118533 | (37.7808170441833, -122.453879118533) | 11 | 6 | 2 | 54 | 16 | |||
| 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 | |||
| 24638 | 199569 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1236 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 6012213.10584 | 2102625.8594 | 37.7540979317002 | -122.400678372936 | (37.7540979317002, -122.400678372936) | 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 | |||
| 25333 | 199595 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1441 Rhode Island St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | 6012041.40362 | 2101659.26991 | 37.7514343097479 | -122.401204246987 | (37.7514343097479, -122.401204246987) | 10 | 3 | 8 | 28856 | 29 | ||||
| 25390 | 246783 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 175 Brewster St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6010050.00115 | 2098693.85293 | 37.7431806261 | -122.407881696082 | (37.7431806261, -122.407881696082) | 10 | 7 | 7 | 28859 | 2 | ||||
| 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 | |||
| 25867 | 217494 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1834 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5993466.4471 | 2102963.36193 | 37.7539612311319 | -122.465532871667 | (37.7539612311319, -122.465532871667) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 26204 | 84910 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5546 Anza St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/2007 12:00:00 AM | 18 | Permit No. 49266 | 5981366.54955 | 2111678.1896 | 37.7771843232036 | -122.50802318732 | (37.7771843232036, -122.50802318732) | 11 | 6 | 2 | 55 | 26 | ||
| 26871 | 199533 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 101 Pennsylvania Ave | 6 | Front Yard : Yard | Tree | Private 2 | 4 | 6014329.6983 | 2106362.34828 | 37.7644753436933 | -122.393620122984 | (37.7644753436933, -122.393620122984) | 14 | 3 | 8 | 310 | 29 | ||||
| 27493 | 98814 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6011900.23089 | 2099755.59596 | 37.7461993561215 | -122.401558659925 | (37.7461993561215, -122.401558659925) | 10 | 3 | 8 | 58 | 1 | |||
| 27526 | 254166 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 5301 Anza St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 3ft | 5982204.13343 | 2111649.99569 | 37.7771562281008 | -122.505123677977 | (37.7771562281008, -122.505123677977) | 11 | 6 | 2 | 55 | 26 | ||||
| 28259 | 90722 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4650X Cabrillo St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981131.94143 | 2110306.49344 | 37.7734042232339 | -122.508732892327 | (37.7734042232339, -122.508732892327) | 11 | 6 | 2 | 55 | 26 | ||
| 28529 | 199578 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1275 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 6012281.81813 | 2102445.37278 | 37.7536061868776 | -122.400428070902 | (37.7536061868776, -122.400428070902) | 10 | 3 | 8 | 28856 | 29 | |||
| 29794 | 199606 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1515 19th St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 14 | Width 3ft | 6013141.4962 | 2105177.84105 | 37.7611568525403 | -122.397646731323 | (37.7611568525403, -122.397646731323) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||||
| 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 | |||
| 31019 | 199561 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 601 Wisconsin St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | Width 3ft | 6012720.09988 | 2104604.72261 | 37.7595597213173 | -122.399063941474 | (37.7595597213173, -122.399063941474) | 10 | 3 | 8 | 28856 | 29 | |||
| 31444 | 199600 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1500 22nd St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 13 | Width 3ft | 6013491.56821 | 2103854.04221 | 37.7575414771611 | -122.396343185582 | (37.7575414771611, -122.396343185582) | 10 | 3 | 8 | 28856 | 29 | |||
| 32056 | 199570 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1399 De Haro St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | 6012307.76781 | 2101930.26834 | 37.752193269208 | -122.40030215414 | (37.752193269208, -122.40030215414) | 10 | 3 | 8 | 28856 | 29 | ||||
| 32789 | 32956 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1218 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/01/1996 12:00:00 AM | 12 | 3x8 | Permit Number 37270 | 6013588.68321 | 2106187.45016 | 37.7639539086769 | -122.396170851203 | (37.7639539086769, -122.396170851203) | 14 | 3 | 8 | 28856 | 29 |
| 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 | ||||
| 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 | ||||
| 34358 | 55063 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 599X 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1972 12:00:00 AM | 4 | Permit Number 10952 | 5982538.31905 | 2111794.35525 | 37.7775722542249 | -122.503978338592 | (37.7775722542249, -122.503978338592) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 34780 | 90721 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4650X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981150.16516 | 2110306.92668 | 37.7734064869384 | -122.508669887159 | (37.7734064869384, -122.508669887159) | 11 | 6 | 2 | 55 | 26 | ||
| 35282 | 199555 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 15 | : Yard | Tree | Private 2 | 8 | 6014446.64039 | 2105914.65899 | 37.7632525840546 | -122.393184320496 | (37.7632525840546, -122.393184320496) | 14 | 3 | 8 | 28856 | 29 | ||||
| 35549 | 243970 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6006476.24786 | 2097234.87805 | 37.7389738835382 | -122.420135291714 | (37.7389738835382, -122.420135291714) | 2 | 7 | 7 | 28859 | 2 | |||
| 36481 | 199579 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2212 25th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6012144.74308 | 2101906.79924 | 37.7521197361546 | -122.400864273582 | (37.7521197361546, -122.400864273582) | 10 | 3 | 8 | 28856 | 29 | |||
| 38078 | 38815 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 204 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/30/1998 12:00:00 AM | 8 | Permit Number 40651 | 5994944.16478 | 2114141.25002 | 37.7847379015342 | -122.461232820546 | (37.7847379015342, -122.461232820546) | 11 | 6 | 2 | 54 | 11 | |
| 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 | |||
| 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 | |||
| 39390 | 244005 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 889 Duncan St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 54 | Width 4ft | 6000841.56286 | 2099632.44298 | 37.7452379367907 | -122.439789239379 | (37.7452379367907, -122.439789239379) | 2 | 4 | 5 | 63 | 22 | |||
| 39638 | 244008 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 784 Duncan St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 6001407.7232 | 2099722.39928 | 37.7455171457036 | -122.437837998345 | (37.7455171457036, -122.437837998345) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 40524 | 244015 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 74 Newburg St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6002317.38718 | 2099770.68382 | 37.7457014087109 | -122.43469597844 | (37.7457014087109, -122.43469597844) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||||
| 42837 | 199592 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1453 Rhode Island St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 6012056.44689 | 2101608.80688 | 37.7512965884693 | -122.401148679688 | (37.7512965884693, -122.401148679688) | 10 | 3 | 8 | 28856 | 29 | ||||
| 43505 | 243999 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 240 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | Width 5ft | 6004722.77399 | 2100192.7659 | 37.7469966132138 | -122.426408548623 | (37.7469966132138, -122.426408548623) | 2 | 7 | 5 | 63 | 22 | |||
| 43895 | 217495 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1834 09th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5993465.96971 | 2102985.66158 | 37.7540224326934 | -122.465536142479 | (37.7540224326934, -122.465536142479) | 1 | 8 | 4 | 56 | 12 | |||
| 44320 | 199612 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1570 Michigan St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | 6016520.08797 | 2100945.2789 | 37.7497226822544 | -122.385666519716 | (37.7497226822544, -122.385666519716) | 10 | 3 | 8 | 58 | 1 | ||||
| 45058 | 243960 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1485 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6009591.25577 | 2100642.20365 | 37.7485046755637 | -122.409605408672 | (37.7485046755637, -122.409605408672) | 2 | 4 | 7 | 28859 | 19 | |||
| 45739 | 199558 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 265 Arkansas St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 2ft | 6012944.07027 | 2105820.99329 | 37.7629118111405 | -122.398374675861 | (37.7629118111405, -122.398374675861) | 14 | 3 | 8 | 28856 | 29 | |||
| 45886 | 243993 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 479 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6003506.23365 | 2098907.96472 | 37.7434000031111 | -122.430523577396 | (37.7434000031111, -122.430523577396) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | ||||
| 46797 | 47839 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4400 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 8 | Permit Number 45601 | 5981941.89951 | 2110334.18546 | 37.7735279659603 | -122.505933234325 | (37.7735279659603, -122.505933234325) | 11 | 6 | 2 | 55 | 26 | |
| 47998 | 199553 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 9 | : Yard | Tree | Private 2 | 20 | 6014424.93308 | 2105923.01259 | 37.7632743152759 | -122.393259984074 | (37.7632743152759, -122.393259984074) | 14 | 3 | 8 | 28856 | 29 | ||||
| 48352 | 30689 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 529 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1995 12:00:00 AM | 12 | Permit Number 34609 | 6004554.59281 | 2110367.64108 | 37.7749248947896 | -122.427714942511 | (37.7749248947896, -122.427714942511) | 7 | 9 | 11 | 28852 | 10 | |
| 49145 | 217541 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 82 Ventura Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 5994344.60971 | 2101818.25531 | 37.7508676703211 | -122.462412949005 | (37.7508676703211, -122.462412949005) | 1 | 8 | 4 | 29491 | 40 | |||
| 49371 | 244000 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 308 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6008619.26951 | 2097248.33163 | 37.7391313386509 | -122.412726634432 | (37.7391313386509, -122.412726634432) | 10 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );