Street_Tree_List

Data source: data.sfgov.org

396 rows where qSpecies = 38 sorted by qCareAssistant descending

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant ▲ PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
29645 50707 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1658 40th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/28/2004 12:00:00 AM 5   Permit Number 47266 5983788.66504778 2103867.70402192 37.75588137239 -122.499067221884 (37.75588137239, -122.499067221884)
35457 46390 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2447 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 7   Permit Number 44623 5982678.99712077 2098464.70885711 37.7409810943186 -122.502504874921 (37.7409810943186, -122.502504874921)
38448 35388 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 753 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/23/1998 12:00:00 AM 7   Permit Number 38842 6011306.158319999 2104840.46729 37.7601281288176 -122.40397067131799 (37.7601281288176, -122.403970671318)
46923 50575 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1347 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/06/2003 12:00:00 AM 0   Permit Number 47190 5983353.97136461 2105974.76120709 37.7616412492229 -122.50072631562 (37.7616412492229, -122.50072631562)
47735 46973 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1783 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/2002 12:00:00 AM 7   Permit Number 44992 5982214.017865701 2102979.50871383 37.753350143755796 -122.504446973742 (37.7533501437558, -122.504446973742)
49254 48530 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2251(REVISED) 26th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/22/2002 12:00:00 AM 6   Permit Number 45852 5988214.95937948 2099991.18132471 37.7454961303111 -122.48347566224899 (37.7454961303111, -122.483475662249)
56915 38348 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1607 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/1998 12:00:00 AM 0   Permit Number 40415 5981863.96536039 2104143.69244361 37.756526067201705 -122.505743805317 (37.7565260672017, -122.505743805317)
57032 30756 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1547 Thomas Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1995 12:00:00 AM 1   Permit Number 34637 6015015.9888 2093715.5638 37.729788030208795 -122.390362726863 (37.7297880302088, -122.390362726863)
65640 46969 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1658 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/2002 12:00:00 AM 7   Permit Number 44989 5982547.49278996 2103828.23178681 37.7557001072445 -122.503356606053 (37.7557001072445, -122.503356606053)
66736 68069 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 239 Noriega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1993 12:00:00 AM     Permit Number 31806 5993313.66059206 2103207.09024288 37.7546216328473 -122.466078949095 (37.7546216328473, -122.466078949095)
66814 52554 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1719 38th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/12/2006 12:00:00 AM 8   Permit Number 48649 5984370.92860727 2103469.2332854997 37.754821420904996 -122.49702418509099 (37.754821420905, -122.497024185091)
67487 47082 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 175 Beaumont Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/03/2002 12:00:00 AM 5   Permit Number 45068 5996827.60082146 2111762.20695793 37.778313889032205 -122.45454486671998 (37.7783138890322, -122.45454486672)
69872 50219 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2726 Balboa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/2004 12:00:00 AM 8 3x3 Permit Number 46926 5987073.255969999 2111201.4718400002 37.776209992885 -122.48824709613301 (37.776209992885, -122.488247096133)
70656 38369 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 4245 Lawton St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/07/1998 12:00:00 AM 5   Permit Number 40431 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224)
78902 52384 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 36TA MARINA Gladys St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/14/2005 12:00:00 AM     Permit Number 48509 6005730.58900637 2097520.8738626 37.739717121816604 -122.422733759035 (37.7397171218166, -122.422733759035)
78959 52269 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 403 Fair Oaks St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/29/2005 12:00:00 AM     Permit Number 48434 6005520.49766263 2101354.49181367 37.7502315077339 -122.423732674774 (37.7502315077339, -122.423732674774)
79212 33405 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 390 Santa Ana Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/04/1998 12:00:00 AM     Permit Number 40744 5992420.09105205 2094203.06284675 37.729847269288896 -122.468514054616 (37.7298472692889, -122.468514054616)
83364 31185 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 720 Shields St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1995 12:00:00 AM     Permit Number 34883 5992147.8527206 2089880.99524616 37.7179642061069 -122.469140766842 (37.7179642061069, -122.469140766842)
83936 31575 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1922 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/10/1995 12:00:00 AM     Permit Number 35114 5989431.17806618 2102257.22974077 37.7517888142139 -122.479435972521 (37.7517888142139, -122.479435972521)
84780 33391 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 129 Pinehurst Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/14/1996 12:00:00 AM     Permit Number 37510 5993545.21642202 2093774.31911417 37.7287349718633 -122.464593277929 (37.7287349718633, -122.464593277929)
85274 52492 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 390ON GATES Tompkins Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM     Permit Number 48601 6008184.68107457 2096494.82661811 37.7370379770988 -122.41417595350599 (37.7370379770988, -122.414175953506)
85479 49654 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 81 Alpha St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/16/2003 12:00:00 AM     Permit Number 46507 6011171.19956943 2088331.01703059 37.7147891465513 -122.403276034448 (37.7147891465513, -122.403276034448)
86481 52106 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 727 Rockdale Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/26/2005 12:00:00 AM     Permit Number 48298 5997405.05193713 2098248.96190456 37.741243026323 -122.451572279627 (37.741243026323, -122.451572279627)
87840 50881 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2040 15th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/2004 12:00:00 AM     Permit Number 47391 5991642.80129947 2101534.85210656 37.7499335653235 -122.47173531309299 (37.7499335653235, -122.471735313093)
88035 34348 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 330 Arlington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1997 12:00:00 AM     Permit Number 38106 6004294.50938701 2096370.47715627 37.7364772644099 -122.42761717220199 (37.7364772644099, -122.427617172202)
88257 47451 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 5049 Anza St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM     Permit Number 45359 5983034.2663237 2111680.83899779 37.7772897229163 -122.502254315782 (37.7772897229163, -122.502254315782)
88909 45437 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 50 Urbano Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/13/2001 12:00:00 AM     Permit Number 44224 5993813.83621392 2092411.23769418 37.7250077648019 -122.46356576496599 (37.7250077648019, -122.463565764966)
89703 37850 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 211 Edinburg St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/07/1998 12:00:00 AM     Permit Number 40141 6003943.02561838 2092441.0681196998 37.725668101811706 -122.42855239521201 (37.7256681018117, -122.428552395212)
91138 47550 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1681 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM     Permit Number 45414 6003392.60348895 2098449.5926945 37.7421349817765 -122.430883775787 (37.7421349817765, -122.430883775787)
92573 31375 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 630 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/21/1995 12:00:00 AM     Permit Number 34977 5991276.37232485 2099107.33925567 37.7432470351435 -122.47282544581499 (37.7432470351435, -122.472825445815)
93065 31600 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1631 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/10/1995 12:00:00 AM     Permit Number 35126 5988991.64827869 2102380.23074862 37.7521010026968 -122.480964913447 (37.7521010026968, -122.480964913447)
93390 33301 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1120 Taylor St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/14/1996 12:00:00 AM     Permit Number 37453 6009052.27411403 2116787.86536385 37.7928066833324 -122.412610401728 (37.7928066833324, -122.412610401728)
93638 31942 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1300 La Playa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/01/1998 12:00:00 AM     Permit Number 39715 5980916.9213303 2106151.77480086 37.761983899941 -122.50916807626999 (37.761983899941, -122.50916807627)
94127 30765 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1593 Underwood Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/31/1995 12:00:00 AM     Permit Number 34646 6014616.43299999 2093667.83534348 37.729634805621096 -122.391740711397 (37.7296348056211, -122.391740711397)
94727 68575 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 7633 Geary Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/18/1993 12:00:00 AM     Permit Number 32467 5983299.26193695 2112364.72668983 37.779183045029896 -122.501388226383 (37.7791830450299, -122.501388226383)
95135 50288 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 300 Valley St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797933998 37.744430384839504 -122.42903293346001 (37.7444303848395, -122.42903293346)
95217 50293 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 300 Valley St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797933998 37.744430384839504 -122.42903293346001 (37.7444303848395, -122.42903293346)
96489 50428 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 11 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2003 12:00:00 AM     Permit Number 47081 5996479.47890892 2089951.8399168998 37.7184080697361 -122.454173429085 (37.7184080697361, -122.454173429085)
96706 52103 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 641 Rockdale Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/26/2005 12:00:00 AM     Permit Number 48295 5997742.5728031 2098061.02519693 37.7407463206184 -122.450391713191 (37.7407463206184, -122.450391713191)
97029 33402 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 377 Santa Ana Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/19/1996 12:00:00 AM     Permit Number 37520 5992522.58969687 2094276.01733921 37.730053504422 -122.468165013068 (37.730053504422, -122.468165013068)
98101 47351 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 246 Monticello St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/13/2002 12:00:00 AM     Permit Number 45277 5991716.56988019 2090163.16086716 37.7187140338834 -122.470652049529 (37.7187140338834, -122.470652049529)
98528 47604 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 645 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/20/2002 12:00:00 AM     Permit Number 45440 6008713.69382569 2095849.48701302 37.7352957148385 -122.412301312985 (37.7352957148385, -122.412301312985)
98932 52980 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 531 Arch St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/01/2006 12:00:00 AM     Permit Number 49067 5992711.66457877 2090721.03501475 37.720303313737105 -122.467252978798 (37.7203033137371, -122.467252978798)
99862 67131 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1439 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/29/1992 12:00:00 AM     Permit Number 30551 5994253.6761319 2105720.38065143 37.761576666998295 -122.463010486718 (37.7615766669983, -122.463010486718)
100951 50290 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 300 Valley St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797933998 37.744430384839504 -122.42903293346001 (37.7444303848395, -122.42903293346)
102346 50292 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 300 Valley St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2003 12:00:00 AM   3x3 Permit Number 47005 6003944.88624926 2099274.1797933998 37.744430384839504 -122.42903293346001 (37.7444303848395, -122.42903293346)
103188 32605 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1370 36th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/23/1996 12:00:00 AM     Permit Number 37071 5984960.54583105 2105873.44387063 37.7614572492102 -122.49516243722 (37.7614572492102, -122.49516243722)
103787 50490 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 242 Miramar Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/2003 12:00:00 AM     Permit Number 47126 5995378.87438655 2091597.86421043 37.722864487352 -122.458096796728 (37.722864487352, -122.458096796728)
104926 45431 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 851 Head St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/13/2001 12:00:00 AM     Permit Number 44219 5993920.58856776 2091576.5612161 37.72272209583179 -122.463136201451 (37.7227220958318, -122.463136201451)
105148 52497 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 371 Richland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM     Permit Number 48606 6007135.79724675 2096038.97616324 37.7357273409345 -122.417770123047 (37.7357273409345, -122.417770123047)
105417 45429 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 851 Head St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/13/2001 12:00:00 AM     Permit Number 44219 5993920.58856776 2091576.5612161 37.72272209583179 -122.463136201451 (37.7227220958318, -122.463136201451)
105491 31546 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 220 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/10/1995 12:00:00 AM 6   Permit Number 35095 5998394.38199367 2112672.66987383 37.7809035197163 -122.44919042402901 (37.7809035197163, -122.449190424029)
107841 50489 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 242 Miramar Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/2003 12:00:00 AM     Permit Number 47126 5995378.87438655 2091597.86421043 37.722864487352 -122.458096796728 (37.722864487352, -122.458096796728)
107992 45360 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 458 Victoria St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/2003 12:00:00 AM     Permit Number 46747 5993277.37926203 2090218.01876098 37.718954793548605 -122.46526098645 (37.7189547935486, -122.46526098645)
108311 47453 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 5049 Anza St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM     Permit Number 45359 5983034.2663237 2111680.83899779 37.7772897229163 -122.502254315782 (37.7772897229163, -122.502254315782)
110211 31168 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 570 Ramsell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/21/1995 12:00:00 AM     Permit Number 34869 5993027.58275469 2090995.29108117 37.7210745862886 -122.466180882741 (37.7210745862886, -122.466180882741)
110567 51442 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 775 Andover St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/19/2004 12:00:00 AM     Permit Number 47761 6007380.25742092 2095203.71769531 37.7334476580973 -122.41686576869301 (37.7334476580973, -122.416865768693)
110762 68097 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 49 Bessie St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 04/26/1993 12:00:00 AM     Permit Number 31842 6008240.85722104 2100065.07433688 37.746844244689605 -122.414234251858 (37.7468442446896, -122.414234251858)
113922 50423 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 75 Granada Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2003 12:00:00 AM     Permit Number 47076 5995600.08487961 2090390.5729411999 37.7195622602365 -122.45724482931699 (37.7195622602365, -122.457244829317)
115167 47225 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1643 Felton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/09/2002 12:00:00 AM     Permit Number 45170 6006193.94874397 2092417.83045771 37.7257314225765 -122.42076946999399 (37.7257314225765, -122.420769469994)
115428 36089 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1706 Great Hwy 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/01/2002 12:00:00 AM     Permit Number 44997 5981032.08177403 2103436.82774177 37.754536221771204 -122.508568229446 (37.7545362217712, -122.508568229446)
115918 34621 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 370 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2016 12:00:00 AM 3   Permit Number 778228 6003497.10528776 2099542.95496323 37.7451430220882 -122.430600441889 (37.7451430220882, -122.430600441889)
117463 46381 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2495 43rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM     Permit Number 44618 5983000.42559938 2098163.19803029 37.740172110361705 -122.501371213543 (37.7401721103617, -122.501371213543)
119851 34725 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 114 Sutro Heights Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM     Permit Number 38379 5981286.97907127 2111325.91865707 37.776212402307 -122.508272287748 (37.776212402307, -122.508272287748)
121341 46382 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2495 43rd Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM     Permit Number 44618 5983000.42559938 2098163.19803029 37.740172110361705 -122.501371213543 (37.7401721103617, -122.501371213543)
122120 36328 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 40 Eastwood Dr 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/22/1998 12:00:00 AM     Permit Number 39300 5995640.5044713 2092769.77027097 37.7260972907371 -122.457277138944 (37.7260972907371, -122.457277138944)
123140 40483 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 165 Margaret Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/15/1999 12:00:00 AM     Permit Number 41562 5996732.70371963 2089259.1130924 37.716520521088796 -122.45324815845699 (37.7165205210888, -122.453248158457)
123652 45430 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 851 Head St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/13/2001 12:00:00 AM     Permit Number 44219 5993920.58856776 2091576.5612161 37.72272209583179 -122.463136201451 (37.7227220958318, -122.463136201451)
126023 40449 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 255 Ellsworth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/06/2003 12:00:00 AM     Permit Number 47061 6008102.60669454 2097399.44811028 37.7395172589666 -122.414523716357 (37.7395172589666, -122.414523716357)
126240 31667 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2571 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/12/1995 12:00:00 AM     Permit Number 35175 5981777.56166178 2097600.02639588 37.7385539042174 -122.505557573977 (37.7385539042174, -122.505557573977)
126667 50289 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 300 Valley St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797933998 37.744430384839504 -122.42903293346001 (37.7444303848395, -122.42903293346)
127237 50114 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1252 Ulloa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/29/2003 12:00:00 AM     Permit Number 46839 5992244.12505327 2098460.15223335 37.7415260004029 -122.469432140867 (37.7415260004029, -122.469432140867)
127692 63441 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 299 Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/1997 12:00:00 AM     Permit Number 24028 6008993.82853707 2096920.83270323 37.738253113659 -122.411408443517 (37.738253113659, -122.411408443517)
128740 69291 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 830 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/09/1994 12:00:00 AM     Permit Number 33363 5991479.92264349 2102518.55863113 37.752625141975706 -122.472370253301 (37.7526251419757, -122.472370253301)
128843 47111 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 189 Bonview St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/03/2002 12:00:00 AM 6 3x3 Permit Number 45095 6007076.38254046 2097931.15674799 37.740919506174706 -122.41810964654499 (37.7409195061747, -122.418109646545)
129606 80358 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 336 Campbell Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/03/2002 12:00:00 AM 3     6011201.39619 2088230.4496900002 37.714514695375705 -122.403164591892 (37.7145146953757, -122.403164591892)
133901 51414 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1531 25th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/14/2004 12:00:00 AM 0   Permit Number 47738 5988357.88494646 2104888.81015522 37.7589520258954 -122.48334041038 (37.7589520258954, -122.48334041038)
139074 63714 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 220 Precita Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 11/22/1997 12:00:00 AM     Permit Number 24378 6007857.54148412 2100263.37846132 37.7473672046192 -122.41557376317499 (37.7473672046192, -122.415573763175)
140587 31580 DPW Maintained 3 Leptospermum laevigatum :: Australian Tea Tree 38 1841 23rd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/10/1995 12:00:00 AM     Permit Number 35119 5989049.89925793 2102807.07383274 37.75327638601021 -122.48079472188999 (37.7532763860102, -122.48079472189)
141290 48774 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 629 Crescent Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/20/2004 12:00:00 AM     Permit Number 47773 6007825.24973386 2095718.75627166 37.7348868619711 -122.415363748684 (37.7348868619711, -122.415363748684)
142094 109138 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 759 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773583 5985365.401319999 2110729.9835 37.7748156320332 -122.49412018624099 (37.7748156320332, -122.494120186241)
143225 47963 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 558 Melrose Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/05/2002 12:00:00 AM     Permit Number 45693 5996827.75466141 2095403.22069376 37.73339623393571 -122.453362951949 (37.7333962339357, -122.453362951949)
143336 58925 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 3925 Kirkham St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/1994 12:00:00 AM     Permit Number 18201 5982715.08927534 2104886.86517056 37.7586166666309 -122.502855377053 (37.7586166666309, -122.502855377053)
143583 34718 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 626 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/28/1997 12:00:00 AM     Permit Number 38373 5981358.16274912 2111480.6327423 37.7766413961782 -122.508037533581 (37.7766413961782, -122.508037533581)
145098 68368 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 194 Cayuga Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/30/1993 12:00:00 AM     Permit Number 32189 6002712.41508002 2094283.54436078 37.730657406687 -122.432938086411 (37.730657406687, -122.432938086411)
145101 50291 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 300 Valley St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/28/2003 12:00:00 AM   3x3   6003944.88624926 2099274.1797933998 37.744430384839504 -122.42903293346001 (37.7444303848395, -122.42903293346)
145200 109133 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 774 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/29/2015 12:00:00 AM 3 3x3 Permit Number 773526 5985442.4 2110611.6 37.7744950899459 -122.493845109753 (37.7744950899459, -122.493845109753)
145765 68315 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 3820 Quintara St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/09/1993 12:00:00 AM     Permit Number 32128 5981623.22584135 2100818.01716678 37.7473805290726 -122.506329747472 (37.7473805290726, -122.506329747472)
150971 52086 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 550 44th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/19/2005 12:00:00 AM 7   Permit Number 48283 5982264.87127 2112012.82882 37.7781560348973 -122.50494046388201 (37.7781560348973, -122.504940463882)
154916 37082 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1268 45th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/15/2002 12:00:00 AM 6   Permit Number 44549 5982146.28824129 2106471.58463776 37.762934408685396 -122.504939947841 (37.7629344086854, -122.504939947841)
155355 32594 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1379 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/22/1996 12:00:00 AM 1   Permit Number 37062 5985531.05347187 2105840.85496484 37.76140115330671 -122.49318691517 (37.7614011533067, -122.49318691517)
158119 46395 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2091 46th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 9   Permit Number 44627 5981974.76389525 2100876.77542895 37.74756255280229 -122.505118527994 (37.7475625528023, -122.505118527994)
159182 78557 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2234 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/2016 12:00:00 AM 3   Permit Number 771299 5981748.2661 2099861.5988 37.7447618317919 -122.505826480334 (37.7447618317919, -122.505826480334)
160532 38367 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 4245 Lawton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1999 12:00:00 AM 5   Permit Number 41159 5981126.11155374 2104152.1959616 37.7565059606627 -122.508296152224 (37.7565059606627, -122.508296152224)
167106 47850 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 1342 41st Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/14/2002 12:00:00 AM 7   Permit Number 45609 5983405.04544412 2106002.56953842 37.7617206013965 -122.50055173019501 (37.7617206013965, -122.500551730195)
173361 46399 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 2110 47th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/05/2002 12:00:00 AM 5   Permit Number 44629 5981721.80383178 2100709.75793181 37.7470890826019 -122.505980852245 (37.7470890826019, -122.505980852245)
178121 47450 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38 5049 Anza St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/14/2002 12:00:00 AM 7   Permit Number 45359 5982925.588409999 2111676.1494 37.7772704608477 -122.502629914355 (37.7772704608477, -122.502629914355)
188897 84120 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 336 Campbell Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/24/2006 12:00:00 AM 6     6011186.92342 2088226.0732 37.7145018701492 -122.403214308206 (37.7145018701492, -122.403214308206)
103 117428 Permitted Site 1 Leptospermum laevigatum :: Australian Tea Tree 38   2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/14/2016 12:00:00 AM 3   Permit Number 776915          
1699 237552 Undocumented 2 Leptospermum laevigatum :: Australian Tea Tree 38 102 Hancock St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/30/2017 12:00:00 AM 3 Width 3ft Permit Number 779869 6003566.97457 2105097.88602 37.7603995118464 -122.430755182518 (37.7603995118464, -122.430755182518)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 95.87ms · Data source: data.sfgov.org