Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 63 | 63 | 222541 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Newburg St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | Permit Number 779491 | 6002580.9472199995 | 2099999.66602 | 37.7463450993615 | -122.433800991143 | (37.7463450993615, -122.433800991143) | ||
| 81 | 81 | 221366 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 55 Homestead St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/22/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 778991 | 6000992.93047 | 2101385.53728 | 37.750060130381605 | -122.439391477336 | (37.7500601303816, -122.439391477336) | |
| 232 | 232 | 2726 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2211 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002817.4873 | 2114756.5606 | 37.7868773504916 | -122.43403775447099 | (37.7868773504916, -122.434037754471) | |||
| 932 | 932 | 7693 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008532.7031 | 2121045.4305 | 37.804467726204 | -122.41470958714899 | (37.804467726204, -122.414709587149) | |||
| 1091 | 1091 | 110107 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4130 MORAGA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/2016 12:00:00 AM | 15 | 3x3 | Permit Number 774958 | 5981430.4 | 2103553.9 | 37.7548811373619 | -122.507199448976 | (37.7548811373619, -122.507199448976) | |
| 1162 | 1162 | 251437 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3377 Market St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5999965.0 | 2104239.0 | 37.7578364910366 | -122.443151017453 | (37.7578364910366, -122.443151017453) | ||||
| 1503 | 1503 | 220995 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 610 Clipper St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 779880 | 6001157.49823 | 2100904.8155400003 | 37.748749547471206 | -122.438787950406 | (37.7487495474712, -122.438787950406) | |
| 1563 | 1563 | 125822 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2301 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6003751.95692 | 2115935.8856900004 | 37.7901684673368 | -122.43088890270398 | (37.7901684673368, -122.430888902704) | |||
| 1792 | 1792 | 200049 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1590 Shafter Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6015007.7446 | 2094143.437 | 37.7309624265756 | -122.390421112537 | (37.7309624265756, -122.390421112537) | |||
| 1803 | 1803 | 200050 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1590 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6014991.2562 | 2094154.9788 | 37.730993203361 | -122.39047892232401 | (37.730993203361, -122.390478922324) | |||
| 1806 | 1806 | 200048 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1590 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6015017.0879999995 | 2094135.7424 | 37.7309418170544 | -122.39038827315399 | (37.7309418170544, -122.390388273154) | |||
| 1895 | 1895 | 222302 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 151 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x4 | 6007412.8768 | 2100213.34589 | 37.7472048215433 | -122.41710784185499 | (37.7472048215433, -122.417107841855) | |||
| 1994 | 1994 | 42166 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 354 05th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011846.02554 | 2111882.36991 | 37.77949374398221 | -122.402598720465 | (37.7794937439822, -122.402598720465) | ||
| 2014 | 2014 | 42165 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 354 05th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | 4 | Permit Number 779305 | 6011856.41574 | 2111871.95313 | 37.7794657219919 | -122.40256204342501 | (37.7794657219919, -122.402562043425) | ||
| 2935 | 2935 | 246004 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999001.0122 | 2108580.4285 | 37.7697019524613 | -122.44679725758199 | (37.7697019524613, -122.446797257582) | |||
| 3004 | 3004 | 246005 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Ashbury St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998995.5612 | 2108615.5567 | 37.7697980941931 | -122.446818640382 | (37.7697980941931, -122.446818640382) | |||
| 3006 | 3006 | 246006 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 600 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998992.533 | 2108633.4236 | 37.7698469791765 | -122.446830400622 | (37.7698469791765, -122.446830400622) | |||
| 3012 | 3012 | 222459 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 103 Germania St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 12 | Width 3ft | Permit Number 37768 | 6003745.35961 | 2108826.05534 | 37.7706462694291 | -122.430404237367 | (37.7706462694291, -122.430404237367) | |
| 3036 | 3036 | 182177 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5988865.0 | 2104441.0 | 37.7577519603078 | -122.48155379203999 | (37.7577519603078, -122.48155379204) | |||
| 3038 | 3038 | 182175 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5988757.0 | 2104389.0 | 37.757602901925104 | -122.481923487166 | (37.7576029019251, -122.481923487166) | |||
| 3041 | 3041 | 182178 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5988865.0 | 2104441.0 | 37.7577519603078 | -122.48155379203999 | (37.7577519603078, -122.48155379204) | |||
| 3042 | 3042 | 182176 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5988865.0 | 2104441.0 | 37.7577519603078 | -122.48155379203999 | (37.7577519603078, -122.48155379204) | |||
| 3373 | 3373 | 7694 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 581 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008552.9537 | 2121047.3143 | 37.8044740363975 | -122.414639641316 | (37.8044740363975, -122.414639641316) | |||
| 3450 | 3450 | 12305 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 916 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004841.0657 | 2112154.2707 | 37.779846742390106 | -122.426851238143 | (37.7798467423901, -122.426851238143) | |||
| 3597 | 3597 | 2727 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2211 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002841.2741 | 2114762.0117 | 37.7868936677446 | -122.433955847511 | (37.7868936677446, -122.433955847511) | |||
| 3606 | 3606 | 220870 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1305 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2014 12:00:00 AM | 1 | Width 4ft | Permit Number 771153 | 5998204.3493099995 | 2105944.91927 | 37.762419969235 | -122.449362963227 | (37.762419969235, -122.449362963227) | |
| 4173 | 4173 | 9876 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1505 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | 6005371.567000001 | 2114888.4319 | 37.7873840540746 | -122.425210607423 | (37.7873840540746, -122.425210607423) | |||
| 4343 | 4343 | 13198 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2125 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002212.7759 | 2119440.8173 | 37.799704770189 | -122.436465304667 | (37.799704770189, -122.436465304667) | |||
| 4369 | 4369 | 222216 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | Width 3ft | Permit Number 780743 | 6002014.89564 | 2096488.79408 | 37.7366729276156 | -122.435507211887 | (37.7366729276156, -122.435507211887) | ||
| 5309 | 5309 | 7322 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2020 Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6002943.5503 | 2115286.7425 | 37.7883402486731 | -122.43363951152 | (37.7883402486731, -122.43363951152) | |||
| 5358 | 5358 | 13246 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2361 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001096.9833 | 2119276.5389 | 37.7991902392326 | -122.440314559231 | (37.7991902392326, -122.440314559231) | |||
| 5803 | 5803 | 22598 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 835 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005965.95079 | 2112761.85116 | 37.7815785478641 | -122.42300295452401 | (37.7815785478641, -122.423002954524) | |||
| 5932 | 5932 | 22599 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 835 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005992.6226 | 2112765.71653 | 37.7815906662302 | -122.422910957475 | (37.7815906662302, -122.422910957475) | |||
| 6097 | 6097 | 13288 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2639 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999748.1213 | 2119120.526 | 37.7986849783519 | -122.44497084658899 | (37.7986849783519, -122.444970846589) | |||
| 6370 | 6370 | 13272 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2499X Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000478.6195 | 2119188.7816 | 37.7989140544396 | -122.44244799989201 | (37.7989140544396, -122.442447999892) | |||
| 6417 | 6417 | 18979 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2916 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000692.61661 | 2115558.6800700002 | 37.7889589430353 | -122.4414468761 | (37.7889589430353, -122.4414468761) | |||
| 6583 | 6583 | 9878 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1515 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4X4 | 6005350.7284 | 2115053.9831 | 37.787837439149 | -122.425294489862 | (37.787837439149, -122.425294489862) | |||
| 6765 | 6765 | 7321 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2020 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6002947.4804 | 2115269.8991 | 37.7882942239799 | -122.43362470978799 | (37.7882942239799, -122.433624709788) | |||
| 7260 | 7260 | 9879 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1515 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6005356.5169 | 2115030.8291 | 37.7877741910602 | -122.42527281445 | (37.7877741910602, -122.42527281445) | |||
| 7607 | 7607 | 5218 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 923 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2X3 | 6001447.2358 | 2111647.0619 | 37.778261599821896 | -122.43855561900499 | (37.7782615998219, -122.438555619005) | |||
| 7769 | 7769 | 13131 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1727 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 6003964.7125 | 2119675.6431 | 37.8004489355963 | -122.43041972679701 | (37.8004489355963, -122.430419726797) | |||
| 8033 | 8033 | 13273 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2499X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000515.185 | 2119195.2822 | 37.7989339874751 | -122.442321938486 | (37.7989339874751, -122.442321938486) | |||
| 8157 | 8157 | 8714 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3134 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5997363.0327 | 2113062.182 | 37.7819139740148 | -122.452786470687 | (37.7819139740148, -122.452786470687) | |||
| 8444 | 8444 | 13167 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1906 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/26/1993 12:00:00 AM | 26 | 3X3 | 6003216.0169 | 2119655.6641 | 37.8003516396791 | -122.433009083838 | (37.8003516396791, -122.433009083838) | ||
| 8506 | 8506 | 9875 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1505 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6005369.2516 | 2114917.3744 | 37.7874633921653 | -122.425220678493 | (37.7874633921653, -122.425220678493) | |||
| 8524 | 8524 | 12306 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 916 Laguna St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004837.4799 | 2112172.7972 | 37.7798974088486 | -122.42686496280899 | (37.7798974088486, -122.426864962809) | |||
| 8730 | 8730 | 97454 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 758 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/11/2011 12:00:00 AM | 3 | 3x3 | 6007159.12761 | 2121599.09194 | 37.805910669901294 | -122.41950228141899 | (37.8059106699013, -122.419502281419) | |
| 8855 | 8855 | 9874 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1505 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4x4 | 6005366.9362 | 2114940.5284 | 37.787526836475394 | -122.42523033753 | (37.7875268364754, -122.42523033753) | |||
| 9374 | 9374 | 86958 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 80 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000699.0 | 2098232.0 | 37.7413845365366 | -122.440181788906 | (37.7413845365366, -122.440181788906) | |||
| 9716 | 9716 | 138189 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1837 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003405.7885 | 2115073.4289 | 37.7877807602684 | -122.43202500502701 | (37.7877807602684, -122.432025005027) | |||
| 10100 | 10100 | 42164 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 05th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/21/2000 12:00:00 AM | Permit Number 42459 | 6011853.6 | 2111898.2 | 37.779537632618705 | -122.40257363052 | (37.7795376326187, -122.40257363052) | |||
| 10158 | 10158 | 44811 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2700x Kirkham St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2001 12:00:00 AM | Permit Number 43905 | 5986360.0 | 2105036.0 | 37.7592396918496 | -122.490260766294 | (37.7592396918496, -122.490260766294) | ||
| 10603 | 10603 | 15752 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4650 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6001867.7453 | 2091760.7427 | 37.7236824200899 | -122.435677812364 | (37.7236824200899, -122.435677812364) | |||
| 10623 | 10623 | 97764 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400X Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6001442.97937 | 2088937.5583900001 | 37.715906453794 | -122.43694413518601 | (37.715906453794, -122.436944135186) | |||
| 10927 | 10927 | 24271 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001388.30533 | 2086462.2685599998 | 37.70910674815379 | -122.436956008017 | (37.7091067481538, -122.436956008017) | |||
| 10937 | 10937 | 15758 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4709 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6001757.7313 | 2091475.0143 | 37.72289162485271 | -122.43603767508101 | (37.7228916248527, -122.436037675081) | |||
| 10942 | 10942 | 4875 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6000876.37429 | 2097986.48313 | 37.7407205018559 | -122.43955089567801 | (37.7407205018559, -122.439550895678) | |||
| 11017 | 11017 | 15749 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4620 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002012.6233 | 2091985.3851 | 37.7243074656115 | -122.435193054818 | (37.7243074656115, -122.435193054818) | |||
| 11032 | 11032 | 24272 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001382.61488 | 2086464.9875900003 | 37.7091138905754 | -122.43697586956301 | (37.7091138905754, -122.436975869563) | |||
| 11159 | 11159 | 27098 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 681 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6005904.97939 | 2093585.43761 | 37.728921125007204 | -122.421851317801 | (37.7289211250072, -122.421851317801) | |||
| 11289 | 11289 | 24269 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001399.20674 | 2086458.92155 | 37.7090981776115 | -122.43691809171999 | (37.7090981776115, -122.43691809172) | |||
| 11327 | 11327 | 15737 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4509 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002463.4528 | 2092593.7586 | 37.7260035131187 | -122.433678063335 | (37.7260035131187, -122.433678063335) | |||
| 11516 | 11516 | 112475 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1799X Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988753.5421 | 2104412.2034 | 37.7576664111078 | -122.48193714554199 | (37.7576664111078, -122.481937145542) | |||
| 11666 | 11666 | 108844 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 420 Woolsey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | Permit Number 772583 | 6010500.63404 | 2091864.14228 | 37.724452908148606 | -122.405842528314 | (37.7244529081486, -122.405842528314) | |
| 11941 | 11941 | 116686 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002102.67453 | 2092656.42028 | 37.7261550900614 | -122.43492972844 | (37.7261550900614, -122.43492972844) | |||
| 12112 | 12112 | 15753 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4650 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001853.0947 | 2091735.5112 | 37.7236123079051 | -122.43572665254999 | (37.7236123079051, -122.43572665255) | |||
| 12255 | 12255 | 97766 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 400X Amazon Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6001498.9346199995 | 2088909.8627799999 | 37.71583358803421 | -122.436748746672 | (37.7158335880342, -122.436748746672) | |||
| 12399 | 12399 | 27110 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 507 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 8 | 3x3 | 6004770.57223 | 2093533.93769 | 37.728715677564395 | -122.425769383358 | (37.7287156775644, -122.425769383358) | ||
| 12443 | 12443 | 1098 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2319 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999519.61819 | 2089252.78521 | 37.7166624877513 | -122.44361477910299 | (37.7166624877513, -122.443614779103) | |||
| 12602 | 12602 | 15747 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4596 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002118.4331 | 2092158.7505 | 37.724789495929606 | -122.434839677987 | (37.7247894959296, -122.434839677987) | |||
| 12766 | 12766 | 31651 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3530 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/02/2016 12:00:00 AM | 3 | Permit Number 778640 | 5981977.0239 | 2096750.5895 | 37.736233320022 | -122.50480501648701 | (37.736233320022, -122.504805016487) | |
| 12804 | 12804 | 113544 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 182 Gambier St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6005841.47064 | 2092905.54198 | 37.7270506988092 | -122.42202259277398 | (37.7270506988092, -122.422022592774) | |||
| 12815 | 12815 | 1189 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3027 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/26/1995 12:00:00 AM | 10 | 3X3 | 5996602.206590001 | 2087199.5988900003 | 37.710858092411605 | -122.45355059790701 | (37.7108580924116, -122.453550597907) | ||
| 13019 | 13019 | 24270 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300X Winding Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6001396.0736 | 2086458.9864 | 37.709098177596005 | -122.436928924942 | (37.709098177596, -122.436928924942) | |||
| 13352 | 13352 | 32080 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3851 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2017 12:00:00 AM | 3 | 3x3 | Permit Number 51784 | 6003941.65438147 | 2105363.49480285 | 37.761150030842295 | -122.42947828104799 | (37.7611500308423, -122.429478281048) | |
| 13540 | 13540 | 27121 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2335 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2002 12:00:00 AM | 12 | 2x2 | 6013101.69827 | 2096426.31583 | 37.7371248216631 | -122.39717069499599 | (37.7371248216631, -122.397170694996) | ||
| 13636 | 13636 | 10904 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1336 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017110.58947 | 2095748.7321799998 | 37.7354866750771 | -122.38326285221001 | (37.7354866750771, -122.38326285221) | |||
| 13667 | 13667 | 109904 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 224 12th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779440 | 6007796.5595 | 2109021.55143 | 37.7714117049152 | -122.41640489308 | (37.7714117049152, -122.41640489308) | |
| 13724 | 13724 | 4898 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017985.0017 | 2094485.55993 | 37.7320665362465 | -122.380151894906 | (37.7320665362465, -122.380151894906) | |||
| 14242 | 14242 | 10905 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1336 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6017099.8174 | 2095796.95321 | 37.735618485109995 | -122.38330345120899 | (37.73561848511, -122.383303451209) | |||
| 14277 | 14277 | 28892 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 525 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/11/2006 12:00:00 AM | 3 | 3x3 | 6013279.98389 | 2111799.84006 | 37.7793470888229 | -122.397632224368 | (37.7793470888229, -122.397632224368) | ||
| 14360 | 14360 | 5802 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 218X Cashmere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6016122.2563 | 2096227.4462099997 | 37.736746459772604 | -122.386713296401 | (37.7367464597726, -122.386713296401) | |||
| 14668 | 14668 | 105550 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6017193.2263 | 2092868.7457 | 37.727583366960204 | -122.382776791229 | (37.7275833669602, -122.382776791229) | |||
| 15035 | 15035 | 108029 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1308 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6017326.2062 | 2092992.2495 | 37.727929830314295 | -122.382325662572 | (37.7279298303143, -122.382325662572) | |||
| 15053 | 15053 | 100251 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 540 Delancey St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6015234.41692 | 2113622.27838 | 37.7844597292764 | -122.390998376191 | (37.7844597292764, -122.390998376191) | |||
| 15093 | 15093 | 5801 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 218X Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6016115.70396 | 2096246.37508 | 37.736798071860704 | -122.386737270517 | (37.7367980718607, -122.386737270517) | |||
| 15178 | 15178 | 67715 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 472 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 8 | 3x3 | Permit Number 31328 | 6013692.95356 | 2112582.14451 | 37.781518105329795 | -122.39625842359399 | (37.7815181053298, -122.396258423594) |
| 15440 | 15440 | 122718 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 472 Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6014329.5757 | 2104932.99379 | 37.760550641114 | -122.393520505067 | (37.760550641114, -122.393520505067) | |||
| 16158 | 16158 | 27173 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2240 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012904.02749 | 2096271.59206 | 37.736688976016104 | -122.39784328714701 | (37.7366889760161, -122.397843287147) | ||
| 16354 | 16354 | 43351 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 385 08th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1977 12:00:00 AM | 26 | 3x3 | Permit Number 43103 | 6010005.031690001 | 2109964.91982 | 37.7741259209126 | -122.408832212936 | (37.7741259209126, -122.408832212936) | |
| 16440 | 16440 | 105549 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6017207.7562 | 2092857.3745 | 37.72755294661221 | -122.38272576976802 | (37.7275529466122, -122.382725769768) | |||
| 16462 | 16462 | 5800 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Dukes Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X4 | 6016181.284109999 | 2096289.1674099998 | 37.7369192015603 | -122.38651351199199 | (37.7369192015603, -122.386513511992) | |||
| 16623 | 16623 | 4897 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018099.28954 | 2094405.0263599998 | 37.731851711585996 | -122.37975117949 | (37.731851711586, -122.37975117949) | |||
| 16806 | 16806 | 29053 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 340 11th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2005 12:00:00 AM | 3 | 3x3 | 6008751.0689900005 | 2108844.78645 | 37.770979979973 | -122.413090685387 | (37.770979979973, -122.413090685387) | ||
| 16821 | 16821 | 7409 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1074 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6010471.6875 | 2111110.7430000002 | 37.7772982123977 | -122.40729875221399 | (37.7772982123977, -122.407298752214) | |||
| 16916 | 16916 | 4369 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 989 Chenery St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001020.80227 | 2096135.40108 | 37.7356460826069 | -122.438918897095 | (37.7356460826069, -122.438918897095) | |||
| 16917 | 16917 | 3443 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 21 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 3X3 | 5999529.741909999 | 2099788.8465400003 | 37.745592625791296 | -122.444336516539 | (37.7455926257913, -122.444336516539) | |||
| 16979 | 16979 | 10038 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005474.31982 | 2106984.12162 | 37.7656865461171 | -122.424292710045 | (37.7656865461171, -122.424292710045) | |||
| 17023 | 17023 | 4229 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3987 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003999.73105 | 2100398.02374 | 37.7475193045808 | -122.428923399303 | (37.7475193045808, -122.428923399303) | |||
| 17059 | 17059 | 4483 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1556 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004548.2822199995 | 2099779.76153 | 37.745852733114795 | -122.42698251575199 | (37.7458527331148, -122.426982515752) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");