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) | ||
| 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) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 17287 | 17287 | 4230 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3987 Cesar Chavez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6004020.01969 | 2100398.84161 | 37.7475226986238 | -122.42885330076099 | (37.7475226986238, -122.428853300761) | |||
| 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) | |||
| 17443 | 17443 | 4863 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 22 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000706.81411 | 2098191.7850599997 | 37.7412745606821 | -122.440151887408 | (37.7412745606821, -122.440151887408) | |||
| 17602 | 17602 | 4876 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Crags Ct | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3X3 | 6000878.44646 | 2097957.44454 | 37.74064088666079 | -122.43954164975099 | (37.7406408866608, -122.439541649751) | |||
| 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) | |||
| 17943 | 17943 | 4857 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 9 Crags Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6000644.55264 | 2098284.20496 | 37.741524779037704 | -122.440373791542 | (37.7415247790377, -122.440373791542) | |||
| 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) | |||
| 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) | |||
| 18186 | 18186 | 105551 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6017214.0 | 2092838.0 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | |||
| 18251 | 18251 | 26063 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 2X3 | 5994596.9562 | 2088110.4909 | 37.713244032213105 | -122.46054712266199 | (37.7132440322131, -122.460547122662) | |||
| 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) | |||
| 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) | |||
| 18644 | 18644 | 15641 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3620 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005331.1371 | 2097074.8536 | 37.73846990523921 | -122.424083184386 | (37.7384699052392, -122.424083184386) | |||
| 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) | |||
| 18712 | 18712 | 10788 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 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) | |||
| 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) |
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");