Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlantDate, PermitNotes
| Link | rowid | TreeID | qLegalStatus ▼ | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16457 | 16457 | 93053 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | Front Yard : Yard 7 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 36 | Permit Number 53387 | |||||||||
| 78096 | 78096 | 93927 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 737 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.48050136001899 | (37.7173141872637, -122.480501360019) | |||
| 85216 | 85216 | 93054 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 737 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | 49 | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.48050136001899 | (37.7173141872637, -122.480501360019) | ||
| 89482 | 89482 | 20501 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 1204 Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 24 | 40 | 5984687.760267501 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | |||
| 93689 | 93689 | 87762 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 747 Howard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/28/2008 12:00:00 AM | 3x3 | Permit Number 50415 | 6012202.0 | 2113577.0 | 37.7841666723804 | -122.401486377799 | (37.7841666723804, -122.401486377799) | ||
| 114937 | 114937 | 100745 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 760 Duboce Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002024.1 | 2108325.5 | 37.7691742163209 | -122.43632225874201 | (37.7691742163209, -122.436322258742) | ||||
| 119139 | 119139 | 93928 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 737 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 04/28/2010 12:00:00 AM | Permit Number 53387 | 5988857.6 | 2089713.7 | 37.7173141872637 | -122.48050136001899 | (37.7173141872637, -122.480501360019) | |||
| 121574 | 121574 | 107680 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 330 Seacliff Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2014 12:00:00 AM | 3 | Permit Number 773561 | 5986760.072509999 | 2115557.0644799997 | 37.7881509278055 | -122.48965084577401 | (37.7881509278055, -122.489650845774) | ||
| 143452 | 143452 | 93925 | Permitted Site 1 | Pinus Spp :: Pine Spp 105 | 3711 19th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990297.3 | 2090806.0 | 37.7203969366505 | -122.475604756889 | (37.7203969366505, -122.475604756889) | |||||
| 697 | 697 | 251362 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1300X Stanyan St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 5997565.0 | 2104877.0 | 37.7594511396077 | -122.451497194349 | (37.7594511396077, -122.451497194349) | ||||
| 10196 | 10196 | 173897 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 90x Knollview Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997593.0 | 2101480.0 | 37.7501254274205 | -122.451155378281 | (37.7501254274205, -122.451155378281) | ||||
| 23978 | 23978 | 187335 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2200 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985078.6769 | 2099672.3252 | 37.744437598438 | -122.49429677682 | (37.744437598438, -122.49429677682) | |||
| 27463 | 27463 | 211050 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 50 Garcia Ave | 26 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 20 | Width 3ft | 5994765.06139 | 2099250.41987 | 37.7438412428942 | -122.460772924632 | (37.7438412428942, -122.460772924632) | |||
| 27965 | 27965 | 234486 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 787 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 3ft | 6003746.3772 | 2103694.46852 | 37.756556224011 | -122.43003459711201 | (37.756556224011, -122.430034597112) | |||
| 28154 | 28154 | 141534 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996778.1712 | 2111479.8816 | 37.7775358625794 | -122.454695458772 | (37.7775358625794, -122.454695458772) | |||
| 28380 | 28380 | 234484 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 310 Liberty St | 42 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6003878.87158 | 2103925.4289 | 37.7571978893843 | -122.42959285554 | (37.7571978893843, -122.42959285554) | |||
| 28544 | 28544 | 185496 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2400 Sunset Blvd | 50 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5985141.6583 | 2098649.8553 | 37.7416338578085 | -122.49400366283501 | (37.7416338578085, -122.494003662835) | |||
| 30047 | 30047 | 183336 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 4711 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981096.0962 | 2106871.8479 | 37.7639715747264 | -122.508601850774 | (37.7639715747264, -122.508601850774) | |||
| 34593 | 34593 | 234491 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 24 Saturn St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 17 | Width 3ft | 6000385.28479 | 2106021.7264900003 | 37.762755374980394 | -122.44182544748999 | (37.7627553749804, -122.44182544749) | |||
| 36960 | 36960 | 186829 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1200 Sunset Blvd | 94 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984823.8588 | 2106586.1554 | 37.763406151967004 | -122.49568774634399 | (37.763406151967, -122.495687746344) | |||
| 37649 | 37649 | 186778 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1200 Sunset Blvd | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 0ft | 5984835.1586 | 2106804.893 | 37.7640074057024 | -122.49566479975401 | (37.7640074057024, -122.495664799754) | |||
| 38786 | 38786 | 141495 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5996998.9899 | 2111511.9757 | 37.777636647844204 | -122.45393389566001 | (37.7776366478442, -122.45393389566) | |||
| 39235 | 39235 | 245150 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 100 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6000845.3118 | 2109360.3422 | 37.7719485860085 | -122.440473841976 | (37.7719485860085, -122.440473841976) | |||
| 42103 | 42103 | 245149 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1192 Page St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000871.2374 | 2109327.7689 | 37.771860624085605 | -122.440381827143 | (37.7718606240856, -122.440381827143) | |||
| 47475 | 47475 | 181474 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1400 Sunset Blvd | 34 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984899.5262 | 2105276.2272 | 37.7598138863622 | -122.495329430578 | (37.7598138863622, -122.495329430578) | |||
| 48416 | 48416 | 181408 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1500 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984930.7159 | 2104693.9263 | 37.758216876291705 | -122.49517862143298 | (37.7582168762917, -122.495178621433) | |||
| 48959 | 48959 | 186736 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1200 Sunset Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 0ft | 5984872.7556 | 2106587.8007 | 37.76341353282 | -122.49551875201401 | (37.76341353282, -122.495518752014) | |||
| 49052 | 49052 | 187039 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2501 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984947.4301 | 2097783.6094 | 37.7392440133349 | -122.49461138245701 | (37.7392440133349, -122.494611382457) | |||
| 51422 | 51422 | 187401 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2100 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985066.4729 | 2100733.1142 | 37.747349522643 | -122.49441715533301 | (37.747349522643, -122.494417155333) | |||
| 52433 | 52433 | 186132 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1700 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984975.4043 | 2103142.7715 | 37.753960450821 | -122.494909702152 | (37.753960450821, -122.494909702152) | |||
| 52966 | 52966 | 182054 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1358 30th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 5986815.972999999 | 2106023.5284 | 37.761977792282295 | -122.48875640158998 | (37.7619777922823, -122.48875640159) | |||
| 53283 | 53283 | 200142 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 700 Jamestown Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015325.0376 | 2088350.2198 | 37.7150729908419 | -122.388919862472 | (37.7150729908419, -122.388919862472) | |||
| 53997 | 53997 | 185510 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2200 Sunset Blvd | 57 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985082.4009 | 2099946.5475 | 37.745190756452104 | -122.49430410924101 | (37.7451907564521, -122.494304109241) | |||
| 56394 | 56394 | 185163 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2500 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985155.9352 | 2097682.682 | 37.7389790952829 | -122.493883039881 | (37.7389790952829, -122.493883039881) | |||
| 59145 | 59145 | 182059 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1358 30th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5986815.972999999 | 2106006.8659 | 37.7619320416514 | -122.48875517676001 | (37.7619320416514, -122.48875517676) | |||
| 60317 | 60317 | 211047 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 50 Garcia Ave | 23 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5994823.08708 | 2099248.0117900004 | 37.7438379693465 | -122.460572112329 | (37.7438379693465, -122.460572112329) | |||
| 61676 | 61676 | 185166 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2500 Sunset Blvd | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985143.9825 | 2097713.2278 | 37.7390622665176 | -122.49392661672199 | (37.7390622665176, -122.493926616722) | |||
| 63895 | 63895 | 181494 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1400 Sunset Blvd | 54 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984852.1847 | 2105397.6443 | 37.7601444918652 | -122.49550211431801 | (37.7601444918652, -122.495502114318) | |||
| 65122 | 65122 | 211044 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 372 Santa Clara Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 53 | Width 3ft | 5993146.9743 | 2095534.4165400001 | 37.73354479774971 | -122.466097865337 | (37.7335447977497, -122.466097865337) | |||
| 66704 | 66704 | 181365 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1600 Sunset Blvd | 92 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984912.4611 | 2104151.8757 | 37.75672748706779 | -122.495201781242 | (37.7567274870678, -122.495201781242) | |||
| 66801 | 66801 | 141530 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5996711.9256 | 2111472.0638 | 37.777510597006895 | -122.45492405811301 | (37.7775105970069, -122.454924058113) | |||
| 67160 | 67160 | 141491 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5996944.1281 | 2111502.1006 | 37.77760638771021 | -122.454122966753 | (37.7776063877102, -122.454122966753) | |||
| 69201 | 69201 | 234493 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 3278 Market St | 1 | : Yard 23 | Tree 1 | Private 1 | 14 | Width 3ft | 5999564.06934 | 2104457.47233 | 37.758413493117104 | -122.444553299888 | (37.7584134931171, -122.444553299888) | |||
| 74715 | 74715 | 234488 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 4090 20th St | 7 | : Yard 23 | Tree 1 | Private 1 | 16 | Width 3ft | 6003119.17834 | 2104176.3954 | 37.7578439389691 | -122.43223808994101 | (37.7578439389691, -122.432238089941) | |||
| 76781 | 76781 | 234489 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 4067 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6003294.37691 | 2104155.43702 | 37.757796324356796 | -122.431630684215 | (37.7577963243568, -122.431630684215) | |||
| 77185 | 77185 | 186156 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1700 Sunset Blvd | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984977.8278 | 2103337.3397 | 37.7544948232836 | -122.49491566635 | (37.7544948232836, -122.49491566635) | |||
| 81251 | 81251 | 110699 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 85074 | 85074 | 106324 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 800 INDIANA ST | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | ||||
| 86766 | 86766 | 110697 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 89635 | 89635 | 110703 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 9 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 91726 | 91726 | 110707 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 13 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 93740 | 93740 | 110709 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 15 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 100155 | 100155 | 110713 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 19 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 102018 | 102018 | 110259 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 655 SANCHEZ ST | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003729.2 | 2104438.0 | 37.75859681194179 | -122.430147043342 | (37.7585968119418, -122.430147043342) | |||||
| 103860 | 103860 | 98343 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999x Turk St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 02/01/2012 12:00:00 AM | 5x3 | Permit Number 768613 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||
| 104424 | 104424 | 117419 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 452 OAK ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6004802.0 | 2110240.0 | 37.774588415373 | -122.426850015779 | (37.774588415373, -122.426850015779) | |||||
| 104501 | 104501 | 106211 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1646 35TH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Permit Number 773238 | 5985355.0 | 2103995.9 | 37.7563251201532 | -122.49365984919201 | (37.7563251201532, -122.493659849192) | ||||
| 105826 | 105826 | 110705 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 116410 | 116410 | 112904 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 727 BURNETT AVE | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5999303.0 | 2101616.0 | 37.750596607185 | -122.44525189688 | (37.750596607185, -122.44525189688) | |||||
| 117765 | 117765 | 110711 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 17 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 122583 | 122583 | 110701 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2999X Turk St | 7 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5x3 | 5996638.0 | 2111487.0 | 37.7775473668867 | -122.455180869531 | (37.7775473668867, -122.455180869531) | ||||
| 126098 | 126098 | 110616 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 182X LOWER TER | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999820.0 | 2106230.0 | 37.763295015778205 | -122.44379552503 | (37.7632950157782, -122.44379552503) | |||||
| 129810 | 129810 | 187119 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2600 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985168.1593 | 2097316.6584 | 37.737974807749204 | -122.493813809362 | (37.7379748077492, -122.493813809362) | |||
| 130271 | 130271 | 234492 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 33 Mars St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 3ft | 5999611.22264 | 2105612.60046 | 37.761587879610204 | -122.444473240453 | (37.7615878796102, -122.444473240453) | |||
| 131566 | 131566 | 141485 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996846.7484 | 2111491.4026 | 37.7775714294456 | -122.454459061112 | (37.7775714294456, -122.454459061112) | |||
| 134005 | 134005 | 194520 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1600 Bay Shore Blvd | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6012006.62045 | 2091255.62525 | 37.7228661524341 | -122.40059377909901 | (37.7228661524341, -122.400593779099) | |||
| 141004 | 141004 | 110271 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 298X 28TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6004269.0 | 2099559.0 | 37.74523077681479 | -122.427932506483 | (37.7452307768148, -122.427932506483) | ||||
| 151044 | 151044 | 185161 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2500 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985124.0613 | 2097656.7845 | 37.738906122757896 | -122.493991335448 | (37.7389061227579, -122.493991335448) | |||
| 152090 | 152090 | 234485 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 3690 21st St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6003802.67178 | 2103657.18078 | 37.7564570287815 | -122.429837250793 | (37.7564570287815, -122.429837250793) | |||
| 155389 | 155389 | 181498 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1400 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5984861.653 | 2105433.8466 | 37.7602444476946 | -122.495472038545 | (37.7602444476946, -122.495472038545) | |||
| 155983 | 155983 | 185171 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2500 Sunset Blvd | 23 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985156.5992 | 2097759.0465 | 37.739188810565096 | -122.493886370266 | (37.7391888105651, -122.493886370266) | |||
| 156019 | 156019 | 187232 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2401 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984921.2891 | 2098611.514 | 37.7415156862998 | -122.494762787921 | (37.7415156862998, -122.494762787921) | |||
| 157663 | 157663 | 211048 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 50 Garcia Ave | 24 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | Width 3ft | 5994800.345480001 | 2099248.4883 | 37.743837969354 | -122.46065078142401 | (37.743837969354, -122.460650781424) | |||
| 159924 | 159924 | 234470 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 3717 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005016.09462 | 2102506.34942 | 37.7533657549424 | -122.425558901529 | (37.7533657549424, -122.425558901529) | |||
| 160315 | 160315 | 187220 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2401 Sunset Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 29 | Width 0ft | 5984921.2891 | 2098780.6261 | 37.7419800224632 | -122.494775253241 | (37.7419800224632, -122.494775253241) | |||
| 162273 | 162273 | 234487 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 380 Cumberland St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 44 | Width 3ft | 6003189.58252 | 2104492.34613 | 37.7587154557579 | -122.432017164278 | (37.7587154557579, -122.432017164278) | |||
| 164216 | 164216 | 186134 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1700 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5984955.6705 | 2103171.5067 | 37.754038194553 | -122.49498006395001 | (37.754038194553, -122.49498006395) | |||
| 167264 | 167264 | 186490 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1400 Lower Great Hwy | 36 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5980883.265 | 2105397.7493 | 37.7599115788226 | -122.509228480711 | (37.7599115788226, -122.509228480711) | |||
| 167582 | 167582 | 141484 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5996823.7065 | 2111503.4721 | 37.7776032476224 | -122.45453964246201 | (37.7776032476224, -122.454539642462) | |||
| 168797 | 168797 | 181422 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1500 Sunset Blvd | 55 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984930.7159 | 2104775.5208 | 37.758440912104994 | -122.49518463838301 | (37.758440912105, -122.495184638383) | |||
| 173740 | 173740 | 141619 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 31 LOYOLA TER | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5998404.7923 | 2110908.8953 | 37.7760612473543 | -122.449027315104 | (37.7760612473543, -122.449027315104) | |||
| 174229 | 174229 | 141487 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 0ft | 5996890.9122 | 2111495.5172 | 37.777585259805704 | -122.45430658183001 | (37.7775852598057, -122.45430658183) | |||
| 177477 | 177477 | 234490 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 4053 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 3ft | 6003306.74467 | 2104167.5073599997 | 37.7578301676468 | -122.43158877311001 | (37.7578301676468, -122.43158877311) | |||
| 177907 | 177907 | 200796 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 700 Jamestown Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 6015315.685 | 2088368.925 | 37.7151238332906 | -122.388953494511 | (37.7151238332906, -122.388953494511) | |||
| 178134 | 178134 | 185537 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2201 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984862.7264 | 2100065.7068 | 37.7455050775816 | -122.49507247978701 | (37.7455050775816, -122.495072479787) | |||
| 178334 | 178334 | 141536 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996809.4424 | 2111483.7219 | 37.7775482006436 | -122.454587559354 | (37.7775482006436, -122.454587559354) | |||
| 179426 | 179426 | 186012 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1900 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985010.9219 | 2101736.8552 | 37.750102270029004 | -122.49468323246599 | (37.750102270029, -122.494683232466) | |||
| 179859 | 179859 | 185865 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2000 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985059.0462 | 2100990.2907 | 37.7480552245721 | -122.494461791049 | (37.7480552245721, -122.494461791049) | |||
| 182325 | 182325 | 141493 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996968.2673 | 2111507.0382 | 37.777621329210604 | -122.45403981826999 | (37.7776213292106, -122.45403981827) | |||
| 182614 | 182614 | 186783 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1200 Sunset Blvd | 51 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 0ft | 5984862.3254 | 2106838.1239 | 37.7641002392741 | -122.49557329041001 | (37.7641002392741, -122.49557329041) | |||
| 183371 | 183371 | 185462 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2400 Sunset Blvd | 13 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985138.3382 | 2098374.943 | 37.740878828405 | -122.49399488645399 | (37.740878828405, -122.493994886454) | |||
| 183885 | 183885 | 186135 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1700 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984963.2871 | 2103177.7384 | 37.7540557509571 | -122.494954183766 | (37.7540557509571, -122.494954183766) | |||
| 184244 | 184244 | 211045 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 380 Santa Clara Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 33 | Width 3ft | 5993150.7745 | 2095420.35942 | 37.7332318444736 | -122.466076441693 | (37.7332318444736, -122.466076441693) | |||
| 184380 | 184380 | 186133 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 1700 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984952.5547 | 2103165.275 | 37.754020901623704 | -122.494990379508 | (37.7540209016237, -122.494990379508) | |||
| 184967 | 184967 | 132165 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 3075 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6000074.17402 | 2115752.57218 | 37.789456068495795 | -122.44360053206499 | (37.7894560684958, -122.443600532065) | |||
| 186053 | 186053 | 211049 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 50 Garcia Ave | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 3ft | 5994782.37935 | 2099248.2683200003 | 37.7438363316793 | -122.46071288771499 | (37.7438363316793, -122.460712887715) | |||
| 186189 | 186189 | 233336 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 5545 Diamond Heights Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 9ft | 6001777.475869999 | 2097325.41548 | 37.7389566084644 | -122.436387932367 | (37.7389566084644, -122.436387932367) | |||
| 187590 | 187590 | 141489 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 2901 TURK BLVD | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 0ft | 5996912.3083 | 2111498.8089 | 37.777595524924 | -122.45423280375 | (37.777595524924, -122.45423280375) | |||
| 188552 | 188552 | 211046 | Undocumented 2 | Pinus Spp :: Pine Spp 105 | 251 Wildwood Way | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | Width 3ft | 5995705.57302 | 2093291.07499 | 37.727532405390896 | -122.457089894179 | (37.7275324053909, -122.457089894179) | |||
| 812 | 812 | 19648 | DPW Maintained 3 | Pinus Spp :: Pine Spp 105 | 100 STAIRWAY5 | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60ST |
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");