trees
302 rows where qSpecies_id = 167 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 5094 | 60559 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 682 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/09/1982 12:00:00 AM | 7 | Permit Number 20169 | 5985086.77627 | 2111238.89557 | 37.7761966512901 | -122.495121529295 | (37.7761966512901, -122.495121529295) | 11 | 6 | 2 | 55 | 26 | |
| 6825 | 142622 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 651 GREENWICH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6009763.2288 | 2120171.9265 | 37.8021383608566 | -122.410389510852 | (37.8021383608566, -122.410389510852) | 3 | 1 | 10 | 308 | 23 | |||
| 9460 | 70130 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2614 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5990525.20475 | 2112006.61125 | 37.7786214745109 | -122.476364817556 | (37.7786214745109, -122.476364817556) | 11 | 6 | 2 | 55 | 26 | |||
| 10103 | 238559 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 358 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6004157.57388 | 2100161.25542 | 37.7468781266282 | -122.428360715999 | (37.7468781266282, -122.428360715999) | 2 | 7 | 5 | 63 | 22 | |||
| 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 | |
| 15367 | 74918 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2650 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5995120.86057 | 2110292.38931 | 37.7741801236558 | -122.460342548793 | (37.7741801236558, -122.460342548793) | 11 | 6 | 2 | 54 | 11 | |||
| 15489 | 67578 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 118 Connecticut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/05/1992 12:00:00 AM | 6 | Permit Number 31142 | 6013124.0144 | 2106441.06609 | 37.7646244162146 | -122.397795803828 | (37.7646244162146, -122.397795803828) | 14 | 3 | 8 | 28856 | 29 | |
| 16791 | 71817 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1271 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5988923.2164 | 2106695.866 | 37.7639465970002 | -122.481517596706 | (37.7639465970002, -122.481517596706) | 1 | 8 | 3 | 56 | 35 | |||
| 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 | |
| 18770 | 19796 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 STAIRWAY21 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 40ST | |||||||||||||
| 22520 | 12417 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1691 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/1989 12:00:00 AM | 6 | 4X4 | 6004447.0274 | 2114613.1852 | 37.7865760223406 | -122.428389697922 | (37.7865760223406, -122.428389697922) | 13 | 9 | 11 | 29490 | 13 | ||
| 23016 | 60906 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1443 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20696 | 5994564.62076665 | 2105704.92459357 | 37.7615521348608 | -122.461933943385 | (37.7615521348608, -122.461933943385) | 1 | 5 | 11 | 56 | 12 | ||
| 24410 | 120407 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 647 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5988776.18848 | 2110908.47629 | 37.7755047148615 | -122.482334786454 | (37.7755047148615, -122.482334786454) | 11 | 6 | 2 | 55 | 26 | |||
| 26232 | 54232 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1265 03rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 9972 | 5995143.28929522 | 2106927.58636529 | 37.7649425453263 | -122.460021156774 | (37.7649425453263, -122.460021156774) | 15 | 5 | 11 | 56 | 12 | ||
| 26525 | 32263 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1027 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/1997 12:00:00 AM | 6 | Permit Number 38508 | 6001961.80669 | 2101044.74865 | 37.7491794962361 | -122.436016672442 | (37.7491794962361, -122.436016672442) | 2 | 4 | 5 | 28862 | 22 | ||
| 27952 | 117633 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 100 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/05/2018 12:00:00 AM | 3 | 3x3 | 5997552.92531 | 2115962.18049 | 37.7898874813666 | -122.452338860365 | (37.7898874813666, -122.452338860365) | 11 | 6 | 1 | 54 | 31 | ||
| 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 | |||
| 28698 | 63544 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1457 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/13/1987 12:00:00 AM | 5 | Permit Number 24160 | 6000753.318 | 2110998.5304 | 37.776441399194 | -122.440909593922 | (37.776441399194, -122.440909593922) | 15 | 5 | 11 | 29492 | 10 | |
| 29782 | 115782 | Undocumented 4 | Prunus blireiana :: Flowering Plum 167 | 437 MISSISSIPPI ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/09/2016 12:00:00 AM | 3 | 3x3 | 6014121 | 2105062 | 37.7608932727115 | -122.394250910939 | (37.7608932727115, -122.394250910939) | 10 | 3 | 8 | 28856 | 29 | ||
| 31006 | 44821 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1608 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2001 12:00:00 AM | Permit Number 43913 | 5993106.95790851 | 2104515.64796333 | 37.7582026654605 | -122.466888899121 | (37.7582026654605, -122.466888899121) | 1 | 8 | 4 | 56 | 12 | |||
| 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 | |||
| 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 | ||
| 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 | ||
| 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 | ||
| 34370 | 63667 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 4040 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24317 | 6003634.2199128 | 2100428.29946056 | 37.7475817391255 | -122.430189473003 | (37.7475817391255, -122.430189473003) | 2 | 4 | 5 | 63 | 22 | ||
| 37321 | 238556 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1374 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6003884.87618 | 2100253.42684 | 37.7471157733724 | -122.429310250782 | (37.7471157733724, -122.429310250782) | 2 | 7 | 5 | 63 | 22 | |||
| 37361 | 63891 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 61 Brady St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/22/1987 12:00:00 AM | Permit Number 24600 | 6006704.26059714 | 2109561.52554736 | 37.7728328593412 | -122.420221545678 | (37.7728328593412, -122.420221545678) | 8 | 2 | 9 | 28853 | 19 | ||
| 38211 | 123559 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 131 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 7ft | 5994253.7419 | 2114658.86132 | 37.7861193636966 | -122.463659017412 | (37.7861193636966, -122.463659017412) | 11 | 6 | 1 | 54 | 11 | |||
| 38410 | 196516 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 948 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6015218.63504 | 2104201.55531 | 37.7585916272177 | -122.390394521914 | (37.7585916272177, -122.390394521914) | 10 | 3 | 8 | 28856 | 29 | |||
| 39125 | 246183 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 789 Buena Vista Ave West | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999949.17 | 2108240.0487 | 37.7688214743495 | -122.443493165297 | (37.7688214743495, -122.443493165297) | 15 | 5 | 11 | 29492 | 9 | |||
| 39527 | 139116 | Undocumented 4 | Prunus blireiana :: Flowering Plum 167 | 1501 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6004490.8408 | 2114272.6601 | 37.7856435047825 | -122.428213836711 | (37.7856435047825, -122.428213836711) | 13 | 9 | 11 | 29490 | 13 | ||||
| 41074 | 123858 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 346 Lake St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5994396.82631 | 2114914.43525 | 37.7868293438726 | -122.463182538439 | (37.7868293438726, -122.463182538439) | 11 | 6 | 1 | 54 | 11 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 43973 | 64675 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 827 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/07/1988 12:00:00 AM | Permit Number 25611 | 6005699.53822151 | 2104160.47613012 | 37.7579461954401 | -122.423312985478 | (37.7579461954401, -122.423312985478) | 2 | 4 | 5 | 28859 | 19 | ||
| 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 | ||
| 46275 | 122127 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 109 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990810.49016 | 2114703.81512 | 37.7860437889569 | -122.475574912767 | (37.7860437889569, -122.475574912767) | 11 | 6 | 2 | 54 | 26 | |||
| 47384 | 51865 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 141 Alpine Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/15/2005 12:00:00 AM | Permit Number 48086 | 6001731.90100781 | 2108013.17914536 | 37.7683000536682 | -122.43731059058 | (37.7683000536682, -122.43731059058) | 15 | 5 | 5 | 29492 | 3 | |||
| 48436 | 13239 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2335X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3X3 | 6001220.66377 | 2119285.57244 | 37.7992220840374 | -122.439887231455 | (37.7992220840374, -122.439887231455) | 13 | 9 | 1 | 57 | 17 | |||
| 48565 | 60083 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1270 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/16/1982 12:00:00 AM | 3 | Permit Number 19584 | 5988965.7237 | 2106688.207 | 37.7639280389731 | -122.481370017438 | (37.7639280389731, -122.481370017438) | 1 | 8 | 3 | 56 | 35 | |
| 50258 | 124235 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1 Paramount Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 5996597.66018 | 2111009.83191 | 37.7762348739685 | -122.455285924869 | (37.7762348739685, -122.455285924869) | 11 | 6 | 2 | 54 | 16 | |||
| 50692 | 51422 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 655 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/30/2009 12:00:00 AM | 3x3 | Permit Number 52282 | 6013199.59186321 | 2110555.37408537 | 37.7759255920049 | -122.397823019146 | (37.7759255920049, -122.397823019146) | 6 | 2 | 9 | 28856 | 34 | ||
| 51191 | 56269 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 27 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/12/2001 12:00:00 AM | Permit Number 44402 | 6006135.85394887 | 2104023.0641993 | 37.7575935091812 | -122.421794258753 | (37.7575935091812, -122.421794258753) | 2 | 4 | 5 | 28859 | 19 | |||
| 53680 | 138762 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1508 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2018 12:00:00 AM | 3 | Width 0ft | Permit Number 782176 | 6000175.6546 | 2114135.1395 | 37.7850208059477 | -122.443133211033 | (37.7850208059477, -122.443133211033) | 15 | 6 | 1 | 29490 | 27 | |
| 55618 | 238558 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 29 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004887.16641 | 2101620.38269 | 37.7509258105963 | -122.425941700662 | (37.7509258105963, -122.425941700662) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 57104 | 238543 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3765 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6005249.86202 | 2104271.17824 | 37.7582247685753 | -122.4248760328 | (37.7582247685753, -122.4248760328) | 2 | 4 | 5 | 28859 | 19 | |||
| 62681 | 59573 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 964 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/07/1981 12:00:00 AM | Permit Number 18963 | 6003107.75578888 | 2102621.90086172 | 37.7535750192842 | -122.432166582864 | (37.7535750192842, -122.432166582864) | 2 | 4 | 5 | 28862 | 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 | |||
| 62720 | 52648 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 542@ ANZA 08th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/24/2010 12:00:00 AM | 2 | Permit Number 48732 | 5993472.64423 | 2111791.25598 | 37.7782006595283 | -122.466152920318 | (37.7782006595283, -122.466152920318) | 11 | 6 | 2 | 54 | 11 | ||
| 65535 | 40939 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2011 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/17/2000 12:00:00 AM | 4 | Permit Number 42024 | 6003842.4279 | 2115465.9547 | 37.7888832815445 | -122.43054233468 | (37.7888832815445, -122.43054233468) | 13 | 9 | 1 | 29490 | 27 | ||
| 68303 | 57628 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 534 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/1990 12:00:00 AM | 7 | Permit Number 28866 | 5990653.09771 | 2111727.01603 | 37.7778611992683 | -122.475901966903 | (37.7778611992683, -122.475901966903) | 11 | 6 | 2 | 54 | 26 | ||
| 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 | |||
| 69413 | 63672 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 370 27th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/15/2015 12:00:00 AM | 3 | Permit Number 24323 | 6004106.96627638 | 2100160.80457488 | 37.7468740249128 | -122.428535680279 | (37.7468740249128, -122.428535680279) | 2 | 7 | 5 | 63 | 22 | ||
| 69673 | 185737 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2134 32nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5986377.6988 | 2100714.0842 | 37.7473739221204 | -122.489881691592 | (37.7473739221204, -122.489881691592) | 1 | 8 | 3 | 29491 | 35 | |||
| 70523 | 67971 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 2643 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | 2 | Permit Number 31692 | 5987328.75308 | 2111152.20759 | 37.7760896301586 | -122.48735965405 | (37.7760896301586, -122.48735965405) | 11 | 6 | 2 | 55 | 26 | |
| 72104 | 238572 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 414 Collingwood St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6002097.32586 | 2103433.45375 | 37.7557460085737 | -122.435718923989 | (37.7557460085737, -122.435718923989) | 2 | 4 | 5 | 28862 | 22 | ||||
| 73350 | 67526 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1301 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31064 | 6013774.38377619 | 2105211.91246173 | 37.761285626876 | -122.395460215282 | (37.761285626876, -122.395460215282) | 10 | 3 | 8 | 28856 | 29 | ||
| 76964 | 196533 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1301 19th St | 1 | : | Tree | Private 2 | 5 | Width 4ft | 6013698.90567 | 2105212.75779 | 37.7612837495574 | -122.395721323302 | (37.7612837495574, -122.395721323302) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 77356 | 60791 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 276 Ewing Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/14/1983 12:00:00 AM | Permit Number 20465 | 5998453.93543616 | 2112227.70718861 | 37.7796851739557 | -122.44895233828 | (37.7796851739557, -122.44895233828) | 15 | 6 | 2 | 54 | 16 | ||
| 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 | |||
| 79119 | 4209 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3929 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6004325.38397 | 2100415.60352 | 37.747586001896 | -122.427798564152 | (37.747586001896, -122.427798564152) | 2 | 4 | 5 | 63 | 22 | |||
| 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 | ||
| 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 | |||
| 81771 | 63785 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 4007 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24470 | 6003796.64349499 | 2101262.51482532 | 37.7498814982247 | -122.42968731122 | (37.7498814982247, -122.42968731122) | 2 | 4 | 5 | 28862 | 22 | ||
| 82409 | 63662 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3929 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24311 | 6004353.00566134 | 2100414.81780831 | 37.7475854070132 | -122.427702994 | (37.7475854070132, -122.427702994) | 2 | 4 | 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 | ||
| 83761 | 44069 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 45 Hartford St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 43593 | 6002668.59972375 | 2105639.21740039 | 37.761834937896 | -122.433900935359 | (37.761834937896, -122.433900935359) | 15 | 4 | 5 | 28862 | 3 | ||||
| 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 | ||
| 85134 | 123200 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1310 09th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 9ft | 5993097.33077 | 2112035.35395 | 37.7788492259481 | -122.467469010607 | (37.7788492259481, -122.467469010607) | 11 | 6 | 2 | 54 | 11 | |||
| 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 | |||
| 87153 | 238548 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 76 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010523.51123 | 2100011.17861 | 37.7468242140742 | -122.406337213897 | (37.7468242140742, -122.406337213897) | 2 | 7 | 7 | 28859 | 2 | |||
| 88206 | 44237 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 415 Eureka St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/2001 12:00:00 AM | Permit Number 43676 | 6001527.40561887 | 2103403.09040324 | 37.755630249317 | -122.437687712198 | (37.755630249317, -122.437687712198) | 2 | 4 | 5 | 28862 | 22 | |||
| 89330 | 10116 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 842 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3X3 | 6005634.91055 | 2104075.87142 | 37.7577102430435 | -122.423530480645 | (37.7577102430435, -122.423530480645) | 2 | 4 | 5 | 28859 | 19 | |||
| 89391 | 64617 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1635 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1988 12:00:00 AM | 6 | Permit Number 25522 | 6004008.12859 | 2120059.46677 | 37.8015052752171 | -122.43029688889 | (37.8015052752171, -122.43029688889) | 13 | 9 | 1 | 57 | 17 | ||
| 89413 | 182859 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1830 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5986931.5262 | 2102786.1611 | 37.7530956091735 | -122.488118856463 | (37.7530956091735, -122.488118856463) | 1 | 8 | 3 | 56 | 35 | |||
| 89930 | 67744 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1460 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/04/1992 12:00:00 AM | Permit Number 31363 | 5994310.57601305 | 2105578.84704093 | 37.7611913298083 | -122.462803426682 | (37.7611913298083, -122.462803426682) | 1 | 5 | 11 | 56 | 12 | ||
| 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 | ||
| 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 | ||
| 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 | ||
| 96292 | 118174 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 855 33rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 5985693.27669 | 2109963.71146 | 37.7727308467676 | -122.492929558244 | (37.7727308467676, -122.492929558244) | 11 | 6 | 2 | 55 | 26 | |||
| 97602 | 63680 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1290 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/03/1987 12:00:00 AM | Permit Number 24335 | 6003854.79358898 | 2100760.12330994 | 37.7485053408812 | -122.42945040251 | (37.7485053408812, -122.42945040251) | 2 | 4 | 5 | 28862 | 22 | ||
| 98612 | 213708 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1330 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5990694.19648 | 2105216.19153 | 37.7599866214079 | -122.475284333917 | (37.7599866214079, -122.475284333917) | 1 | 8 | 4 | 56 | 12 | |||
| 99655 | 58883 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1831 38th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/22/1980 12:00:00 AM | 3 | Permit Number 18147 | 5984400.4624 | 2102704.4443 | 37.752723252787 | -122.496865608544 | (37.752723252787, -122.496865608544) | 1 | 8 | 3 | 56 | 35 | ||
| 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 | ||
| 100481 | 196532 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1317 19th St | 1 | : | Tree | Private 2 | 5 | Width 6ft | 6013654.12142 | 2105210.03972 | 37.761273794973 | -122.395876023757 | (37.761273794973, -122.395876023757) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 102825 | 196517 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014492.80276 | 2101818.43499 | 37.7520077993331 | -122.392738083189 | (37.7520077993331, -122.392738083189) | 10 | 3 | 8 | 28856 | 1 | ||||
| 103090 | 60911 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 9 Hugo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/18/1983 12:00:00 AM | Permit Number 20703 | 5995767.1919331 | 2107036.52457374 | 37.7652775252135 | -122.457871132491 | (37.7652775252135, -122.457871132491) | 15 | 5 | 11 | 56 | 12 | ||
| 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 | ||
| 104075 | 119033 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 745 44th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 4ft | 5982267.74264 | 2110681.16094 | 37.7744998336605 | -122.504831829725 | (37.7744998336605, -122.504831829725) | 11 | 6 | 2 | 55 | 26 | |||
| 104270 | 63655 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1374 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/26/1987 12:00:00 AM | Permit Number 24302 | 6003882.00730683 | 2100268.96113166 | 37.747158264512 | -122.429321278666 | (37.747158264512, -122.429321278666) | 2 | 7 | 5 | 63 | 22 | ||
| 105028 | 39133 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 786 Capp St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/21/1999 12:00:00 AM | Permit Number 40812 | 6007317.12360596 | 2102737.01571967 | 37.7541288594826 | -122.417617789975 | (37.7541288594826, -122.417617789975) | 2 | 4 | 7 | 28859 | 19 | ||
| 106286 | 63666 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 4019 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/02/1987 12:00:00 AM | Permit Number 24316 | 6003771.80904203 | 2100383.61201619 | 37.7474668298055 | -122.42971051138 | (37.7474668298055, -122.42971051138) | 2 | 4 | 5 | 63 | 22 | ||
| 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 |
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) );