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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 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) | |||
| 18279 | 18279 | 4484 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1566 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/1990 12:00:00 AM | 12 | 3X3 | 6004549.88502 | 2099732.13285 | 37.7457220463542 | -122.42697358187701 | (37.7457220463542, -122.426973581877) | ||
| 18393 | 18393 | 65663 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 35 Los Palmos Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/14/1991 12:00:00 AM | Permit Number 28583 | 5998824.47448758 | 2095859.96140736 | 37.7347645844735 | -122.44649260756701 | (37.7347645844735, -122.446492607567) | ||
| 18431 | 18431 | 1350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 261 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 5999733.43875 | 2099278.43357 | 37.7442027739306 | -122.443595506633 | (37.7442027739306, -122.443595506633) | |||
| 18490 | 18490 | 90663 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3600X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5984396.70061 | 2110421.43862 | 37.7739117254104 | -122.497448288038 | (37.7739117254104, -122.497448288038) | ||
| 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) | |||
| 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) | ||
| 18988 | 18988 | 16343 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996035.52811 | 2094660.72414 | 37.7313120760949 | -122.456048222959 | (37.7313120760949, -122.456048222959) | ||
| 19049 | 19049 | 19343 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 521 Shields St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5992618.01059 | 2089830.6740400002 | 37.7178531919595 | -122.467511993496 | (37.7178531919595, -122.467511993496) | |||
| 19087 | 19087 | 4196 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3877 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004712.79139 | 2100439.23243 | 37.7476727891643 | -122.42646061396401 | (37.7476727891643, -122.426460613964) | |||
| 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) | ||||
| 19627 | 19627 | 16344 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/19/2013 12:00:00 AM | 3 | 5 | 5996005.09349 | 2094651.8098799998 | 37.7312858527477 | -122.45615279610901 | (37.7312858527477, -122.456152796109) | ||
| 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) | |||
| 19703 | 19703 | 16350 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 922X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/23/1998 12:00:00 AM | 3 | 5 | 5995968.77487 | 2094643.75333 | 37.731261646602995 | -122.45627777310601 | (37.731261646603, -122.456277773106) | ||
| 19828 | 19828 | 26060 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5994622.6639 | 2088111.4430000002 | 37.713248125396 | -122.46045833760701 | (37.713248125396, -122.460458337607) | |||
| 19869 | 19869 | 1340 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 157 Amber Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10 | 3X3 | 5999318.51798 | 2099488.255 | 37.7447552202944 | -122.445045288424 | (37.7447552202944, -122.445045288424) | |||
| 19879 | 19879 | 25601 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1425 Cortland Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6009396.61831 | 2097480.31655 | 37.7398119185732 | -122.41005527655099 | (37.7398119185732, -122.410055276551) | |||
| 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) | |||
| 19999 | 19999 | 1998 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 213 Bocana St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6007163.78515 | 2097749.92103 | 37.7404267922562 | -122.41779459653799 | (37.7404267922562, -122.417794596538) | |||
| 20024 | 20024 | 3441 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 14 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999497.99147 | 2099800.2431099997 | 37.7456221064729 | -122.444447123237 | (37.7456221064729, -122.444447123237) | |||
| 20027 | 20027 | 3444 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 22 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 5999501.27167 | 2099733.2475400004 | 37.745438339921996 | -122.44443096691799 | (37.745438339922, -122.444430966918) | |||
| 20048 | 20048 | 3452 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 42 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999533.14078 | 2099571.88767 | 37.744997102831896 | -122.44430917535401 | (37.7449971028319, -122.444309175354) | |||
| 20088 | 20088 | 4215 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3947 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6004216.72102 | 2100407.9706900003 | 37.7475588963331 | -122.42817377030599 | (37.7475588963331, -122.428173770306) | |||
| 20092 | 20092 | 24477 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 94 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/23/2011 12:00:00 AM | 3 | 3x3 | 6002318.918930001 | 2096714.27726 | 37.7373093148834 | -122.43447219024401 | (37.7373093148834, -122.434472190244) | ||
| 20145 | 20145 | 3440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999495.83861 | 2099835.0042 | 37.7457174292197 | -122.44445706524401 | (37.7457174292197, -122.444457065244) | |||
| 20148 | 20148 | 17245 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501 Ortega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 3 | 5992555.1394 | 2103055.38176 | 37.754161290716205 | -122.468691056856 | (37.7541612907162, -122.468691056856) | |||
| 20190 | 20190 | 4864 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 25 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/27/1992 12:00:00 AM | 25 | 2X2 | 6000739.41947 | 2098202.35217 | 37.7413054316983 | -122.440039907412 | (37.7413054316983, -122.440039907412) | ||
| 20227 | 20227 | 4881 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 83 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 2X2 | 6000907.7136 | 2097921.62837 | 37.74054420955 | -122.439437888659 | (37.74054420955, -122.439437888659) | |||
| 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) | |||
| 20471 | 20471 | 8716 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3140 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5997420.69043 | 2113059.93694 | 37.7819111134077 | -122.452586840538 | (37.7819111134077, -122.452586840538) | |||
| 20553 | 20553 | 5090 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2599 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6002264.68723 | 2096743.2424700002 | 37.737385768040106 | -122.434661764636 | (37.7373857680401, -122.434661764636) | |||
| 20560 | 20560 | 22807 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 16 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/01/1991 12:00:00 AM | 12 | 2X2 | 5998909.64995 | 2099772.3846 | 37.745512026751896 | -122.446479507446 | (37.7455120267519, -122.446479507446) | ||
| 20698 | 20698 | 17233 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Ora Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6001155.387569999 | 2098531.68959 | 37.7422333863766 | -122.438625231576 | (37.7422333863766, -122.438625231576) | |||
| 20747 | 20747 | 1331 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4X Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5999508.60348 | 2099913.11882 | 37.7459326414862 | -122.44441853919399 | (37.7459326414862, -122.444418539194) | |||
| 20816 | 20816 | 3449 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 30 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5999507.11863 | 2099668.7039099997 | 37.7452614522515 | -122.44440611146601 | (37.7452614522515, -122.444406111466) | |||
| 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) | |||
| 21275 | 21275 | 5112 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2711 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 4X4 | 6002382.81986 | 2096188.0405700002 | 37.7358680173011 | -122.434213645952 | (37.7358680173011, -122.434213645952) | |||
| 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) | |||
| 21448 | 21448 | 5058 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5521 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001859.76299 | 2097506.95056 | 37.739459736871204 | -122.436116409072 | (37.7394597368712, -122.436116409072) | |||
| 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) | |||
| 21696 | 21696 | 10044 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 Guerrero St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005474.87318 | 2106843.21233 | 37.7652996739685 | -122.424280773353 | (37.7652996739685, -122.424280773353) | |||
| 21714 | 21714 | 26062 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 236 Broad St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3X3 | 5994603.6211 | 2088111.4430000002 | 37.71324702988721 | -122.460524155594 | (37.7132470298872, -122.460524155594) | |||
| 21784 | 21784 | 10043 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 360 Guerrero St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6005477.51423 | 2106859.7680900004 | 37.765345281278 | -122.424272816157 | (37.765345281278, -122.424272816157) | |||
| 21834 | 21834 | 4871 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 48 Crags Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6000859.63404 | 2098067.6041 | 37.7409422881585 | -122.43961459104901 | (37.7409422881585, -122.439614591049) | |||
| 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) | |||
| 22253 | 22253 | 4256 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4082 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003396.9856199995 | 2100411.62921 | 37.7475225268465 | -122.431008624962 | (37.7475225268465, -122.431008624962) | |||
| 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) | |||
| 22386 | 22386 | 9093 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989210.8329 | 2112629.8539 | 37.78025641160821 | -122.48095732694999 | (37.7802564116082, -122.48095732695) | |||
| 22392 | 22392 | 9015 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5990451.7846 | 2112676.0938 | 37.780455430166704 | -122.47666772777599 | (37.7804554301667, -122.476667727776) | |||
| 22394 | 22394 | 9094 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989203.8431 | 2112625.0148 | 37.7802427184836 | -122.48098115319901 | (37.7802427184836, -122.480981153199) | |||
| 22395 | 22395 | 9019 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5317 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/12/2011 12:00:00 AM | 3 | 8M | 5990422.2126 | 2112674.4808 | 37.780449286015 | -122.476769912257 | (37.780449286015, -122.476769912257) | ||
| 22396 | 22396 | 21529 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1300 Sutter St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6006199.49469 | 2114932.42153 | 37.7875515759816 | -122.42234927152799 | (37.7875515759816, -122.422349271528) | |||
| 22405 | 22405 | 9178 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987973.0454 | 2112592.9065 | 37.7800829358976 | -122.485236638901 | (37.7800829358976, -122.485236638901) | |||
| 22408 | 22408 | 21538 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1350 Sutter St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6006090.48396 | 2114915.1534700003 | 37.787498012379 | -122.42272519983 | (37.787498012379, -122.42272519983) | |||
| 22427 | 22427 | 9095 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989203.3055 | 2112634.6929 | 37.780269260588604 | -122.480983721798 | (37.7802692605886, -122.480983721798) | |||
| 22433 | 22433 | 9091 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989224.2748 | 2112631.4669 | 37.7802616218044 | -122.48091094389 | (37.7802616218044, -122.48091094389) | |||
| 22441 | 22441 | 9219 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987356.9662 | 2112573.6226 | 37.779994079355895 | -122.487366491184 | (37.7799940793559, -122.487366491184) | |||
| 22462 | 22462 | 9179 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987967.3441 | 2112595.2541 | 37.7800890496186 | -122.48525653433799 | (37.7800890496186, -122.485256534338) | |||
| 22464 | 22464 | 9180 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987967.6795 | 2112585.8637 | 37.7800632857697 | -122.485254684827 | (37.7800632857697, -122.485254684827) | |||
| 22465 | 22465 | 9099 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989192.0143 | 2112627.1655 | 37.780247936097396 | -122.481022231507 | (37.7802479360974, -122.481022231507) | |||
| 22471 | 22471 | 9181 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6100 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987959.6305 | 2112590.5589 | 37.7800757085683 | -122.485282874223 | (37.7800757085683, -122.485282874223) | |||
| 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) | |||
| 22497 | 22497 | 9218 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 6300 Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5987387.1497 | 2112575.6349 | 37.78000136471471 | -122.48726222211799 | (37.7800013647147, -122.487262222118) | |||
| 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) | |||
| 22507 | 22507 | 9049 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5500 Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989816.2539 | 2112654.318 | 37.7803587568757 | -122.478864709732 | (37.7803587568757, -122.478864709732) | |||
| 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) | |||
| 22524 | 22524 | 9096 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5700 Geary Blvd | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8M | 5989196.3157 | 2112631.4669 | 37.78025999658 | -122.48100766619 | (37.78025999658, -122.48100766619) |
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");