trees
302 rows where qSpecies_id = 167 sorted by Latitude
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1517 | 19783 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY19 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 50ST | |||||||||||||
| 2582 | 19774 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY17 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 20ST | |||||||||||||
| 3812 | 19927 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 3853 | 19924 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 6216 | 19931 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY37 | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 20ST | |||||||||||||
| 7721 | 19582 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY4 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 8077 | 19587 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY4 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | |||||||||||||
| 10276 | 20049 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY52 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 10 | |||||||||||||
| 10775 | 19839 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY25 | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60X | |||||||||||||
| 13835 | 20004 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY46 | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 2 | |||||||||||||
| 16360 | 19788 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY19 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 50ST | |||||||||||||
| 18770 | 19796 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY21 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 19416 | 20072 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY55 | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 45X | |||||||||||||
| 131218 | 187550 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 15 Chicago Way | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6003854.31887 | 2086791.04585 | 37.7101493555763 | -122.428456511776 | (37.7101493555763, -122.428456511776) | 9 | 7 | 6 | 309 | 5 | |||
| 93316 | 62805 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 15 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1991 12:00:00 AM | 5 | Permit Number 29952 | 6003841.76502 | 2086802.53618 | 37.7101801951336 | -122.428500718859 | (37.7101801951336, -122.428500718859) | 9 | 7 | 6 | 309 | 5 | ||
| 96789 | 179167 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 111 Brunswick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6000723.35107 | 2087387.59269 | 37.7116096657128 | -122.439320465973 | (37.7116096657128, -122.439320465973) | 9 | 7 | 6 | 28861 | 5 | |||
| 42783 | 179169 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 7 Teddy Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6011399.30958 | 2087676.99992 | 37.7130060844452 | -122.402441626885 | (37.7130060844452, -122.402441626885) | 9 | 7 | 8 | 309 | 39 | |||
| 53390 | 213716 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 252 Lobos St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5994453.52606 | 2088731.32317 | 37.7149404380182 | -122.461087834836 | (37.7149404380182, -122.461087834836) | 9 | 8 | 6 | 28861 | 24 | |||
| 150775 | 34800 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 67 Ellington Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1997 12:00:00 AM | 6 | Permit Number 38436 | 5999719.34945 | 2088765.88289 | 37.7153369536092 | -122.442889465097 | (37.7153369536092, -122.442889465097) | 9 | 7 | 6 | 28861 | 25 | |
| 175231 | 179168 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 200x Mansell St | 21 | Median : Cutout | Tree | DPW 1 | 9 | Width 0ft | 6011032.14311 | 2090534.05643 | 37.7208304767293 | -122.40391160924 | (37.7208304767293, -122.40391160924) | 10 | 3 | 7 | 309 | 28 | |||
| 127426 | 45342 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 466 Ralston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/27/2001 12:00:00 AM | Permit Number 44172 | 5992247.31717609 | 2090977.05466926 | 37.7209794647769 | -122.46887668176 | (37.7209794647769, -122.46887668176) | 9 | 8 | 6 | 64 | 24 | ||
| 1585 | 34112 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1398 Plymouth Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
| 154377 | 34113 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1398 Plymouth Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37977 | 5995892.17100072 | 2093289.41859175 | 37.7275385716585 | -122.456444707829 | (37.7275385716585, -122.456444707829) | 9 | 7 | 4 | 28861 | 40 | ||
| 45898 | 34127 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1401 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/1997 12:00:00 AM | Permit Number 37983 | 5995840.26429469 | 2093321.75315516 | 37.7276243745144 | -122.456626485978 | (37.7276243745144, -122.456626485978) | 9 | 7 | 4 | 28861 | 40 | ||
| 134167 | 213715 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Judson Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999200.66697 | 2093467.5999 | 37.728217201345 | -122.445020057043 | (37.728217201345, -122.445020057043) | 9 | 7 | 4 | 28861 | 40 | |||
| 33119 | 213714 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Judson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 5999173.83796 | 2093468.34199 | 37.7282177076567 | -122.445112858974 | (37.7282177076567, -122.445112858974) | 9 | 7 | 4 | 28861 | 40 | |||
| 126896 | 213713 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Judson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 5999159.40748 | 2093468.82637 | 37.7282182139859 | -122.445162780338 | (37.7282182139859, -122.445162780338) | 9 | 7 | 4 | 28861 | 40 | |||
| 69449 | 213711 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 38 Hearst Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6000905.90328 | 2094365.19154 | 37.7307789597781 | -122.439189308837 | (37.7307789597781, -122.439189308837) | 9 | 7 | 4 | 63 | 40 | |||
| 77247 | 213710 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 38 Hearst Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6000922.38678 | 2094365.15978 | 37.7307798105294 | -122.439132320623 | (37.7307798105294, -122.439132320623) | 9 | 7 | 4 | 63 | 40 | |||
| 143285 | 60381 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1350 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19961 | 6016233.53392592 | 2094275.31577425 | 37.7313924611256 | -122.386192505476 | (37.7313924611256, -122.386192505476) | 10 | 3 | 8 | 58 | 1 | ||
| 158240 | 60370 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1439 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19948 | 6015729.73368672 | 2094586.16842125 | 37.7322181026296 | -122.387955935836 | (37.7322181026296, -122.387955935836) | 10 | 3 | 8 | 58 | 1 | ||
| 90863 | 213712 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 611 Joost Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 5998085.35885 | 2094959.97852 | 37.7322512012233 | -122.448983163356 | (37.7322512012233, -122.448983163356) | 9 | 7 | 4 | 59 | 40 | ||||
| 79931 | 60386 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1432 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/06/1982 12:00:00 AM | Permit Number 19966 | 6015791.47503069 | 2094604.97930734 | 37.7322731738529 | -122.387743792201 | (37.7322731738529, -122.387743792201) | 10 | 3 | 8 | 58 | 1 | ||
| 106731 | 65345 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 182 Lippard Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/21/1994 12:00:00 AM | Permit Number 28177 | 6001753.2001687 | 2095039.63295635 | 37.7326789990165 | -122.43630832371 | (37.7326789990165, -122.43630832371) | 9 | 7 | 5 | 63 | 40 | ||
| 33084 | 47171 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 230 San Leandro Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/08/2002 12:00:00 AM | Permit Number 45135 | 5992362.95598719 | 2095257.05561838 | 37.7327379703821 | -122.468788241573 | (37.7327379703821, -122.468788241573) | 9 | 8 | 4 | 59 | 40 | ||
| 51250 | 85264 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
| 123284 | 85263 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
| 160965 | 85262 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
| 190777 | 85265 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3000 Ocean Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2007 12:00:00 AM | Permit Number 49557 | 5989530.4 | 2095609.1 | 37.7335405447433 | -122.478606721292 | (37.7335405447433, -122.478606721292) | 1 | 8 | 4 | 64 | 35 | |||
| 153565 | 65660 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 106 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28580 | 5999382.81726917 | 2095526.44780449 | 37.7338807102318 | -122.444538269179 | (37.7338807102318, -122.444538269179) | 9 | 7 | 4 | 59 | 40 | ||
| 77109 | 65661 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 76 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28581 | 5999609.85654862 | 2095526.3392082 | 37.7338933644168 | -122.443753320491 | (37.7338933644168, -122.443753320491) | 9 | 7 | 4 | 63 | 40 | ||
| 31857 | 65669 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 979 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1990 12:00:00 AM | Permit Number 28589 | 5998410.3805024 | 2095666.47034675 | 37.734209643166 | -122.447910340725 | (37.734209643166, -122.447910340725) | 9 | 7 | 4 | 59 | 40 | ||
| 17389 | 61219 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 179 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1983 12:00:00 AM | 7 | Permit Number 21088 | 6011237.71128 | 2095645.35601 | 37.7348765255373 | -122.403560449172 | (37.7348765255373, -122.403560449172) | 10 | 3 | 8 | 58 | 1 | |
| 12154 | 61218 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 175 Elmira St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/17/1983 12:00:00 AM | 8 | Permit Number 21087 | 6011233.77043 | 2095695.97338 | 37.7350152900164 | -122.403577634297 | (37.7350152900164, -122.403577634297) | 10 | 3 | 8 | 58 | 1 | |
| 189098 | 238561 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 84 Richland Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 2ft | 6005027.1753 | 2096150.27417 | 37.7359140517929 | -122.42506837081 | (37.7359140517929, -122.42506837081) | 2 | 7 | 5 | 28859 | 2 | |||
| 80699 | 185053 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2719 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5983670.2351 | 2096626.4658 | 37.735991973866 | -122.498941812175 | (37.735991973866, -122.498941812175) | 1 | 8 | 3 | 29491 | 35 | |||
| 152640 | 218233 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 365 Wawona St | 1 | : | Tree | Private 2 | 6 | Width 2ft | 5991919.11048 | 2097078.05412 | 37.737712321755 | -122.470455286603 | (37.737712321755, -122.470455286603) | 1 | 8 | 4 | 59 | 40 | |||
| 138858 | 218234 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 363 Wawona St | 1 | : | Tree | Private 2 | 5 | Width 2ft | 5991942.37249 | 2097100.26262 | 37.7377746456792 | -122.470376476289 | (37.7377746456792, -122.470376476289) | 1 | 8 | 4 | 59 | 40 | |||
| 110192 | 49555 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 71REVISED Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/2003 12:00:00 AM | Permit Number 46444 | 6009365.93611768 | 2097039.29774225 | 37.7385992569024 | -122.410130235329 | (37.7385992569024, -122.410130235329) | 10 | 7 | 7 | 28859 | 2 | |||
| 99731 | 65675 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 35 Sequoia Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28595 | 5998245.89042686 | 2097529.81502266 | 37.7393165384712 | -122.448613189427 | (37.7393165384712, -122.448613189427) | 9 | 7 | 4 | 59 | 40 | ||
| 103124 | 65676 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 29 Sequoia Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28596 | 5998246.67335369 | 2097607.91153994 | 37.7395310174996 | -122.448616105598 | (37.7395310174996, -122.448616105598) | 9 | 7 | 4 | 59 | 40 | ||
| 91037 | 65677 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 25 Sequoia Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1990 12:00:00 AM | Permit Number 28597 | 5998247.19530514 | 2097659.9759073 | 37.7396740035761 | -122.448618049723 | (37.7396740035761, -122.448618049723) | 9 | 7 | 4 | 59 | 40 | ||
| 42259 | 183468 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2531 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987663.5713 | 2098059.3859 | 37.7401598234787 | -122.485240531105 | (37.7401598234787, -122.485240531105) | 1 | 8 | 3 | 29491 | 35 | |||
| 185215 | 182092 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2691 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987764.3751 | 2098252.1671 | 37.7406950216778 | -122.484906136221 | (37.7406950216778, -122.484906136221) | 1 | 8 | 3 | 29491 | 35 | |||
| 114334 | 57241 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2630 Ulloa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1975 12:00:00 AM | 3 | Permit Number 14529 | 5987816.4921 | 2098311.7293 | 37.740861599204 | -122.484730305914 | (37.740861599204, -122.484730305914) | 1 | 8 | 3 | 29491 | 35 | ||
| 78638 | 181961 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2468 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5987695.3371 | 2098486.355 | 37.741334018552 | -122.485162019071 | (37.741334018552, -122.485162019071) | 1 | 8 | 3 | 29491 | 35 | |||
| 98385 | 182117 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2468 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987697.3676 | 2098504.9682 | 37.7413852437695 | -122.48515636377 | (37.7413852437695, -122.48515636377) | 1 | 8 | 3 | 29491 | 35 | |||
| 130298 | 182113 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2462 27th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 0ft | 5988005.6699 | 2098548.963 | 37.7415239963656 | -122.484093600478 | (37.7415239963656, -122.484093600478) | 1 | 8 | 3 | 29491 | 35 | |||
| 144321 | 23667 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 315 Virginia Ave | 2 | Median : Cutout | Tree | DPW 1 | 6 | 12 | 6006939.5968988 | 2098278.7889768 | 37.7418663267774 | -122.418607247372 | (37.7418663267774, -122.418607247372) | 2 | 7 | 7 | 28859 | 2 | |||
| 123584 | 23662 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 311 Virginia Ave | 1 | Median : Cutout | Tree | DPW 1 | 6 | 12 | 6006938.1768512 | 2098312.3803834 | 37.7419584813283 | -122.41861453897 | (37.7419584813283, -122.41861453897) | 2 | 7 | 7 | 28859 | 2 | |||
| 147138 | 238569 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1623 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003376.35703 | 2098716.75556 | 37.7428676287329 | -122.430959013851 | (37.7428676287329, -122.430959013851) | 2 | 7 | 5 | 63 | 22 | |||
| 183518 | 181884 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2364 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5986431.5008 | 2099166.4136 | 37.7431275754829 | -122.48958185913 | (37.7431275754829, -122.48958185913) | 1 | 8 | 3 | 29491 | 35 | |||
| 1067 | 238562 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 623 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6002513.88087 | 2098855.53984 | 37.7431997906349 | -122.433951130242 | (37.7431997906349, -122.433951130242) | 2 | 7 | 5 | 63 | 7 | |||
| 56706 | 238550 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 263 29th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6004819.40708 | 2098979.89063 | 37.7436717980264 | -122.425988074184 | (37.7436717980264, -122.425988074184) | 2 | 7 | 5 | 63 | 22 | |||
| 50588 | 238552 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 263 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004835.34917 | 2098981.16674 | 37.7436762029056 | -122.425933041078 | (37.7436762029056, -122.425933041078) | 2 | 7 | 5 | 63 | 22 | |||
| 81984 | 238551 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 263 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004827.45458 | 2098981.61516 | 37.7436769880021 | -122.425960370593 | (37.7436769880021, -122.425960370593) | 2 | 7 | 5 | 63 | 22 | |||
| 138936 | 22856 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 140 Turquoise Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 5999949.39722 | 2099144.09084 | 37.7438462152458 | -122.442839126451 | (37.7438462152458, -122.442839126451) | 2 | 7 | 5 | 63 | 7 | |||
| 22590 | 181828 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2311 31st Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5986682.779 | 2099487.7451 | 37.7440245328775 | -122.488736632211 | (37.7440245328775, -122.488736632211) | 1 | 8 | 3 | 29491 | 35 | |||
| 183117 | 181827 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2311 31st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5986682.1022 | 2099505.6814 | 37.7440737416666 | -122.488740290538 | (37.7440737416666, -122.488740290538) | 1 | 8 | 3 | 29491 | 35 | |||
| 186444 | 246650 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 11 | Side Yard : Yard | Tree | Private 2 | 5 | 6009031.04128 | 2099150.93712 | 37.744378579707 | -122.411437288125 | (37.744378579707, -122.411437288125) | 2 | 7 | 7 | 28859 | 2 | ||||
| 66168 | 246649 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 10 | Side Yard : Yard | Tree | Private 2 | 5 | 6009030.81997 | 2099159.02309 | 37.744400769587 | -122.411438624517 | (37.744400769587, -122.411438624517) | 2 | 7 | 7 | 28859 | 2 | ||||
| 99034 | 246645 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 6 | Side Yard : Yard | Tree | Private 2 | 5 | 6009048.82114 | 2099170.00785 | 37.7444319409756 | -122.411377155852 | (37.7444319409756, -122.411377155852) | 2 | 7 | 7 | 28859 | 2 | ||||
| 86414 | 246644 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 5 | Side Yard : Yard | Tree | Private 2 | 4 | 6009046.23893 | 2099176.02556 | 37.7444483194522 | -122.411386509679 | (37.7444483194522, -122.411386509679) | 2 | 7 | 7 | 28859 | 2 | ||||
| 130614 | 246643 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3350 Harrison St | 4 | Side Yard : Yard | Tree | Private 2 | 7 | 6009035.26115 | 2099177.78886 | 37.7444525453606 | -122.411424593276 | (37.7444525453606, -122.411424593276) | 2 | 7 | 7 | 28859 | 2 | ||||
| 31744 | 238553 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 226 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6004403.59335 | 2099297.10954 | 37.7445192993223 | -122.427448451804 | (37.7445192993223, -122.427448451804) | 2 | 7 | 5 | 63 | 22 | |||
| 68867 | 238555 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1519 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003981.56028 | 2099428.33383 | 37.7448557321227 | -122.428917110339 | (37.7448557321227, -122.428917110339) | 2 | 7 | 5 | 63 | 22 | |||
| 33231 | 64308 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1519 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/10/1988 12:00:00 AM | Permit Number 25119 | 6003981.51464704 | 2099431.34343854 | 37.7448639932298 | -122.428917482655 | (37.7448639932298, -122.428917482655) | 2 | 7 | 5 | 63 | 22 | ||
| 62703 | 238563 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 552 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6002357.1288 | 2099469.61588 | 37.7448770028803 | -122.434537034955 | (37.7448770028803, -122.434537034955) | 2 | 7 | 5 | 63 | 22 | |||
| 83252 | 64834 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 552 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1989 12:00:00 AM | Permit Number 25843 | 6002326.41169322 | 2099472.15020661 | 37.7448822177818 | -122.434643430049 | (37.7448822177818, -122.434643430049) | 2 | 7 | 5 | 63 | 22 | ||
| 92552 | 63685 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1488 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24342 | 6003919.51862242 | 2099605.68059427 | 37.7453391734545 | -122.429144281616 | (37.7453391734545, -122.429144281616) | 2 | 7 | 5 | 63 | 22 | ||
| 14594 | 238571 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1474 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003271.46405 | 2099643.85136 | 37.7454072746301 | -122.431387870873 | (37.7454072746301, -122.431387870873) | 2 | 7 | 5 | 63 | 22 | |||
| 28650 | 238570 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1474 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003271.44835 | 2099657.02659 | 37.745443449856 | -122.431388865507 | (37.745443449856, -122.431388865507) | 2 | 7 | 5 | 63 | 22 | |||
| 185325 | 238554 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6003916.2981 | 2099645.9415 | 37.7454495382776 | -122.429158287842 | (37.7454495382776, -122.429158287842) | 2 | 7 | 5 | 63 | 22 | |||
| 123402 | 63670 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1480 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24320 | 6003916.84938378 | 2099651.07656136 | 37.7454636691757 | -122.429156747668 | (37.7454636691757, -122.429156747668) | 2 | 7 | 5 | 63 | 22 | ||
| 84475 | 64804 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1476 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25803 | 6003915.51476447 | 2099673.7745449 | 37.7455259170349 | -122.42916298071 | (37.7455259170349, -122.42916298071) | 2 | 7 | 5 | 63 | 22 | ||
| 101816 | 63684 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1477 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24341 | 6003967.42510642 | 2099676.82682244 | 37.7455372363545 | -122.428983700412 | (37.7455372363545, -122.428983700412) | 2 | 7 | 5 | 63 | 22 | ||
| 133226 | 46266 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1461 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 44550 | 6003962.08662823 | 2099767.6187722 | 37.7457862278615 | -122.429008632092 | (37.7457862278615, -122.429008632092) | 2 | 7 | 5 | 63 | 22 | ||
| 77254 | 60515 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 255 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25818 | 6004877.54107387 | 2099860.14096955 | 37.7460920491494 | -122.425849704584 | (37.7460920491494, -122.425849704584) | 2 | 7 | 5 | 63 | 22 | ||
| 34949 | 238549 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 125 Mullen Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6009831.14885 | 2099860.0052 | 37.7463703703058 | -122.408720684427 | (37.7463703703058, -122.408720684427) | 2 | 7 | 7 | 28859 | 2 | |||
| 112416 | 238564 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 631 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6002380.96657 | 2100028.16957 | 37.7464120134059 | -122.434494537516 | (37.7464120134059, -122.434494537516) | 2 | 7 | 5 | 63 | 22 | |||
| 41106 | 238565 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 625 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6002419.36541 | 2100030.86231 | 37.7464215867002 | -122.434361951369 | (37.7464215867002, -122.434361951369) | 2 | 7 | 5 | 63 | 22 | |||
| 86086 | 238566 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 621 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6002444.33707 | 2100031.09777 | 37.7464236506235 | -122.43427561915 | (37.7464236506235, -122.43427561915) | 2 | 7 | 5 | 63 | 22 | |||
| 192532 | 185747 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1802 Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5987565.4993 | 2100345.9151 | 37.7464323129859 | -122.48574739527 | (37.7464323129859, -122.48574739527) | 1 | 8 | 3 | 29491 | 35 | |||
| 62414 | 185746 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2195 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5987582.8307 | 2100358.089 | 37.7464667491467 | -122.485688359332 | (37.7464667491467, -122.485688359332) | 1 | 8 | 3 | 29491 | 35 | |||
| 168286 | 238567 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 638 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6002382.79124 | 2100064.95153 | 37.7465131116006 | -122.434490857486 | (37.7465131116006, -122.434490857486) | 2 | 7 | 5 | 63 | 22 | |||
| 126638 | 185745 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2195 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 5987583.2114 | 2100377.5043 | 37.7465200805681 | -122.485688467617 | (37.7465200805681, -122.485688467617) | 1 | 8 | 3 | 29491 | 35 | |||
| 77173 | 256161 | Undocumented 4 | Prunus blireiana :: Flowering Plum 167 | 198X Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009711 | 2099918 | 37.7465228810693 | -122.409140238555 | (37.7465228810693, -122.409140238555) | 2 | 7 | 7 | 28859 | 2 | ||||
| 73507 | 238544 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1673 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009719.77093 | 2099951.13854 | 37.7466143635754 | -122.409112247438 | (37.7466143635754, -122.409112247438) | 2 | 7 | 7 | 28859 | 2 | |||
| 181631 | 238545 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1673 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6009720.83243 | 2099966.93881 | 37.7466578071094 | -122.409109691579 | (37.7466578071094, -122.409109691579) | 2 | 7 | 7 | 28859 | 2 | |||
| 191094 | 63659 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 411 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24307 | 6003836.58732035 | 2100093.87745401 | 37.7466749538841 | -122.429465853369 | (37.7466749538841, -122.429465853369) | 2 | 7 | 5 | 63 | 22 |
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) );