trees
2,306 rows where qSpecies_id = 15 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194460 | 234487 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 380 Cumberland St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 44 | Width 3ft | 6003189.58252 | 2104492.34613 | 37.7587154557579 | -122.432017164278 | (37.7587154557579, -122.432017164278) | 2 | 4 | 5 | 28862 | 3 | |||
194226 | 20570 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1392X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984737.8310876 | 2105717.624989 | 37.7610163726955 | -122.49592120853 | (37.7610163726955, -122.49592120853) | 1 | 8 | 3 | 56 | 35 | |||
194125 | 185477 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2400 Sunset Blvd | 29 | unknown : Yard | Tree | Private 2 | 38 | Width 0ft | 5985132.3618 | 2098455.9558 | 37.7411009180553 | -122.494021519499 | (37.7411009180553, -122.494021519499) | 1 | 8 | 3 | 29491 | 35 | |||
194083 | 4978 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5200X Diamond Heights Blvd | 14 | Median : Cutout | Tree | DPW 1 | 48 | 12 | 6001055.51411 | 2099325.52296 | 37.7444073831894 | -122.439027441656 | (37.7444073831894, -122.439027441656) | 2 | 7 | 5 | 63 | 7 | |||
193834 | 111412 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150x SAN MARCOS AVE | 7 | Median : Yard | Tree | Private 2 | 36 | 5993566 | 2100407 | 37.7469478560931 | -122.465002947317 | (37.7469478560931, -122.465002947317) | 1 | 8 | 4 | 29491 | 40 | ||||
193693 | 255496 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2100 Turk Blvd | 1 | Back Yard : Yard | Tree | Private 2 | 5999950 | 2111978 | 37.7790849877594 | -122.443758873408 | (37.7790849877594, -122.443758873408) | 15 | 5 | 1 | 29490 | 16 | |||||
193689 | 20677 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501X Sunset Blvd | 31 | Median : Cutout | Tree | DPW 1 | 50 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | ||||
193681 | 185412 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2300 Sunset Blvd | 28 | unknown : Yard | Tree | Private 2 | 47 | Width 0ft | 5985078.1422 | 2099185.3906 | 37.7431005765205 | -122.494262741341 | (37.7431005765205, -122.494262741341) | 1 | 8 | 3 | 29491 | 35 | |||
193595 | 194497 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1800 Illinois St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 7ft | 6016247.03322 | 2100654.64673 | 37.7489095539354 | -122.386590499369 | (37.7489095539354, -122.386590499369) | 10 | 3 | 8 | 58 | 1 | |||
193530 | 2294 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 45 | 14M | 5990137.07953 | 2088614.48643 | 37.7143702930322 | -122.475998609661 | (37.7143702930322, -122.475998609661) | 1 | 8 | 4 | 64 | 14 | |||
193463 | 102056 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 332 19th Ave | 1 | Back Yard : Yard | Tree | Private 2 | 5990007.7 | 2113121.3 | 37.7816520743217 | -122.478236569715 | (37.7816520743217, -122.478236569715) | 11 | 6 | 2 | 55 | 26 | |||||
193436 | 105653 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 150 BRONTE ST | 3 | Unaccepted Street : Yard | Tree | Private 2 | 16 | Permit Number 770978 | 6009287.5 | 2096640.3 | 37.737499298819 | -122.410373266073 | (37.737499298819, -122.410373266073) | 10 | 7 | 7 | 28859 | 2 | |||
193392 | 20816 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1792X Sunset Blvd | 20 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984829.6375693 | 2102999.3844439 | 37.7535582155387 | -122.495403216296 | (37.7535582155387, -122.495403216296) | 1 | 8 | 3 | 56 | 35 | |||
193382 | 178313 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Serrano Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 43 | 5989165.0392 | 2090617.52486 | 37.7198137266005 | -122.479504788413 | (37.7198137266005, -122.479504788413) | 1 | 8 | 4 | 64 | 14 | ||||
193355 | 211280 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 450 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 5999088.89925 | 2094998.37338 | 37.7324139668229 | -122.445516469327 | (37.7324139668229, -122.445516469327) | 9 | 7 | 4 | 59 | 40 | |||
193331 | 20759 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1692X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
193323 | 94637 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 170X Crestmont Dr | 2 | Front Yard : Yard | Tree | Private 2 | 09/24/2010 12:00:00 AM | Permit Number 53783 | 5995178.5 | 2103444 | 37.7553795372421 | -122.459647037768 | (37.7553795372421, -122.459647037768) | 1 | 5 | 4 | 63 | 12 | |||
193251 | 173722 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 928 Carolina St | 1 | Median : Cutout | Tree | DPW 1 | 17 | 3x3 | 6012423 | 2103596 | 37.7567734300957 | -122.400020627969 | (37.7567734300957, -122.400020627969) | 10 | 3 | 8 | 28856 | 29 | |||
193238 | 176152 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 2 | Median : Cutout | Tree | Private 2 | 20 | 5x10 | 5987747.4162 | 2088772.85017 | 37.7146662689143 | -122.484269735661 | (37.7146662689143, -122.484269735661) | 1 | 8 | 4 | 64 | 14 | |||
193178 | 211142 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Terrace Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | 5993344.39912 | 2096880.05499 | 37.7372509740365 | -122.465513038912 | (37.7372509740365, -122.465513038912) | 1 | 8 | 4 | 59 | 40 | ||||
193154 | 87273 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 4 Miraloma Dr | 1 | Back Yard : Cutout | Tree | Private 2 | 03/12/2008 12:00:00 AM | Permit Number 50295 | 5995203 | 2097905 | 37.7401722415629 | -122.45916124145 | (37.7401722415629, -122.45916124145) | 9 | 7 | 4 | 59 | 40 | |||
193094 | 21415 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2692X Sunset Blvd | 17 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
192960 | 186149 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1700 Sunset Blvd | 34 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 0ft | 5984949.4388 | 2103270.5218 | 37.7543096978884 | -122.495008914875 | (37.7543096978884, -122.495008914875) | 1 | 8 | 3 | 56 | 35 | |||
192948 | 20506 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1211X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 60 | 5984783.6901595 | 2107169.3790132 | 37.7650051676015 | -122.495869700491 | (37.7650051676015, -122.495869700491) | 11 | 6 | 2 | 55 | 8 | |||
192947 | 11868 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1400X Junipero Serra Blvd | 12 | Median : Cutout | Tree | DPW 1 | 0 | 2X2 | 5991386.4673518 | 2088368.501669 | 37.71376724375 | -122.471662357701 | (37.71376724375, -122.471662357701) | 1 | 8 | 4 | 64 | 14 | |||
192919 | 20761 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1692X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 60 | 5984807.4869191 | 2103677.7923597 | 37.7554196391607 | -122.495529849669 | (37.7554196391607, -122.495529849669) | 1 | 8 | 3 | 56 | 35 | |||
192848 | 251488 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Bosworth St | 30 | Front Yard : Yard | Tree | DPW 1 | 6001649 | 2095572 | 37.7341348351459 | -122.436706663072 | (37.7341348351459, -122.436706663072) | 9 | 7 | 5 | 63 | 7 | |||||
192771 | 116657 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199x Esmeralda Ave | 11 | Unaccepted Street : Yard | Tree | DPW 1 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) | 2 | 7 | 7 | 28859 | 2 | |||||
192723 | 249793 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 199 Chestnut St | 1 | Front Yard : Yard | Tree | Private 2 | 8 | Width 0ft | 6010888.03809 | 2121029.58951 | 37.8045562827982 | -122.406557583781 | (37.8045562827982, -122.406557583781) | 3 | 1 | 10 | 308 | 23 | |||
192530 | 114586 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 155x BRONTE ST | 1 | Unaccepted Street : Yard | Tree | Private 2 | 15 | 3x3 | Permit Number 777226 | 6009330 | 2096609 | 37.7374157381662 | -122.410224113722 | (37.7374157381662, -122.410224113722) | 10 | 7 | 7 | 28859 | 2 | ||
192432 | 181479 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1400 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 45 | Width 0ft | 5984881.7035 | 2105327.4674 | 37.7599535341185 | -122.495394848671 | (37.7599535341185, -122.495394848671) | 1 | 8 | 3 | 56 | 35 | |||
192391 | 253097 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | DPW | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035 | 2097938 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | 1 | 8 | 4 | 59 | 40 | |
192318 | 178305 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 825 Brotherhood Way | 1 | Front Yard : Yard | Tree | Private 2 | 2 | Width 0ft | 5989317.68799 | 2088635.92572 | 37.7143816145814 | -122.478832286179 | (37.7143816145814, -122.478832286179) | 1 | 8 | 4 | 64 | 14 | |||
192018 | 110881 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 800 INDIANA ST | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 6014913.4 | 2104437.2 | 37.7592217202179 | -122.391466645187 | (37.7592217202179, -122.391466645187) | 10 | 3 | 8 | 28856 | 29 | |||||
191992 | 94463 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 744 Carolina St | 1 | : | Tree | Private 2 | 06/10/2010 12:00:00 AM | Permit Number 53681 | 6012327.5 | 2104524.9 | 37.7593186601765 | -122.400416148756 | (37.7593186601765, -122.400416148756) | 10 | 3 | 8 | 28856 | 29 | |||
191938 | 211147 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Terrace Dr | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5993511.61003 | 2096780.42946 | 37.7369870697942 | -122.464927685472 | (37.7369870697942, -122.464927685472) | 1 | 8 | 4 | 59 | 40 | ||||
191929 | 51721 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1335 Douglass St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/02/2005 12:00:00 AM | Permit Number 47991 | 6001394.735632 | 2099881.41998428 | 37.7459530403724 | -122.437894295142 | (37.7459530403724, -122.437894295142) | 2 | 4 | 5 | 63 | 22 | |||
191847 | 211123 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 28 | Median : Yard | Tree | DPW 1 | 2 | Width 8ft | 5994165.13571 | 2101402.30942 | 37.7497152520618 | -122.463003406981 | (37.7497152520618, -122.463003406981) | 1 | 8 | 4 | 29491 | 40 | |||
191821 | 104940 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 111X Gonzalez Dr | Sidewalk: Curb side : Yard | Tree | Private 2 | 5990327.80869 | 2090136.76282 | 37.718561145924 | -122.475450461306 | (37.718561145924, -122.475450461306) | 1 | 8 | 4 | 64 | 14 | ||||||
191770 | 186075 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1901 Sunset Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5984841.5431 | 2102025.7523 | 37.7508855867305 | -122.495290248015 | (37.7508855867305, -122.495290248015) | 1 | 8 | 3 | 29491 | 35 | |||
191706 | 201555 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200 Jerrold Ave | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6019901.03231 | 2093652.00045 | 37.7298832655955 | -122.373469980666 | (37.7298832655955, -122.373469980666) | 10 | 3 | 8 | 58 | 1 | ||||
191704 | 20718 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1601X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 60 | 5984865.3499442 | 2104298.7792234 | 37.7571280850658 | -122.495375540207 | (37.7571280850658, -122.495375540207) | 1 | 8 | 3 | 56 | 35 | |||
191593 | 91111 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 2650 Turk Blvd | 2 | Front Yard : Yard | Tree | Private 2 | On Campus | 5998086.4 | 2111055.5 | 37.7764455713486 | -122.450139282915 | (37.7764455713486, -122.450139282915) | 15 | 6 | 2 | 29492 | 16 | ||||
191464 | 256767 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900 Brotherhood Way | 22 | Front Yard : Yard | Tree | DPW 1 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.7146433748779 | -122.483682180705 | (37.7146433748779, -122.483682180705) | 1 | 8 | 4 | 64 | 14 | ||||
191443 | 21313 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2501X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5985074.8907349 | 2098188.1189419 | 37.740362147215 | -122.494200494189 | (37.740362147215, -122.494200494189) | 1 | 8 | 3 | 29491 | 35 | |||
191436 | 20976 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2002X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | |||
191318 | 186032 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1900 Sunset Blvd | 27 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 0ft | 5984997.3715 | 2102028.6723 | 37.7509027266766 | -122.494751602019 | (37.7509027266766, -122.494751602019) | 1 | 8 | 3 | 29491 | 35 | |||
190788 | 21255 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2401X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5985051.1945321 | 2098862.1753589 | 37.7422115377949 | -122.494332098234 | (37.7422115377949, -122.494332098234) | 1 | 8 | 3 | 29491 | 35 | |||
190636 | 114113 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1200X JUNIPERO SERRA BLVD | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | 5991123 | 2089585 | 37.7170922039834 | -122.472661630304 | (37.7170922039834, -122.472661630304) | 1 | 8 | 4 | 64 | 14 | ||||
190619 | 21112 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2201X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 60 | 5985004.6737667 | 2100227.1692458 | 37.7459567185928 | -122.494593556276 | (37.7459567185928, -122.494593556276) | 1 | 8 | 3 | 29491 | 35 | |||
190576 | 211116 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 335x Pacheco St | 16 | Median : Yard | Tree | DPW 1 | 30 | Width 8ft | 5994179.36475 | 2101243.69399 | 37.7492805539696 | -122.462942696445 | (37.7492805539696, -122.462942696445) | 1 | 8 | 4 | 29491 | 40 | |||
190443 | 178242 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 62 Tomaso Ct | 2 | Front Yard : Yard | Tree | Private 2 | 17 | Width 8ft | 6009144.65272 | 2086270.07017 | 37.709016817728 | -122.410135233474 | (37.709016817728, -122.410135233474) | 9 | 7 | 8 | 309 | 39 | |||
190437 | 21380 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2601X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 40 | 5985098.343425 | 2097506.3093477 | 37.7384914535226 | -122.494069167367 | (37.7384914535226, -122.494069167367) | 1 | 8 | 3 | 29491 | 35 | |||
190335 | 173903 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 675 Corbett Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5999984 | 2103563 | 37.7559814441149 | -122.443036761048 | (37.7559814441149, -122.443036761048) | 2 | 5 | 5 | 28862 | 38 | |||||
190202 | 99163 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 302X Pacheco St | 47 | Median : Cutout | Tree | Private 2 | 18 | 5994341.5 | 2100725.2 | 37.7478662384021 | -122.46234443277 | (37.7478662384021, -122.46234443277) | 1 | 8 | 4 | 29491 | 40 | ||||
190157 | 117273 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 17 PEREGO TER | 1 | Back Yard : Yard | Tree | Private 2 | 5999542 | 2101494 | 37.7502752643571 | -122.444416651791 | (37.7502752643571, -122.444416651791) | 2 | 5 | 5 | 63 | 38 | |||||
189976 | 178205 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 21 Santos St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 31 | Width 6ft | 6006695.10117 | 2087172.75522 | 37.7113577971033 | -122.418665232027 | (37.7113577971033, -122.418665232027) | 9 | 7 | 8 | 309 | 39 | |||
189784 | 184502 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1963 47th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 0ft | 5981638.5485 | 2101729.1831 | 37.7498832372827 | -122.506344320901 | (37.7498832372827, -122.506344320901) | 1 | 8 | 3 | 29491 | 35 | |||
189769 | 111515 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800x BOSWORTH ST | 10 | Front Yard : Yard | Tree | DPW 1 | 17 | 6001905 | 2095492 | 37.7339297189054 | -122.435815869962 | (37.7339297189054, -122.435815869962) | 9 | 7 | 5 | 63 | 7 | ||||
189750 | 248176 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 218 Esmeralda Ave | 5 | Side Yard : Yard | Tree | Private 2 | 31 | 6007352.57269 | 2098728.04066 | 37.7431231135451 | -122.417211135295 | (37.7431231135451, -122.417211135295) | 2 | 7 | 7 | 28859 | 2 | ||||
189740 | 185970 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2001 Sunset Blvd | 29 | Sidewalk: Property side : Yard | Tree | Private 2 | 68 | Width 0ft | 5984877.0596 | 2101205.8095 | 37.748636327835 | -122.495106974471 | (37.748636327835, -122.495106974471) | 1 | 8 | 3 | 29491 | 35 | |||
189733 | 211088 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1888 Funston Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 56 | Permit Number 777893 | 5992224.94282 | 2102558.27283 | 37.7527772781709 | -122.469796758012 | (37.7527772781709, -122.469796758012) | 1 | 8 | 4 | 56 | 12 | |||
189389 | 178252 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100x Mansell St | 11 | Median : Cutout | Tree | DPW 1 | 28 | Width 0ft | 6011405.60208 | 2090646.90467 | 37.7211611925117 | -122.402628599549 | (37.7211611925117, -122.402628599549) | 10 | 3 | 8 | 309 | 28 | |||
189253 | 233317 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 3 | Sidewalk: Curb side : Pot | Tree | DPW 1 | 20 | Width 8ft | 6001489.22958 | 2098922.00585 | 37.7433240886333 | -122.437498855898 | (37.7433240886333, -122.437498855898) | 2 | 7 | 5 | 63 | 7 | |||
189242 | 99522 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 26 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | |||
189190 | 211173 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 800x Junipero Serra Blvd | 54 | Median : Cutout | Tree | DPW 1 | 24 | Width 0ft | 5991356.55108 | 2092861.75062 | 37.7261028691334 | -122.472093069844 | (37.7261028691334, -122.472093069844) | 9 | 8 | 4 | 59 | 40 | |||
189125 | 178327 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 28 | 5990329.94614 | 2089929.88135 | 37.7179932244997 | -122.475427976322 | (37.7179932244997, -122.475427976322) | 1 | 8 | 4 | 64 | 14 | ||||
189065 | 181353 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2300 Sunset Blvd | 15 | unknown : Yard | Tree | Private 2 | 34 | Width 0ft | 5985103.1353 | 2099041.4304 | 37.7427067632535 | -122.49416571483 | (37.7427067632535, -122.49416571483) | 1 | 8 | 3 | 29491 | 35 | |||
189049 | 184033 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1600 Sunset Blvd | 33 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984960.4323 | 2103807.95 | 37.7557859707791 | -122.495010522673 | (37.7557859707791, -122.495010522673) | 1 | 8 | 3 | 56 | 35 | |||
188916 | 100069 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 619 Gonzalez Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/2012 12:00:00 AM | Permit Number 769006 | 5990435 | 2090585 | 37.7197981072685 | -122.475112652722 | (37.7197981072685, -122.475112652722) | 1 | 8 | 4 | 64 | 40 | |||
188852 | 113080 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 89 Castenada Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10x2 | Permit Number 776239 | 5994496.1 | 2101295.2 | 37.7494402154084 | -122.461851162221 | (37.7494402154084, -122.461851162221) | 1 | 8 | 4 | 29491 | 40 | |||
188772 | 20987 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2002X Sunset Blvd | 27 | Median : Cutout | Tree | DPW 1 | 30 | 5984887.6165706 | 2101567.3225095 | 37.7496295616808 | -122.495097123245 | (37.7496295616808, -122.495097123245) | 1 | 8 | 3 | 29491 | 35 | ||||
188717 | 254288 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100X Junipero Serra Blvd | 4 | Median : Yard | Tree | Private 2 | 3x3 | 5991400 | 2095443 | 37.7331928478719 | -122.472130937334 | (37.7331928478719, -122.472130937334) | 1 | 8 | 4 | 64 | 40 | ||||
188579 | 114935 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 4400x OCEAN AVE | 11 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5985931 | 2095134 | 37.7320264068308 | -122.491015755892 | (37.7320264068308, -122.491015755892) | 1 | 8 | 4 | 64 | 35 | ||||
188554 | 116070 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 4150X CLEMENT ST | 4 | Front Yard : Yard | Tree | DPW 1 | 3x3 | 5983115 | 2113126 | 37.7812624555251 | -122.502082001527 | (37.7812624555251, -122.502082001527) | 11 | 6 | 2 | 55 | 15 | ||||
188400 | 186166 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1700 Sunset Blvd | 51 | Sidewalk: Property side : Yard | Tree | Private 2 | 40 | Width 0ft | 5984945.6305 | 2103456.7811 | 37.7548208915507 | -122.495035818149 | (37.7548208915507, -122.495035818149) | 1 | 8 | 3 | 56 | 35 | |||
188160 | 4972 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5200X Diamond Heights Blvd | 8 | Median : Cutout | Tree | DPW 1 | 24 | 12 | 6000878.47383 | 2099482.1675 | 37.7448274169614 | -122.439650836444 | (37.7448274169614, -122.439650836444) | 2 | 7 | 5 | 63 | 7 | |||
188154 | 178253 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 200x Mansell St | 20 | Median : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6011075.03755 | 2090535.49996 | 37.7208368367282 | -122.403763436926 | (37.7208368367282, -122.403763436926) | 10 | 3 | 7 | 309 | 28 | |||
188133 | 181485 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1400 Sunset Blvd | 45 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 0ft | 5984881.7035 | 2105355.8723 | 37.760031526051 | -122.49539694358 | (37.760031526051, -122.49539694358) | 1 | 8 | 3 | 56 | 35 | |||
188113 | 187368 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2200 Sunset Blvd | 53 | Sidewalk: Property side : Yard | Tree | Private 2 | 47 | Width 0ft | 5985070.5518 | 2099880.8695 | 37.7450097290597 | -122.494340240463 | (37.7450097290597, -122.494340240463) | 1 | 8 | 3 | 29491 | 35 | |||
187946 | 98141 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 75 Starview Way | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | 5997450.6 | 2101840.3 | 37.7511065679937 | -122.451673790409 | (37.7511065679937, -122.451673790409) | 1 | 5 | 4 | 63 | 38 | ||||
187732 | 218285 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 50x Junipero Serra Frontage West | 0 | Median : Yard | Tree | DPW 1 | 11 | 5991436.68421 | 2095414.89925 | 37.7331178131424 | -122.47200206387 | (37.7331178131424, -122.47200206387) | 1 | 8 | 4 | 64 | 40 | ||||
187701 | 186941 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2800 Sunset Blvd | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 0ft | 5985176.7397 | 2095994.232 | 37.7343442797052 | -122.49368672437 | (37.7343442797052, -122.49368672437) | 1 | 8 | 3 | 29491 | 35 | |||
187656 | 178237 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501 Sunnydale Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 53 | Width 10ft | 6007383.79648 | 2087366.79731 | 37.7119293468405 | -122.416298653474 | (37.7119293468405, -122.416298653474) | 9 | 7 | 8 | 309 | 39 | |||
187562 | 211187 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 500 Junipero Serra Blvd | 31 | : | Tree | Private 2 | 38 | Width 0ft | 5991335.91068 | 2093609.81613 | 37.7281556760309 | -122.472218927281 | (37.7281556760309, -122.472218927281) | 9 | 8 | 4 | 64 | 40 | |||
187527 | 11674 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700X Junipero Serra Blvd | 11 | Median : Cutout | Tree | DPW 1 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991293.10776 | 2092904.88683 | 37.7262176388172 | -122.472315530661 | (37.7262176388172, -122.472315530661) | 9 | 8 | 4 | 64 | 40 | ||
187487 | 20823 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1801X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984911.465596 | 2102939.293478 | 37.7533980132231 | -122.495115810531 | (37.7533980132231, -122.495115810531) | 1 | 8 | 3 | 56 | 35 | |||
187346 | 21439 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2692X Sunset Blvd | 34 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60 | 5985040.0664617 | 2096882.0619327 | 37.7367740271268 | -122.494224659054 | (37.7367740271268, -122.494224659054) | 1 | 8 | 3 | 29491 | 35 | |||
187303 | 118359 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 8 Keystone Way | 1 | Front Yard : Yard | Tree | Private 2 | 20 | 3x3 | 5994105 | 2092664 | 37.7257185609933 | -122.46257757783 | (37.7257185609933, -122.46257757783) | 9 | 8 | 4 | 59 | 40 | |||
187288 | 211151 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100 Terrace Dr | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 39 | 5993575.92443 | 2096738.74273 | 37.7368763164955 | -122.464702297369 | (37.7368763164955, -122.464702297369) | 1 | 8 | 4 | 59 | 40 | ||||
187164 | 20620 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1492X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984803.7392562 | 2105036.6950477 | 37.7591505890295 | -122.495643037613 | (37.7591505890295, -122.495643037613) | 1 | 8 | 3 | 56 | 35 | |||
186943 | 181505 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1400 Sunset Blvd | 64 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5984869.4504 | 2105475.0616 | 37.7603580691521 | -122.495448111176 | (37.7603580691521, -122.495448111176) | 1 | 8 | 3 | 56 | 35 | |||
186925 | 20636 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1492X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 42 | 60 | 5984803.7392562 | 2105036.6950477 | 37.7591505890295 | -122.495643037613 | (37.7591505890295, -122.495643037613) | 1 | 8 | 3 | 56 | 35 | |||
186839 | 21071 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2192X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 48 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | 1 | 8 | 3 | 29491 | 35 | |||
186837 | 253810 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 281 Ralston St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x6 | Permit Number 780772 | 5992187.95019 | 2089731.22021 | 37.7175552771373 | -122.468991274833 | (37.7175552771373, -122.468991274833) | 9 | 8 | 6 | 64 | 24 | |||
186768 | 118464 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 501 Point Lobos Ave | 1 | Front Yard : Yard | Tree | Private 2 | 22 | 5981239.04477 | 2112631.92257 | 37.7797954778141 | -122.508535077879 | (37.7797954778141, -122.508535077879) | 11 | 6 | 2 | 55 | 26 | ||||
186683 | 211092 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1995 18th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | 5990629.40713 | 2101847.44348 | 37.7507331740119 | -122.475262462411 | (37.7507331740119, -122.475262462411) | 1 | 8 | 4 | 29491 | 12 | ||||
186602 | 105138 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 175X ESMERALDA AVE | 4 | unknown : Yard | Tree | DPW 1 | 25 | 6007213 | 2098808 | 37.7433348108676 | -122.417699407763 | (37.7433348108676, -122.417699407763) | 2 | 7 | 7 | 28859 | 2 | ||||
186588 | 95882 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | ||
186480 | 178345 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 145 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 8ft | 6004800.93333 | 2092272.08617 | 37.7252526275981 | -122.425574653146 | (37.7252526275981, -122.425574653146) | 9 | 7 | 6 | 28861 | 5 |
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) );