Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker ▼ | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 19503 | 19503 | 113857 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1201 SAN BRUNO AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011184.0 | 2102716.0 | 37.754287987368706 | -122.40424363426001 | (37.7542879873687, -122.40424363426) | ||||
| 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) | |||
| 22079 | 22079 | 4859 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 17 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6000712.83991 | 2098222.9013099996 | 37.7413603416151 | -122.440133283139 | (37.7413603416151, -122.440133283139) | |||
| 22100 | 22100 | 19346 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 538 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5992530.80337 | 2089863.7154 | 37.717938880250394 | -122.46781582943999 | (37.7179388802504, -122.46781582944) | |||
| 22230 | 22230 | 3451 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 38 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 3X3 | 5999519.82118 | 2099605.44915 | 37.745088494646396 | -122.44435764339701 | (37.7450884946464, -122.444357643397) | |||
| 22260 | 22260 | 9373 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 292 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3x4 | 6001116.19267 | 2097967.75303 | 37.740682719538796 | -122.438720354687 | (37.7406827195388, -122.438720354687) | |||
| 22477 | 22477 | 9883 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1530 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6005400.00219 | 2115093.82301 | 37.787949613228 | -122.42512684742701 | (37.787949613228, -122.425126847427) | |||
| 22486 | 22486 | 21531 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1301 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006257.76496 | 2114889.71602 | 37.7874376040064 | -122.422144632576 | (37.7874376040064, -122.422144632576) | |||
| 22504 | 22504 | 21526 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6006270.376630001 | 2114940.85918 | 37.787578741804204 | -122.422104633424 | (37.7875787418042, -122.422104633424) | |||
| 22511 | 22511 | 21525 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 6006287.01156 | 2114943.3231200003 | 37.7875864454 | -122.422047254877 | (37.7875864454, -122.422047254877) | |||
| 22557 | 22557 | 21535 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1337 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006166.93073 | 2114876.17563 | 37.787395301706795 | -122.422457938402 | (37.7873953017068, -122.422457938402) | |||
| 22620 | 22620 | 21530 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1307 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6006237.14055 | 2114887.59542 | 37.7874306180636 | -122.422215838204 | (37.7874306180636, -122.422215838204) | |||
| 22786 | 22786 | 9882 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1530 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6005403.02502 | 2115071.7670299998 | 37.7878892237663 | -122.425114819002 | (37.7878892237663, -122.425114819002) | |||
| 22855 | 22855 | 188957 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1708 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6014940.685740001 | 2096639.31184 | 37.73781187133179 | -122.39082730983499 | (37.7378118713318, -122.390827309835) | |||
| 22972 | 22972 | 108950 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 601 STEINER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775169 | 6003025.4 | 2110381.6 | 37.774876602731204 | -122.433005738531 | (37.7748766027312, -122.433005738531) | |
| 23011 | 23011 | 7688 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 545 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 0 | 6008696.1209 | 2121067.5649 | 37.8045376819256 | -122.414145630391 | (37.8045376819256, -122.414145630391) | |||
| 23074 | 23074 | 8830 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4000 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/11/1993 12:00:00 AM | 4 | 3x3 | 5994612.73133 | 2112879.8624299997 | 37.7812553917023 | -122.462287945756 | (37.7812553917023, -122.462287945756) | ||
| 23374 | 23374 | 189044 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 12th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007758.60706 | 2109046.4903599997 | 37.771478047011705 | -122.416537939674 | (37.7714780470117, -122.416537939674) | |||
| 23383 | 23383 | 220866 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3725 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004888.252669999 | 2102494.31533 | 37.753325487792104 | -122.426000149411 | (37.7533254877921, -122.426000149411) | |||
| 23397 | 23397 | 54440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 512 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 25 | Permit Number 10217 | 6014062.04664 | 2104690.51395 | 37.7598699757444 | -122.39442879427601 | (37.7598699757444, -122.394428794276) | ||
| 23406 | 23406 | 205700 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 455 Magellan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993494.37195 | 2099449.4133900004 | 37.744314435578396 | -122.465181086546 | (37.7443144355784, -122.465181086546) | |||
| 23430 | 23430 | 220933 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 155 Appleton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6006212.833769999 | 2096779.64339 | 37.737709065310995 | -122.421013744088 | (37.737709065311, -122.421013744088) | |||
| 23467 | 23467 | 205659 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1598 10th Ave | 7 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 5993106.7424 | 2104692.3682 | 37.7586878807581 | -122.466902491455 | (37.7586878807581, -122.466902491455) | |||
| 23609 | 23609 | 125847 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1752 Taylor St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6008754.651330001 | 2118947.56933 | 37.7987199902862 | -122.413793029843 | (37.7987199902862, -122.413793029843) | |||
| 23617 | 23617 | 205782 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 451 Hearst Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5998547.56823 | 2094367.17005 | 37.730649912448605 | -122.447342555315 | (37.7306499124486, -122.447342555315) | |||
| 23641 | 23641 | 222492 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 265 Beacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6002907.41416 | 2097886.83375 | 37.740562273319505 | -122.43252121989599 | (37.7405622733195, -122.432521219896) | |||
| 23673 | 23673 | 222238 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1022 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997287.2431 | 2106942.28914 | 37.7651059905631 | -122.45260686101801 | (37.7651059905631, -122.452606861018) | |||
| 23720 | 23720 | 188872 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 969 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6012202.49655 | 2103904.7568 | 37.757608911948104 | -122.40080490573798 | (37.7576089119481, -122.400804905738) | |||
| 23812 | 23812 | 220970 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 75 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6000907.15737 | 2097980.81519 | 37.740706690970995 | -122.43944405351601 | (37.740706690971, -122.439444053516) | |||
| 23858 | 23858 | 222304 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 159 Precita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007445.403080001 | 2100226.12885 | 37.747241750408605 | -122.416996273782 | (37.7472417504086, -122.416996273782) | |||
| 23906 | 23906 | 199914 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1220 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6017119.8344 | 2092922.0985 | 37.7277258082427 | -122.38303422196002 | (37.7277258082427, -122.38303422196) | |||
| 23921 | 23921 | 102246 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 337 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x6 | 6013795.01675 | 2105505.95048 | 37.7620941385477 | -122.395409453676 | (37.7620941385477, -122.395409453676) | |||
| 23971 | 23971 | 78224 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1214 Bowdoin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/2000 12:00:00 AM | 5 | 6009704.84764 | 2090538.9392099997 | 37.7207696402774 | -122.40850003035101 | (37.7207696402774, -122.408500030351) | ||
| 23987 | 23987 | 175686 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 212 Madison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6005601.68798 | 2092672.56295 | 37.726397462770706 | -122.42283496838199 | (37.7263974627707, -122.422834968382) | |||
| 24048 | 24048 | 113755 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Amazon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6001200.73843 | 2089055.6919999998 | 37.7162170508648 | -122.43778988730499 | (37.7162170508648, -122.437789887305) | |||
| 24055 | 24055 | 188977 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Thomas Ave | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6012688.07294 | 2095454.3657900002 | 37.7344330140672 | -122.398532612087 | (37.7344330140672, -122.398532612087) | |||
| 24071 | 24071 | 250790 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 284 32nd Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5985915.81821 | 2114007.58209 | 37.7838471713633 | -122.49245762762101 | (37.7838471713633, -122.492457627621) | |||
| 24103 | 24103 | 122254 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1751 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990004.74374 | 2113334.11556 | 37.7822362348945 | -122.47826236215 | (37.7822362348945, -122.47826236215) | |||
| 24105 | 24105 | 205695 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2236 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990740.52284 | 2100154.10993 | 37.7460901613437 | -122.47475463951 | (37.7460901613437, -122.47475463951) | |||
| 24139 | 24139 | 188877 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 711 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011296.96428 | 2105014.49573 | 37.7606054583887 | -122.40401471650299 | (37.7606054583887, -122.404014716503) | |||
| 24165 | 24165 | 54475 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 80 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 10 | Permit Number 10267 | 6012323.1841 | 2095334.0847599998 | 37.73408241247979 | -122.399785717559 | (37.7340824124798, -122.399785717559) | ||
| 24185 | 24185 | 220918 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3590 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008482.3827 | 2098155.73861 | 37.7416151950936 | -122.41326407916999 | (37.7416151950936, -122.41326407917) | |||
| 24237 | 24237 | 222185 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1266 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003207.46719 | 2100851.7918599998 | 37.7487203698443 | -122.431695388655 | (37.7487203698443, -122.431695388655) | |||
| 24324 | 24324 | 138190 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1837 PINE ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003409.3754 | 2115058.633 | 37.7877403378272 | -122.432011538078 | (37.7877403378272, -122.432011538078) | |||
| 24354 | 24354 | 54553 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 12 | Permit Number 10348 | 6012791.48057 | 2095648.57895 | 37.7349720434069 | -122.39818871674801 | (37.7349720434069, -122.398188716748) | ||
| 24442 | 24442 | 205788 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 201 Hearst Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000020.87413 | 2094345.53232 | 37.7306745790527 | -122.442247574877 | (37.7306745790527, -122.442247574877) | |||
| 24448 | 24448 | 220803 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Sycamore St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006506.67533 | 2105838.44875 | 37.7625990368337 | -122.42064067382401 | (37.7625990368337, -122.420640673824) | |||
| 24561 | 24561 | 220882 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 599 Belvedere St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5998626.62137 | 2105762.24598 | 37.7619425398344 | -122.44788933414 | (37.7619425398344, -122.44788933414) | |||
| 24616 | 24616 | 222318 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 838 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009101.97358 | 2104063.21002 | 37.7578705625017 | -122.41153901044301 | (37.7578705625017, -122.411539010443) | |||
| 24699 | 24699 | 54559 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 51 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 10 | Permit Number 10354 | 6012768.0788 | 2095448.27942 | 37.734420759018604 | -122.398255576836 | (37.7344207590186, -122.398255576836) | ||
| 24743 | 24743 | 204401 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1426 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5994301.112480001 | 2105797.04761 | 37.761789906893604 | -122.462851987244 | (37.7617899068936, -122.462851987244) | |||
| 24774 | 24774 | 143056 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 30 EDITH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6010306.5322 | 2120406.926 | 37.8028140529926 | -122.40852599821699 | (37.8028140529926, -122.408525998217) | |||
| 24798 | 24798 | 45088 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1900 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2001 12:00:00 AM | 2 | Permit Number 43969 | 5988077.6041 | 2102404.3375 | 37.752114018434206 | -122.484127544226 | (37.7521140184342, -122.484127544226) | |
| 24882 | 24882 | 220794 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2406 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6011347.91317 | 2102325.1902900003 | 37.753224067640296 | -122.403649282384 | (37.7532240676403, -122.403649282384) | |||
| 24915 | 24915 | 222484 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 59 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002447.270769999 | 2096535.4200900001 | 37.7368254993903 | -122.434015637735 | (37.7368254993903, -122.434015637735) | |||
| 24935 | 24935 | 175691 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1419 Wayland St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007522.85958 | 2091386.22385 | 37.722973663691 | -122.41610248796499 | (37.722973663691, -122.416102487965) | |||
| 24943 | 24943 | 175677 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 165 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6004417.90024 | 2094349.92502 | 37.7309362610921 | -122.427046687756 | (37.7309362610921, -122.427046687756) | |||
| 25061 | 25061 | 222360 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 498 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003186.117380001 | 2102736.4547200003 | 37.7538939996264 | -122.43190377055599 | (37.7538939996264, -122.431903770556) | |||
| 25079 | 25079 | 204442 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2395 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5991351.20232 | 2099149.48654 | 37.743367092409294 | -122.472569777984 | (37.7433670924093, -122.472569777984) | |||
| 25111 | 25111 | 222282 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 322 Elsie St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006404.19555 | 2097095.06945 | 37.7385859402852 | -122.42037449518699 | (37.7385859402852, -122.420374495187) | |||
| 25148 | 25148 | 220775 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2800 Mariposa St | 6 | : 4 | Tree 1 | Private 1 | 18 | Width 3ft | 6009066.85397 | 2105930.68426 | 37.762996251197706 | -122.411792424993 | (37.7629962511977, -122.411792424993) | |||
| 25149 | 25149 | 220954 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3339 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006068.29873 | 2103732.65961 | 37.75679231583621 | -122.42200726293001 | (37.7567923158362, -122.42200726293) | |||
| 25152 | 25152 | 222160 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Fountain St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000360.36109 | 2101597.05955 | 37.7506049001065 | -122.44159410859899 | (37.7506049001065, -122.441594108599) | |||
| 25188 | 25188 | 99927 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 665 Bowdoin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6008996.47999 | 2092997.0616099997 | 37.727479429923896 | -122.411122192648 | (37.7274794299239, -122.411122192648) | ||||
| 25230 | 25230 | 188862 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2145 18th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011298.33693 | 2105542.34604 | 37.7620548939477 | -122.404047117302 | (37.7620548939477, -122.404047117302) | |||
| 25239 | 25239 | 183737 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1014 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989684.0603 | 2099734.5492 | 37.744876881917 | -122.47837703617901 | (37.744876881917, -122.478377036179) | |||
| 25241 | 25241 | 205846 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5994462.98595 | 2090252.1993200001 | 37.7191169462637 | -122.46116531412301 | (37.7191169462637, -122.461165314123) | |||
| 25282 | 25282 | 125851 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1359 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007069.22573 | 2118411.6669099997 | 37.797153742719296 | -122.41958711357901 | (37.7971537427193, -122.419587113579) | |||
| 25287 | 25287 | 188860 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 601 Vermont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6011271.15548 | 2105473.51141 | 37.7618643707515 | -122.40413628328899 | (37.7618643707515, -122.404136283289) | |||
| 25312 | 25312 | 69188 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2249 17th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/26/1994 12:00:00 AM | 6 | Permit Number 33230 | 6010676.3293699995 | 2106439.96142 | 37.7644847703853 | -122.40626165736401 | (37.7644847703853, -122.406261657364) | ||
| 25569 | 25569 | 222200 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Hoffman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6000609.51746 | 2102650.2071599998 | 37.753510781406604 | -122.44080804535801 | (37.7535107814066, -122.440808045358) |
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");