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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
800 | 43502 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Gates St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.7383064636933 | -122.413905114955 | (37.7383064636933, -122.413905114955) | 2 | 7 | 7 | 28859 | 2 | ||
1234 | 74480 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982259.5223 | 2104870.2558 | 37.7585442772343 | -122.504429677037 | (37.7585442772343, -122.504429677037) | 1 | 8 | 3 | 56 | 35 | |||
1528 | 70442 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/26/2017 12:00:00 AM | 3 | Permit Number 780711 | 5983049.5384 | 2098315.9426 | 37.7405943893559 | -122.501212699104 | (37.7405943893559, -122.501212699104) | 1 | 8 | 3 | 29491 | 35 | |
2685 | 264708 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 4 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
2877 | 79593 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2407 Lincoln Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 5988231.6107 | 2107115.9609 | 37.7650598247176 | -122.483940431534 | (37.7650598247176, -122.483940431534) | 1 | 8 | 3 | 56 | 35 | |||
3122 | 74788 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982233.8553 | 2104870.2558 | 37.758542767533 | -122.504518443568 | (37.758542767533, -122.504518443568) | 1 | 8 | 3 | 56 | 35 | |||
3452 | 74635 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5982248.2166 | 2104869.6447 | 37.7585419343481 | -122.504468731299 | (37.7585419343481, -122.504468731299) | 1 | 8 | 3 | 56 | 35 | |||
3642 | 41464 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sweeny St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/06/2000 12:00:00 AM | 6 | Permit Number 42049 | 6010232.6367 | 2095048.38707 | 37.7331811829475 | -122.406993296305 | (37.7331811829475, -122.406993296305) | 10 | 3 | 7 | 309 | 28 | |
3736 | 38554 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1791 La Salle Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/17/1998 12:00:00 AM | 6 | Permit Number 40521 | 6014548.21389 | 2096859.31136 | 37.7383941607708 | -122.392199668106 | (37.7383941607708, -122.392199668106) | 10 | 3 | 8 | 58 | 1 | |
3826 | 78400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 735 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 5986604.8504 | 2110908.229 | 37.7753774919681 | -122.489845844887 | (37.7753774919681, -122.489845844887) | 11 | 6 | 2 | 55 | 26 | |||
4040 | 33572 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 154 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/26/1996 12:00:00 AM | Permit Number 37681 | 6007125.01151204 | 2098130.43275156 | 37.7414694106773 | -122.417955628165 | (37.7414694106773, -122.417955628165) | 2 | 7 | 7 | 28859 | 2 | |||
4132 | 78489 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3345 Ocean Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988664.39778 | 2095197.91873 | 37.7323612287764 | -122.481570599508 | (37.7323612287764, -122.481570599508) | 1 | 8 | 4 | 64 | 35 | |||
4178 | 31221 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 766 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/04/1995 12:00:00 AM | Permit Number 34908 | 5981084.03491617 | 2110503.52214182 | 37.7739423822297 | -122.508913237037 | (37.7739423822297, -122.508913237037) | 11 | 6 | 2 | 55 | 26 | |||
4199 | 78379 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Russia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6001615.3363 | 2090906.3588 | 37.7213221342777 | -122.436489223015 | (37.7213221342777, -122.436489223015) | 9 | 7 | 6 | 28861 | 5 | |||
4343 | 65663 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1991 12:00:00 AM | Permit Number 28583 | 5998824.47448758 | 2095859.96140736 | 37.7347645844735 | -122.446492607567 | (37.7347645844735, -122.446492607567) | 9 | 7 | 4 | 59 | 40 | ||
4569 | 104897 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 303 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990401 | 2090562 | 37.7197329843514 | -122.475228499286 | (37.7197329843514, -122.475228499286) | 1 | 8 | 4 | 64 | 14 | |||||
5159 | 83758 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1640 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11 | 6013046.15855 | 2104759.52511 | 37.7600029395994 | -122.397947120176 | (37.7600029395994, -122.397947120176) | 10 | 3 | 8 | 28856 | 29 | |||
5308 | 30814 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 145 Joost Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/06/1995 12:00:00 AM | 8 | Permit Number 34676 | 6001106.90976 | 2094917.71442 | 37.7323074960919 | -122.438533971982 | (37.7323074960919, -122.438533971982) | 9 | 7 | 4 | 63 | 40 | |
5826 | 78490 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3345 Ocean Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988631.47552 | 2095196.82107 | 37.7323563004975 | -122.481684337683 | (37.7323563004975, -122.481684337683) | 1 | 8 | 4 | 64 | 35 | |||
6979 | 42994 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 Yale St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/05/2000 12:00:00 AM | Permit Number 42870 | 6007553.67502493 | 2091408.33369541 | 37.7230361052022 | -122.415997529963 | (37.7230361052022, -122.415997529963) | 9 | 3 | 7 | 309 | 28 | ||
6980 | 43621 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2095 35th Ave | 1 | 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 | ||
7027 | 42067 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 201 Elsie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42379 | 6006853.95284376 | 2097931.35899667 | 37.7409075395301 | -122.418878742158 | (37.7409075395301, -122.418878742158) | 2 | 7 | 7 | 28859 | 2 | ||
7440 | 78070 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 818 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 4 | 6011825.39206 | 2104537.71061 | 37.7593258220597 | -122.402153592937 | (37.7593258220597, -122.402153592937) | 10 | 3 | 8 | 28856 | 29 | |||
7526 | 54915 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 491 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 10 | Permit Number 10781 | 6011237.02996 | 2106095.07508 | 37.7635691382211 | -122.404298060519 | (37.7635691382211, -122.404298060519) | 8 | 3 | 8 | 28856 | 29 | ||
7617 | 246440 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 485 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 12 | 6003368.11948 | 2099777.56573 | 37.745779900623 | -122.431063194026 | (37.745779900623, -122.431063194026) | 2 | 7 | 5 | 63 | 22 | ||||
7645 | 56389 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1338 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 14 | Permit Number 12542 | 6016160.8061 | 2092941.1028 | 37.7277249515347 | -122.386350953513 | (37.7277249515347, -122.386350953513) | 10 | 3 | 8 | 58 | 1 | ||
8725 | 60817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1150 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 3 | Permit Number 20495 | 5989806.3915 | 2101102.4889 | 37.7486399870467 | -122.478054033081 | (37.7486399870467, -122.478054033081) | 1 | 8 | 3 | 29491 | 35 | |
8871 | 72911 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1970 Scott St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001491.2891 | 2115220.1537 | 37.7880749043224 | -122.438659315373 | (37.7880749043224, -122.438659315373) | 13 | 6 | 1 | 29490 | 27 | |||
8896 | 56726 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1523 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Permit Number 769408 | 6015773.2097 | 2095596.9346 | 37.7349958716637 | -122.387876131204 | (37.7349958716637, -122.387876131204) | 10 | 3 | 8 | 58 | 1 | |||
9250 | 70168 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 5129 Anza St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5982718.93125 | 2111668.17193 | 37.7772364107813 | -122.503344205234 | (37.7772364107813, -122.503344205234) | 11 | 6 | 2 | 55 | 26 | |||
9270 | 97907 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2000 Chestnut St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/1994 12:00:00 AM | 8 | Permit Number 33440 | 6002166.03814 | 2119855.12291 | 37.8008396887472 | -122.436656706436 | (37.8008396887472, -122.436656706436) | 13 | 9 | 1 | 57 | 17 | ||
9504 | 74038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1501 25th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 3 | 6014092.75077 | 2101968.09189 | 37.7523964980076 | -122.394132008099 | (37.7523964980076, -122.394132008099) | 10 | 3 | 8 | 28856 | 1 | |||
9709 | 31362 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2295 17th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/21/1995 12:00:00 AM | 4 | Permit Number 34969 | 5991015.94012 | 2099809.33155 | 37.7451594448661 | -122.47377714392 | (37.7451594448661, -122.47377714392) | 1 | 8 | 4 | 29491 | 40 | |
9718 | 66871 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 350 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/18/1991 12:00:00 AM | Permit Number 30181 | 6001115.30809688 | 2104289.68730442 | 37.7580411890038 | -122.43917641405 | (37.7580411890038, -122.43917641405) | 2 | 4 | 5 | 28862 | 38 | ||
10174 | 73299 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1970 Scott St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001495.5714 | 2115163.912 | 37.7879207227072 | -122.438640467915 | (37.7879207227072, -122.438640467915) | 13 | 6 | 1 | 29490 | 27 | |||
10219 | 78797 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 85 Morse St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 1 | 6001030.80147 | 2087976.50512 | 37.7132441799408 | -122.438300000759 | (37.7132441799408, -122.438300000759) | 9 | 7 | 6 | 28861 | 5 | |||
10711 | 247134 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 500 27th St | 4 | Front Yard : Yard | Tree | Private 2 | 6 | 6003187.16367 | 2100094.09523 | 37.7466387612688 | -122.431711508093 | (37.7466387612688, -122.431711508093) | 2 | 7 | 5 | 63 | 22 | ||||
10882 | 32604 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1327 35th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/23/1996 12:00:00 AM | 6 | Permit Number 37070 | 5985214.1986 | 2106157.4162 | 37.7622518049359 | -122.494306102635 | (37.7622518049359, -122.494306102635) | 1 | 8 | 3 | 56 | 35 | |
10999 | 31902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 965 Natoma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 14 | Permit Number 35327 | 6008027.66279 | 2109898.08591 | 37.7738314549808 | -122.415667565898 | (37.7738314549808, -122.415667565898) | 8 | 2 | 9 | 28853 | 34 | |
11399 | 73153 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1970 Scott St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001494.4295 | 2115195.887 | 37.7880084528635 | -122.438646710686 | (37.7880084528635, -122.438646710686) | 13 | 6 | 1 | 29490 | 27 | |||
11604 | 54558 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 50 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 8 | Permit Number 10353 | 6012731.08144 | 2095469.91543 | 37.7344781060868 | -122.398385007285 | (37.7344781060868, -122.398385007285) | 10 | 3 | 8 | 58 | 1 | ||
12081 | 69044 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1426 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/06/1994 12:00:00 AM | 2 | Permit Number 33051 | 5984041.3218 | 2105444.0326 | 37.7602243472537 | -122.498309886187 | (37.7602243472537, -122.498309886187) | 1 | 8 | 3 | 56 | 35 | |
12114 | 78378 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 35 Russia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6001605.25452 | 2090913.72299 | 37.7213417817901 | -122.436524599656 | (37.7213417817901, -122.436524599656) | 9 | 7 | 6 | 28861 | 5 | |||
12381 | 65434 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 555 O'Farrell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/23/1999 12:00:00 AM | Permit Number 33170 | 6008638.12512872 | 2114173.69680574 | 37.785605560242 | -122.41385837708 | (37.785605560242, -122.41385837708) | 7 | 10 | 9 | 28852 | 36 | ||
12837 | 47215 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.47627 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | 9 | 7 | 7 | 309 | 5 | |
12868 | 111864 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 45 Allston Way | 1 | Front Yard : Yard | Tree | Private 2 | 06/26/2015 12:00:00 AM | 3 | Permit Number 775591 | 5994228.4 | 2098418 | 37.7415247340782 | -122.462568190827 | (37.7415247340782, -122.462568190827) | 1 | 8 | 4 | 59 | 40 | ||
13274 | 188254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013780.02718 | 2089753.49239 | 37.7188403408752 | -122.39435831441 | (37.7188403408752, -122.39435831441) | 10 | 3 | 8 | 58 | 1 | ||||
13378 | 73382 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 502 Broderick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 6001158.1468 | 2110520.1446 | 37.7751509205215 | -122.439474878934 | (37.7751509205215, -122.439474878934) | 15 | 5 | 11 | 29492 | 10 | |||
13380 | 55308 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1595 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/06/1972 12:00:00 AM | 10 | Permit Number 11237 | 6005282.80537 | 2119544.50402 | 37.8001634372533 | -122.425849253052 | (37.8001634372533, -122.425849253052) | 13 | 9 | 1 | 57 | 17 | ||
13824 | 101104 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1580 Noriega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25190 | 5989126.9 | 2103185.1 | 37.754318820325 | -122.480556110859 | (37.754318820325, -122.480556110859) | 1 | 8 | 3 | 56 | 35 | ||||
14011 | 247884 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 387 Mayflower St | 5 | Side Yard : Yard | Tree | Private 2 | 8 | 6009916.04567 | 2098399.55514 | 37.7423650480079 | -122.408324127476 | (37.7423650480079, -122.408324127476) | 10 | 7 | 7 | 28859 | 2 | ||||
14659 | 55328 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 225 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 8 | Permit Number 11259 | 6011565.54063 | 2089256.51546 | 37.717352394562 | -122.40197804257 | (37.717352394562, -122.40197804257) | 10 | 7 | 8 | 309 | 39 | ||
14974 | 71651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 177 Wilson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 5994505.19973 | 2086471.6739 | 37.7087389470079 | -122.460745569971 | (37.7087389470079, -122.460745569971) | 9 | 8 | 6 | 28861 | 25 | |||
15010 | 35807 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
15203 | 70396 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 309 Madison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 7 | 6005777.21829 | 2092245.96314 | 37.7252360153268 | -122.422197872442 | (37.7252360153268, -122.422197872442) | 9 | 7 | 7 | 309 | 5 | |||
15208 | 56135 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 719 Carolina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/1973 12:00:00 AM | 10 | Permit Number 12238 | 6012444.68154 | 2104578.12119 | 37.7594713278533 | -122.400014612979 | (37.7594713278533, -122.400014612979) | 10 | 3 | 8 | 28856 | 29 | ||
15293 | 78417 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3345 Ocean Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5988680.63361 | 2095198.47268 | 37.7323636938327 | -122.481514509695 | (37.7323636938327, -122.481514509695) | 1 | 8 | 4 | 64 | 35 | |||
15396 | 71222 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2207 28th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5987585.8685 | 2100255.6538 | 37.746185666387 | -122.485670338512 | (37.746185666387, -122.485670338512) | 1 | 8 | 3 | 29491 | 35 | |||
15502 | 78224 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 6009704.84764 | 2090538.93921 | 37.7207696402774 | -122.408500030351 | (37.7207696402774, -122.408500030351) | 9 | 3 | 7 | 309 | 28 | |||
15976 | 31863 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 550 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/1995 12:00:00 AM | Permit Number 35305 | 5994717.97074246 | 2111781.46316747 | 37.7782455405542 | -122.461844202225 | (37.7782455405542, -122.461844202225) | 11 | 6 | 2 | 54 | 11 | |||
16632 | 42238 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 479 Natoma St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | 3 | Permit Number 42487 | 6010497.26908 | 2112250.8624 | 37.7804301450699 | -122.407290649051 | (37.7804301450699, -122.407290649051) | 14 | 2 | 9 | 28853 | 34 | |
16704 | 30848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1153 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/1995 12:00:00 AM | 14 | Permit Number 34697 | 6002549.89906 | 2102133.17334 | 37.7522014449412 | -122.434060837652 | (37.7522014449412, -122.434060837652) | 2 | 4 | 5 | 28862 | 22 | |
16874 | 55307 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2770 Franklin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2012 12:00:00 AM | 2 | Permit Number 769514 | 6005272.5834 | 2119510.27332 | 37.8000688708465 | -122.42588218711 | (37.8000688708465, -122.42588218711) | 13 | 9 | 1 | 57 | 17 | ||
17307 | 74930 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4045 Kirkham St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5 | 5982222.2441 | 2104869.0336 | 37.7585387287405 | -122.50455850909 | (37.7585387287405, -122.50455850909) | 1 | 8 | 3 | 56 | 35 | |||
18314 | 204568 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 61 Burnside Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6001187.03477 | 2095752.39336 | 37.7346038888419 | -122.438316738047 | (37.7346038888419, -122.438316738047) | 2 | 7 | 5 | 63 | 7 | ||||
18481 | 37776 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 449 Felton St | 3 | 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 | ||
18867 | 53701 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 2656 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/1970 12:00:00 AM | 12 | Permit Number 6647 | 5999210.43552 | 2117936.02801 | 37.7954019613927 | -122.446746130351 | (37.7954019613927, -122.446746130351) | 13 | 9 | 1 | 57 | 17 | ||
19591 | 264707 | Private 9 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4345 Clement St | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 09/17/2020 12:00:00 AM | 3 | 5982064.28374 | 2113052.50483 | 37.7809988756405 | -122.505711450059 | (37.7809988756405, -122.505711450059) | 11 | 6 | 2 | 55 | 26 | |||
19634 | 53513 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1370 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/17/1973 12:00:00 AM | 11 | Permit Number 12550 | 6015991.6954 | 2093066.1456 | 37.7280589319949 | -122.386944294451 | (37.7280589319949, -122.386944294451) | 10 | 3 | 8 | 58 | 1 | ||
19661 | 175653 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988966.88544 | 2089648.46014 | 37.7171414055178 | -122.480118843736 | (37.7171414055178, -122.480118843736) | 1 | 8 | 4 | 64 | 14 | ||||
19862 | 32496 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 631 Andover St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 9 | Permit Number 37001 | 6007448.1287 | 2095989.14143 | 37.7356080772339 | -122.416686739725 | (37.7356080772339, -122.416686739725) | 2 | 7 | 7 | 28859 | 2 | |
19893 | 115197 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4400 25th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/19/2016 12:00:00 AM | Permit Number 774514 | 6001219.3 | 2101182.5 | 37.7495155185031 | -122.438594134479 | (37.7495155185031, -122.438594134479) | 2 | 4 | 5 | 28862 | 22 | |||
20386 | 49124 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 235 Santa Ana Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/14/2003 12:00:00 AM | Permit Number 46255 | 5992667.25802575 | 2095222.38841823 | 37.7326603583325 | -122.467733682241 | (37.7326603583325, -122.467733682241) | 9 | 8 | 4 | 59 | 40 | ||
20542 | 247885 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 387 Mayflower St | 6 | Side Yard : Yard | Tree | Private 2 | 11 | 6009895.87707 | 2098407.02536 | 37.7423844301873 | -122.408394391499 | (37.7423844301873, -122.408394391499) | 10 | 7 | 7 | 28859 | 2 | ||||
20794 | 60190 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/18/1982 12:00:00 AM | 10 | Permit Number 19735 | 6008544.7327 | 2110936.08659 | 37.776710612043 | -122.413952375309 | (37.776710612043, -122.413952375309) | 8 | 2 | 9 | 28853 | 34 | ||
21606 | 31808 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 90 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/1995 12:00:00 AM | 8 | Permit Number 35278 | 6001963.06642 | 2108140.07721 | 37.7686616230583 | -122.436520096744 | (37.7686616230583, -122.436520096744) | 15 | 5 | 5 | 29492 | 3 | |
21650 | 218260 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1400x Portola Dr | 18 | Median : Yard | Tree | DPW 1 | 12 | 5992795.95946 | 2097207.23373 | 37.738117677685 | -122.46743301504 | (37.738117677685, -122.46743301504) | 1 | 8 | 4 | 59 | 40 | ||||
21768 | 43501 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 401 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.7383064636933 | -122.413905114955 | (37.7383064636933, -122.413905114955) | 2 | 7 | 7 | 28859 | 2 | ||
21777 | 66859 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1116 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1991 12:00:00 AM | 4 | Permit Number 30166 | 5989755.3106 | 2099063.2795 | 37.7430378863443 | -122.478081600833 | (37.7430378863443, -122.478081600833) | 1 | 8 | 3 | 29491 | 35 | ||
21786 | 35811 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 51 Sycamore St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.7625808703221 | -122.420443179735 | (37.7625808703221, -122.420443179735) | 8 | 4 | 7 | 28859 | 19 | ||
22032 | 35268 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 27 Dawnview Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/17/1998 12:00:00 AM | Permit Number 38752 | 5998816.18300655 | 2100713.49368513 | 37.7480907448375 | -122.446870407724 | (37.7480907448375, -122.446870407724) | 2 | 5 | 5 | 63 | 38 | ||
22495 | 204586 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 231 Edna St | 2 | Side Yard : Yard | Tree | Private 2 | 14 | 5998760.41171 | 2095319.00684 | 37.7332755919857 | -122.446675184631 | (37.7332755919857, -122.446675184631) | 9 | 7 | 4 | 59 | 40 | ||||
22795 | 55186 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 352 Thornton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1972 12:00:00 AM | 13 | Permit Number 11096 | 6013396.91313 | 2094278.12637 | 37.7312427671323 | -122.395999500683 | (37.7312427671323, -122.395999500683) | 10 | 3 | 8 | 58 | 1 | ||
23196 | 37229 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1866 34th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/12/1998 12:00:00 AM | 3 | Permit Number 39793 | 5985694.0439 | 2102524.3888 | 37.7523045829279 | -122.492378977466 | (37.7523045829279, -122.492378977466) | 1 | 8 | 3 | 56 | 35 | |
23237 | 114665 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 480 Myra Way | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 5997245.35324946 | 2096954.8836892 | 37.737680654694 | -122.452031115145 | (37.737680654694, -122.452031115145) | 9 | 7 | 4 | 59 | 40 | ||||
23301 | 121802 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1235 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 6008587.55783 | 2110975.09573 | 37.776820126979 | -122.413806990012 | (37.776820126979, -122.413806990012) | 8 | 2 | 9 | 28853 | 34 | ||||
23306 | 92939 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 363 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 5992054.1 | 2096847.4 | 37.7370868080983 | -122.469971777828 | (37.7370868080983, -122.469971777828) | 1 | 8 | 4 | 59 | 40 | ||||
23405 | 30475 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 424 Union St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/1956 12:00:00 AM | 8 | Permit Number 123 | 6010870.8148 | 2119673.484 | 37.8008317865696 | -122.406521568491 | (37.8008317865696, -122.406521568491) | 3 | 1 | 10 | 308 | 23 | ||
23424 | 188870 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1300x De Haro St | 30 | Median : Yard | Tree | DPW 1 | 15 | 6012283.09076 | 2102020.40062 | 37.7524393767806 | -122.400393822023 | (37.7524393767806, -122.400393822023) | 10 | 3 | 8 | 28856 | 29 | ||||
23528 | 42672 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 581 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/2000 12:00:00 AM | 4 | Permit Number 42700 | 6008565.6692 | 2121051.5528 | 37.8044863886348 | -122.414595938174 | (37.8044863886348, -122.414595938174) | 3 | 1 | 10 | 308 | 23 | |
23892 | 57845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 153 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/08/1977 12:00:00 AM | 10 | Permit Number 16786 | 6004375.10165 | 2094347.97988 | 37.7309284999329 | -122.427194511121 | (37.7309284999329, -122.427194511121) | 9 | 7 | 6 | 28861 | 5 | ||
24046 | 42102 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 324 Gennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/21/2000 12:00:00 AM | Permit Number 42408 | 5997476.85720986 | 2094482.06690448 | 37.7309041502726 | -122.451052430403 | (37.7309041502726, -122.451052430403) | 9 | 7 | 4 | 59 | 40 | ||
24325 | 69162 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1201 43rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1994 12:00:00 AM | 6 | Permit Number 33199 | 5982705.2838 | 2106882.9636 | 37.7640968091015 | -122.503037064776 | (37.7640968091015, -122.503037064776) | 1 | 8 | 3 | 56 | 35 | |
24420 | 55329 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 241 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 10 | Permit Number 11260 | 6011497.74978 | 2089236.66648 | 37.7172941095093 | -122.402210970564 | (37.7172941095093, -122.402210970564) | 10 | 7 | 8 | 309 | 39 | ||
24921 | 62865 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 124 Gates St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23233 | 6008284.66656741 | 2098013.35376974 | 37.7412131353607 | -122.413937647032 | (37.7412131353607, -122.413937647032) | 2 | 7 | 7 | 28859 | 2 | ||
25635 | 47841 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 4424 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/14/2002 12:00:00 AM | 3 | Permit Number 45602 | 5981838.80851 | 2110330.17409 | 37.7735108832884 | -122.506289537608 | (37.7735108832884, -122.506289537608) | 11 | 6 | 2 | 55 | 26 | |
25945 | 62056 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1700 Beach St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/12/1985 12:00:00 AM | 8 | Permit Number 22136 | 6002013.39133 | 2121163.89045 | 37.8044245429292 | -122.437278691955 | (37.8044245429292, -122.437278691955) | 13 | 9 | 1 | 57 | 17 | ||
26052 | 94065 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 98 Ney St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Tree 5 on Craut | 6004036 | 2094004 | 37.7299648256421 | -122.428342334562 | (37.7299648256421, -122.428342334562) | 9 | 7 | 6 | 28861 | 5 | ||||
26126 | 43383 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 841 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43131 | 6001927.7573942 | 2101646.83292556 | 37.7508307421205 | -122.436177496021 | (37.7508307421205, -122.436177496021) | 2 | 4 | 5 | 28862 | 22 | ||
26162 | 205755 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 200x Terrace Dr | 36 | Median : Yard | Tree | DPW 1 | 5 | 5993878.86602 | 2096471.77214 | 37.7361607421118 | -122.463635532375 | (37.7361607421118, -122.463635532375) | 1 | 8 | 4 | 59 | 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) );