Data source: data.sfgov.org
This data as json, CSV (advanced)
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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) |
JSON shape: default, array, newline-delimited
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");