Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSiteInfo, PlantType, qCaretaker, qCareAssistant, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▲ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23209 | 23209 | 83033 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | |||
| 4983 | 4983 | 83050 | Private 5 | Rhamnus californica :: Coffeeberry Tree 232 | 100X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018877.26977 | 2097567.07885 | 37.7405769700435 | -122.377280830842 | (37.7405769700435, -122.377280830842) | |||
| 134600 | 134600 | 83049 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 11 | 6018864.1607099995 | 2097578.2563400003 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | |||
| 4989 | 4989 | 83048 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:41:00 AM | 3 | 6018843.8838 | 2097592.61577 | 37.7406452501696 | -122.37739803950001 | (37.7406452501696, -122.3773980395) | |||
| 43784 | 43784 | 83046 | Private 5 | Olea europaea 'Fruitless' :: Fruitless Olive 80 | 100X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018811.25128 | 2097616.11187 | 37.740707968002 | -122.37751250161399 | (37.740707968002, -122.377512501614) | |||
| 4949 | 4949 | 83043 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:49:00 PM | 3 | 6018760.2720099995 | 2097656.0724299997 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | |||
| 4998 | 4998 | 83042 | Private 5 | Olea europaea 'Majestic Beauty' :: Majestic Beauty Fruitless Olive 77 | 100X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:54:00 PM | 3 | 6018742.83505 | 2097668.8048 | 37.740848882771 | -122.37775271773 | (37.740848882771, -122.37775271773) | |||
| 4985 | 4985 | 83041 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:47:00 AM | 3 | 6018722.37051 | 2097684.4746 | 37.74089078129229 | -122.377824564564 | (37.7408907812923, -122.377824564564) | |||
| 5059 | 5059 | 83040 | Private 5 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 6 | 6018704.22704 | 2097697.64106 | 37.740925933998 | -122.37788821227699 | (37.740925933998, -122.377888212277) | |||
| 5054 | 5054 | 83037 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 5 | 6018575.81097 | 2097793.86484 | 37.74118306815279 | -122.378338911137 | (37.7411830681528, -122.378338911137) | |||
| 5000 | 5000 | 83036 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | |||
| 5038 | 5038 | 83035 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 09:50:00 AM | 3 | 6018541.89406 | 2097818.9676900003 | 37.741250126083706 | -122.37845792741501 | (37.7412501260837, -122.378457927415) | |||
| 4980 | 4980 | 83034 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:59:00 PM | 3 | 6018525.50747 | 2097831.43609 | 37.7412834585567 | -122.37851545254298 | (37.7412834585567, -122.378515452543) | |||
| 5014 | 5014 | 3588 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:07:00 AM | 3 | 3X3 | 6018423.14615 | 2097904.9005 | 37.7414795341434 | -122.37887448618 | (37.7414795341434, -122.37887448618) | ||
| 5065 | 5065 | 3592 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018357.04475 | 2097955.64275 | 37.741615217581796 | -122.379106567936 | (37.7416152175818, -122.379106567936) | ||
| 23256 | 23256 | 3593 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 7 | 3X3 | 6018341.35218 | 2097966.95491 | 37.7416454132021 | -122.379161613636 | (37.7416454132021, -122.379161613636) | ||
| 5049 | 5049 | 3594 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3x3 | 6018322.1359 | 2097981.33701 | 37.741683843926396 | -122.379229056502 | (37.7416838439264, -122.379229056502) | |||
| 5063 | 5063 | 3598 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 34 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:10:00 PM | 3 | 3X3 | 6018255.028469999 | 2098031.9569200003 | 37.7418191352571 | -122.37946460960501 | (37.7418191352571, -122.379464609605) | ||
| 4945 | 4945 | 3600 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 36 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:14:00 PM | 3 | 3X3 | 6018222.967130001 | 2098056.59418 | 37.7418850159701 | -122.379577179554 | (37.7418850159701, -122.379577179554) | ||
| 5023 | 5023 | 3601 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 37 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:11:00 AM | 3 | 3X3 | 6018206.00756 | 2098069.0742900004 | 37.7419183484432 | -122.379636687689 | (37.7419183484432, -122.379636687689) | ||
| 22313 | 22313 | 3602 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.4470599997 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | ||
| 22352 | 22352 | 3605 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018137.75637 | 2098119.86028 | 37.7420540318827 | -122.37987620861601 | (37.7420540318827, -122.379876208616) | |||
| 22330 | 22330 | 3607 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3x3 | 6018106.23722 | 2098142.91565 | 37.742115598557895 | -122.37998679465001 | (37.7421155985579, -122.37998679465) | |||
| 22338 | 22338 | 3608 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 44 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018087.01832 | 2098157.15518 | 37.7421536371939 | -122.380054237523 | (37.7421536371939, -122.380054237523) | ||
| 22337 | 22337 | 3609 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 9 | 3X3 | 6018070.77279 | 2098169.47823 | 37.7421865775631 | -122.380111266222 | (37.7421865775631, -122.380111266222) | |||
| 22333 | 22333 | 3610 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 46 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018056.230380001 | 2098180.90993 | 37.742217164400294 | -122.380162344118 | (37.7422171644003, -122.380162344118) | |||
| 22318 | 22318 | 3611 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018038.2961099995 | 2098194.83807 | 37.7422544187983 | -122.380225323637 | (37.7422544187983, -122.380225323637) | ||
| 22328 | 22328 | 3612 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 48 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018020.628269999 | 2098207.76094 | 37.7422889275932 | -122.380287312129 | (37.7422889275932, -122.380287312129) | |||
| 5066 | 5066 | 3614 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 50 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017985.84349 | 2098232.4529 | 37.742354807434396 | -122.380409304248 | (37.7423548074344, -122.380409304248) | |||
| 1081 | 1081 | 3617 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:16:00 PM | 3 | 3X3 | 6017937.25359 | 2098269.56212 | 37.742454020638796 | -122.380579893948 | (37.7424540206388, -122.380579893948) | ||
| 5070 | 5070 | 3618 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017899.85524 | 2098296.735 | 37.7425265680461 | -122.380711096061 | (37.7425265680461, -122.380711096061) | |||
| 1079 | 1079 | 3621 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 57 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:22:00 PM | 3 | 3X3 | 6017849.66978 | 2098333.64293 | 37.7426251400454 | -122.380887189608 | (37.7426251400454, -122.380887189608) | ||
| 22346 | 22346 | 3622 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017832.2114699995 | 2098347.65106 | 37.7426626399605 | -122.380948529647 | (37.7426626399605, -122.380948529647) | |||
| 22348 | 22348 | 3623 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017813.51979 | 2098359.7555299997 | 37.7426948446985 | -122.38101400211 | (37.7426948446985, -122.38101400211) | ||
| 4994 | 4994 | 3624 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:25:00 PM | 3 | 3X3 | 6017797.96297 | 2098371.7943700003 | 37.742727042232396 | -122.38106863050601 | (37.7427270422324, -122.381068630506) | ||
| 22349 | 22349 | 3626 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017765.800369999 | 2098395.89545 | 37.7427914435713 | -122.38118151611201 | (37.7427914435713, -122.381181516112) | |||
| 22335 | 22335 | 3628 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 64 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017730.69941 | 2098422.13413 | 37.7428615520079 | -122.38130471064899 | (37.7428615520079, -122.381304710649) | |||
| 22341 | 22341 | 3629 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017712.663240001 | 2098437.04484 | 37.7429014981049 | -122.38136811194201 | (37.7429014981049, -122.381368111942) | |||
| 22321 | 22321 | 3630 | Private 5 | Melaleuca quinquenervia :: Cajeput 50 | 100X Cargo Way | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017698.24794 | 2098446.68655 | 37.7429271764597 | -122.381418626885 | (37.7429271764597, -122.381418626885) | |||
| 4973 | 4973 | 3631 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 67 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:27:00 PM | 3 | 3X3 | 6017682.09522 | 2098458.88711 | 37.7429597849556 | -122.381475327351 | (37.7429597849556, -122.381475327351) | ||
| 22340 | 22340 | 3632 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 68 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017663.5913 | 2098472.7680200003 | 37.7429968775117 | -122.38154027458799 | (37.7429968775117, -122.381540274588) | |||
| 22310 | 22310 | 3634 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 70 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017632.60306 | 2098495.95511 | 37.743058833606604 | -122.38164903679899 | (37.7430588336066, -122.381649036799) | |||
| 22315 | 22315 | 3636 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017599.14752 | 2098522.45762 | 37.7431297568333 | -122.38176656108601 | (37.7431297568333, -122.381766561086) | |||
| 22327 | 22327 | 3638 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 74 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017567.18226 | 2098548.9302 | 37.7432006800566 | -122.381878930467 | (37.7432006800566, -122.381878930467) | |||
| 22344 | 22344 | 3639 | Private 5 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180001995 | -122.381933568796 | (37.743238180002, -122.381933568796) | ||
| 22339 | 22339 | 3642 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 78 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017503.4842 | 2098606.02713 | 37.7433539389383 | -122.382103154832 | (37.7433539389383, -122.382103154832) | |||
| 22311 | 22311 | 3643 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 79 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017487.6627 | 2098619.8542 | 37.7433910314633 | -122.382158823763 | (37.7433910314633, -122.382158823763) | |||
| 22350 | 22350 | 3645 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 81 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017457.23238 | 2098648.52258 | 37.7434680683118 | -122.38226603915399 | (37.7434680683118, -122.382266039154) | ||
| 4950 | 4950 | 3646 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 82 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:16:00 AM | 3 | 3X3 | 6017441.11571 | 2098662.50366 | 37.7435055673357 | -122.38232273959999 | (37.7435055673357, -122.3823227396) | ||
| 22347 | 22347 | 3647 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 83 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017425.17191 | 2098677.66921 | 37.7435463281955 | -122.38237892474599 | (37.7435463281955, -122.382378924746) | ||
| 5058 | 5058 | 3648 | Private 5 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 100X Cargo Way | 84 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017409.48154 | 2098690.6025 | 37.7435809736936 | -122.382434078367 | (37.7435809736936, -122.382434078367) | ||
| 78203 | 78203 | 26198 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 3830 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3x4 | 6015747.5106037995 | 2098323.3315623 | 37.742480578689 | -122.388155190044 | (37.742480578689, -122.388155190044) | |||
| 109961 | 109961 | 22155 | Private 5 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1570X FAIRFAX AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | 3X3 | 6015579.0 | 2098247.0 | 37.74226164995721 | -122.388732527256 | (37.7422616499572, -122.388732527256) | |||
| 98596 | 98596 | 115128 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 104521 | 104521 | 115129 | Private 5 | Geijera parviflora :: Australian Willow 68 | 499X MAIN ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 6015842.0 | 2114626.0 | 37.7872494168956 | -122.388966430338 | (37.7872494168956, -122.388966430338) | ||||
| 95325 | 95325 | 111308 | Private 5 | Pinus radiata :: Monterey Pine 3 | 780x JAMESTOWN AVE | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6x90 | 6015099.0 | 2088640.0 | 37.7158561393861 | -122.389721379672 | (37.7158561393861, -122.389721379672) | ||||
| 109976 | 109976 | 117353 | Private 5 | Pittosporum crassifolium :: Karo Tree 108 | 101X China Basin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 772935 | 6015309.46376 | 2108739.72137 | 37.771057483634294 | -122.39039747437401 | (37.7710574836343, -122.390397474374) | |||
| 13709 | 13709 | 115878 | Private 5 | Pittosporum undulatum :: Victorian Box 26 | 1125X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6014969.9373 | 2096433.719 | 37.737248978447 | -122.390711808999 | (37.737248978447, -122.390711808999) | ||
| 15625 | 15625 | 109064 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014787.30736 | 2114269.34055 | 37.7862115942283 | -122.39259051256799 | (37.7862115942283, -122.392590512568) | ||
| 14482 | 14482 | 109063 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014773.1420599995 | 2114255.79417 | 37.7861736122787 | -122.39263857322901 | (37.7861736122787, -122.392638573229) | ||
| 16245 | 16245 | 109062 | Private 5 | Magnolia grandiflora :: Southern Magnolia 21 | 401 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2015 12:00:00 AM | 3 | Permit Number 774722 | 6014756.57852 | 2114238.14616 | 37.7861242349771 | -122.392694644144 | (37.7861242349771, -122.392694644144) | ||
| 94178 | 94178 | 22382 | Private 5 | Pyrus spp :: Pear Tree 291 | 2499X Mendell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | ||
| 119892 | 119892 | 22381 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1780 Bancroft Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | |||
| 127060 | 127060 | 22386 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6014045.0718623 | 2092725.5085003 | 37.7270156330804 | -122.393650054041 | (37.7270156330804, -122.393650054041) | |||
| 88690 | 88690 | 80520 | Private 5 | Pyrus spp :: Pear Tree 291 | 2499X Mendell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 2 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 90903 | 90903 | 80593 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1780 Bancroft Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 7 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 94668 | 94668 | 80514 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 97551 | 97551 | 80517 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 3 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 113265 | 113265 | 80510 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1740 Bancroft Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2007 12:00:00 AM | 9 | Permit Number 49651 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | ||
| 114609 | 114609 | 80518 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 5 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 114700 | 114700 | 80515 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 118440 | 118440 | 80512 | Private 5 | Alnus rhombifolia :: White Alder 204 | 1740 Bancroft Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 9 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 119627 | 119627 | 80516 | Private 5 | Pyrus spp :: Pear Tree 291 | 1769X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 4 | 6014044.43135761 | 2092726.27645989 | 37.7270177061512 | -122.393652321999 | (37.7270177061512, -122.393652321999) | |||
| 16217 | 16217 | 22383 | Private 5 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 1799X Armstrong Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/1997 12:00:00 AM | 2 | 4x15 | 6013476.602999999 | 2093118.78047 | 37.7280638732384 | -122.39564279807301 | (37.7280638732384, -122.395642798073) | ||
| 15764 | 15764 | 80467 | Private 5 | Alnus cordata :: Italian Alder 294 | 1780 Bancroft Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/07/2002 12:00:00 AM | 10 | 6013451.73876 | 2092852.71308 | 37.727331923129896 | -122.395710120444 | (37.7273319231299, -122.395710120444) | |||
| 102017 | 102017 | 85741 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 601X Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798001 | 2114488.497614 | 37.78672294116279 | -122.398229721423 | (37.7867229411628, -122.398229721423) | |
| 117366 | 117366 | 85739 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 601X Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798001 | 2114488.497614 | 37.78672294116279 | -122.398229721423 | (37.7867229411628, -122.398229721423) | |
| 142254 | 142254 | 85740 | Private 5 | Platanus x hispanica :: Sycamore: London Plane 15 | 601X Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2007 12:00:00 AM | 3 | 5x5 | Permit Number 770115 | 6013161.811798001 | 2114488.497614 | 37.78672294116279 | -122.398229721423 | (37.7867229411628, -122.398229721423) | |
| 981 | 981 | 191653 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 149 03rd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 5ft | 6012146.38303 | 2114300.35662 | 37.786149737060796 | -122.40172965521799 | (37.7861497370608, -122.401729655218) | |||
| 93974 | 93974 | 121246 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 94513 | 94513 | 121248 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 100736 | 100736 | 121249 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 113673 | 113673 | 121247 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 140147 | 140147 | 121245 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 500 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011462.5792 | 2116351.5538 | 37.791743655166 | -122.40423986853001 | (37.791743655166, -122.40423986853) | ||||
| 127330 | 127330 | 109501 | Private 5 | Ulmus americana :: American Elm 119 | 1400X on Filbert Montgomery St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | see 279 Filbert St. Same tree; shared responsibility | 6011485.9 | 2120124.8 | 37.802105381717894 | -122.404424889694 | (37.8021053817179, -122.404424889694) | ||||
| 90169 | 90169 | 104567 | Private 5 | Tree(s) :: 17 | 8 JOY ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6010448.0 | 2098932.0 | 37.7438568002142 | -122.40652229250799 | (37.7438568002142, -122.406522292508) | ||||
| 97007 | 97007 | 117070 | Private 5 | Tree(s) :: 17 | 6 JOY ST | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010444.0 | 2098901.0 | 37.7437714571602 | -122.406533939617 | (37.7437714571602, -122.406533939617) | |||||
| 82462 | 82462 | 114642 | Private 5 | Crataegus phaenopyrum :: Washington Hawthorn 135 | 30 MacEdonia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 773527 | 6010319.9 | 2099707.2 | 37.745978163196995 | -122.407019863158 | (37.745978163197, -122.407019863158) | |||
| 98944 | 98944 | 108170 | Private 5 | Ginkgo biloba :: Maidenhair Tree 44 | 1645 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 774689 | 6009348.4 | 2099893.7 | 37.7464358384441 | -122.410392359276 | (37.7464358384441, -122.410392359276) | |
| 13466 | 13466 | 104640 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 112 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 2.5x2.5 | 6009509.89326 | 2111697.52669 | 37.778855505921605 | -122.410667371323 | (37.7788555059216, -122.410667371323) | |||
| 123259 | 123259 | 73314 | Private 5 | Photinia fraseri :: Photinia: Chinese photinia 104 | 1142 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/09/2014 12:00:00 AM | 3 | 3x3 | 6009184.98526399 | 2102501.75487234 | 37.7535878144828 | -122.411141625253 | (37.7535878144828, -122.411141625253) | ||
| 79103 | 79103 | 120636 | Private 5 | Private shrub :: Private Shrub 64 | 385 Nevada St | 1 | Sidewalk: Property side : Cutout 5 | Landscaping 2 | Private 1 | 3x3 | 6008960.0 | 2096519.0 | 37.7371478708762 | -122.411497024701 | (37.7371478708762, -122.411497024701) | ||||
| 125580 | 125580 | 109829 | Private 5 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 629 TAYLOR ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/01/2015 12:00:00 AM | Permit Number 775362 | 6009246.3 | 2115118.4 | 37.7882336239769 | -122.41182103906 | (37.7882336239769, -122.41182103906) | |||
| 118626 | 118626 | 114647 | Private 5 | Eriobotrya deflexa :: Bronze Loquat 49 | 331 Prentiss St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | Permit Number 774946 | 6008851.6 | 2097283.6 | 37.7392412152063 | -122.41192582952 | (37.7392412152063, -122.41192582952) | |||
| 76816 | 76816 | 104448 | Private 5 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 88695 | 88695 | 104451 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 92561 | 92561 | 104449 | Private 5 | Acacia melanoxylon :: Blackwood Acacia 5 | 2490X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 100922 | 100922 | 104446 | Private 5 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 2490X Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 3x3 | 6008214.39649 | 2104163.7525299997 | 37.7580968032353 | -122.41461574816002 | (37.7580968032353, -122.41461574816) | ||||
| 139792 | 139792 | 104962 | Private 5 | Jacaranda mimosifolia :: Jacaranda 52 | 1474X SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 74 Aztec St. | 6008023.0 | 2099506.0 | 37.7452969115591 | -122.414948020341 | (37.7452969115591, -122.414948020341) | ||
| 94096 | 94096 | 100243 | Private 5 | Tree(s) :: 17 | 1326-1332 Shotwell St | unknown : Yard 19 | Tree 1 | Private 1 | 6008043.0 | 2100485.0 | 37.7479861507453 | -122.41494814206699 | (37.7479861507453, -122.414948142067) |
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");