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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 77897 | 77897 | 105128 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1835 47TH AVE | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774579 | 5981612.2 | 2102591.6 | 37.752249639902296 | -122.506499383522 | (37.7522496399023, -122.506499383522) | |
| 84395 | 84395 | 104895 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300 Gonzalez Dr | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | ||||||
| 112197 | 112197 | 104793 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700 39th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 5983853.5987599995 | 2111004.1266 | 37.775479771007205 | -122.499370005427 | (37.7754797710072, -122.499370005427) | ||||
| 117796 | 117796 | 86756 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3630 18th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2007 12:00:00 AM | 3x3 | Permit Number 49737 | 6005363.0 | 2105488.0 | 37.7615722645382 | -122.42457130775101 | (37.7615722645382, -122.424571307751) | |||
| 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) | |
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17138 | 17138 | 4856 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 9 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6000665.42788 | 2098259.03827 | 37.7414568658316 | -122.440299807886 | (37.7414568658316, -122.440299807886) | |||
| 17412 | 17412 | 3442 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 18 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 5999499.82966 | 2099767.63619 | 37.7455326806019 | -122.444438424118 | (37.7455326806019, -122.444438424118) | |||
| 17685 | 17685 | 1341 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 172 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5999321.34336 | 2099380.66579 | 37.7444599674701 | -122.44502778580299 | (37.7444599674701, -122.445027785803) | |||
| 17737 | 17737 | 4853 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3X3 | 6000632.86051 | 2098307.8213299997 | 37.7415889582704 | -122.440415912169 | (37.7415889582704, -122.440415912169) | |||
| 17767 | 17767 | 5138 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2885 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1992 12:00:00 AM | 6 | 2x2 | 6002423.3211199995 | 2095400.94978 | 37.7337091452519 | -122.434017371606 | (37.7337091452519, -122.434017371606) | ||
| 17809 | 17809 | 16092 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 286 Monterey Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2014 12:00:00 AM | 3 | 3x3 | 6000192.86492 | 2094709.10895 | 37.73168267679839 | -122.44167906036002 | (37.7316826767984, -122.44167906036) | ||
| 17960 | 17960 | 3459 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 62 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999653.670059999 | 2099474.18097 | 37.7447356995905 | -122.44388538959998 | (37.7447356995905, -122.4438853896) | |||
| 17970 | 17970 | 10345 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 954 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6001545.3048 | 2109077.8189 | 37.7712126807777 | -122.43803227825 | (37.7712126807777, -122.43803227825) | |||
| 17983 | 17983 | 35807 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/22/1998 12:00:00 AM | Permit Number 39051 | 6006563.61712831 | 2105830.66384173 | 37.762580870322104 | -122.42044317973499 | (37.7625808703221, -122.420443179735) | ||
| 18065 | 18065 | 3438 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 5999496.088930001 | 2099864.34678 | 37.745798011161604 | -122.444458308101 | (37.7457980111616, -122.444458308101) | |||
| 18267 | 18267 | 3460 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 66 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5999690.18055 | 2099466.98031 | 37.74471801084229 | -122.44375862655501 | (37.7447180108423, -122.443758626555) | |||
| 18279 | 18279 | 4484 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1566 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1990 12:00:00 AM | 12 | 3X3 | 6004549.88502 | 2099732.13285 | 37.7457220463542 | -122.42697358187701 | (37.7457220463542, -122.426973581877) | ||
| 18393 | 18393 | 65663 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 28583 | 5998824.47448758 | 2095859.96140736 | 37.7347645844735 | -122.44649260756701 | (37.7347645844735, -122.446492607567) | ||
| 18431 | 18431 | 1350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 261 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 5999733.43875 | 2099278.43357 | 37.7442027739306 | -122.443595506633 | (37.7442027739306, -122.443595506633) | |||
| 18490 | 18490 | 90663 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984396.70061 | 2110421.43862 | 37.7739117254104 | -122.497448288038 | (37.7739117254104, -122.497448288038) | ||
| 18698 | 18698 | 4862 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 22 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000700.353999999 | 2098195.46944 | 37.7412843093321 | -122.44017448827299 | (37.7412843093321, -122.440174488273) | |||
| 18724 | 18724 | 4858 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 16 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6000671.66564 | 2098216.18353 | 37.7413395519912 | -122.440275167373 | (37.7413395519912, -122.440275167373) | |||
| 18741 | 18741 | 112413 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 469x IVY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005169.0 | 2110996.0 | 37.7766849510116 | -122.425634307332 | (37.7766849510116, -122.425634307332) | ||||
| 18774 | 18774 | 3456 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999576.30354 | 2099521.60011 | 37.7448614877731 | -122.444156313979 | (37.7448614877731, -122.444156313979) | |||
| 18988 | 18988 | 16343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | ||
| 19049 | 19049 | 19343 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 521 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5992618.01059 | 2089830.6740400002 | 37.7178531919595 | -122.467511993496 | (37.7178531919595, -122.467511993496) | |||
| 19087 | 19087 | 4196 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3877 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004712.79139 | 2100439.23243 | 37.7476727891643 | -122.42646061396401 | (37.7476727891643, -122.426460613964) | |||
| 19282 | 19282 | 4868 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 40 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6000785.76982 | 2098130.67734 | 37.7411112680693 | -122.439874506828 | (37.7411112680693, -122.439874506828) | |||
| 19667 | 19667 | 4866 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6000802.3716400005 | 2098157.55359 | 37.741186008934896 | -122.43981903034701 | (37.7411860089349, -122.439819030347) | |||
| 19828 | 19828 | 26060 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5994622.6639 | 2088111.4430000002 | 37.713248125396 | -122.46045833760701 | (37.713248125396, -122.460458337607) | |||
| 19869 | 19869 | 1340 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 157 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5999318.51798 | 2099488.255 | 37.7447552202944 | -122.445045288424 | (37.7447552202944, -122.445045288424) | |||
| 19879 | 19879 | 25601 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1425 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009396.61831 | 2097480.31655 | 37.7398119185732 | -122.41005527655099 | (37.7398119185732, -122.410055276551) | |||
| 20024 | 20024 | 3441 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 14 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999497.99147 | 2099800.2431099997 | 37.7456221064729 | -122.444447123237 | (37.7456221064729, -122.444447123237) | |||
| 20027 | 20027 | 3444 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 22 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5999501.27167 | 2099733.2475400004 | 37.745438339921996 | -122.44443096691799 | (37.745438339922, -122.444430966918) | |||
| 20048 | 20048 | 3452 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 42 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999533.14078 | 2099571.88767 | 37.744997102831896 | -122.44430917535401 | (37.7449971028319, -122.444309175354) | |||
| 20088 | 20088 | 4215 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3947 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004216.72102 | 2100407.9706900003 | 37.7475588963331 | -122.42817377030599 | (37.7475588963331, -122.428173770306) | |||
| 20092 | 20092 | 24477 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 94 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6002318.918930001 | 2096714.27726 | 37.7373093148834 | -122.43447219024401 | (37.7373093148834, -122.434472190244) | ||
| 20145 | 20145 | 3440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999495.83861 | 2099835.0042 | 37.7457174292197 | -122.44445706524401 | (37.7457174292197, -122.444457065244) | |||
| 20148 | 20148 | 17245 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501 Ortega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3 | 5992555.1394 | 2103055.38176 | 37.754161290716205 | -122.468691056856 | (37.7541612907162, -122.468691056856) | |||
| 20190 | 20190 | 4864 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 25 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1992 12:00:00 AM | 25 | 2X2 | 6000739.41947 | 2098202.35217 | 37.7413054316983 | -122.440039907412 | (37.7413054316983, -122.440039907412) | ||
| 20227 | 20227 | 4881 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 83 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6000907.7136 | 2097921.62837 | 37.74054420955 | -122.439437888659 | (37.74054420955, -122.439437888659) | |||
| 20471 | 20471 | 8716 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997420.69043 | 2113059.93694 | 37.7819111134077 | -122.452586840538 | (37.7819111134077, -122.452586840538) | |||
| 20553 | 20553 | 5090 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2599 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6002264.68723 | 2096743.2424700002 | 37.737385768040106 | -122.434661764636 | (37.7373857680401, -122.434661764636) | |||
| 20560 | 20560 | 22807 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 16 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/1991 12:00:00 AM | 12 | 2X2 | 5998909.64995 | 2099772.3846 | 37.745512026751896 | -122.446479507446 | (37.7455120267519, -122.446479507446) | ||
| 20698 | 20698 | 17233 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Ora Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6001155.387569999 | 2098531.68959 | 37.7422333863766 | -122.438625231576 | (37.7422333863766, -122.438625231576) | |||
| 20747 | 20747 | 1331 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4X Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999508.60348 | 2099913.11882 | 37.7459326414862 | -122.44441853919399 | (37.7459326414862, -122.444418539194) | |||
| 20816 | 20816 | 3449 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 30 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5999507.11863 | 2099668.7039099997 | 37.7452614522515 | -122.44440611146601 | (37.7452614522515, -122.444406111466) |
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");