111 rows where qSpecies_id = 129

View and edit SQL

Suggested facets: qLegalStatus_id, SiteOrder, qCaretaker_id, qCareAssistant, DBH, PlotSize, PermitNotes, Fire Prevention Districts, Supervisor Districts, Zip Codes, Neighborhoods (old)

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)
687 264637 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1290 Egbert Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/04/2020 12:00:00 AM   4x6   6014937 2090724 37.7215694101837 -122.390426859327 (37.7215694101837, -122.390426859327) 10 3 8 58 1
2121 110341 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 564 Grove St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6005076.8079 2111304.1554 37.7775258606118 -122.425975168518 (37.7775258606118, -122.425975168518) 7 9 11 28852 10
2614 22945 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 446 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6006123.08894 2106987.22573 37.7657316814476 -122.422048975848 (37.7657316814476, -122.422048975848) 8 4 5 28853 19
3875 3295 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 4721 California St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/19/2005 12:00:00 AM 6 3X3   5992917.64909 2114121.45234 37.784566708473 -122.468242393585 (37.784566708473, -122.468242393585) 11 6 2 54 11
4925 99065 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 560 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006138.71978 2106309.15909 37.7638707521361 -122.421946740307 (37.7638707521361, -122.421946740307) 8 4 5 28859 19
5397 141400 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 651 GROVE ST 15 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6004844.5154 2111226.902 37.7773006108566 -122.426773243262 (37.7773006108566, -122.426773243262) 7 9 11 28852 10
6282 264636 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1290 Egbert Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 09/04/2020 12:00:00 AM   4x6   6014937 2090724 37.7215694101837 -122.390426859327 (37.7215694101837, -122.390426859327) 10 3 8 58 1
7195 4140 Planning Code 138.1 required 2 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3620 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/11/2020 12:00:00 AM 3 3x6 Permit Number 780969 6006062.29639 2100597.35658 37.7481831571401 -122.421805323766 (37.7481831571401, -122.421805323766) 2 4 5 28859 19
10018 259741 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 639 Grove St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/11/2019 12:00:00 AM 3     6004752.1306 2111210.76413 37.7772510764575 -122.427091682563 (37.7772510764575, -122.427091682563) 7 9 11 28852 10
10353 110340 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 564 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 4x4   6005097.2691 2111307.8756 37.7775372317236 -122.425904651228 (37.7775372317236, -122.425904651228) 7 9 11 28852 10
11230 26974 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 680 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/2018 12:00:00 AM 3 3x6   6006189.7137 2105638.02498 37.7620308514509 -122.421722694966 (37.7620308514509, -122.421722694966) 8 4 5 28859 19
11274 13515 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 333 Market St 9 Sidewalk: Curb side : Cutout Tree DPW 1   11/25/2019 10:27:00 AM 3 4X4   6013400.91851 2116448.99876 37.7921193351998 -122.397540013255 (37.7921193351998, -122.397540013255) 12 2 9 28855 6
11699 99056 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 524 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006116.39403 2106513.26367 37.7644299160351 -122.422038458941 (37.7644299160351, -122.422038458941) 8 4 5 28859 19
16549 103496 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1850X Cabrillo St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2019 12:00:00 AM 3 3x3 Permit Number 771036 5989840.04595 2110621.50302 37.7747785915425 -122.478633697845 (37.7747785915425, -122.478633697845) 11 6 2 55 26
18276 119614 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
18582 259739 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 635 Grove St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/11/2019 12:00:00 AM 3     6004770.46943 2111213.3219 37.7772591364779 -122.427028424855 (37.7772591364779, -122.427028424855) 7 9 11 28852 10
19046 259740 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 637 Grove St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 06/11/2019 12:00:00 AM 3     6004761.30001 2111212.04301 37.7772551064579 -122.427060053728 (37.7772551064579, -122.427060053728) 7 9 11 28852 10
20076 13882 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1027 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/14/2016 08:40:00 AM 3 4X4   6009489.4233125 2112722.2987067 37.7816681394186 -122.410810578934 (37.7816681394186, -122.410810578934) 14 2 9 28853 34
22164 99062 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 548 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006124.33398 2106369.96474 37.7640368987846 -122.422000816338 (37.7640368987846, -122.422000816338) 8 4 5 28859 19
29363 109146 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 6100 California St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 01/29/2015 12:00:00 AM 3 3x3 Permit Number 771557 5988645.31389 2114024.0417 37.7840515692549 -122.483015907997 (37.7840515692549, -122.483015907997) 11 6 2 55 26
31748 22958 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 474 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/23/1994 12:00:00 AM 3 3x3   6006107.21525 2106877.76556 37.7654302344215 -122.422096102646 (37.7654302344215, -122.422096102646) 8 4 5 28853 19
32387 99071 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 567 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006238.66511 2106285.80349 37.7638122593075 -122.421599400126 (37.7638122593075, -122.421599400126) 8 4 7 28859 19
32594 99080 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 515 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 775410 6006223.31377 2106562.86626 37.7645721427534 -122.421672175812 (37.7645721427534, -122.421672175812) 8 4 7 28859 19
33232 82541 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 657 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52586 6004618.75767182 2111536.15402672 37.7781369742486 -122.427576250385 (37.7781369742486, -122.427576250385) 7 9 11 28852 10
40613 114302 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 435 Brannan St 6 Sidewalk: Curb side : Cutout Tree Private 2   07/19/2017 12:00:00 AM 3   Permit Number 780276 6014032.20399 2111804.00666 37.7794003871666 -122.395030252748 (37.7794003871666, -122.395030252748) 6 2 9 28856 34
41627 99060 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 544 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006121.99737 2106412.13789 37.7641525645269 -122.422011894129 (37.7641525645269, -122.422011894129) 8 4 5 28859 19
41755 93969 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3400 Cesar Chavez St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 53400 6006959.5 2100632.2 37.7483293848143 -122.418705286135 (37.7483293848143, -122.418705286135) 2 4 7 28859 19
45966 99079 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 521 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006248.76253 2106537.76034 37.7645046428221 -122.421582372033 (37.7645046428221, -122.421582372033) 8 4 7 28859 19
46036 99063 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 560 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006138.71978 2106309.15909 37.7638707521361 -122.421946740307 (37.7638707521361, -122.421946740307) 8 4 5 28859 19
48024 99078 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 523 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006225.8049 2106517.90539 37.764448831279 -122.42166036603 (37.764448831279, -122.42166036603) 8 4 7 28859 19
51333 60113 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 520 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/1982 12:00:00 AM 3 3x3   6006114.68734 2106544.06971 37.7645144058927 -122.422046550542 (37.7645144058927, -122.422046550542) 8 4 5 28859 19
51380 99076 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 557 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006267.52628 2106357.27284 37.764010124676 -122.421504654052 (37.764010124676, -122.421504654052) 8 4 7 28859 19
51444 103560 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 300X Cornwall St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2013 12:00:00 AM 4 3x3 Permit Number 769959 5994548.41195 2114239.31822 37.7849843868147 -122.462609100644 (37.7849843868147, -122.462609100644) 11 6 2 54 11
55189 13655 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 607 Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/26/2016 10:49:00 AM 3 4X4   6012064.2714323 2115177.7586998 37.7885542943226 -122.402075446971 (37.7885542943226, -122.402075446971) 12 2 9 28855 6
58183 99095 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 657 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006266.81696 2105777.70576 37.7624187297216 -122.421465944573 (37.7624187297216, -122.421465944573) 8 4 7 28859 19
62857 123067 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 604 12th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5992249.44693 2111276.49592 37.7767166209192 -122.470346870506 (37.7767166209192, -122.470346870506) 11 6 2 54 11
63777 22953 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 460 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 4x6   6006126.2342864 2106915.2740853 37.7655342966506 -122.422032984881 (37.7655342966506, -122.422032984881) 8 4 5 28853 19
64632 62317 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 690 05th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 03/29/2018 12:00:00 AM 3   Permit Number 22459 5994436.89437 2110841.52784 37.7756485440016 -122.462748336841 (37.7756485440016, -122.462748336841) 11 6 2 54 11
67735 99550 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 200X Henry St 4 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency 07/19/2016 04:45:00 AM 3 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
70242 234820 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3400 Cesar Chavez St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6006896.08338 2100607.87267 37.7482590167614 -122.418922854526 (37.7482590167614, -122.418922854526) 2 4 7 28859 19
71001 116973 Undocumented 4 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 121 SPEAR ST 3 Sidewalk: Curb side : Cutout Tree Private 2   07/05/2016 12:00:00 AM 3 3x3 Permit Number 777976 6014757 2116474 37.7922633974731 -122.39284966575 (37.7922633974731, -122.39284966575) 12 2 9 28855 6
71696 99064 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 560 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   6006138.71978 2106309.15909 37.7638707521361 -122.421946740307 (37.7638707521361, -122.421946740307) 8 4 5 28859 19
75365 99096 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 623 Valencia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6006260.38456 2105910.51651 37.7627830341769 -122.421497624526 (37.7627830341769, -122.421497624526) 8 4 7 28859 19
79873 124285 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 4201 California St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5994493.43638 2114295.92728 37.7851366537527 -122.462803405372 (37.7851366537527, -122.462803405372) 11 6 2 54 11
82055 60112 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 475 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/26/1982 12:00:00 AM 3 3x3   6006207.18224 2106854.01331 37.7653706541631 -122.421748651963 (37.7653706541631, -122.421748651963) 8 4 7 28853 19
82355 99075 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 559 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006267.52628 2106357.27284 37.764010124676 -122.421504654052 (37.764010124676, -122.421504654052) 8 4 7 28859 19
84042 99059 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 540 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006092.37899 2106431.2635 37.7642034084393 -122.422115694531 (37.7642034084393, -122.422115694531) 8 4 5 28859 19
85040 99066 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 580 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x6   6006132.54262 2106221.80887 37.7636305606357 -122.421961899774 (37.7636305606357, -122.421961899774) 8 4 5 28859 19
85374 59944 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 541 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/04/2010 12:00:00 AM 3 3x3   6006230.19236 2106438.71887 37.7642316511634 -122.421639566353 (37.7642316511634, -122.421639566353) 8 4 7 28859 19
87572 54408 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1274 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/2010 12:00:00 AM   3x3 Permit Number 53914 5993646.90937418 2106826.38813309 37.7645785044123 -122.465189364979 (37.7645785044123, -122.465189364979) 11 8 11 56 12
90934 105853 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3440 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/05/2014 12:00:00 AM 2 3x3 Permit Number 771130 5998386.8139 2115235.64255 37.7879403376223 -122.449401324733 (37.7879403376223, -122.449401324733) 13 6 1 54 31
93031 24554 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 408 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3X3 Permit Number 776709 6007266.67907 2097258.15357 37.7390822977194 -122.417403986799 (37.7390822977194, -122.417403986799) 2 7 7 28859 2
94062 22991 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 663 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/04/2010 12:00:00 AM 5 3x3   6006244.58019 2105713.97043 37.7622424736555 -122.421538326696 (37.7622424736555, -122.421538326696) 8 4 7 28859 19
97766 38892 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 84 Palm Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/23/2014 12:00:00 AM 3   Permit Number 773793 5995918.72229 2113930.22791 37.7842145286919 -122.457845919528 (37.7842145286919, -122.457845919528) 11 6 1 54 31
101055 119613 Significant Tree 6 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2X Sutter St 1 Sidewalk: Property side : Cutout Tree Private 2     12 3x3   6012582 2115890 37.7905388243453 -122.400334219916 (37.7905388243453, -122.400334219916) 4 1 10 28854 6
108926 14097 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1455 Market St 8 Sidewalk: Curb side : Cutout Tree DPW 1   11/23/2016 12:00:00 AM 3 4X4 Permit Number 778907 6007200 2110540 37.7755474375327 -122.418576120309 (37.7755474375327, -122.418576120309) 8 2 9 28853 34
109766 14064 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1390 Market St 7 Sidewalk: Curb side : Cutout Tree DPW 1   04/27/2017 08:26:00 AM 3 4x4   6007685.3945 2111107.6588 37.7771334080887 -122.416937247256 (37.7771334080887, -122.416937247256) 7 2 9 28852 36
111508 234821 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3400 Cesar Chavez St 7 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6006874.27762 2100608.63035 37.7482598692981 -122.418998312118 (37.7482598692981, -122.418998312118) 2 4 7 28859 19
113179 256659 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1455 Market St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/14/2018 12:00:00 AM 3   Permit Number 781724 6007354.4656 2110676.258 37.7759302643824 -122.418051446991 (37.7759302643824, -122.418051446991) 8 2 9 28853 34
113803 70940 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 624 Grove St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/2009 12:00:00 AM   3x3 Permit Number 52586 6004809.96249369 2111265.27573463 37.7774040220808 -122.426895506614 (37.7774040220808, -122.426895506614) 7 9 11 28852 10
115149 13953 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1117 Market St 3 Sidewalk: Curb side : Cutout Tree DPW 1   11/01/2016 07:38:00 AM 3 4X4   6008897.3784125 2112157.6718266 37.7800845945909 -122.412818850612 (37.7800845945909, -122.412818850612) 8 2 9 28853 34
117857 231172 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2968 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/09/2016 12:00:00 AM 3 Width 3ft   6009727.404 2100624.81411 37.7484645559129 -122.409133381503 (37.7484645559129, -122.409133381503) 2 4 7 28859 19
119242 120364 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 6102 California St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5988623.48291 2114024.14495 37.7840505824045 -122.483091441937 (37.7840505824045, -122.483091441937) 11 6 2 55 26
120884 113311 Undocumented 4 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1001x Alemany Blvd 10 Front Yard : Yard Tree Private 2   11/09/2015 12:00:00 AM 20   Permit Number 776808 6003491.75626 2094313.44879 37.7307836910976 -122.430245918511 (37.7307836910976, -122.430245918511) 9 7 6 28861 25
124075 99093 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 677 Valencia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6006238 2105632 37.762017031056 -122.421555263176 (37.762017031056, -122.421555263176) 8 4 7 28859 19
124150 92082 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 67 Ord St   Sidewalk: Curb side : Cutout Tree Private 2   06/23/2009 12:00:00 AM   3x3 Permit Number 52195 6000865 2106002.3 37.7627293574281 -122.440164893316 (37.7627293574281, -122.440164893316) 15 5 5 28862 3
128602 14063 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1390 Market St 6 Sidewalk: Curb side : Cutout Tree DPW 1   04/27/2017 08:13:00 AM 3 4x4   6007701.949 2111122.2657 37.7771744463261 -122.416881015003 (37.7771744463261, -122.416881015003) 7 2 9 28852 36
130392 99070 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 581 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006252.26909 2106239.1087 37.7636848134857 -122.421549031471 (37.7636848134857, -122.421549031471) 8 4 7 28859 19
130432 3218 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3838 California St 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/1994 12:00:00 AM 2 3X3   5995981.80653 2114566.54912 37.785965320402 -122.457673729525 (37.785965320402, -122.457673729525) 11 6 1 54 31
130726 16724 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1075 O'Farrell St 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/30/2015 10:17:00 AM 3 4X4   6006252.84558 2113856.064 37.7845991729485 -122.422088192257 (37.7845991729485, -122.422088192257) 7 9 11 28858 41
132802 99067 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 580 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006132.54262 2106221.80887 37.7636305606357 -122.421961899774 (37.7636305606357, -122.421961899774) 8 4 5 28859 19
133689 103558 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 4201 California St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2013 12:00:00 AM 11 3x3 Permit Number 769959 5994475.89844 2114293.94067 37.7851301889308 -122.462863936545 (37.7851301889308, -122.462863936545) 11 6 2 54 11
135287 99068 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 580 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006132.54262 2106221.80887 37.7636305606357 -122.421961899774 (37.7636305606357, -122.421961899774) 8 4 5 28859 19
137032 14059 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1390 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/26/2017 03:10:00 PM 3 4x4   6007777.9052 2111198.2219 37.7773872760423 -122.416623639707 (37.7773872760423, -122.416623639707) 7 2 9 28852 36
139919 99045 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 455 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006201.54773 2106955.70931 37.7656495696033 -122.421775364545 (37.7656495696033, -122.421775364545) 8 4 7 28853 19
142284 72735 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3000 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/22/1997 12:00:00 AM   3x3   6009584.26051123 2100606.98217244 37.7484075731852 -122.409627112641 (37.7484075731852, -122.409627112641) 2 4 7 28859 19
143579 99061 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 548 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x6   6006124.33398 2106369.96474 37.7640368987846 -122.422000816338 (37.7640368987846, -122.422000816338) 8 4 5 28859 19
144128 99044 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 461 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006204.27673 2106906.45383 37.7655144795923 -122.421762426609 (37.7655144795923, -122.421762426609) 8 4 7 28853 19
144962 117956 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 851X HARRISON ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6012435 2111995 37.7798358648386 -122.400569108585 (37.7798358648386, -122.400569108585) 6 2 9 28856 34
145088 95267 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 2245 Jones St 6 Sidewalk: Property side : Cutout Tree SFUSD 4 DPW for City Agency         6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624) 5 1 10 308 32
147068 120830 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 5751 California St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5989723.47799 2114007.40969 37.7840685806486 -122.479284675494 (37.7840685806486, -122.479284675494) 11 6 2 55 26
147752 50728 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3101 Washington St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/28/2017 12:00:00 AM 3   Permit Number 780126 5999807.59177 2116040.97714 37.7902327454929 -122.444543610603 (37.7902327454929, -122.444543610603) 13 6 1 29490 27
148227 88804 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 55 Page St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/09/2008 12:00:00 AM   3x3 Permit Number 51708 6006333 2111428 37.7779368220791 -122.421638371919 (37.7779368220791, -122.421638371919) 7 9 11 28852 10
148534 22957 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 460 Valencia St 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6006126.23429 2106915.27409 37.7655342966637 -122.422032984869 (37.7655342966637, -122.422032984869) 8 4 5 28853 19
151336 99094 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 677 Valencia St 3 Sidewalk: Curb side : Cutout Tree DPW 1     8 3x3   6006238 2105632 37.762017031056 -122.421555263176 (37.762017031056, -122.421555263176) 8 4 7 28859 19
154752 135631 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3450 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5998366.80455 2115231.89384 37.7879289000462 -122.449470282934 (37.7879289000462, -122.449470282934) 13 6 1 54 31
155974 120829 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 5751 California St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5989740.28285 2114007.05422 37.7840685806306 -122.479226511391 (37.7840685806306, -122.479226511391) 11 6 2 55 26
162591 66767 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 623 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/12/1991 12:00:00 AM 3 3x3   6006260.38456 2105910.51651 37.7627830341769 -122.421497624526 (37.7627830341769, -122.421497624526) 8 4 7 28859 19
163381 99055 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 502 Valencia St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006083.07455 2106599.19361 37.7646639800831 -122.422159807273 (37.7646639800831, -122.422159807273) 8 4 5 28859 19
164214 99058 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 540 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006092.37899 2106431.2635 37.7642034084393 -122.422115694531 (37.7642034084393, -122.422115694531) 8 4 5 28859 19
169083 173938 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 680 Valencia St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x6   6006196.3038013 2105654.3539825 37.7620760586794 -122.421701062175 (37.7620760586794, -122.421701062175) 8 4 5 28859 19
169087 9847 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 1295X Gough St 8 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2009 12:00:00 AM 3 3X3   6005487.54968 2114101.28131 37.7852292855281 -122.424753311633 (37.7852292855281, -122.424753311633) 13 9 11 28858 41
169880 91018 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 95 McCoppin St   Sidewalk: Curb side : Cutout Tree DPW 1   11/17/2008 12:00:00 AM 3 3x3   6006069.437314 2109106.791352 37.771548477703 -122.422385159744 (37.771548477703, -122.422385159744) 8 2 9 28853 19
170188 99072 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 567 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006238.66511 2106285.80349 37.7638122593075 -122.421599400126 (37.7638122593075, -122.421599400126) 8 4 7 28859 19
170724 99043 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 475 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006207.18224 2106854.01331 37.7653706541631 -122.421748651963 (37.7653706541631, -122.421748651963) 8 4 7 28853 19
172381 99077 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 529 Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006227.20287 2106492.6748 37.764379632857 -122.421653738681 (37.764379632857, -122.421653738681) 8 4 7 28859 19
174252 84694 DPW Maintained 1 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 623 Valencia St 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6006260.38456 2105910.51651 37.7627830341769 -122.421497624526 (37.7627830341769, -122.421497624526) 8 4 7 28859 19
174882 99048 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 435 Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6006194.69309 2107079.42494 37.7659888769113 -122.421807861739 (37.7659888769113, -122.421807861739) 8 4 7 28853 19
175580 93036 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 3081 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/14/2010 12:00:00 AM     Permit Number 53145 6007764.8 2103179.8 37.7553698250409 -122.416100967215 (37.7553698250409, -122.416100967215) 2 4 7 28859 19
177030 22974 Permitted Site 7 Platanus x hispanica 'Columbia' :: Columbia Hybrid Plane Tree 129 601X Valencia St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/23/1994 12:00:00 AM 3 3x3   6006253.05747 2106023.17246 37.76309194781 -122.421530967732 (37.76309194781, -122.421530967732) 8 4 7 28859 19

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