trees

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

✎ View and edit SQL

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)
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
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
82730 99738 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900X Ocean Ave 4 Median : Cutout Tree DPW 1           5997264.7 2091625.4 37.7230482703916 -122.451579911331 (37.7230482703916, -122.451579911331) 9 7 4 28861 40
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
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
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
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
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
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
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
121164 99450 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1601X 15th Ave 7 Median : Cutout Tree DPW 1           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604) 1 8 4 56 12
178411 99449 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1601X 15th Ave 4 Median : Cutout Tree DPW 1           5991576.7 2104258.5 37.7574081656565 -122.472162400604 (37.7574081656565, -122.472162400604) 1 8 4 56 12
85130 99433 Undocumented 4 Pinus radiata :: Monterey Pine 15 244 Glenview Dr 1 Sidewalk: Curb side : Yard Tree Private 2           5999066 2100737 37.7481695560511 -122.446008243376 (37.7481695560511, -122.446008243376) 2 5 5 63 38
15601 99374 Property Tree 8 Pinus radiata :: Monterey Pine 15 21 Panorama Dr   Back Yard : Yard Tree Private 2     24     5998009 2100230 37.7467170430405 -122.449626769288 (37.7467170430405, -122.449626769288) 1 5 4 63 38
28400 99274 Undocumented 4 Pinus radiata :: Monterey Pine 15 16 Joy St 1 Unaccepted Street : Yard Tree Private 2       3x3 Permit Number 768828 6010347.9 2098933.4 37.7438550437031 -122.406868515265 (37.7438550437031, -122.406868515265) 2 7 7 28859 2
84386 99192 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1155@Sansome Battery St 3 Front Yard : Yard Tree Private 2       Plaza Permit Number 768022 6012245 2120028 37.8018819838627 -122.401791216362 (37.8018819838627, -122.401791216362) 3 1 10 28860 6
138542 99165 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 14 Median : Cutout Tree Private 2     18     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
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
73193 99162 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 46 Median : Cutout Tree Private 2     24     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
99624 99161 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 45 Median : Cutout Tree Private 2     18     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
58497 99160 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 44 Median : Cutout Tree Private 2     48     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
82810 99159 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 43 Median : Cutout Tree Private 2     18     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
99762 99158 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 42 Median : Cutout Tree Private 2     12     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
58761 99157 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 40 Median : Cutout Tree Private 2     24     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
44275 99156 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 39 Median : Cutout Tree Private 2     6     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
55150 99155 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 38 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
72761 99150 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 34 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
44216 99149 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 33 Median : Cutout Tree Private 2     24     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
83923 99147 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 31 Median : Cutout Tree Private 2     24     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
89706 99142 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 25 Median : Cutout Tree Private 2     24     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
126420 99141 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 23 Median : Cutout Tree Private 2     9     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
117823 99140 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 24 Median : Cutout Tree Private 2     12     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
175235 99139 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 22 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
95751 99138 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 21 Median : Cutout Tree Private 2     18     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
149397 99137 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 20 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
136280 99134 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 17 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
20180 99132 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 15 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
23741 99131 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 14 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
65236 99130 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 13 Median : Cutout Tree Private 2     18     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
32643 99129 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 12 Median : Cutout Tree Private 2     18     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
84421 99127 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 10 Median : Cutout Tree Private 2     48     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
134593 99126 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 9 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
122089 99124 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 7 Median : Cutout Tree Private 2     12     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
133508 99123 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 4 Median : Cutout Tree Private 2     6     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
29849 99121 Undocumented 4 Pinus radiata :: Monterey Pine 15 302X Pacheco St 2 Median : Cutout Tree Private 2     3     5994341.5 2100725.2 37.7478662384021 -122.46234443277 (37.7478662384021, -122.46234443277) 1 8 4 29491 40
166498 98840 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1101X Portola Dr 5 Sidewalk: Property side : Yard Tree DPW 1           5994967.95791 2097979.30417 37.740362747151 -122.459979297607 (37.740362747151, -122.459979297607) 9 8 4 59 40
147811 98831 Undocumented 4 Pinus radiata :: Monterey Pine 15 333@Lopez Pacheco St 2 Sidewalk: Curb side : Cutout Tree Private 2           5994230.9 2100817.4 37.748113026994 -122.462733567037 (37.748113026994, -122.462733567037) 1 8 4 29491 40
75993 98822 Undocumented 4 Pinus radiata :: Monterey Pine 15 373 Castenada Ave 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 56980 5993476.3 2100002.1 37.7458309308973 -122.465283713064 (37.7458309308973, -122.465283713064) 1 8 4 29491 40
107818 98757 Significant Tree 6 Pinus radiata :: Monterey Pine 15 340 Castenada Ave 1 Front Yard : Yard Tree Private 2           5993579.1 2100062.8 37.7460035255592 -122.464932655613 (37.7460035255592, -122.464932655613) 1 8 4 29491 40
68077 98722 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 701X Brotherhood Way 1 Sidewalk: Curb side : Yard Tree DPW 1           5991112.8 2087998.1 37.7127343737121 -122.472581254687 (37.7127343737121, -122.472581254687) 1 8 4 64 14
177029 98721 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 700X Brotherhood Way   Front Yard : Yard Tree DPW 1           5991178.9 2088065.4 37.7129229890255 -122.472357697274 (37.7129229890255, -122.472357697274) 1 8 4 64 14
127263 98715 Property Tree 8 Pinus radiata :: Monterey Pine 15 26 Vernon St   Back Yard : Yard Tree Private 2           5992459 2088068 37.713004133171 -122.467933479353 (37.713004133171, -122.467933479353) 9 8 6 64 24
117185 98714 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 500X Brotherhood Way   Front Yard : Yard Tree DPW 1           5992573.4 2087955 37.7127004679185 -122.467529866031 (37.7127004679185, -122.467529866031) 9 8 6 64 24
130932 98553 Undocumented 4 Pinus radiata :: Monterey Pine 15 143@Gladview Skyview Way 2 Sidewalk: Curb side : Yard Tree Private 2           5997951.6 2102231.3 37.752208836846 -122.449969465547 (37.752208836846, -122.449969465547) 1 5 4 63 38
44195 98552 Undocumented 4 Pinus radiata :: Monterey Pine 15 143@Gladview Skyview Way 1 Sidewalk: Curb side : Yard Tree Private 2           5997951.6 2102231.3 37.752208836846 -122.449969465547 (37.752208836846, -122.449969465547) 1 5 4 63 38
23065 98547 Significant Tree 6 Pinus radiata :: Monterey Pine 15 555@Rio Teresita Blvd 3 Front Yard : Yard Tree Private 2           5999006.5 2097247.3 37.7385842819574 -122.445963035448 (37.7385842819574, -122.445963035448) 9 7 4 59 40
9602 98360 Permitted Site 7 Pinus radiata :: Monterey Pine 15 807 Francisco St 1 Sidewalk: Curb side : Yard Tree Private 2         Permit Number 768654 6007370.5 2120864.5 37.8039055703948 -122.418718664572 (37.8039055703948, -122.418718664572) 5 1 1 28858 32
183500 98157 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 2 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
89599 98156 Significant Tree 6 Pinus radiata :: Monterey Pine 15 149x Chaves Ave 1 Front Yard : Yard Tree Private 2           5996703.5 2098396.7 37.7416084783757 -122.454008650942 (37.7416084783757, -122.454008650942) 9 7 4 59 40
85195 98151 Significant Tree 6 Pinus radiata :: Monterey Pine 15 850 Rockdale Dr 3 Front Yard : Yard Tree Private 2         Permit Number 768501 5996729.9 2098301.3 37.7413480470066 -122.453910481227 (37.7413480470066, -122.453910481227) 9 7 4 59 40
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
75471 98104 Significant Tree 6 Pinus radiata :: Monterey Pine 15 1@Carl Irving St 8 Sidewalk: Property side : Yard Tree Private 2     15     5995817.2 2106753.3 37.7645027364821 -122.45767767256 (37.7645027364821, -122.45767767256) 15 5 11 56 12
115258 97537 Permitted Site 7 Pinus radiata :: Monterey Pine 15 300 Winfield St 3 Unaccepted Street : Yard Tree Private 2           6006649.9 2098038.3 37.7411896837785 -122.419591868256 (37.7411896837785, -122.419591868256) 2 7 7 28859 2
186015 97536 Permitted Site 7 Pinus radiata :: Monterey Pine 15 300 Winfield St 2 Unaccepted Street : Yard Tree Private 2         Permit Number 768224 6006649.9 2098038.3 37.7411896837785 -122.419591868256 (37.7411896837785, -122.419591868256) 2 7 7 28859 2
85873 97535 Permitted Site 7 Pinus radiata :: Monterey Pine 15 300 Winfield St 1 Unaccepted Street : Yard Tree Private 2           6006649.9 2098038.3 37.7411896837785 -122.419591868256 (37.7411896837785, -122.419591868256) 2 7 7 28859 2
169535 97404 Permitted Site 7 Pinus radiata :: Monterey Pine 15 2@Melrose Stanford Heights Ave 1 Sidewalk: Curb side : Yard Tree Private 2           5997807 2095590.8 37.7339673631019 -122.449990957178 (37.7339673631019, -122.449990957178) 9 7 4 59 40
141531 97403 Permitted Site 7 Pinus radiata :: Monterey Pine 15 2 STANFORD HEIGHTS AVE 1 Sidewalk: Curb side : Yard Tree Private 2           5997807 2095590.8 37.7339673631019 -122.449990957178 (37.7339673631019, -122.449990957178) 9 7 4 59 40
33684 97290 Property Tree 8 Pinus radiata :: Monterey Pine 15 55 Hiliritas Ave   Front Yard : Yard Tree Private 2         Permit Number 778896 6001461.7 2096833.2 37.7375871516219 -122.437444499981 (37.7375871516219, -122.437444499981) 2 7 5 63 7
135239 96875 Permitted Site 7 Pinus radiata :: Monterey Pine 15 2100X San Jose Ave 7 Sidewalk: Property side : Yard Tree Private 2           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923) 9 7 6 28861 25
127483 96868 Permitted Site 7 Pinus radiata :: Monterey Pine 15 2100X San Jose Ave 2 Sidewalk: Property side : Yard Tree Private 2           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923) 9 7 6 28861 25
146759 96866 Permitted Site 7 Pinus radiata :: Monterey Pine 15 2100X San Jose Ave 1 Sidewalk: Property side : Yard Tree Private 2           5999221.1 2091561.9 37.7229857575378 -122.444812491923 (37.7229857575378, -122.444812491923) 9 7 6 28861 25
5276 9649 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 420X Masonic Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   5999128.38767 2111347.91542 37.7773080410323 -122.446555809153 (37.7773080410323, -122.446555809153) 15 5 11 29492 16
133453 9648 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 420X Masonic Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   5999128.38767 2111347.91542 37.7773080410323 -122.446555809153 (37.7773080410323, -122.446555809153) 15 5 11 29492 16
149072 9647 Permitted Site 7 Pinus radiata :: Monterey Pine 15 420X Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     50 3X3   5999128.38767 2111347.91542 37.7773080410323 -122.446555809153 (37.7773080410323, -122.446555809153) 15 5 11 29492 16
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
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
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
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
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
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
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
40755 95686 Undocumented 4 Pinus radiata :: Monterey Pine 15 373 Castenada Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   03/08/2011 12:00:00 AM     Permit Number 56980 5993476.3 2100002.1 37.7458309308973 -122.465283713064 (37.7458309308973, -122.465283713064) 1 8 4 29491 40
1378 95407 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2X Cranleigh Dr 9 Median : Yard Tree DPW 1     80     5991370.3 2095943.7 37.7345659248964 -122.472270103664 (37.7345659248964, -122.472270103664) 1 8 4 64 40
6758 95372 Significant Tree 6 Pinus radiata :: Monterey Pine 15 180 Yukon St   Back Yard : Cutout Tree Private 2     15   Permit Number 767755 6000174.3 2103956.9 37.7570738455347 -122.442406920559 (37.7570738455347, -122.442406920559) 2 4 5 28862 3
38536 95334 Permitted Site 7 Pinus radiata :: Monterey Pine 15 466 Gonzalez Dr 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2011 12:00:00 AM 75   Permit Number 767212 5989603.4 2089229.6 37.7160282834266 -122.477888136934 (37.7160282834266, -122.477888136934) 1 8 4 64 14
116546 95242 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2620 Larkin St   Front Yard : Yard Tree Private 2     37   Permit Number 56959 6006630 2120172 37.801962421987 -122.421232011572 (37.801962421987, -122.421232011572) 5 9 1 28858 32
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
8781 94862 Permitted Site 7 Pinus radiata :: Monterey Pine 15   2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53932                    
10108 94859 Permitted Site 7 Pinus radiata :: Monterey Pine 15   1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53932                    
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
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
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
169730 93194 Undocumented 4 Pinus radiata :: Monterey Pine 15 442 Campbell Ave 1 Front Yard : Yard Tree Private 2           6010752.9 2088369 37.7148700691491 -122.404724531269 (37.7148700691491, -122.404724531269) 9 7 8 309 39
67795 93075 Permitted Site 7 Pinus radiata :: Monterey Pine 15 1230 Twin Peaks Blvd 1 Sidewalk: Property side : Yard Tree Private 2   02/01/2010 12:00:00 AM     Permit Number 53156 5997905.5 2100119.1 37.7464066170132 -122.449976668748 (37.7464066170132, -122.449976668748) 2 5 4 63 38
47675 92871 Permitted Site 7 Pinus radiata :: Monterey Pine 15 3600 Jackson St   Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 53088 5997031 2116025 37.7900300525901 -122.454149203806 (37.7900300525901, -122.454149203806) 11 6 1 54 31
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
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
138623 91110 Significant Tree 6 Pinus radiata :: Monterey Pine 15 2650 Turk Blvd 1 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
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

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