2,306 rows where qSpecies_id = 15 sorted by rowid descending

View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);