trees
2,306 rows where qSpecies_id = 15 sorted by PlantDate 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
43863 | 57589 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 93 Arbor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50021 | 6001851.03848289 | 2096750.6660448 | 37.7373826596428 | -122.436092469726 | (37.7373826596428, -122.436092469726) | 2 | 7 | 5 | 63 | 7 | ||
77642 | 113535 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 100X CASHMERE ST | 1 | Median : Yard | Tree | DPW 1 | 12/05/2015 12:49:00 PM | 3 | 6017054 | 2095889 | 37.7358686950692 | -122.383468266853 | (37.7358686950692, -122.383468266853) | 10 | 3 | 8 | 58 | 1 | |||
50856 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394 | 2087287 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | 9 | 8 | 4 | 64 | 24 | |
59701 | 86946 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 495 Pacheco St | 1 | Back Yard : Yard | Tree | Private 2 | 11/20/2007 12:00:00 AM | 3x3 | Permit Number 51051 | 5993544.7 | 2101797.8 | 37.750765410178 | -122.465177603148 | (37.750765410178, -122.465177603148) | 1 | 8 | 4 | 29491 | 40 | ||
93603 | 95230 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1@Carl Irving St | 6 | Front Yard : Yard | Tree | Private 2 | 11/16/2010 12:00:00 AM | 27 | 5995817.2 | 2106753.3 | 37.7645027364821 | -122.45767767256 | (37.7645027364821, -122.45767767256) | 15 | 5 | 11 | 56 | 12 | |||
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
117614 | 40618 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 201 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/03/2001 12:00:00 AM | Permit Number 41624 | 6005148.26696606 | 2109558.58269734 | 37.7727369810284 | -122.425603701556 | (37.7727369810284, -122.425603701556) | 7 | 9 | 11 | 28852 | 10 | ||
873 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 500 RAYMOND AVE | 2 | Front Yard : Cutout | Tree | Private 2 | 10/06/2015 12:00:00 AM | 3x3 | 6008527 | 2088690 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | 9 | 7 | 8 | 309 | 18 | |||
2578 | 139478 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 416 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/02/2020 12:00:00 AM | 3 | Width 0ft | 5999096.683 | 2111385.8942 | 37.7774105099956 | -122.446668218684 | (37.7774105099956, -122.446668218684) | 15 | 5 | 11 | 29492 | 16 | ||
182311 | 94636 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 170X Crestmont Dr | 1 | 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 | |||
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 | |||
47842 | 251598 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 900x Moraga St | 1 | Side Yard : Yard | Tree | Private 2 | 09/06/2017 12:00:00 AM | 3 | 3x3 | Permit Number 781621 | 5991390 | 2103897 | 37.7564047756354 | -122.47278171886 | (37.7564047756354, -122.47278171886) | 1 | 8 | 4 | 56 | 12 | |
71822 | 4982 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 08/31/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780192 | 6001462.73007 | 2098944.10019 | 37.7433832478516 | -122.437592066128 | (37.7433832478516, -122.437592066128) | 2 | 7 | 5 | 63 | 7 | |
106832 | 115830 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1X JUNIPERO SERRA BLVD OFF RAMP | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | 3x3 | 5991168 | 2088425 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) | 1 | 8 | 4 | 64 | 14 | ||
138420 | 2286 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 600X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5991856 | 2088020 | 37.7128374968227 | -122.470014135427 | (37.7128374968227, -122.470014135427) | 9 | 8 | 6 | 64 | 24 | |
142019 | 104750 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1X Junipero Serra Blvd Off Ramp | 2 | Front Yard : Yard | Tree | Private 2 | 08/30/2016 12:00:00 AM | 3 | Permit Number 770709 | 5991326.15861 | 2088181.65405 | 37.7132507161795 | -122.47185719554 | (37.7132507161795, -122.47185719554) | 1 | 8 | 4 | 64 | 14 | ||
161304 | 2288 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 600X Brotherhood Way | 3 | Median : Cutout | Tree | DPW 1 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5991856 | 2088020 | 37.7128374968227 | -122.470014135427 | (37.7128374968227, -122.470014135427) | 9 | 8 | 6 | 64 | 24 | |
109137 | 101039 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1010X Portola Dr | 13 | Front Yard : Yard | Tree | DPW 1 | 08/23/2014 12:00:00 AM | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | 1 | 7 | 4 | 59 | 40 | ||||
144728 | 253098 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1290 Portola Dr | 2 | Sidewalk: Property side : Yard | Tree | DPW 1 | 08/22/2017 12:00:00 AM | 3 | 3x3 | 5994035 | 2097938 | 37.740195634398 | -122.463202075736 | (37.740195634398, -122.463202075736) | 1 | 8 | 4 | 59 | 40 | ||
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 | |
8603 | 185680 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 2101 Sunset Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 08/21/2020 12:00:00 AM | 3 | Width 0ft | Permit Number 785560 | 5984864.6841 | 2100703.8022 | 37.7472572283713 | -122.495112755215 | (37.7472572283713, -122.495112755215) | 1 | 8 | 3 | 29491 | 35 | |
167818 | 99950 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1545 05th Ave | 1 | Front Yard : Yard | Tree | Private 2 | 08/14/2012 12:00:00 AM | Permit Number 768941 | 5994712.1 | 2105033.7 | 37.7597176147703 | -122.461375215787 | (37.7597176147703, -122.461375215787) | 1 | 5 | 4 | 56 | 12 | |||
25020 | 54835 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 117 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/09/1972 12:00:00 AM | 15 | Permit Number 10689 | 5998722.2979 | 2110262.8651 | 37.7743055679817 | -122.447882461981 | (37.7743055679817, -122.447882461981) | 15 | 5 | 11 | 29492 | 16 | ||
119122 | 251575 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 300 Sussex St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 08/02/2017 12:00:00 AM | 3 | 3x3 | Permit Number 780395 | 6001194 | 2096647 | 37.7370606668352 | -122.438356728037 | (37.7370606668352, -122.438356728037) | 2 | 7 | 5 | 63 | 7 | |
36006 | 96113 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 229 Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767768 | 5982054.02521 | 2112599.84865 | 37.7797554116507 | -122.505713372558 | (37.7797554116507, -122.505713372558) | 11 | 6 | 2 | 55 | 26 |
178069 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 520X Oak Park Dr | 1 | Back Yard : Yard | Tree | Private 2 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.7560745928775 | -122.460253542676 | (37.7560745928775, -122.460253542676) | 1 | 5 | 4 | 63 | 12 | |||
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 | |||
28191 | 4983 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 5300 Diamond Heights Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/10/2017 12:00:00 AM | 3 | 3X3 | Permit Number 780192 | 6001475.6363 | 2098933.58975 | 37.7433551224547 | -122.437546687242 | (37.7433551224547, -122.437546687242) | 2 | 7 | 5 | 63 | 7 | |
84518 | 112016 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 115 Red Rock Way | Sidewalk: Property side : Yard | Tree | Private 2 | 07/08/2015 12:00:00 AM | 3 | 6000032.1 | 2099934.7 | 37.7460217534147 | -122.442609914587 | (37.7460217534147, -122.442609914587) | 2 | 7 | 5 | 63 | 22 | ||||
145146 | 85057 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 114 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/29/2007 12:00:00 AM | Permit Number 49394 | 6004707 | 2103005 | 37.7547174630604 | -122.426663322428 | (37.7547174630604, -122.426663322428) | 2 | 4 | 5 | 28862 | 22 | |||
108844 | 40487 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1955 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/21/1999 12:00:00 AM | Permit Number 41566 | 5993136.04980647 | 2102175.12230653 | 37.7517778666293 | -122.466618163119 | (37.7517778666293, -122.466618163119) | 1 | 8 | 4 | 29491 | 12 | |||
47218 | 99951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1160 Battery St | 1 | Front Yard : Yard | Tree | Private 2 | 06/19/2012 12:00:00 AM | Permit Number 768993 | 6012314.3 | 2120017.7 | 37.8018575696458 | -122.401550680127 | (37.8018575696458, -122.401550680127) | 3 | 1 | 10 | 28860 | 6 | |||
2266 | 87917 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 160 Gardenside Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367 | 2102115 | 37.7519703925615 | -122.445066449965 | (37.7519703925615, -122.445066449965) | 2 | 5 | 5 | 63 | 38 | ||
54524 | 87918 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 160 Gardenside Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367 | 2102115 | 37.7519703925615 | -122.445066449965 | (37.7519703925615, -122.445066449965) | 2 | 5 | 5 | 63 | 38 | ||
104930 | 87916 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 160 Gardenside Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367 | 2102115 | 37.7519703925615 | -122.445066449965 | (37.7519703925615, -122.445066449965) | 2 | 5 | 5 | 63 | 38 | ||
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 | |||
174959 | 117016 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 301X UPPER TER | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778184 | 5999259 | 2105755 | 37.7619587697456 | -122.445701671171 | (37.7619587697456, -122.445701671171) | 15 | 5 | 5 | 29492 | 3 | |
34293 | 111094 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 150x FONT BLVD | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 30 | 3x3 | Permit Number 775594 | 5990976 | 2089133 | 37.7158426125161 | -122.473136789074 | (37.7158426125161, -122.473136789074) | 1 | 8 | 4 | 64 | 14 | ||
47284 | 111091 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 423 GONZALEZ DR | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775595 | 5989758 | 2089186 | 37.715917540265 | -122.477350587483 | (37.715917540265, -122.477350587483) | 1 | 8 | 4 | 64 | 14 | |
133714 | 111093 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100x FONT BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/04/2015 12:00:00 AM | 50 | 3x3 | Permit Number 775594 | 5990916 | 2088996 | 37.715462969911 | -122.473334188491 | (37.715462969911, -122.473334188491) | 1 | 8 | 4 | 64 | 14 | |
164792 | 111088 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 136 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 06/04/2015 12:00:00 AM | 45 | 3x3 | Permit Number 775596 | 5990091 | 2089770 | 37.7175403760398 | -122.476242228391 | (37.7175403760398, -122.476242228391) | 1 | 8 | 4 | 64 | 14 | |
2512 | 99518 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
24612 | 99521 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 20 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
98170 | 99523 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 33 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
132638 | 99519 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 5 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
144800 | 99520 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 19 | 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 | |||
149713 | 99524 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1501@Everglade Sloat Blvd | 12 | Sidewalk: Property side : Cutout | Tree | Private 2 | 05/22/2012 12:00:00 AM | Permit Number 768821 | 5986536.9 | 2095861.8 | 37.7340601352242 | -122.488974540344 | (37.7340601352242, -122.488974540344) | 1 | 8 | 4 | 64 | 35 | |||
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 | |||
42183 | 110954 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 126X Mendell St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6017060.74507 | 2098543.22184 | 37.7431570265693 | -122.383629676533 | (37.7431570265693, -122.383629676533) | 10 | 3 | 8 | 58 | 1 | |||
101814 | 110427 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 1860 09TH AVE | 2 | Front Yard : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | Permit Number 775447 | 5993494 | 2102835 | 37.7536103714224 | -122.465428263995 | (37.7536103714224, -122.465428263995) | 1 | 8 | 4 | 56 | 12 | ||
125282 | 110236 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 100 BUCHANAN ST | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 3x20 | 6004868.5 | 2109011.4 | 37.7712187378523 | -122.426532477218 | (37.7712187378523, -122.426532477218) | 7 | 9 | 5 | 28852 | 10 | ||
133009 | 110951 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
141742 | 110952 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
146688 | 110953 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 220 Newhall St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 05/12/2015 12:00:00 AM | 3 | 6016803.8 | 2098347.9 | 37.7426065069695 | -122.384504531053 | (37.7426065069695, -122.384504531053) | 10 | 3 | 8 | 58 | 1 | |||
71480 | 112615 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 1798x 22ND ST | 2 | Unaccepted Street : Yard | Tree | Private 2 | 05/02/2016 12:00:00 AM | 3 | 6012787 | 2103832 | 37.7574417223043 | -122.398778335858 | (37.7574417223043, -122.398778335858) | 10 | 3 | 8 | 28856 | 29 | |||
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 | |||
30806 | 52742 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 432@ NOE 28th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/26/2006 12:00:00 AM | Permit Number 48791 | 6003090.32224136 | 2099513.72726182 | 37.7450397163723 | -122.4320049394 | (37.7450397163723, -122.4320049394) | 2 | 7 | 5 | 63 | 22 | |||
78402 | 110167 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 131x GARCES DR | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | Permit Number 770873 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | ||
129931 | 109962 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 121x GARCES DR | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 04/21/2015 12:00:00 AM | 3 | 3x3 | Permit Number 770873 | 5989202 | 2088902 | 37.7151054701837 | -122.479251597893 | (37.7151054701837, -122.479251597893) | 1 | 8 | 4 | 64 | 14 | |
38301 | 79685 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 2 Hahn St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/18/2008 12:00:00 AM | 3x3 | Permit Number 50355 | 6007801.88811391 | 2088315.49386025 | 37.7145577712837 | -122.414920709681 | (37.7145577712837, -122.414920709681) | 9 | 7 | 8 | 309 | 39 | ||
8163 | 82435 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 51 Peralta Ave | 1 | Front Yard : Yard | Tree | Private 2 | 04/02/2005 12:00:00 AM | 20 | 6010636.52703341 | 2100363.58782589 | 37.7477981742678 | -122.405971235802 | (37.7477981742678, -122.405971235802) | 2 | 7 | 7 | 28859 | 2 | |||
101630 | 11669 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700X Junipero Serra Blvd | 6 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991300.01472 | 2092992.81009 | 37.7264594539326 | -122.472298060428 | (37.7264594539326, -122.472298060428) | 9 | 8 | 4 | 64 | 40 | ||
131010 | 11671 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 700X Junipero Serra Blvd | 8 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991299.29019 | 2092958.43644 | 37.7263650305198 | -122.472298060431 | (37.7263650305198, -122.472298060431) | 9 | 8 | 4 | 64 | 40 | ||
140809 | 29616 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 900X Junipero Serra Blvd | 25 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991162.4882 | 2090905.9355 | 37.7207214537212 | -122.472621393673 | (37.7207214537212, -122.472621393673) | 9 | 8 | 4 | 64 | 40 | ||
41989 | 69895 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 51x PRENTISS ST | 2 | Back Yard : Yard | Tree | DPW 1 | 03/29/2003 12:00:00 AM | 12 | 6008906.8 | 2098323.8 | 37.7421004736884 | -122.411808454692 | (37.7421004736884, -122.411808454692) | 10 | 7 | 7 | 28859 | 2 | |||
74302 | 108365 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 5290 DIAMOND HEIGHTS BLVD | 7 | Sidewalk: Property side : Cutout | Tree | Private 2 | 03/23/2016 12:00:00 AM | 3 | 3x10 | 6001137.6 | 2099182.7 | 37.7440198953745 | -122.438733374106 | (37.7440198953745, -122.438733374106) | 2 | 7 | 5 | 63 | 7 | ||
173581 | 251197 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 3 | Front Yard : Yard | Tree | Private 2 | 03/22/2017 12:00:00 AM | 3 | Permit Number 779570 | 6002798.55883 | 2107703.57748 | 37.7675105430125 | -122.433598998019 | (37.7675105430125, -122.433598998019) | 15 | 5 | 5 | 28862 | 3 | ||
180810 | 251196 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 900X 14th St | 2 | Front Yard : Cutout | Tree | Private 2 | 03/22/2017 12:00:00 AM | 3 | 6002515 | 2107976 | 37.768242455455 | -122.434599270731 | (37.768242455455, -122.434599270731) | 15 | 5 | 5 | 28862 | 3 | |||
18723 | 95885 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 16 | 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 | ||
19601 | 95883 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Everglade Sloat Blvd | 14 | 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 | ||
50854 | 95880 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Clearfield Sloat Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
144742 | 95881 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Ocean Sloat Blvd | 17 | 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 | ||
155478 | 95884 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 1501@Everglade Sloat Blvd | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 03/16/2011 12:00:00 AM | 12 | Permit Number 767134 | 5986316.3 | 2095724.7 | 37.7336708170949 | -122.489727133621 | (37.7336708170949, -122.489727133621) | 1 | 8 | 4 | 64 | 35 | ||
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 | ||
45971 | 91488 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 750x Brotherhood Way | 22 | Median : Cutout | Tree | DPW 1 | 03/15/2007 12:00:00 AM | 3 | 5991053.474445 | 2088092.036965 | 37.7129888676025 | -122.472793145921 | (37.7129888676025, -122.472793145921) | 1 | 8 | 4 | 64 | 14 | |||
78333 | 91486 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 750x Brotherhood Way | 20 | Median : Cutout | Tree | DPW 1 | 03/15/2007 12:00:00 AM | 3 | 5991053.474445 | 2088092.036965 | 37.7129888676025 | -122.472793145921 | (37.7129888676025, -122.472793145921) | 1 | 8 | 4 | 64 | 14 | |||
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 | |||
12739 | 30076 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 11 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
21587 | 30086 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 22 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
29182 | 30079 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 14 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
35519 | 30055 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 1 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
35748 | 30062 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 7 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
39717 | 30064 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 9 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
41865 | 30081 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 16 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
42877 | 30058 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 3 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
45412 | 30080 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 15 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
46878 | 30075 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 20 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
49772 | 30074 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 10 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
50741 | 30065 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 10 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
56132 | 30085 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 21 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
56653 | 30060 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 5 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | 3X3 | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
58727 | 30063 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 8 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
64998 | 30092 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 28 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
68747 | 30088 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 24 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
69754 | 30066 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 510X Brotherhood Way | 11 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5992600.642524 | 2087870.68608 | 37.7124705349467 | -122.467429580771 | (37.7124705349467, -122.467429580771) | 9 | 8 | 4 | 64 | 24 | ||
70108 | 30089 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 25 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
70226 | 30087 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 23 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
82629 | 30091 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 27 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
97030 | 30077 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 12 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 | ||
120667 | 30090 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 410X Brotherhood Way | 26 | Median : Cutout | Tree | DPW 1 | 03/10/2007 12:00:00 AM | 6 | M | 5993748.152574 | 2087576.478532 | 37.7117288925291 | -122.463442127126 | (37.7117288925291, -122.463442127126) | 9 | 8 | 4 | 64 | 24 |
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) );