trees
603 rows where qSpecies_id = 172 sorted by rowid descending
This data as json, CSV (advanced)
rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
156170 | 197174 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 3 | Front Yard : Yard | Tree | Private 2 | 16 | 6012741.09137 | 2102852.39923 | 37.754749394281 | -122.3988683569 | (37.754749394281, -122.3988683569) | 10 | 3 | 8 | 28856 | 29 | ||||
156144 | 240266 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 517 Powhattan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6008451.38564 | 2098131.73505 | 37.7415475462877 | -122.413369559781 | (37.7415475462877, -122.413369559781) | 2 | 7 | 7 | 28859 | 2 | ||||
155766 | 43424 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | 9 | 7 | 6 | 28861 | 25 | |||
155710 | 197191 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 12 | Front Yard : Yard | Tree | Private 2 | 18 | 6015839.12005 | 2099880.54912 | 37.7467614521736 | -122.387947067298 | (37.7467614521736, -122.387947067298) | 3 | 8 | 58 | 1 | |||||
155581 | 240267 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 517 Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008465.29724 | 2098131.45059 | 37.7415475462934 | -122.413321437934 | (37.7415475462934, -122.413321437934) | 2 | 7 | 7 | 28859 | 2 | ||||
155576 | 197176 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 5 | Front Yard : Yard | Tree | Private 2 | 8 | 6012733.87653 | 2102837.73579 | 37.7547087296482 | -122.398892278868 | (37.7547087296482, -122.398892278868) | 10 | 3 | 8 | 28856 | 29 | ||||
155440 | 122361 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
155260 | 82821 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
155235 | 43428 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | 9 | 7 | 6 | 28861 | 25 | |||
155168 | 248108 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 138 Rutledge St | 2 | Side Yard : Yard | Tree | Private 2 | 9 | 6010425.17878 | 2099467.65541 | 37.7453263167524 | -122.406638943637 | (37.7453263167524, -122.406638943637) | 2 | 7 | 7 | 28859 | 2 | ||||
154987 | 187173 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984924.4635 | 2099259.0989 | 37.7432939651876 | -122.494799546416 | (37.7432939651876, -122.494799546416) | 1 | 8 | 3 | 29491 | 35 | |||
154848 | 83004 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 2 | 3x3 | Permit Number 52363 | 6015190.2158 | 2094494.6392 | 37.7319368775726 | -122.38981479563 | (37.7319368775726, -122.38981479563) | 10 | 3 | 8 | 58 | 1 | |
154564 | 44158 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
153743 | 86758 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
153671 | 46627 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1426 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/24/2008 12:00:00 AM | 0 | 3x3 | Permit Number 51060 | 6016155.81653285 | 2095029.68224774 | 37.7334594988152 | -122.386513771605 | (37.7334594988152, -122.386513771605) | 10 | 3 | 8 | 58 | 1 | |
153607 | 136276 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1927 Jackson St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6004921.8107 | 2117075.88034 | 37.7933648188709 | -122.426922521966 | (37.7933648188709, -122.426922521966) | 13 | 9 | 1 | 28858 | 27 | |||
153592 | 44155 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
152360 | 197180 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300x De Haro St | 11 | Median : Yard | Tree | DPW 1 | 1 | 6012255.35088 | 2102175.8421 | 37.752864638318 | -122.400500669565 | (37.752864638318, -122.400500669565) | 10 | 3 | 8 | 28856 | 29 | ||||
152028 | 186718 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984858.7629 | 2106161.3325 | 37.7622417513471 | -122.495535691127 | (37.7622417513471, -122.495535691127) | 1 | 8 | 3 | 56 | 35 | |||
152026 | 197193 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 15 | Front Yard : Yard | Tree | Private 2 | 10 | 6015814.64437 | 2099848.11828 | 37.7466710478274 | -122.388029439803 | (37.7466710478274, -122.388029439803) | 3 | 8 | 58 | 1 | |||||
151904 | 240258 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005731.26515 | 2097042.36388 | 37.7384032789939 | -122.422697425158 | (37.7384032789939, -122.422697425158) | 2 | 7 | 7 | 28859 | 2 | |||
151051 | 214003 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 618 Detroit St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5999463.68077 | 2095057.68316 | 37.7325982064306 | -122.444225026661 | (37.7325982064306, -122.444225026661) | 9 | 7 | 4 | 63 | 40 | |||
150842 | 247067 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2401 Castro St | 3 | Front Yard : Yard | Tree | Private 2 | 2 | 6002720.65307 | 2098435.27212 | 37.7420575653112 | -122.43320614446 | (37.7420575653112, -122.43320614446) | 2 | 7 | 5 | 63 | 22 | ||||
150261 | 185926 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2000 Sunset Blvd | 69 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985039.332 | 2101464.7083 | 37.7493566919454 | -122.494564929901 | (37.7493566919454, -122.494564929901) | 1 | 8 | 3 | 29491 | 35 | |||
149820 | 43450 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999728.91774 | 2091148.65353 | 37.7218800449238 | -122.443027412104 | (37.7218800449238, -122.443027412104) | 9 | 7 | 6 | 28861 | 25 | |
149795 | 44152 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
149673 | 82823 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
149518 | 109194 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 4705 03rd St | Back Yard : Yard | Tree | Arts Commission 19 | 45 | 6015121.6 | 2095617 | 37.7350148477359 | -122.390130397219 | (37.7350148477359, -122.390130397219) | 10 | 3 | 8 | 58 | 1 | |||||
149454 | 213998 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1550 15th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 5991562.73982 | 2104919.95067 | 37.7592235268581 | -122.472258895832 | (37.7592235268581, -122.472258895832) | 1 | 8 | 4 | 56 | 12 | ||||
149127 | 247906 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 582 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 14 | 6009848.12474 | 2098746.9527 | 37.7433151223901 | -122.408583479341 | (37.7433151223901, -122.408583479341) | 2 | 7 | 7 | 28859 | 2 | ||||
148885 | 240210 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 51 13th St | 7 | : | Tree | Private 2 | 17 | Width 5ft | 6008246.66601 | 2108275.00033 | 37.7693871520159 | -122.414795103918 | (37.7693871520159, -122.414795103918) | 8 | 4 | 7 | 28853 | 19 | |||
147980 | 111447 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 37 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
147827 | 186721 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 55 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984840.7181 | 2106188.7756 | 37.7623160457552 | -122.495600124584 | (37.7623160457552, -122.495600124584) | 1 | 8 | 3 | 56 | 35 | |||
146842 | 247840 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 77 Nevada St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6009043.26333 | 2098169.73656 | 37.7416851038897 | -122.41132572452 | (37.7416851038897, -122.41132572452) | 10 | 7 | 7 | 28859 | 2 | ||||
146395 | 240249 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6005950.84346 | 2096924.89627 | 37.7380931253039 | -122.421929887075 | (37.7380931253039, -122.421929887075) | 2 | 7 | 7 | 28859 | 2 | |||
145677 | 43427 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | 9 | 7 | 6 | 28861 | 25 | |||
145588 | 95750 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003564.18987 | 2092436.84432 | 37.7256350580097 | -122.429861698861 | (37.7256350580097, -122.429861698861) | 9 | 7 | 6 | 28861 | 5 |
144961 | 240291 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2854 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009093.93311 | 2103358.72756 | 37.7559357619427 | -122.411517046282 | (37.7559357619427, -122.411517046282) | 2 | 4 | 7 | 28859 | 19 | |||
144463 | 43455 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | Permit Number 43162 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||
144324 | 248047 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 38 Rutledge St | 4 | Side Yard : Yard | Tree | Private 2 | 10 | 6010533.5153 | 2099430.75993 | 37.7452310704548 | -122.406261732916 | (37.7452310704548, -122.406261732916) | 2 | 7 | 7 | 28859 | 2 | ||||
144216 | 111439 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6 | 5999870.68262 | 2091075.24274 | 37.7216865575792 | -122.442532100582 | (37.7216865575792, -122.442532100582) | 9 | 7 | 6 | 28861 | 25 | |||
144174 | 197201 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6012348.82133 | 2096403.61302 | 37.7370205425534 | -122.399772154858 | (37.7370205425534, -122.399772154858) | 10 | 3 | 8 | 58 | 1 | ||||
143972 | 247528 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Waller St | 9 | Side Yard : Yard | Tree | Private 2 | 2 | 6000060.08033 | 2108486.82414 | 37.7695053822964 | -122.443127261125 | (37.7695053822964, -122.443127261125) | 15 | 5 | 11 | 29492 | 9 | ||||
143954 | 247841 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 77 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6009047.64568 | 2098175.65883 | 37.7417016109343 | -122.411310990032 | (37.7417016109343, -122.411310990032) | 10 | 7 | 7 | 28859 | 2 | ||||
142891 | 142295 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 455 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000605.8018 | 2110575.2317 | 37.7752707254694 | -122.441389511979 | (37.7752707254694, -122.441389511979) | 15 | 5 | 11 | 29492 | 16 | |||
142670 | 43426 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | 9 | 7 | 6 | 28861 | 25 | |||
141902 | 240243 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6006173.88542 | 2096803.38775 | 37.7377720664226 | -122.421150093012 | (37.7377720664226, -122.421150093012) | 2 | 7 | 7 | 28859 | 2 | |||
141167 | 240261 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6005665.98783 | 2097078.5629 | 37.7384989902395 | -122.422925694672 | (37.7384989902395, -122.422925694672) | 2 | 7 | 7 | 28859 | 2 | |||
140708 | 92256 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 854 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/23/2009 12:00:00 AM | 7 | 3x3 | Permit Number 52705 | 5981409.14795 | 2109916.38361 | 37.7723494315348 | -122.507745058107 | (37.7723494315348, -122.507745058107) | 11 | 6 | 2 | 55 | 26 | |
140654 | 240211 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1001 San Jose Ave | 17 | Front Yard : Yard | Tree | Private 2 | 2 | 6005198.75303 | 2096936.51441 | 37.7380825816504 | -122.424531067257 | (37.7380825816504, -122.424531067257) | 2 | 7 | 5 | 28859 | 2 | ||||
140467 | 197206 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6019299.00025 | 2093665.65157 | 37.7298876336035 | -122.375552245738 | (37.7298876336035, -122.375552245738) | 10 | 3 | 8 | 58 | 1 | ||||
140411 | 90246 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986239.468923 | 2111161.958067 | 37.7760528187899 | -122.491128444049 | (37.7760528187899, -122.491128444049) | 11 | 6 | 2 | 55 | 26 | |
140317 | 202104 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 8ft | 6012020.3729 | 2092885.52976 | 37.7273423030982 | -122.400660684147 | (37.7273423030982, -122.400660684147) | 10 | 3 | 8 | 58 | 1 | |||
139974 | 30885 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 248 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 16 | Permit Number 34717 | 6003986.5052 | 2089044.44729 | 37.7163441880118 | -122.428160134779 | (37.7163441880118, -122.428160134779) | 9 | 7 | 6 | 28861 | 5 | ||
139340 | 96616 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2943 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 3 | 3x6 | Permit Number 767742 | 6002898.54873 | 2118761.82237 | 37.7978793705859 | -122.434043718143 | (37.7978793705859, -122.434043718143) | 13 | 9 | 1 | 57 | 17 | |
139293 | 247619 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 10 | Front Yard : Yard | Tree | Private 2 | 4 | 6009506.60291 | 2096847.67057 | 37.738080973649 | -122.409630353184 | (37.738080973649, -122.409630353184) | 10 | 7 | 7 | 28859 | 2 | ||||
139145 | 43449 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 24 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999756.32409 | 2091134.05765 | 37.7218415305512 | -122.442931628018 | (37.7218415305512, -122.442931628018) | 9 | 7 | 6 | 28861 | 25 | |
139094 | 202103 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 8ft | 6012036.54433 | 2092874.73876 | 37.7273135751543 | -122.400604021475 | (37.7273135751543, -122.400604021475) | 10 | 3 | 8 | 58 | 1 | |||
138755 | 187016 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2501 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984995.5183 | 2097938.2985 | 37.7396715624933 | -122.494456517472 | (37.7396715624933, -122.494456517472) | 1 | 8 | 3 | 29491 | 35 | |||
138725 | 42690 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |||
138624 | 240321 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 355 Masonic Ave | 7 | Front Yard : Yard | Tree | Private 2 | 10 | Width 3ft | 6000321.62859 | 2106905.98054 | 37.7651796900124 | -122.442109087376 | (37.7651796900124, -122.442109087376) | 15 | 5 | 5 | 28862 | 3 | |||
138093 | 185178 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Sunset Blvd | 30 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985128.0455 | 2097804.2012 | 37.7393111225821 | -122.49398842161 | (37.7393111225821, -122.49398842161) | 1 | 8 | 3 | 29491 | 35 | |||
137807 | 247611 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6009478.11673 | 2096708.87716 | 37.7376982806503 | -122.409719050602 | (37.7376982806503, -122.409719050602) | 10 | 7 | 7 | 28859 | 2 | ||||
137699 | 47703 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 138 Laidley St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/03/2003 12:00:00 AM | 10 | 6x3 | Permit Number 45499 | 6003736.17026094 | 2097556.1914573 | 37.739701367535 | -122.429632126542 | (37.739701367535, -122.429632126542) | 2 | 7 | 5 | 63 | 7 | |
137603 | 181532 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984901.4756 | 2105774.4271 | 37.7611819183613 | -122.495359430973 | (37.7611819183613, -122.495359430973) | 1 | 8 | 3 | 56 | 35 | |||
137430 | 141623 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1801 GROVE ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5998914.533 | 2110398.874 | 37.7746899995309 | -122.44722727877 | (37.7746899995309, -122.44722727877) | 15 | 5 | 11 | 29492 | 16 | |||
136991 | 247826 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 96 Banks St | 2 | Front Yard : Yard | Tree | Private 2 | 6 | 6008666.54857 | 2098148.46053 | 37.7416055489639 | -122.412626779128 | (37.7416055489639, -122.412626779128) | 10 | 7 | 7 | 28859 | 2 | ||||
136434 | 43457 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999502.576 | 2091265.96486 | 37.7221892471271 | -122.443818239036 | (37.7221892471271, -122.443818239036) | 9 | 7 | 6 | 28861 | 25 | |
135580 | 111441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 31 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5 | 5999897.1183 | 2091063.84845 | 37.7216567783095 | -122.442439902078 | (37.7216567783095, -122.442439902078) | 9 | 7 | 6 | 28861 | 25 | |||
135496 | 136280 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1080 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6008340.68232 | 2118631.36541 | 37.797828516615 | -122.415203104753 | (37.797828516615, -122.415203104753) | 5 | 1 | 10 | 308 | 21 | ||||
135363 | 185183 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Sunset Blvd | 35 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985128.0455 | 2097828.1066 | 37.7393767603936 | -122.493990182941 | (37.7393767603936, -122.493990182941) | 1 | 8 | 3 | 29491 | 35 | |||
134803 | 197187 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Illinois St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6016257.35591 | 2100633.78015 | 37.7488528300966 | -122.386553348365 | (37.7488528300966, -122.386553348365) | 10 | 3 | 8 | 58 | 1 | |||
134473 | 43434 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 26 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 7 | Permit Number 43162 | 5999832.90051 | 2091096.83279 | 37.7217436851966 | -122.44266425237 | (37.7217436851966, -122.44266425237) | 9 | 7 | 6 | 28861 | 25 | |
134429 | 18936 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2721 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001590.13521 | 2115636.51425 | 37.7892237457171 | -122.438347166582 | (37.7892237457171, -122.438347166582) | 13 | 6 | 1 | 29490 | 27 | |||
133309 | 240217 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6006077.44236 | 2095815.28321 | 37.73505351389 | -122.421413392023 | (37.73505351389, -122.421413392023) | 2 | 7 | 7 | 28859 | 2 | |||
132841 | 240297 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Clipper St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002954.68882 | 2100970.79913 | 37.7490328042172 | -122.432577993181 | (37.7490328042172, -122.432577993181) | 2 | 4 | 5 | 28862 | 22 | |||
132396 | 44148 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
132280 | 43432 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 3 | Permit Number 43162 | 5999683.18724 | 2091173.0602 | 37.7219444525549 | -122.443187242296 | (37.7219444525549, -122.443187242296) | 9 | 7 | 6 | 28861 | 25 | |
132190 | 247005 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 401 Valley St | 5 | Side Yard : Yard | Tree | Private 2 | 2 | Width 8ft | 6003245.1291 | 2099189.57819 | 37.7441584535423 | -122.431446509373 | (37.7441584535423, -122.431446509373) | 2 | 7 | 5 | 63 | 22 | |||
131747 | 187262 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2401 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984975.6548 | 2098407.337 | 37.7409582534083 | -122.494559764363 | (37.7409582534083, -122.494559764363) | 1 | 8 | 3 | 29491 | 35 | |||
131569 | 185403 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2300 Sunset Blvd | 17 | unknown : Yard | Tree | Private 2 | 1 | Width 0ft | 5985110.6332 | 2099073.9214 | 37.742796413512 | -122.494142183825 | (37.742796413512, -122.494142183825) | 1 | 8 | 3 | 29491 | 35 | |||
130307 | 122365 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
130143 | 248185 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 216 Esmeralda Ave | 4 | Side Yard : Yard | Tree | Private 2 | 8 | 6007424.69416 | 2098705.39025 | 37.7430649777618 | -122.416960153407 | (37.7430649777618, -122.416960153407) | 2 | 7 | 7 | 28859 | 2 | ||||
130033 | 240310 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 310 Liberty St | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6004042.34228 | 2103935.98204 | 37.7572361204577 | -122.429028262938 | (37.7572361204577, -122.429028262938) | 2 | 4 | 5 | 28862 | 3 | |||
129541 | 111443 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 33 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 17 | 5999927.23458 | 2091047.72982 | 37.7216142367899 | -122.442334641847 | (37.7216142367899, -122.442334641847) | 9 | 7 | 6 | 28861 | 25 | |||
129326 | 197194 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 37 | Front Yard : Yard | Tree | Private 2 | 12 | 6015675.19682 | 2099860.17709 | 37.746696432096 | -122.388512480964 | (37.746696432096, -122.388512480964) | 3 | 8 | 58 | 1 | |||||
129275 | 240262 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 316 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006842.705 | 2097236.16728 | 37.7389980645073 | -122.418868340323 | (37.7389980645073, -122.418868340323) | 2 | 7 | 7 | 28859 | 2 | |||
128850 | 202106 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6011990.13515 | 2092907.27832 | 37.7274003336589 | -122.400766743908 | (37.7274003336589, -122.400766743908) | 10 | 3 | 8 | 58 | 1 | |||
128545 | 12728 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1600 Lake St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/19/2005 12:00:00 AM | 2 | 4X4 | 5990457.1993 | 2114785.86556 | 37.7862485896694 | -122.476803188002 | (37.7862485896694, -122.476803188002) | 11 | 6 | 1 | 55 | 33 | ||
127893 | 179338 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2134 San Jose Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 8ft | 5998927.16036 | 2091160.9726 | 37.7218681244079 | -122.445799757562 | (37.7218681244079, -122.445799757562) | 9 | 7 | 6 | 28861 | 25 | |||
127752 | 44138 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 20 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
126888 | 197203 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 88 05th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6010503.85094 | 2113243.76912 | 37.7831568013875 | -122.407337895824 | (37.7831568013875, -122.407337895824) | 14 | 2 | 9 | 28853 | 34 | ||||
126782 | 52156 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1771 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 11 | Permit Number 48348 | 6014341.22767 | 2095259.71993 | 37.733990516147 | -122.392803455827 | (37.733990516147, -122.392803455827) | 10 | 3 | 8 | 58 | 1 | |
126726 | 186267 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Sunset Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985013.4867 | 2102384.0807 | 37.7518795238693 | -122.494722074862 | (37.7518795238693, -122.494722074862) | 1 | 8 | 3 | 56 | 35 | |||
126104 | 116750 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2255 15th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | 6002535.32204955 | 2107055.77989845 | 37.7657169099067 | -122.434463175931 | (37.7657169099067, -122.434463175931) | 15 | 5 | 5 | 28862 | 3 | ||||
126055 | 43435 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 25 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 14 | Permit Number 43162 | 5999819.49506 | 2091104.19362 | 37.7217631321556 | -122.442711119627 | (37.7217631321556, -122.442711119627) | 9 | 7 | 6 | 28861 | 25 | |
125678 | 240240 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 24 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 10ft | 6006428.42427 | 2095784.70659 | 37.7349893400784 | -122.420197750546 | (37.7349893400784, -122.420197750546) | 2 | 7 | 7 | 28859 | 2 | |||
125434 | 136272 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2 Emerson St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 5ft | 5998704.619 | 2113641.52424 | 37.7835814810315 | -122.448186950386 | (37.7835814810315, -122.448186950386) | 15 | 6 | 1 | 54 | 31 | |||
125368 | 247116 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2301 Castro St | 34 | Front Yard : Yard | Tree | Private 2 | 2 | 6002706.05137 | 2098649.0279 | 37.742643660667 | -122.433271902871 | (37.742643660667, -122.433271902871) | 2 | 7 | 5 | 63 | 22 | ||||
122995 | 240230 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006284.0301 | 2095795.275 | 37.7350102214481 | -122.420697723227 | (37.7350102214481, -122.420697723227) | 2 | 7 | 7 | 28859 | 2 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );