trees
390 rows where qSpecies_id = 126 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | ||||
| 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 | |
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 |
| 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 | ||
| 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 | ||
| 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 | |
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | |
| 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 | |||
| 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 | |||
| 51671 | 243965 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 60 Ramona Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 73 | Width 5ft | 6005189.67155 | 2107490.26222 | 37.7670602101766 | -122.425313267905 | (37.7670602101766, -122.425313267905) | 8 | 4 | 5 | 28853 | 19 | |||
| 51997 | 89512 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4700X Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5984063.36258 | 2111770.60585 | 37.7775966059221 | -122.498701028226 | (37.7775966059221, -122.498701028226) | 11 | 6 | 2 | 55 | 26 | ||
| 54833 | 90695 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4100X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982874.37736 | 2110367.17949 | 37.7736734008467 | -122.50271015187 | (37.7736734008467, -122.50271015187) | 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 | |||
| 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 | |||
| 58467 | 90738 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4451X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981732.83736 | 2110270.97597 | 37.7733421032725 | -122.506651709597 | (37.7733421032725, -122.506651709597) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 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 | |||
| 60244 | 199531 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1098 19th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 18 | 6014488.94971 | 2105281.88683 | 37.7615174797697 | -122.392993710091 | (37.7615174797697, -122.392993710091) | 10 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 71941 | 199560 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1224 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6013565.3857 | 2106186.89187 | 37.763951079408 | -122.39625139179 | (37.763951079408, -122.39625139179) | 14 | 3 | 8 | 28856 | 29 | |||
| 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 | |
| 73821 | 65394 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 290 Napoleon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1989 12:00:00 AM | 53 | Permit Number 28237 | 6011952.10102 | 2099776.9681 | 37.7462609336071 | -122.401380800085 | (37.7462609336071, -122.401380800085) | 10 | 3 | 8 | 58 | 1 | ||
| 74346 | 90730 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4575X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981423.24219 | 2110260.00092 | 37.773293734399 | -122.507721808797 | (37.773293734399, -122.507721808797) | 11 | 6 | 2 | 55 | 26 | ||
| 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 | |||
| 76379 | 217491 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1213 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 3ft | 5991098.23401 | 2105172.09937 | 37.7598889667237 | -122.473883760333 | (37.7598889667237, -122.473883760333) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | ||||
| 78576 | 244002 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1351 Douglass St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 36 | Width 6ft | 6001401.78652 | 2099724.90862 | 37.7455236981732 | -122.437858706115 | (37.7455236981732, -122.437858706115) | 2 | 4 | 5 | 63 | 22 | |||
| 81156 | 199597 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1400 De Haro St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 65 | 6012249.42802 | 2101848.61895 | 37.7519658243772 | -122.400498168571 | (37.7519658243772, -122.400498168571) | 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 | ||||
| 88119 | 90745 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4345 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982053.54954 | 2110284.79915 | 37.7733989368092 | -122.505543365519 | (37.7733989368092, -122.505543365519) | 11 | 6 | 2 | 55 | 26 | ||
| 88169 | 90729 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4601X Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981296.19925 | 2110254.1964 | 37.7732703114755 | -122.508160828969 | (37.7732703114755, -122.508160828969) | 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 | |||
| 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 | |||
| 96330 | 90693 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4046 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5982986.41354 | 2110371.00337 | 37.7736904834902 | -122.50232289085 | (37.7736904834902, -122.50232289085) | 11 | 6 | 2 | 55 | 26 | ||
| 98780 | 243987 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3098 25th St | 1 | : | Tree | Private 2 | 21 | Width 3ft | 6009038.63911 | 2101607.11758 | 37.7511231326358 | -122.411584519713 | (37.7511231326358, -122.411584519713) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 106455 | 243990 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3250 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008996.81508 | 2099767.79019 | 37.7460704023351 | -122.411599210152 | (37.7460704023351, -122.411599210152) | 2 | 7 | 7 | 28859 | 2 | |||
| 108656 | 4447 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1361 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6004544.06336 | 2100936.24099 | 37.7490279200058 | -122.42707946086 | (37.7490279200058, -122.42707946086) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | ||||
| 109382 | 246640 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3350 Harrison St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6009029.3215 | 2099227.55373 | 37.744588855582 | -122.411448646563 | (37.744588855582, -122.411448646563) | 2 | 7 | 7 | 28859 | 2 | ||||
| 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 | |||
| 113310 | 217490 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1219 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 5991058.25824 | 2105170.14194 | 37.759881276613 | -122.474021872835 | (37.759881276613, -122.474021872835) | 1 | 8 | 4 | 56 | 12 | |||
| 114250 | 91013 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4243 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5982353.14616 | 2110293.57319 | 37.773440654471 | -122.504507686123 | (37.773440654471, -122.504507686123) | 11 | 6 | 2 | 55 | 26 | ||
| 114943 | 244010 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1527 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 44 | Width 1ft | 6002055.26477 | 2099571.9631 | 37.7451408837581 | -122.435588143684 | (37.7451408837581, -122.435588143684) | 2 | 7 | 5 | 63 | 22 | |||
| 117010 | 57583 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 2001 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1976 12:00:00 AM | 31 | Permit Number 16451 | 6011409.07768 | 2106483.20737 | 37.764644474674 | -122.403730310432 | (37.764644474674, -122.403730310432) | 8 | 3 | 8 | 28856 | 29 | ||
| 117235 | 90718 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 4606 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5981306.68716 | 2110312.4984 | 37.7734310096789 | -122.508128878588 | (37.7734310096789, -122.508128878588) | 11 | 6 | 2 | 55 | 26 | ||
| 117853 | 243998 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 3717 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 56 | Width 4ft | 6004940.55097 | 2102498.12305 | 37.7533388984784 | -122.42581956194 | (37.7533388984784, -122.42581956194) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 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 | |||
| 119513 | 244011 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1327 Diamond St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 70 | Width 10ft | 6002019.91281 | 2100146.50257 | 37.746716425824 | -122.435751483069 | (37.746716425824, -122.435751483069) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 124731 | 243969 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 336 Elsie St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6006478.44335 | 2097240.82056 | 37.7389903240494 | -122.420128122327 | (37.7389903240494, -122.420128122327) | 2 | 7 | 7 | 28859 | 2 | |||
| 125405 | 199545 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1 01st St | 1 | : Yard | Tree | Private 2 | 12 | 6014356.43896 | 2105915.99545 | 37.7632512422621 | -122.393496393361 | (37.7632512422621, -122.393496393361) | 14 | 3 | 8 | 28856 | 29 | ||||
| 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 | |||
| 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 | |||
| 130546 | 217492 | DPW Maintained 1 | Yucca gloriosa :: Spanish Dagger 126 | 1211 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 5991111.74461 | 2105172.65449 | 37.7598912734774 | -122.473837074718 | (37.7598912734774, -122.473837074718) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 |
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) );