Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4747 | 4747 | 253677 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 199X Kissling St | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 5x10 | |||||||||
| 7041 | 7041 | 20305 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 50X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 7433 | 7433 | 19666 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60ST | ||||||||
| 10919 | 10919 | 19986 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY46 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | ||||||||
| 11206 | 11206 | 20301 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 50X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 11841 | 11841 | 19663 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 11943 | 11943 | 19664 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 12961 | 12961 | 87019 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 10 Osceola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | Permit Number 49949 | ||||||||
| 14276 | 14276 | 19667 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY5 | 66 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST | ||||||||
| 16176 | 16176 | 19976 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY45 | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 16885 | 16885 | 19980 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 100 STAIRWAY45 | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30ST | ||||||||
| 161403 | 161403 | 118538 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7900x Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 5982472.235830001 | 2112389.87128 | 37.7792034803758 | -122.504251064408 | (37.7792034803758, -122.504251064408) | |||
| 128707 | 128707 | 27300 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1999 12:00:00 AM | 6 | 5x5 | 5982547.933540001 | 2112415.51016 | 37.7792783288562 | -122.50399109880101 | (37.7792783288562, -122.503991098801) | ||
| 86601 | 86601 | 27299 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 6 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982630.17797 | 2112395.09735 | 37.779227117259296 | -122.503705073784 | (37.7792271172593, -122.503705073784) | ||
| 143978 | 143978 | 27298 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 5 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982658.07107 | 2112395.9042 | 37.7792309725957 | -122.503608641413 | (37.7792309725957, -122.503608641413) | ||
| 111288 | 111288 | 27297 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982680.863919999 | 2112396.64212 | 37.7792343387449 | -122.50352984750401 | (37.7792343387449, -122.503529847504) | ||
| 114112 | 114112 | 27296 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 3 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982703.46074 | 2112397.7930900003 | 37.7792388274313 | -122.50345176232 | (37.7792388274313, -122.50345176232) | ||
| 92056 | 92056 | 27295 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 2 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 06/10/1999 12:00:00 AM | 6 | 5X5 | 5982729.47953 | 2112398.50568 | 37.779242313567295 | -122.50336180684499 | (37.7792423135673, -122.503361806845) | ||
| 125546 | 125546 | 27294 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 7800X Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | Fire Dept 11 | 02/12/2001 12:00:00 AM | 6 | 5X5 | 5982752.16339 | 2112399.44122 | 37.77924621575129 | -122.503283404585 | (37.7792462157513, -122.503283404585) | ||
| 96458 | 96458 | 116067 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 4150X CLEMENT ST | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 04/15/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777818 | 5983115.0 | 2113126.0 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | |
| 117254 | 117254 | 24789 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 7700 Geary Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 4X4 | 5983110.07731 | 2112460.67779 | 37.779435386439204 | -122.50204978501301 | (37.7794353864392, -122.502049785013) | |||
| 185501 | 185501 | 184347 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1251 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984658.9334 | 2106421.3632 | 37.7629440193232 | -122.49624600189699 | (37.7629440193232, -122.496246001897) | |||
| 64531 | 64531 | 184348 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1251 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984683.9949 | 2106431.9954 | 37.762974680362206 | -122.496160108596 | (37.7629746803622, -122.496160108596) | |||
| 70507 | 70507 | 184801 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1301 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984720.8276 | 2105758.3732 | 37.7611272600096 | -122.49598302148998 | (37.7611272600096, -122.49598302149) | |||
| 44224 | 44224 | 186691 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984728.0673 | 2105259.502 | 37.7597579231437 | -122.49592118002701 | (37.7597579231437, -122.495921180027) | |||
| 69894 | 69894 | 186685 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984734.6622 | 2105357.4834 | 37.7600273389586 | -122.495905599978 | (37.7600273389586, -122.495905599978) | |||
| 69007 | 69007 | 186699 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1401 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984730.9983 | 2105175.3386 | 37.759527005597604 | -122.495904834542 | (37.7595270055976, -122.495904834542) | |||
| 74141 | 74141 | 186421 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984727.9626 | 2104153.7573 | 37.756721849906 | -122.495839973726 | (37.756721849906, -122.495839973726) | |||
| 170936 | 170936 | 186435 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984740.5243 | 2104016.8346 | 37.7563466338471 | -122.495786431621 | (37.7563466338471, -122.495786431621) | |||
| 177987 | 177987 | 186620 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1501 Sunset Blvd | 91 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984755.0749 | 2104355.2681 | 37.7572767304033 | -122.495761074715 | (37.7572767304033, -122.495761074715) | |||
| 36257 | 36257 | 186440 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984767.7413 | 2103960.7256 | 37.7561941679911 | -122.495688168642 | (37.7561941679911, -122.495688168642) | |||
| 91520 | 91520 | 186238 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1701 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984762.5292 | 2103340.0793 | 37.7544897398871 | -122.49566041616501 | (37.7544897398871, -122.495660416165) | |||
| 70815 | 70815 | 186456 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984777.372 | 2103875.7247 | 37.755961343063895 | -122.49564859346701 | (37.7559613430639, -122.495648593467) | |||
| 28596 | 28596 | 186468 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1601 Sunset Blvd | 56 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984781.1405 | 2103769.7876 | 37.755670689824704 | -122.495627747424 | (37.7556706898247, -122.495627747424) | |||
| 55771 | 55771 | 186733 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1250 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984855.8629 | 2106397.0571 | 37.7628888152225 | -122.49556310804701 | (37.7628888152225, -122.495563108047) | |||
| 187908 | 187908 | 181540 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1300 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984863.0454 | 2105869.1102 | 37.7614396414651 | -122.49549932614799 | (37.7614396414651, -122.495499326148) | |||
| 174927 | 174927 | 181557 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1300 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984875.8554 | 2106073.5142 | 37.76200162774529 | -122.495470098326 | (37.7620016277453, -122.495470098326) | |||
| 161248 | 161248 | 186247 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1701 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984819.3113 | 2103171.6078 | 37.754030488698895 | -122.49545162726801 | (37.7540304886989, -122.495451627268) | |||
| 25884 | 25884 | 186251 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1701 Sunset Blvd | 62 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984830.2927 | 2103110.5403 | 37.7538634572036 | -122.495409148018 | (37.7538634572036, -122.495409148018) | |||
| 174392 | 174392 | 181538 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1300 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984897.5768 | 2105857.4141 | 37.761409549185 | -122.495379035532 | (37.761409549185, -122.495379035532) | |||
| 136877 | 136877 | 181519 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1400 Sunset Blvd | 79 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984899.8047 | 2105606.7824 | 37.76072151501489 | -122.49535284581002 | (37.7607215150149, -122.49535284581) | |||
| 44219 | 44219 | 186081 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1901 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984821.8866 | 2101948.8735 | 37.7506733477582 | -122.49535255189899 | (37.7506733477582, -122.495352551899) | |||
| 49925 | 49925 | 186380 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1801 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984843.2782 | 2102467.9478 | 37.7520998356184 | -122.495316855331 | (37.7520998356184, -122.495316855331) | |||
| 166214 | 166214 | 181513 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1400 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984909.8299 | 2105563.3396 | 37.7606028201969 | -122.49531496977501 | (37.7606028201969, -122.495314969775) | |||
| 72881 | 72881 | 186381 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1801 Sunset Blvd | 48 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984844.8943 | 2102435.3563 | 37.75201044294921 | -122.495308863381 | (37.7520104429492, -122.495308863381) | |||
| 169644 | 169644 | 185964 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2001 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984823.122 | 2101326.4259 | 37.7489643495953 | -122.495302381208 | (37.7489643495953, -122.495302381208) | |||
| 68825 | 68825 | 185954 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2001 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984829.7049 | 2101412.004 | 37.749199709057706 | -122.495285928093 | (37.7491997090577, -122.495285928093) | |||
| 177368 | 177368 | 181473 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1400 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984918.4628 | 2105275.6702 | 37.759813465723795 | -122.49526389807 | (37.7598134657238, -122.49526389807) | |||
| 74910 | 74910 | 186080 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1901 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984851.2986 | 2101988.3321 | 37.7507834123081 | -122.49525375381599 | (37.7507834123081, -122.495253753816) | |||
| 54231 | 54231 | 181385 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1500 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984917.5854 | 2104501.8427 | 37.7576886993488 | -122.495209866912 | (37.7576886993488, -122.495209866912) | |||
| 175688 | 175688 | 185676 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2101 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984839.348999999 | 2100771.308 | 37.747441097621206 | -122.495205338122 | (37.7474410976212, -122.495205338122) | |||
| 37001 | 37001 | 185960 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2001 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984855.8243 | 2101346.8117 | 37.7490222380818 | -122.49519080130301 | (37.7490222380818, -122.495190801303) | |||
| 64562 | 64562 | 181379 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1500 Sunset Blvd | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984933.4588 | 2104463.134 | 37.7575833453331 | -122.495152116603 | (37.7575833453331, -122.495152116603) | |||
| 179757 | 179757 | 185955 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2001 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984875.9978 | 2101408.1817 | 37.7491919243755 | -122.49512556709298 | (37.7491919243755, -122.495125567093) | |||
| 170555 | 170555 | 181384 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1500 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984945.4334 | 2104486.2478 | 37.75764751046 | -122.49511240858 | (37.75764751046, -122.49511240858) | |||
| 183135 | 183135 | 186167 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1700 Sunset Blvd | 52 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984926.5892 | 2103481.0156 | 37.7548863180592 | -122.49510345420799 | (37.7548863180592, -122.495103454208) | |||
| 136097 | 136097 | 185539 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2201 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984878.3804 | 2100042.8891 | 37.7454433428019 | -122.495016669314 | (37.7454433428019, -122.495016669314) | |||
| 37263 | 37263 | 185562 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2201 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984881.299 | 2099768.8111 | 37.7446909699364 | -122.494986371806 | (37.7446909699364, -122.494986371806) | |||
| 174832 | 174832 | 185700 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2101 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984899.9898 | 2100515.832 | 37.7467431803198 | -122.494976814737 | (37.7467431803198, -122.494976814737) | |||
| 156327 | 156327 | 185563 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2201 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984887.6667 | 2099768.5458 | 37.7446906142612 | -122.49496433430599 | (37.7446906142612, -122.494964334306) | |||
| 72624 | 72624 | 185709 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2101 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984908.4893 | 2100423.9717 | 37.7464914545154 | -122.49494065264601 | (37.7464914545154, -122.494940652646) | |||
| 171858 | 171858 | 185535 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2201 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984921.0973 | 2100070.748 | 37.745522336384795 | -122.49487101697099 | (37.7455223363848, -122.494871016971) | |||
| 67079 | 67079 | 186038 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1900 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984981.8854 | 2102120.1374 | 37.7511529582795 | -122.494811896529 | (37.7511529582795, -122.494811896529) | |||
| 185213 | 185213 | 187193 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2301 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984945.2043 | 2099085.395 | 37.7428182353231 | -122.49471502746701 | (37.7428182353231, -122.494715027467) | |||
| 179683 | 179683 | 185932 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2000 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984999.1426 | 2101513.5873 | 37.7494885480173 | -122.494707506851 | (37.7494885480173, -122.494707506851) | |||
| 45298 | 45298 | 186040 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 1900 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985014.7934 | 2102133.6877 | 37.7511920899125 | -122.49469909773998 | (37.7511920899125, -122.49469909774) | |||
| 179595 | 179595 | 185906 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2000 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985026.2976 | 2101345.2263 | 37.7490278641469 | -122.49460119526 | (37.7490278641469, -122.49460119526) | |||
| 69760 | 69760 | 185902 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2000 Sunset Blvd | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985031.1855 | 2101301.2352 | 37.7489073626901 | -122.494581050501 | (37.7489073626901, -122.494581050501) | |||
| 30200 | 30200 | 185930 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2000 Sunset Blvd | 73 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985039.332 | 2101497.8374 | 37.7494476553955 | -122.494567371863 | (37.7494476553955, -122.494567371863) | |||
| 170060 | 170060 | 185310 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 35 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984962.2385 | 2097256.121 | 37.737796538483295 | -122.494521307154 | (37.7377965384833, -122.494521307154) | |||
| 164480 | 164480 | 185307 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 32 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984973.1253 | 2097316.8359 | 37.7379638824881 | -122.494488141215 | (37.7379638824881, -122.494488141215) | |||
| 183666 | 183666 | 187385 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2200 Sunset Blvd | 71 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985037.3743 | 2100116.159 | 37.7456538284953 | -122.49447230207399 | (37.7456538284953, -122.494472302074) | |||
| 153955 | 153955 | 185290 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984983.8028 | 2097379.2257 | 37.738135813056005 | -122.494455822202 | (37.738135813056, -122.494455822202) | |||
| 172467 | 172467 | 187388 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2200 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985049.5619 | 2100144.9354 | 37.7457335539505 | -122.49443228067 | (37.7457335539505, -122.49443228067) | |||
| 100839 | 100839 | 111575 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 1x SUNSET BLVD OFF RAMP | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | 3x3 | 5984955.0 | 2095624.0 | 37.7333147463652 | -122.494426056577 | (37.7333147463652, -122.494426056577) | |||
| 135334 | 135334 | 184982 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2701 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984985.373 | 2096691.7859999998 | 37.7362483795762 | -122.494399733702 | (37.7362483795762, -122.494399733702) | |||
| 38117 | 38117 | 185308 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2601 Sunset Blvd | 33 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985001.1798 | 2097292.5499 | 37.737898841519105 | -122.494389354717 | (37.7378988415191, -122.494389354717) | |||
| 54265 | 54265 | 185439 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2300 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985094.1378 | 2099479.3093 | 37.74390853380999 | -122.494229093058 | (37.74390853381, -122.494229093058) | |||
| 84253 | 84253 | 21431 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2692X Sunset Blvd | 28 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 117137 | 117137 | 21429 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2692X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | |||
| 157592 | 157592 | 185023 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2701 Sunset Blvd | 49 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985046.0879999995 | 2096329.59 | 37.735257439095705 | -122.49416313243499 | (37.7352574390957, -122.494163132435) | |||
| 163106 | 163106 | 185033 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2701 Sunset Blvd | 59 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985049.8565 | 2096299.4419 | 37.7351748809707 | -122.494147882197 | (37.7351748809707, -122.494147882197) | |||
| 79809 | 79809 | 21491 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2792X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | 5985060.3629888 | 2096294.4798015 | 37.735161871163605 | -122.49411119238 | (37.7351618711636, -122.49411119238) | |||
| 141886 | 141886 | 21459 | DPW Maintained 3 | Pinus canariensis :: Canary Island Pine 71 | 2701X Sunset Blvd | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | 5985119.006821499 | 2096832.7848434 | 37.73664334454379 | -122.49394810120701 | (37.7366433445438, -122.493948101207) | |||
| 28677 | 28677 | 187129 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 0ft | 5985149.8207 | 2097410.2322 | 37.738230663406604 | -122.493884107972 | (37.7382306634066, -122.493884107972) | |||
| 53718 | 53718 | 187133 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 69 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985163.4571 | 2097445.4987 | 37.738328293602294 | -122.493839558913 | (37.7383282936023, -122.493839558913) | |||
| 137509 | 137509 | 187121 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2600 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985174.7424 | 2097328.4139 | 37.7380074703554 | -122.493791914706 | (37.7380074703554, -122.493791914706) | |||
| 147538 | 147538 | 186878 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 27 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985170.4646 | 2096439.5838 | 37.7355667300556 | -122.493741225987 | (37.7355667300556, -122.493741225987) | |||
| 160627 | 160627 | 186893 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985181.9251 | 2096557.8565 | 37.7358921458374 | -122.493710315825 | (37.7358921458374, -122.493710315825) | |||
| 115433 | 115433 | 186889 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985183.3004 | 2096502.846 | 37.7357411821318 | -122.49370150858101 | (37.7357411821318, -122.493701508581) | |||
| 35365 | 35365 | 186855 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985186.2801 | 2096278.9071 | 37.735126479902895 | -122.49367471051 | (37.7351264799029, -122.49367471051) | |||
| 173075 | 173075 | 186890 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985200.262 | 2096503.3044 | 37.7357434330648 | -122.493642900348 | (37.7357434330648, -122.493642900348) | |||
| 159660 | 159660 | 186880 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 29 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5985201.1788 | 2096460.2128 | 37.73562516865071 | -122.49363655642 | (37.7356251686507, -122.49363655642) | |||
| 39074 | 39074 | 186875 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2700 Sunset Blvd | 24 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5985206.2214 | 2096387.7822 | 37.7354265885186 | -122.493613787113 | (37.7354265885186, -122.493613787113) | |||
| 63231 | 63231 | 185118 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 2850 35th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 0ft | 5985615.0479 | 2096000.8357 | 37.734388044102204 | -122.49217185843099 | (37.7343880441022, -122.492171858431) | |||
| 96595 | 96595 | 106311 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 142007 | 142007 | 106310 | Significant Tree 6 | Pinus canariensis :: Canary Island Pine 71 | 99X Clearfield Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 04/15/2014 12:00:00 AM | Permit Number 772542 | 5985798.26078 | 2095453.4648400003 | 37.73289581695511 | -122.49149816384899 | (37.7328958169551, -122.491498163849) | |||
| 102481 | 102481 | 114925 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 3 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 103199 | 103199 | 114934 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 4400x OCEAN AVE | 10 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 02/17/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777127 | 5985931.0 | 2095134.0 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | |
| 71190 | 71190 | 91505 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/04/2009 12:00:00 AM | 3x3 | Permit Number 52122 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) |
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");