trees
302 rows where qSpecies_id = 167 sorted by Zip Codes
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 | |||||||||||||
| 181649 | 67772 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 146 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/15/1992 12:00:00 AM | Permit Number 31403 | 6004564.19848572 | 2108804.14815363 | 37.7706324670974 | -122.427570300779 | (37.7706324670974, -122.427570300779) | 7 | 9 | 11 | 28852 | 10 | ||
| 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 | ||
| 159664 | 238542 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 38 Ramona Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005184.86734 | 2107563.56231 | 37.7672612032636 | -122.425335101659 | (37.7672612032636, -122.425335101659) | 8 | 4 | 5 | 28853 | 19 | |||
| 1951 | 196519 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014493.82827 | 2101802.94838 | 37.7519653333515 | -122.392733453506 | (37.7519653333515, -122.392733453506) | 10 | 3 | 8 | 28856 | 1 | ||||
| 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 | |
| 27193 | 196521 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014496.49753 | 2101766.20536 | 37.7518645930792 | -122.392721652585 | (37.7518645930792, -122.392721652585) | 10 | 3 | 8 | 28856 | 1 | ||||
| 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 | ||
| 36460 | 196525 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 777 Rhode Island St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 6011871.67435 | 2104748.04731 | 37.7599059432265 | -122.402008311954 | (37.7599059432265, -122.402008311954) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | ||
| 54150 | 196518 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014492.91389 | 2101810.69981 | 37.7519865663454 | -122.392737157804 | (37.7519865663454, -122.392737157804) | 10 | 3 | 8 | 28856 | 1 | ||||
| 67328 | 196531 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6014106.81933 | 2105287.87473 | 37.7615126872711 | -122.394315771076 | (37.7615126872711, -122.394315771076) | 10 | 3 | 8 | 28856 | 29 | |||
| 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 | ||
| 76925 | 196524 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 500 De Haro St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6012039.23838 | 2106001.02013 | 37.7633556787538 | -122.401516847728 | (37.7633556787538, -122.401516847728) | 8 | 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 | |||
| 90030 | 40825 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 695 05th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | Permit Number 41762 | 6013368.81391754 | 2110378.20910645 | 37.7754485595516 | -122.39722520599 | (37.7754485595516, -122.39722520599) | 6 | 2 | 9 | 28856 | 34 | |||
| 91244 | 196523 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1801 Mariposa St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011996.40725 | 2106050.20307 | 37.7634883341404 | -122.401668444652 | (37.7634883341404, -122.401668444652) | 8 | 3 | 8 | 28856 | 29 | |||
| 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 | |||
| 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 | ||||
| 107498 | 196522 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1801 Mariposa St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011980.51858 | 2106049.29218 | 37.7634849464005 | -122.401723334779 | (37.7634849464005, -122.401723334779) | 8 | 3 | 8 | 28856 | 29 | |||
| 109538 | 196529 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6014166.99848 | 2105290.36806 | 37.7615228783907 | -122.394107809149 | (37.7615228783907, -122.394107809149) | 10 | 3 | 8 | 28856 | 29 | |||
| 127350 | 98667 | Undocumented 4 | Prunus blireiana :: Flowering Plum 167 | 396 Townsend St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013391.9 | 2110381 | 37.7754575079339 | -122.397145540942 | (37.7754575079339, -122.397145540942) | 6 | 2 | 9 | 28856 | 34 | ||||
| 128132 | 196520 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1100 Pennsylvania Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | 6014495.9358 | 2101776.59314 | 37.7518930845169 | -122.392724321763 | (37.7518930845169, -122.392724321763) | 10 | 3 | 8 | 28856 | 1 | ||||
| 140595 | 196528 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 400 Texas St | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6013752.07769 | 2105195.94744 | 37.7612405497197 | -122.395536244627 | (37.7612405497197, -122.395536244627) | 10 | 3 | 8 | 28856 | 29 | |||
| 163456 | 196527 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 333 Texas St | 1 | : | Tree | Private 2 | 1 | Width 3ft | 6013792.65149 | 2105531.32389 | 37.7621636768226 | -122.395419411895 | (37.7621636768226, -122.395419411895) | 10 | 3 | 8 | 28856 | 29 | |||
| 172690 | 40824 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 695 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/1999 12:00:00 AM | Permit Number 41762 | 6013368.81391754 | 2110378.20910645 | 37.7754485595516 | -122.39722520599 | (37.7754485595516, -122.39722520599) | 6 | 2 | 9 | 28856 | 34 | |||
| 174135 | 196526 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1327 Rhode Island St | 1 | : | Tree | Private 2 | 7 | Width 3ft | 6012008.29844 | 2102189.51462 | 37.752888399289 | -122.401355988709 | (37.752888399289, -122.401355988709) | 10 | 3 | 8 | 28856 | 29 | |||
| 183391 | 196530 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1150 19th St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 4ft | 6014129.09689 | 2105289.45573 | 37.7615182666641 | -122.394238832278 | (37.7615182666641, -122.394238832278) | 10 | 3 | 8 | 28856 | 29 | |||
| 34044 | 39132 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 786 Capp St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/19/1998 12:00:00 AM | Permit Number 40812 | 6007317.12360596 | 2102737.01571967 | 37.7541288594826 | -122.417617789975 | (37.7541288594826, -122.417617789975) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 38111 | 98123 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 900 York St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774687 | 6009897 | 2103882.5 | 37.7574189360449 | -122.40877671519 | (37.7574189360449, -122.40877671519) | 2 | 4 | 7 | 28859 | 19 | |
| 42239 | 238547 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 178 Peralta Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6009850.79636 | 2100052.59551 | 37.7469002814368 | -122.408666329408 | (37.7469002814368, -122.408666329408) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||
| 47162 | 44322 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3101 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | Permit Number 43712 | 6007112.9770146 | 2100542.34949089 | 37.7480913155606 | -122.418168196056 | (37.7480913155606, -122.418168196056) | 2 | 4 | 7 | 28859 | 2 | |||
| 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 | |||
| 56501 | 45755 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 27 Liberty St | 2 | 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 | |||
| 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 | |||
| 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 | ||||
| 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 | |||
| 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 | ||||
| 78325 | 44326 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 3101 Mission St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/02/2001 12:00:00 AM | Permit Number 43712 | 6007112.9770146 | 2100542.34949089 | 37.7480913155606 | -122.418168196056 | (37.7480913155606, -122.418168196056) | 2 | 4 | 7 | 28859 | 2 | |||
| 84667 | 98122 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 900 York St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774687 | 6009897 | 2103882.5 | 37.7574189360449 | -122.40877671519 | (37.7574189360449, -122.40877671519) | 2 | 4 | 7 | 28859 | 19 | |
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | ||||
| 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 | ||
| 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 | |||
| 111333 | 109267 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 900 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/25/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774687 | 6009897 | 2103882.5 | 37.7574189360449 | -122.40877671519 | (37.7574189360449, -122.40877671519) | 2 | 4 | 7 | 28859 | 19 | |
| 113719 | 238560 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 3329 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6007360.6242 | 2105555.31734 | 37.7618697145455 | -122.417667096959 | (37.7618697145455, -122.417667096959) | 2 | 4 | 7 | 28859 | 19 | |||
| 119371 | 64408 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 80 Montcalm St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/02/1988 12:00:00 AM | Permit Number 25254 | 6010509.94669729 | 2100012.34807199 | 37.7468266663579 | -122.406384201378 | (37.7468266663579, -122.406384201378) | 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 | |||
| 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 | ||||
| 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 | |||
| 166319 | 238541 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 31 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6005390.57049 | 2103524.39032 | 37.7561822103525 | -122.424336286693 | (37.7561822103525, -122.424336286693) | 2 | 4 | 5 | 28859 | 19 | |||
| 180109 | 64262 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 159 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/03/1988 12:00:00 AM | Permit Number 25064 | 6010000.52253468 | 2100073.98033326 | 37.7469673841837 | -122.408150095635 | (37.7469673841837, -122.408150095635) | 2 | 7 | 7 | 28859 | 2 | ||
| 181019 | 64271 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 1627 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/01/1988 12:00:00 AM | Permit Number 25074 | 6009690.91214732 | 2100255.03327712 | 37.7474471748973 | -122.409233479729 | (37.7474471748973, -122.409233479729) | 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 | |||
| 181767 | 238546 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 1550 York St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6010196.53495 | 2100318.93034 | 37.7476509365422 | -122.407489565592 | (37.7476509365422, -122.407489565592) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | ||||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |
| 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 | ||
| 22807 | 238573 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 414 Collingwood St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6002098.58859 | 2103426.99001 | 37.7557283324208 | -122.435714094642 | (37.7557283324208, -122.435714094642) | 2 | 4 | 5 | 28862 | 22 | ||||
| 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 | ||
| 34573 | 238557 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 4014 26th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6003783.51976 | 2100724.3526 | 37.7484030872306 | -122.429694315247 | (37.7484030872306, -122.429694315247) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 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 | ||
| 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 | ||||
| 80138 | 238574 | DPW Maintained 1 | Prunus blireiana :: Flowering Plum 167 | 290 States St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6000331.0714 | 2106844.50131 | 37.7650114214522 | -122.442072013715 | (37.7650114214522, -122.442072013715) | 15 | 5 | 5 | 28862 | 3 | |||
| 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 | ||
| 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 | ||||
| 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 | |||
| 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 | ||
| 123995 | 48404 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 229 States St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/24/2002 12:00:00 AM | Permit Number 45785 | 6000714.62430191 | 2106535.28548397 | 37.7641842416872 | -122.440723221205 | (37.7641842416872, -122.440723221205) | 15 | 5 | 5 | 28862 | 3 | |||
| 147558 | 40222 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 4387 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 41401 | 6001391.00854692 | 2101128.86800083 | 37.7493780241405 | -122.437996521237 | (37.7493780241405, -122.437996521237) | 2 | 4 | 5 | 28862 | 22 | ||
| 179037 | 63775 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 29 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/09/1987 12:00:00 AM | Permit Number 24456 | 6004942.98585197 | 2101617.48681583 | 37.7509210136603 | -122.425748465468 | (37.7509210136603, -122.425748465468) | 2 | 4 | 5 | 28862 | 22 | ||
| 182259 | 84042 | Permitted Site 7 | Prunus blireiana :: Flowering Plum 167 | 508 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50447 | 6003026.52400311 | 2103317.18885819 | 37.7554795089619 | -122.432497158122 | (37.7554795089619, -122.432497158122) | 2 | 4 | 5 | 28862 | 22 | ||
| 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 | ||
| 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 |
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) );