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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |
| 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) | |||
| 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) | |
| 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) | |
| 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) | |||
| 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) | ||
| 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) |
| 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) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 18895 | 18895 | 37776 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 449 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1998 12:00:00 AM | Permit Number 40114 | 6009618.93348363 | 2093468.47161568 | 37.72880870980371 | -122.409003606238 | (37.7288087098037, -122.409003606238) | ||
| 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) | |||
| 19204 | 19204 | 15640 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3620 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6005331.9888 | 2097082.5189 | 37.7384910005149 | -122.424080784585 | (37.7384910005149, -122.424080784585) | |||
| 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) | |||
| 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) | |||
| 19933 | 19933 | 26061 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 5994614.7294 | 2088111.1256 | 37.7132467974329 | -122.46048573878299 | (37.7132467974329, -122.460485738783) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 20395 | 20395 | 43502 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 401 Gates St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/19/2000 12:00:00 AM | Permit Number 43180 | 6008272.42807324 | 2096955.00828501 | 37.73830646369329 | -122.413905114955 | (37.7383064636933, -122.413905114955) | ||
| 20446 | 20446 | 4375 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1035 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000885.93841 | 2096177.1796 | 37.7357531225975 | -122.43938816603 | (37.7357531225975, -122.43938816603) | |||
| 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) | |||
| 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) | |||
| 20936 | 20936 | 3454 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 46 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999549.90183 | 2099548.27551 | 37.7449332257802 | -122.444249522399 | (37.7449332257802, -122.444249522399) | |||
| 20962 | 20962 | 3446 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 26 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5999504.19515 | 2099700.97572 | 37.745349896074295 | -122.444418539177 | (37.7453498960743, -122.444418539177) | |||
| 21010 | 21010 | 26523 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2827 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6008996.21929 | 2101987.30534 | 37.75216466358871 | -122.41175807359899 | (37.7521646635887, -122.411758073599) | |||
| 21017 | 21017 | 1925 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 96 Berkeley Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6001058.612819999 | 2097389.17311 | 37.7390907990037 | -122.43887799141899 | (37.7390907990037, -122.438877991419) | |||
| 21093 | 21093 | 4212 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3939 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004266.44714 | 2100411.8898 | 37.7475724706926 | -122.428002099622 | (37.7475724706926, -122.428002099622) | |||
| 21375 | 21375 | 22812 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 33 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2X2 | 5999068.47154 | 2099593.84313 | 37.745030865178 | -122.44591749052601 | (37.745030865178, -122.445917490526) | |||
| 21532 | 21532 | 4874 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 64 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000875.46201 | 2097999.81649 | 37.7407570602008 | -122.439555005583 | (37.7407570602008, -122.439555005583) | |||
| 21998 | 21998 | 22832 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 96 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 5999484.67049 | 2098974.10299 | 37.743352964077395 | -122.44443382318 | (37.7433529640774, -122.44443382318) | |||
| 22049 | 22049 | 26522 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2829 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6008999.5105099995 | 2101948.0462700003 | 37.75205705160771 | -122.411743918249 | (37.7520570516077, -122.411743918249) |
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");