trees
3,267 rows where qSpecies_id = 67 sorted by PlotSize
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26637 | 55149 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4201-4203 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/21/1972 12:00:00 AM | Permit Number 11053 | 6001854.68954035 | 2102324.20100835 | 37.7526864815527 | -122.436478647094 | (37.7526864815527, -122.436478647094) | 2 | 4 | 5 | 28862 | 22 | |||
| 26819 | 64809 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29687 | 6002621.59304129 | 2100025.86145885 | 37.7464193322717 | -122.433662314673 | (37.7464193322717, -122.433662314673) | 2 | 7 | 5 | 63 | 22 | ||
| 27153 | 67346 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 855 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30832 | 6010206.11053857 | 2104246.74223384 | 37.7584363722785 | -122.407733365614 | (37.7584363722785, -122.407733365614) | 10 | 4 | 7 | 28859 | 19 | ||
| 27200 | 103055 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2301 Noriega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 29932 | 5986892 | 2102979 | 37.7536227864704 | -122.488269714105 | (37.7536227864704, -122.488269714105) | 1 | 8 | 3 | 56 | 35 | ||||
| 27592 | 42830 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
| 27771 | 53400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2502 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/16/1969 12:00:00 AM | 10 | Permit Number 6299 | 5990880.06647 | 2112020.40978 | 37.7786799348836 | -122.475138234513 | (37.7786799348836, -122.475138234513) | 11 | 6 | 2 | 54 | 26 | ||
| 28220 | 67519 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 343 Staples Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/22/1992 12:00:00 AM | Permit Number 31055 | 5997813.90677575 | 2093780.36383283 | 37.7289967307539 | -122.449836649621 | (37.7289967307539, -122.449836649621) | 9 | 7 | 4 | 28861 | 40 | ||
| 28474 | 57078 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 524 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1999 12:00:00 AM | Permit Number 14345 | 6002992.77928438 | 2102146.1303475 | 37.7522621466226 | -122.432530215855 | (37.7522621466226, -122.432530215855) | 2 | 4 | 5 | 28862 | 22 | ||
| 28731 | 54993 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 681 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 4 | Permit Number 10871 | 5990951.13867 | 2110770.38221 | 37.7752518210128 | -122.474801107552 | (37.7752518210128, -122.474801107552) | 11 | 6 | 2 | 54 | 26 | ||
| 28748 | 188256 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013789.26124 | 2089763.61893 | 37.7188686596462 | -122.394327104323 | (37.7188686596462, -122.394327104323) | 10 | 3 | 8 | 58 | 1 | ||||
| 30362 | 217834 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2 Cranleigh Dr | 25 | Front Yard : Yard | Tree | Private 2 | 15 | 5991396.17639 | 2095791.92324 | 37.7341506817918 | -122.472169581465 | (37.7341506817918, -122.472169581465) | 1 | 8 | 4 | 64 | 40 | ||||
| 31272 | 69362 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3521 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/18/1994 12:00:00 AM | 7 | Permit Number 33456 | 6002627.22111 | 2120704.30709 | 37.8031975232214 | -122.435121592481 | (37.8031975232214, -122.435121592481) | 13 | 9 | 1 | 57 | 17 | |
| 31416 | 54560 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 55 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 10 | Permit Number 10355 | 6012764.33231 | 2095423.50723 | 37.7343525310416 | -122.398266792293 | (37.7343525310416, -122.398266792293) | 10 | 3 | 8 | 58 | 1 | ||
| 31438 | 188881 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 875 Vermont St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6011300.93761 | 2104283.5706 | 37.7585987228662 | -122.403949537249 | (37.7585987228662, -122.403949537249) | 10 | 3 | 8 | 28856 | 29 | ||||
| 31511 | 31182 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34880 | 5992624.59921054 | 2089874.97031305 | 37.7179751991794 | -122.467492439169 | (37.7179751991794, -122.467492439169) | 9 | 8 | 6 | 64 | 24 | ||
| 31966 | 37779 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 449 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.7288087098037 | -122.409003606238 | (37.7288087098037, -122.409003606238) | 10 | 3 | 7 | 309 | 28 | ||
| 32059 | 62223 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2010 12:00:00 AM | 3 | Permit Number 53519 | 6001462.98995 | 2093679.24123 | 37.7289271819206 | -122.437214279825 | (37.7289271819206, -122.437214279825) | 9 | 7 | 6 | 28861 | 25 | |
| 33772 | 60306 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1731 Grove St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/07/1982 12:00:00 AM | 6 | Permit Number 19876 | 5999539.5651 | 2110487.8324 | 37.7749699505091 | -122.445071570973 | (37.7749699505091, -122.445071570973) | 15 | 5 | 11 | 29492 | 16 | ||
| 33832 | 62064 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1259 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1985 12:00:00 AM | 8 | Permit Number 22145 | 5983337.283 | 2106566.0084 | 37.7632636666362 | -122.500827758091 | (37.7632636666362, -122.500827758091) | 1 | 8 | 3 | 56 | 35 | ||
| 35092 | 66605 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 246 Athens St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1991 12:00:00 AM | Permit Number 29800 | 6004471.01014592 | 2091844.94810518 | 37.7240611530605 | -122.426684762239 | (37.7240611530605, -122.426684762239) | 9 | 7 | 6 | 28861 | 5 | ||
| 35966 | 47272 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2407 Lincoln Wy | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/09/2002 12:00:00 AM | Permit Number 45213 | 5988289.74121062 | 2107116.743846 | 37.7650653584421 | -122.483739432305 | (37.7650653584421, -122.483739432305) | 1 | 8 | 3 | 56 | 35 | |||
| 36269 | 47348 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 46 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/13/2002 12:00:00 AM | Permit Number 45274 | 5994469.1469604 | 2090229.4816179 | 37.7190549234375 | -122.461142372223 | (37.7190549234375, -122.461142372223) | 9 | 8 | 6 | 28861 | 24 | ||
| 36494 | 38922 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 Lakeview Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/02/1998 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | 9 | 8 | 6 | 28861 | 24 | |||
| 36546 | 55003 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 571 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 10 | Permit Number 10881 | 5990924.60032 | 2111507.07887 | 37.7772730502959 | -122.474946695736 | (37.7772730502959, -122.474946695736) | 11 | 6 | 2 | 54 | 26 | ||
| 36580 | 42885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2546 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 4 | Permit Number 42806 | 5985850.2562 | 2097897.6252 | 37.7396098709906 | -122.491498248106 | (37.7396098709906, -122.491498248106) | 1 | 8 | 3 | 29491 | 35 | |
| 36690 | 42398 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Gennessee St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | 9 | 7 | 4 | 59 | 40 | ||
| 37915 | 43699 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 901 Balboa St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/25/2000 12:00:00 AM | 4 | Permit Number 43342 | 5992748.80796 | 2111348.45458 | 37.7769430589995 | -122.468624685117 | (37.7769430589995, -122.468624685117) | 11 | 6 | 2 | 54 | 11 | |
| 38082 | 115170 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2483 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/14/2016 12:00:00 AM | Permit Number 775167 | 5983603.3 | 2098266.1 | 37.7404900382804 | -122.499294352828 | (37.7404900382804, -122.499294352828) | 1 | 8 | 3 | 29491 | 35 | |||
| 38175 | 56730 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1551 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6015631.7584 | 2095701.097 | 37.7352740434099 | -122.388372450522 | (37.7352740434099, -122.388372450522) | 10 | 3 | 8 | 58 | 1 | ||||
| 38256 | 125805 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 349 Marina Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6001675.8593 | 2121806.39816 | 37.8061695046764 | -122.438492810894 | (37.8061695046764, -122.438492810894) | 13 | 9 | 1 | 57 | 17 | ||||
| 39118 | 32369 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 858 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/03/1996 12:00:00 AM | 6 | Permit Number 36919 | 6008860.83914 | 2119402.12264 | 37.7999740436362 | -122.413457749072 | (37.7999740436362, -122.413457749072) | 3 | 1 | 10 | 308 | 32 | ||
| 39133 | 49207 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2550 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2003 12:00:00 AM | Permit Number 46296 | 5987860.19003089 | 2106475.09481786 | 37.7632785526853 | -122.485178041739 | (37.7632785526853, -122.485178041739) | 1 | 8 | 3 | 56 | 35 | |||
| 39297 | 69323 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2130 Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/23/1994 12:00:00 AM | 8 | Permit Number 33406 | 6007673.53376 | 2119706.35756 | 37.8007426600105 | -122.417587861288 | (37.8007426600105, -122.417587861288) | 5 | 1 | 1 | 308 | 32 | ||
| 39560 | 32490 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 26 Uranus Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 5 | Permit Number 36996 | 5999294.82707 | 2105565.3001 | 37.7614399465063 | -122.445564118098 | (37.7614399465063, -122.445564118098) | 15 | 5 | 5 | 28862 | 3 | |
| 40060 | 112793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 23x Joice St | 4 | Unaccepted Street : Cutout | Tree | Private 2 | 8 | 6010304.6147 | 2116218.08658 | 37.7913124139936 | -122.408237021841 | (37.7913124139936, -122.408237021841) | 5 | 1 | 10 | 28857 | 21 | ||||
| 40242 | 67987 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201 Granada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1993 12:00:00 AM | Permit Number 31711 | 5995615.55852093 | 2091245.53486568 | 37.7219106715002 | -122.457253158986 | (37.7219106715002, -122.457253158986) | 9 | 8 | 4 | 28861 | 24 | ||
| 40381 | 42165 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 354 05th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011856.41574 | 2111871.95313 | 37.7794657219919 | -122.402562043425 | (37.7794657219919, -122.402562043425) | 14 | 2 | 9 | 28856 | 34 | ||
| 40436 | 69156 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1255 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 7 | Permit Number 33192 | 5983336.7375 | 2106596.5609 | 37.7633475230998 | -122.5008319043 | (37.7633475230998, -122.5008319043) | 1 | 8 | 3 | 56 | 35 | |
| 41099 | 204587 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 231 Edna St | 3 | Side Yard : Yard | Tree | Private 2 | 15 | 5998761.63986 | 2095307.99591 | 37.733245428731 | -122.446670146634 | (37.733245428731, -122.446670146634) | 9 | 7 | 4 | 59 | 40 | ||||
| 41349 | 43584 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 117 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43245 | 6005148.55344947 | 2099289.0817491 | 37.7445393628941 | -122.424871957382 | (37.7445393628941, -122.424871957382) | 2 | 7 | 5 | 63 | 22 | ||
| 42058 | 31004 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 285 Chicago Way | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | Permit Number 34778 | 6002766.74364375 | 2086692.10708835 | 37.7098160865806 | -122.432208324272 | (37.7098160865806, -122.432208324272) | 9 | 7 | 6 | 28861 | 5 | ||
| 42240 | 42884 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2514 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/03/2000 12:00:00 AM | 4 | Permit Number 42805 | 5985844.8171 | 2098079.769 | 37.7401096713575 | -122.491530457619 | (37.7401096713575, -122.491530457619) | 1 | 8 | 3 | 29491 | 35 | |
| 42426 | 218261 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x Portola Dr | 19 | Median : Yard | Tree | DPW 1 | 8 | 5992797.06764 | 2097201.38756 | 37.7381016895493 | -122.467428758544 | (37.7381016895493, -122.467428758544) | 1 | 8 | 4 | 59 | 40 | ||||
| 42595 | 59553 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/30/1981 12:00:00 AM | 9 | Permit Number 18938 | 6005363.02873 | 2118214.93321 | 37.7965173077913 | -122.425476975078 | (37.7965173077913, -122.425476975078) | 13 | 9 | 1 | 28858 | 17 | ||
| 43191 | 43520 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 720 Central Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | 5 | Permit Number 43195 | 5999637.6503 | 2111009.9076 | 37.776409033576 | -122.444769809105 | (37.776409033576, -122.444769809105) | 15 | 5 | 11 | 29492 | 16 | |
| 43794 | 32060 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3641 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1995 12:00:00 AM | 4 | Permit Number 35437 | 6004597.15155 | 2105983.21796 | 37.7628887345501 | -122.427255342182 | (37.7628887345501, -122.427255342182) | 8 | 4 | 5 | 28862 | 3 | |
| 43858 | 220926 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 99 Esmeralda Ave | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 5 | 6007313.3532 | 2098768.19788 | 37.7432311697946 | -122.417349591335 | (37.7432311697946, -122.417349591335) | 2 | 7 | 7 | 28859 | 2 | ||||
| 44792 | 58679 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2823 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/11/1979 12:00:00 AM | 11 | Permit Number 17907 | 5999510.1538 | 2118572.9915 | 37.7971680104441 | -122.445754889478 | (37.7971680104441, -122.445754889478) | 13 | 9 | 1 | 57 | 17 | ||
| 44986 | 54440 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 512 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1972 12:00:00 AM | 25 | Permit Number 10217 | 6014062.04664 | 2104690.51395 | 37.7598699757444 | -122.394428794276 | (37.7598699757444, -122.394428794276) | 10 | 3 | 8 | 28856 | 29 | ||
| 45242 | 53793 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 258 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/08/1972 12:00:00 AM | 5 | Permit Number 9485 | 5987461.74395 | 2114234.65378 | 37.784560908121 | -122.487126051666 | (37.784560908121, -122.487126051666) | 11 | 6 | 1 | 55 | 26 | ||
| 45623 | 45667 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3201 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2001 12:00:00 AM | 5 | Permit Number 44363 | 5999332.42339 | 2119845.91977 | 37.8006529814106 | -122.446461503008 | (37.8006529814106, -122.446461503008) | 13 | 9 | 1 | 57 | 17 | ||
| 45977 | 33246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2455 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/13/1996 12:00:00 AM | 3 | Permit Number 37427 | 5987953.5529 | 2098598.711 | 37.7416575568292 | -122.484277448664 | (37.7416575568292, -122.484277448664) | 1 | 8 | 3 | 29491 | 35 | |
| 46244 | 43503 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 414 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43181 | 6008275.24653868 | 2096942.34637883 | 37.7382718551597 | -122.413894474617 | (37.7382718551597, -122.413894474617) | 2 | 7 | 7 | 28859 | 2 | ||
| 46292 | 104895 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 300 Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | ||||||
| 46339 | 54188 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 758 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/25/2002 12:00:00 AM | Permit Number 40732 | 5994446.73850644 | 2089956.09273845 | 37.7183029732854 | -122.461200022537 | (37.7183029732854, -122.461200022537) | 9 | 8 | 6 | 28861 | 24 | ||
| 46398 | 65961 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2567 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1990 12:00:00 AM | 8 | Permit Number 28983 | 5987671.3147 | 2097818.6015 | 37.7394991439696 | -122.485196095129 | (37.7394991439696, -122.485196095129) | 1 | 8 | 3 | 29491 | 35 | ||
| 46569 | 92915 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 340 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
| 46940 | 44811 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2700x Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/2001 12:00:00 AM | Permit Number 43905 | 5986360 | 2105036 | 37.7592396918496 | -122.490260766294 | (37.7592396918496, -122.490260766294) | 1 | 8 | 3 | 56 | 35 | ||
| 47074 | 31181 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 521 Shields St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/21/1995 12:00:00 AM | Permit Number 34879 | 5992668.86925851 | 2089822.40668247 | 37.7178334279778 | -122.467335598289 | (37.7178334279778, -122.467335598289) | 9 | 8 | 6 | 64 | 24 | ||
| 47417 | 188251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013763.34518 | 2089782.1261 | 37.7189180360183 | -122.394417981716 | (37.7189180360183, -122.394417981716) | 10 | 3 | 8 | 58 | 1 | ||||
| 47923 | 62828 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1868 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/08/1986 12:00:00 AM | Permit Number 23193 | 6000301.60270907 | 2093170.70232582 | 37.7274647632092 | -122.441192796651 | (37.7274647632092, -122.441192796651) | 9 | 7 | 6 | 28861 | 25 | ||
| 48295 | 54813 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 330 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/10/1972 12:00:00 AM | 10 | Permit Number 10667 | 5997647.89997 | 2115270.37281 | 37.7879934021327 | -122.451960326717 | (37.7879934021327, -122.451960326717) | 11 | 6 | 1 | 54 | 31 | ||
| 49500 | 204570 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 404 Baden St | 2 | Side Yard : Yard | Tree | Private 2 | 3 | 6000772.02371 | 2095261.55097 | 37.733232536033 | -122.43971638892 | (37.733232536033, -122.43971638892) | 9 | 7 | 5 | 63 | 40 | ||||
| 49572 | 188879 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 800 Vermont St | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6011290.47515 | 2104318.93293 | 37.7586952354223 | -122.403988209898 | (37.7586952354223, -122.403988209898) | 10 | 3 | 8 | 28856 | 29 | ||||
| 49667 | 53512 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1362 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12547 | 6016030.8057 | 2093035.8489 | 37.727977908748 | -122.38680697572 | (37.727977908748, -122.38680697572) | 10 | 3 | 8 | 58 | 1 | ||
| 49756 | 116671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 Esmeralda Ave | 7 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 49776 | 42833 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
| 49942 | 205754 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Terrace Dr | 35 | Median : Yard | Tree | DPW 1 | 5 | 5993872.8693 | 2096472.52816 | 37.7361624724174 | -122.46365632018 | (37.7361624724174, -122.46365632018) | 1 | 8 | 4 | 59 | 40 | ||||
| 50216 | 92917 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 346 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 5992028 | 2097000 | 37.7375043003581 | -122.470073124763 | (37.7375043003581, -122.470073124763) | 1 | 8 | 4 | 59 | 40 | ||||
| 50381 | 188946 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 398 Quint St | 3 | Front Yard : Yard | Tree | Private 2 | 9 | 6015180.72711 | 2099016.74699 | 37.7443531342865 | -122.390163407814 | (37.7443531342865, -122.390163407814) | 10 | 3 | 8 | 58 | 1 | ||||
| 50425 | 42399 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Gennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | 9 | 7 | 4 | 59 | 40 | ||
| 50639 | 67344 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 845 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/27/1992 12:00:00 AM | Permit Number 30830 | 6010203.04777611 | 2104302.92364301 | 37.7585904623549 | -122.407747919472 | (37.7585904623549, -122.407747919472) | 10 | 4 | 7 | 28859 | 19 | ||
| 50699 | 67289 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1801 Silliman St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/22/1992 12:00:00 AM | Permit Number 30765 | 6005600.48989505 | 2092717.74835563 | 37.7265214644021 | -122.422842320006 | (37.7265214644021, -122.422842320006) | 9 | 7 | 7 | 309 | 5 | ||
| 50978 | 218223 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 399 Claremont Blvd | 2 | Side Yard : Yard | Tree | Private 2 | 12 | 5993474.17256 | 2097846.02445 | 37.73991076848 | -122.465134496264 | (37.73991076848, -122.465134496264) | 1 | 8 | 4 | 59 | 40 | ||||
| 52861 | 44282 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1588 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/27/2001 12:00:00 AM | Permit Number 43704 | 6014189.45600011 | 2095460.4720274 | 37.7345333093335 | -122.393342225003 | (37.7345333093335, -122.393342225003) | 10 | 3 | 8 | 58 | 1 | |||
| 53062 | 43620 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43271 | 5985386.76911027 | 2100967.4929928 | 37.7480118028434 | -122.493326874686 | (37.7480118028434, -122.493326874686) | 1 | 8 | 3 | 29491 | 35 | ||
| 53134 | 33548 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 252 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/1996 12:00:00 AM | Permit Number 37656 | 6007019.4634549 | 2097570.65263156 | 37.7399264382232 | -122.418280898297 | (37.7399264382232, -122.418280898297) | 2 | 7 | 7 | 28859 | 2 | |||
| 53139 | 64816 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3870 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/05/1989 12:00:00 AM | Permit Number 25825 | 6004739.34476521 | 2100487.63613572 | 37.7478071955981 | -122.426372239638 | (37.7478071955981, -122.426372239638) | 2 | 4 | 5 | 63 | 22 | ||
| 53380 | 39921 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1938 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/25/1999 12:00:00 AM | 4 | Permit Number 41195 | 6001498.9973 | 2115128.5111 | 37.7878237158389 | -122.43862607739 | (37.7878237158389, -122.43862607739) | 13 | 6 | 1 | 29490 | 27 | |
| 53878 | 63011 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 199 Powhattan Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/23/1986 12:00:00 AM | Permit Number 23425 | 6007777.05506636 | 2098194.1467313 | 37.7416810309377 | -122.415705589886 | (37.7416810309377, -122.415705589886) | 2 | 7 | 7 | 28859 | 2 | ||
| 54526 | 40684 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/10/1999 12:00:00 AM | Permit Number 41667 | 6004026.21190005 | 2093997.85413123 | 37.7299473965939 | -122.428375735336 | (37.7299473965939, -122.428375735336) | 9 | 7 | 6 | 28861 | 5 | ||
| 54574 | 54441 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 516 Mississippi St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/23/1972 12:00:00 AM | 12 | Permit Number 10218 | 6014063.35386 | 2104670.62124 | 37.7598154273534 | -122.394422880319 | (37.7598154273534, -122.394422880319) | 10 | 3 | 8 | 28856 | 29 | ||
| 54586 | 117116 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 76 Oakwood St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6005231.58471967 | 2105020.01841489 | 37.7602798751206 | -122.424992522324 | (37.7602798751206, -122.424992522324) | 2 | 4 | 5 | 28859 | 19 | ||||
| 54919 | 204381 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 47 Ralston St | 4 | Back Yard : Yard | Tree | Private 2 | 5 | 5992175.93878 | 2088248.61457 | 37.7134837071825 | -122.468924959729 | (37.7134837071825, -122.468924959729) | 9 | 8 | 6 | 64 | 24 | ||||
| 54937 | 31347 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 517 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/12/1995 12:00:00 AM | Permit Number 34958 | 6004983.34013269 | 2110750.23773381 | 37.7759996553204 | -122.426259058519 | (37.7759996553204, -122.426259058519) | 7 | 9 | 11 | 28852 | 10 | ||
| 54997 | 31001 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 285 Chicago Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/13/1995 12:00:00 AM | 9 | Permit Number 34778 | 6002746.71825 | 2086679.2341 | 37.709779604712 | -122.432276616899 | (37.709779604712, -122.432276616899) | 9 | 7 | 6 | 28861 | 5 | |
| 55188 | 175656 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5990014.12726 | 2089314.59531 | 37.716285489253 | -122.476474690052 | (37.716285489253, -122.476474690052) | 1 | 8 | 4 | 64 | 14 | ||||
| 55296 | 98116 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060 Pierce St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 23584 | 6001457.2753 | 2118966.43976 | 37.7983592955935 | -122.439045591788 | (37.7983592955935, -122.439045591788) | 13 | 9 | 1 | 57 | 17 | |||
| 55619 | 188884 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 861 Vermont St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6011309.01524 | 2104361.95853 | 37.7588144099776 | -122.403927117158 | (37.7588144099776, -122.403927117158) | 10 | 3 | 8 | 28856 | 29 | ||||
| 56078 | 38346 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1862 45th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/29/1998 12:00:00 AM | 3 | Permit Number 40413 | 5982280.7574 | 2102429.3074 | 37.7518433707941 | -122.504175425295 | (37.7518433707941, -122.504175425295) | 1 | 8 | 3 | 56 | 35 | |
| 56665 | 92931 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 323 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 5992282 | 2096978 | 37.7374585742898 | -122.469193334242 | (37.7374585742898, -122.469193334242) | 1 | 8 | 4 | 59 | 40 | ||||
| 57323 | 56315 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 234 09th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1973 12:00:00 AM | 12 | Permit Number 12449 | 5993086.94537 | 2113893.42731 | 37.7839503904288 | -122.467640101935 | (37.7839503904288, -122.467640101935) | 11 | 6 | 2 | 54 | 11 | ||
| 57324 | 104918 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 719 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990421 | 2090607 | 37.719857702396 | -122.475162650507 | (37.719857702396, -122.475162650507) | 1 | 8 | 4 | 64 | 40 | |||||
| 57668 | 64314 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 158 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/25/1988 12:00:00 AM | Permit Number 25131 | 6004545.85418713 | 2097571.72864017 | 37.739789842685 | -122.426833689992 | (37.739789842685, -122.426833689992) | 2 | 7 | 5 | 63 | 7 | ||
| 58552 | 42397 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 600 Gennessee St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42555 | 5997487.92419847 | 2095274.73436784 | 37.7330812596511 | -122.451071309951 | (37.7330812596511, -122.451071309951) | 9 | 7 | 4 | 59 | 40 | ||
| 58928 | 41287 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 80X Rosemont Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/19/2000 12:00:00 AM | Permit Number 771150 | 6005120.37250824 | 2107836.80061549 | 37.7680078062065 | -122.425577628833 | (37.7680078062065, -122.425577628833) | 8 | 4 | 5 | 28853 | 19 | ||
| 59223 | 66041 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 74 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/25/1990 12:00:00 AM | 13 | Permit Number 29080 | 6004614.4703 | 2093089.36495 | 37.7274861568572 | -122.426277398677 | (37.7274861568572, -122.426277398677) | 9 | 7 | 6 | 28861 | 5 | ||
| 59842 | 67242 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Hermann St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/08/1992 12:00:00 AM | 8 | Permit Number 30706 | 6003591.5003746 | 2108669.41865848 | 37.7702074667281 | -122.430925257683 | (37.7702074667281, -122.430925257683) | 15 | 9 | 11 | 29492 | 10 | |
| 59979 | 42834 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 Broadway | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/29/2000 12:00:00 AM | Permit Number 42767 | 6006419.40791846 | 2117956.96761218 | 37.7958686285947 | -122.421803333655 | (37.7958686285947, -122.421803333655) | 13 | 9 | 10 | 28858 | 32 | ||
| 60932 | 98117 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3060 Pierce St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Permit Number 23584 | 6001455.49775 | 2118981.69776 | 37.798401088908 | -122.439052836736 | (37.798401088908, -122.439052836736) | 13 | 9 | 1 | 57 | 17 |
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) );