443 rows where qSpecies_id = 32 sorted by qCareAssistant

View and edit SQL

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)
57 230549 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 39 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/2020 12:00:00 AM 3 Width 3ft Permit Number 787877 6005359.28388 2095944.60166 37.7353680760624 -122.423905517743 (37.7353680760624, -122.423905517743) 2 7 7 28859 2
613 161126 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 485 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001694.7774 2090903.55181 37.721318940793 -122.436214417168 (37.721318940793, -122.436214417168) 9 7 6 28861 5
922 91748 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 3 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008877.354104 2103306.550106 37.7557803438331 -122.412262362741 (37.7557803438331, -122.412262362741) 2 4 7 28859 19
1087 233496 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 60 Yukon St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6000227.44313 2104506.90628 37.7585870568739 -122.442262614226 (37.7585870568739, -122.442262614226) 2 4 5 28862 3
1405 96265 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2776 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/19/2011 12:00:00 AM     Permit Number 767311 6004841.3 2119075.5 37.798850712467 -122.427343605274 (37.798850712467, -122.427343605274) 13 9 1 57 17
2706 211314 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1950 08th Ave 3 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5993864.84081 2102208.58731 37.7519117832189 -122.464100354143 (37.7519117832189, -122.464100354143) 1 8 4 29491 12
2751 32002 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2652 Union St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/13/1995 12:00:00 AM   5x5 Permit Number 35399 6000302.11365106 2118206.59769697 37.7962071755692 -122.442988194102 (37.7962071755692, -122.442988194102) 13 9 1 57 17
2889 211318 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 355 Staples Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   5997726.4515 2093787.92348 37.7290124835257 -122.450139532341 (37.7290124835257, -122.450139532341) 9 7 4 28861 40
3069 233426 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2197 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008801.72689 2105503.58115 37.7618086469759 -122.412679216788 (37.7618086469759, -122.412679216788) 8 4 7 28859 19
3388 261119 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2067 Bancroft Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 5x5   6011786.16554 2094038.32843 37.730494584078 -122.401551330673 (37.730494584078, -122.401551330673) 10 3 8 58 1
3506 161128 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 485 London St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6001711.00806 2090931.14538 37.7213956286903 -122.436160286079 (37.7213956286903, -122.436160286079) 9 7 6 28861 5
4051 260659 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
4192 264915 Private 9 Pistacia chinensis :: Chinese Pistache 32 1461 Revere Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   11/09/2020 12:00:00 AM 3 3x3 Permit Number 784397 6015819.34366 2093828.22518 37.7301419060949 -122.387593270969 (37.7301419060949, -122.387593270969) 10 3 8 58 1
4937 132212 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2654 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6000265.26964 2118199.18789 37.7961847294893 -122.443115149071 (37.7961847294893, -122.443115149071) 13 9 1 57 17
5052 139847 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 829 Golden Gate Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005684.1962 2112380.729 37.7805161769301 -122.423950581978 (37.7805161769301, -122.423950581978) 7 9 11 28852 41
6112 233465 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2460 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008820.36078 2104131.22912 37.7580415272211 -122.41251775699 (37.7580415272211, -122.41251775699) 2 4 7 28859 19
6345 175597 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 650 London St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 2ft   6001092.21629 2090034.68248 37.7188989677059 -122.438235084102 (37.7188989677059, -122.438235084102) 9 7 6 28861 5
6458 211310 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1645 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   5993991.2178 2104316.50873 37.7577068768914 -122.46381631408 (37.7577068768914, -122.46381631408) 1 5 4 56 12
7104 9470 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 800X Golden Gate Ave 26 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/15/2005 12:00:00 AM 3 3X3   6005716.3316921 2112434.9405022 37.7806668426278 -122.423843265886 (37.7806668426278, -122.423843265886) 7 9 11 28852 41
7122 194543 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 184 Hooper St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6012559.7859 2107618.88108 37.7678269955571 -122.399830043335 (37.7678269955571, -122.399830043335) 14 3 8 28856 20
8498 233506 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1941 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008710.79759 2107246.55273 37.7665893413473 -122.413116956406 (37.7665893413473, -122.413116956406) 8 4 7 28853 19
8550 260661 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
8831 233416 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2601 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008962 2103248 37.7556243278629 -122.411965491523 (37.7556243278629, -122.411965491523) 2 4 7 28859 19
9107 264723 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 335 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/18/2020 12:00:00 AM 3 4x4 Permit Number 782646 6008658.96802 2100212.34216 37.7472720863526 -122.412798868954 (37.7472720863526, -122.412798868954) 2 7 7 28859 2
9356 260660 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
9475 163463 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 109 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/24/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995872.36784 2087580.2575 37.7118614273349 -122.456100577893 (37.7118614273349, -122.456100577893) 9 8 6 28861 24
10091 163462 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995871.2375 2087597.30845 37.7119081803938 -122.45610571662 (37.7119081803938, -122.45610571662) 9 8 6 28861 24
10307 233401 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3025 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6008031.26632 2103842.02923 37.7572031342345 -122.415226318935 (37.7572031342345, -122.415226318935) 2 4 7 28859 19
10399 161129 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 485 London St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 0ft   6001722.11588 2090948.37155 37.7214435589648 -122.436123121581 (37.7214435589648, -122.436123121581) 9 7 6 28861 5
10542 233492 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 416 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6001776.45872 2103391.52743 37.7556126580189 -122.436825582043 (37.7556126580189, -122.436825582043) 2 4 5 28862 22
10598 91743 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2708 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008911.299202 2102677.621362 37.7540553520509 -122.412100523216 (37.7540553520509, -122.412100523216) 2 4 7 28859 19
10685 233450 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3050 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009002.96054 2100768.18815 37.7488176180461 -122.411648631477 (37.7488176180461, -122.411648631477) 2 4 7 28859 19
10817 233461 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     0 Width 3ft   6008869.1508 2103187.08693 37.7554518646255 -122.41228228931 (37.7554518646255, -122.41228228931) 2 4 7 28859 19
10960 166315 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
11175 233468 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2355 Harrison St 11 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008789.90434 2104591.00964 37.7593022705969 -122.412655591576 (37.7593022705969, -122.412655591576) 2 4 7 28859 19
11621 171168 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 61 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6004706.69577 2093156.0367 37.7276744353238 -122.425963318556 (37.7276744353238, -122.425963318556) 9 7 6 28861 5
11691 233464 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2905 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008837.85782 2103822.74046 37.7571954693154 -122.412435439344 (37.7571954693154, -122.412435439344) 2 4 7 28859 19
12003 166317 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008865.69274 2103234.56357 37.755582030708 -122.412297603862 (37.755582030708, -122.412297603862) 2 4 7 28859 19
12121 11883 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 400X Keith St 3 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6017703.73127 2096843.30561 37.7385249167977 -122.381288201801 (37.7385249167977, -122.381288201801) 10 3 8 58 1
12761 261857 Private 9 Pistacia chinensis :: Chinese Pistache 32 176 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/2020 12:00:00 AM 3     5992988.80812 2088380.73889 37.7138934199028 -122.466125014283 (37.7138934199028, -122.466125014283) 9 8 6 64 24
13031 261121 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 80 Vesta St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 5x5                      
13269 211313 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2331 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5992606.24128 2099598.30232 37.7446719916245 -122.468262856359 (37.7446719916245, -122.468262856359) 1 8 4 29491 40
13489 160999 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 265 Munich St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 0 Width 0ft   6004550.61216 2090876.91947 37.7214076589281 -122.426340700176 (37.7214076589281, -122.426340700176) 9 7 6 28861 5
14763 97267 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2050X Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/24/2012 12:00:00 AM 2 3x3 Permit Number 769192 5999912.27224 2116008.29642 37.7901489853223 -122.444179075813 (37.7901489853223, -122.444179075813) 13 6 1 29490 27
14913 233381 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 399x Tompkins Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 2ft   6008152.13666 2096545.8865 37.7371763483116 -122.414292086129 (37.7371763483116, -122.414292086129) 2 7 7 28859 2
14931 132217 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2860 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5999261.04653 2118404.81755 37.7966920235835 -122.446604753326 (37.7966920235835, -122.446604753326) 13 9 1 57 17
15217 161127 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 485 London St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2019 12:00:00 AM 3 Width 0ft   6001702.30852 2090917.36085 37.7213572852021 -122.436189371961 (37.7213572852021, -122.436189371961) 9 7 6 28861 5
15232 233458 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2652 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008875.8887 2103056.30656 37.7550931493426 -122.412249744651 (37.7550931493426, -122.412249744651) 2 4 7 28859 19
15538 233362 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 154 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6006411.92043 2106982.43417 37.7657348109283 -122.421049627935 (37.7657348109283, -122.421049627935) 8 4 7 28853 19
15836 199688 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2000 Jennings St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6015592.0163 2092881.2495 37.7275291054366 -122.388313110838 (37.7275291054366, -122.388313110838) 10 3 8 58 1
16103 247814 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 532 30th St 1 : Tree Private 2     5 Width 3ft   6003126.49354 2098351.09832 37.7418494576778 -122.431796869036 (37.7418494576778, -122.431796869036) 2 7 5 63 22
16166 166316 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008870.16891 2103155.64589 37.7553655917605 -122.412276546247 (37.7553655917605, -122.412276546247) 2 4 7 28859 19
16610 211317 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 45 Linares Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5993928.12229 2102221.55917 37.7519510476114 -122.463882461023 (37.7519510476114, -122.463882461023) 1 8 4 29491 12
16867 233369 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3698 24th St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6005236.6856 2101975.24545 37.7519199283811 -122.424758271091 (37.7519199283811, -122.424758271091) 2 4 5 28859 19
17190 233382 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 399x Tompkins Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 2ft   6008169.60603 2096545.72694 37.7371768914874 -122.414231675074 (37.7371768914874, -122.414231675074) 2 7 7 28859 2
17374 163460 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995870.33981 2087649.24929 37.7120507463226 -122.45611257216 (37.7120507463226, -122.45611257216) 9 8 6 28861 24
17446 9465 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 800X Golden Gate Ave 21 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/10/2007 12:00:00 AM 6 3X3   6005716.3316921 2112434.9405022 37.7806668426278 -122.423843265886 (37.7806668426278, -122.423843265886) 7 9 11 28852 41
17511 260658 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
17666 52759 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 22 Gaven St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/06/2014 12:00:00 AM 3   Permit Number 774111 6010286.03762 2095339.86575 37.7339845095792 -122.406829209621 (37.7339845095792, -122.406829209621) 10 3 7 309 28
17779 233482 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1830 Harrison St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6008616.65718 2107731.28246 37.7679150113072 -122.413476857889 (37.7679150113072, -122.413476857889) 8 4 7 28853 19
18435 261120 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2901 Jennings St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2019 12:00:00 AM 3 5x5                      
18441 260662 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2 Varela Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   10/03/2019 12:00:00 AM 3 3x6   5990178.30137 2091110.96603 37.7212273981358 -122.476038353928 (37.7212273981358, -122.476038353928) 1 8 4 64 14
18592 111041 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2700X Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6004870.73043 2118877.40927 37.7983084704282 -122.427227648441 (37.7983084704282, -122.427227648441) 13 9 1 57 17
18610 259660 Planning Code 138.1 required 2 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 5 Sidewalk: Curb side : Cutout Tree Private 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
19222 22826 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 84 Turquoise Way 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/02/2015 02:48:00 PM 3 3x3   5999343.3761 2099052.93009 37.743561341476 -122.444928046502 (37.743561341476, -122.444928046502) 2 7 5 63 7
19586 194533 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2200 Alameda St 9 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6010348.85424 2107885.73513 37.7684362115906 -122.40749624758 (37.7684362115906, -122.40749624758) 8 4 8 28853 19
19607 163461 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 115 Plymouth Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/10/2020 12:00:00 AM 3 3x3 Permit Number 774886 5995870.30801 2087623.97935 37.7119813591246 -122.456110856234 (37.7119813591246, -122.456110856234) 9 8 6 28861 24
21704 233429 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2101 Harrison St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6008762.87625 2106190.29183 37.7636920162083 -122.412862138879 (37.7636920162083, -122.412862138879) 8 4 7 28859 19
21910 96514 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2525 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/16/2011 12:00:00 AM 3 3x3   6008931.78407 2103601.217 37.7565924865992 -122.412094949605 (37.7565924865992, -122.412094949605) 2 4 7 28859 19
21926 194544 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 184 Hooper St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 4ft   6012545.36949 2107606.50724 37.7677922160651 -122.399879039311 (37.7677922160651, -122.399879039311) 14 3 8 28856 20
22493 233394 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 271 Shotwell St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6007790.53489 2106496.52663 37.7644782394947 -122.416246865994 (37.7644782394947, -122.416246865994) 8 4 7 28859 19
22785 233411 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2709 Harrison St 1 Sidewalk: Curb side : Yard Tree Private 2     2 Width 8ft   6008945.30625 2102700.68655 37.754120591896 -122.411984548072 (37.754120591896, -122.411984548072) 2 4 7 28859 19
23623 233402 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3025 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6008058.99429 2103844.13337 37.7572104700033 -122.415130573511 (37.7572104700033, -122.415130573511) 2 4 7 28859 19
23719 132215 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2860 Filbert St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5999237.1134 2118402.93591 37.7966854900001 -122.446687431602 (37.7966854900001, -122.446687431602) 13 9 1 57 17
23779 233442 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 95 Montezuma St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6007954.1776 2099786.14211 37.7460622517822 -122.415205824295 (37.7460622517822, -122.415205824295) 2 7 7 28859 2
23903 107340 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 300X EUGENIA AVE 1 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2014 12:00:00 AM 3 3x3 Permit Number 773835 6006696 2098030 37.7411694904711 -122.419431881915 (37.7411694904711, -122.419431881915) 2 7 7 28859 2
24832 9460 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 800X Golden Gate Ave 16 Sidewalk: Curb side : Cutout Tree DPW 1   02/17/1998 12:00:00 AM 6 3X3   6005350.8775 2112393.4845 37.7805323769118 -122.425104597895 (37.7805323769118, -122.425104597895) 7 9 11 28852 41
25550 211315 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1950 08th Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 3ft   5993849.45223 2102159.58974 37.7517763614982 -122.464150012924 (37.7517763614982, -122.464150012924) 1 8 4 29491 12
26016 233380 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 397 Park St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 2ft   6007405.88509 2096272.27203 37.7363831156735 -122.416852845398 (37.7363831156735, -122.416852845398) 2 7 7 28859 2
26149 29650 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1500X La Salle Ave 9 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015718.9286 2096019.8862 37.7361542039988 -122.388093308135 (37.7361542039988, -122.388093308135) 10 3 8 58 1
26635 26526 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2789 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   09/30/2011 12:00:00 AM 3 3x3   6009007 2102243 37.7528673485866 -122.411738857609 (37.7528673485866, -122.411738857609) 2 4 7 28859 19
26684 194530 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 616 Carolina St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 6ft   6012360.41946 2105070.75065 37.7608192812075 -122.400340636111 (37.7608192812075, -122.400340636111) 10 3 8 28856 29
26805 139841 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 855 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005489.2243 2112352.6717 37.7804281291994 -122.424623086227 (37.7804281291994, -122.424623086227) 7 9 11 28852 41
27892 9514 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 1024 Golden Gate Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2005 12:00:00 AM 3 3X3   6004658.34921 2112287.36137 37.7802018438259 -122.427492819652 (37.7802018438259, -122.427492819652) 7 9 11 29490 41
28365 233483 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1830 Harrison St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008612.51284 2107745.14575 37.7679528439771 -122.413492173322 (37.7679528439771, -122.413492173322) 8 4 7 28853 19
28716 233494 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 885 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6003128.49899 2103230.63077 37.7552476232057 -122.432138316435 (37.7552476232057, -122.432138316435) 2 4 5 28862 22
28926 233410 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2727 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6008964.10696 2102573.01039 37.7537710766793 -122.41191050868 (37.7537710766793, -122.41191050868) 2 4 7 28859 19
30388 91747 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2600 Harrison St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008877.354104 2103306.550106 37.7557803438331 -122.412262362741 (37.7557803438331, -122.412262362741) 2 4 7 28859 19
30722 91760 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2190X Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008735.241541 2105700.534049 37.7623457027108 -122.412923089625 (37.7623457027108, -122.412923089625) 8 4 7 28859 19
30724 200624 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1382 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6016324.8756 2094912.2277 37.7331463494491 -122.385921096754 (37.7331463494491, -122.385921096754) 10 3 8 58 1
31941 91751 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2660 Harrison St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008895.550687 2102970.363593 37.7548582726151 -122.412175673836 (37.7548582726151, -122.412175673836) 2 4 7 28859 19
32774 233361 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 28 Camp St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/30/2017 12:00:00 AM 3 Width 3ft   6005734.12152 2106385.89097 37.7640586131313 -122.423351580335 (37.7640586131313, -122.423351580335) 8 4 5 28859 19
33947 91831 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1817X Harrison St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008669.779404 2108251.243793 37.7693456867114 -122.41332988852 (37.7693456867114, -122.41332988852) 8 4 7 28853 19
34806 91741 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 2844 Harrison St   Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 3 3x3   6008953.436672 2101893.072239 37.7519035204675 -122.411899364623 (37.7519035204675, -122.411899364623) 2 4 7 28859 19
34960 115370 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 481 Anderson St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 773523 6007887 2096619.6 37.7373638523191 -122.415214003631 (37.7373638523191, -122.415214003631) 2 7 7 28859 2
35068 233485 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1812 Harrison St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6008609.33505 2107860.39921 37.7682691247363 -122.413511317219 (37.7682691247363, -122.413511317219) 8 4 7 28853 19
36402 16950 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 630 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003955.1515 2110112.5344 37.7741905079368 -122.429770337641 (37.7741905079368, -122.429770337641) 7 9 11 29492 10
36781 29649 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 1500X La Salle Ave 8 Median : Cutout Tree DPW 1   04/07/2006 12:00:00 AM 3 12x31   6015738.3943 2096009.2115 37.7361259719003 -122.388025261983 (37.7361259719003, -122.388025261983) 10 3 8 58 1
37190 233448 DPW Maintained 1 Pistacia chinensis :: Chinese Pistache 32 3250 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008442.79349 2104490.88845 37.7590078730361 -122.41384899104 (37.7590078730361, -122.41384899104) 2 4 7 28859 19
37442 87929 Permitted Site 7 Pistacia chinensis :: Chinese Pistache 32 2801x 16TH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   06/18/2008 12:00:00 AM   3x3 Permit Number 50953 6008059 2106775 37.7652579548966 -122.415338031053 (37.7652579548966, -122.415338031053) 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)
);