trees

7,157 rows where qSpecies_id = 36 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
24959 98573 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 11 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
25271 92213 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3001 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2009 12:00:00 AM   3x3 Permit Number 52643 5999733.7 2116663.4 37.7919375385156 -122.444844029888 (37.7919375385156, -122.444844029888) 13 6 1 29490 27
25327 46668 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1340 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/19/2002 12:00:00 AM     Permit Number 44797 5991479.72631887 2106292.04540428 37.7629861303814 -122.472646033385 (37.7629861303814, -122.472646033385) 1 8 11 56 12
25468 63164 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1543 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/17/1986 12:00:00 AM     Permit Number 23701 5992730.2589462 2104961.69256792 37.7594056385467 -122.468224124164 (37.7594056385467, -122.468224124164) 1 8 4 56 12
25761 33837 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3943 26th St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/22/1997 12:00:00 AM     Permit Number 37851 6004250.30927987 2100701.51542662 37.7483668024919 -122.428078539782 (37.7483668024919, -122.428078539782) 2 4 5 63 22
26057 46250 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1675 Hawes St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM     Permit Number 44536 6016787.6752368 2092188.79463336 37.7256939401069 -122.384131467798 (37.7256939401069, -122.384131467798) 10 3 8 58 1
26244 256808 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1098x Geary St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
26420 44445 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 41 Toyon Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM     Permit Number 43775 6003205.02185069 2086565.08055066 37.7094921393696 -122.430684496452 (37.7094921393696, -122.430684496452) 9 7 6 28861 5
27110 56263 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 275 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/1973 12:00:00 AM     Permit Number 12389 5997442.16701528 2106406.61050088 37.7636440286356 -122.452032368392 (37.7636440286356, -122.452032368392) 15 5 11 29492 9
27272 173641 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 657 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012793 2114089 37.7856054636163 -122.399477673173 (37.7856054636163, -122.399477673173) 6 2 9 28853 6
27385 54905 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 294 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/19/1972 12:00:00 AM   5.5x6 Permit Number 10771 5996797.86843618 2107029.63432639 37.7653177662624 -122.454305788489 (37.7653177662624, -122.454305788489) 15 5 11 29492 12
27909 51596 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 130 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2005 12:00:00 AM     Permit Number 47889 5999316.0541876 2107729.2257987 37.7673827567962 -122.445646320311 (37.7673827567962, -122.445646320311) 15 5 11 29492 9
28250 49442 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2900 22nd St 5 Sidewalk: Curb side : Cutout Tree Private 2   03/28/2003 12:00:00 AM   3x3 Permit Number 46377 6008885.40306298 2103350.58196767 37.7559016970239 -122.412237638681 (37.7559016970239, -122.412237638681) 2 4 7 28859 19
28793 33717 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 165 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1996 12:00:00 AM     Permit Number 37785 6003482.53929351 2108775.34571812 37.7704921421212 -122.431309715576 (37.7704921421212, -122.431309715576) 15 9 11 29492 10
28978 37162 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3555 Cesar Chavez St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/08/1998 12:00:00 AM     Permit Number 39738 6006329.64997303 2100518.61882542 37.7479820345383 -122.420875232711 (37.7479820345383, -122.420875232711) 2 4 7 28859 2
28986 97431 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1696@ Newhall St McKinnon Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014941.5 2096322.6 37.7369422906262 -122.390802367297 (37.7369422906262, -122.390802367297) 10 3 8 58 1
29090 95725 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 845 Brazil Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/07/2011 12:00:00 AM   3x3 Permit Number 767472 6004159.7 2090885 37.7214077415573 -122.427692550789 (37.7214077415573, -122.427692550789) 9 7 6 28861 5
29869 52309 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 4724GRANDVIEW 25th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/2005 12:00:00 AM     Permit Number 48469 6000284.59344425 2101117.41576557 37.7492835968612 -122.441821697928 (37.7492835968612, -122.441821697928) 2 4 5 28862 22
29939 30471 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 535 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/29/1956 12:00:00 AM     Permit Number 116 6010391.91073115 2119560.70154745 37.8004953099758 -122.408170826336 (37.8004953099758, -122.408170826336) 3 1 10 308 23
30000 92217 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3001 Pacific Ave 8 Sidewalk: Curb side : Cutout Tree Private 2   07/17/2009 12:00:00 AM   3x3 Permit Number 52643 5999733.7 2116663.4 37.7919375385156 -122.444844029888 (37.7919375385156, -122.444844029888) 13 6 1 29490 27
30378 110304 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3735 BUCHANAN ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002991 2121133 37.8043952513031 -122.433893386438 (37.8043952513031, -122.433893386438) 13 9 1 57 17
31390 47024 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 551 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/23/2002 12:00:00 AM     Permit Number 46001 6003934.98038847 2109705.23960301 37.7730710340161 -122.429811056053 (37.7730710340161, -122.429811056053) 7 9 11 29492 10
31699 52697 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1432 PARNASSUS 05th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/2006 12:00:00 AM     Permit Number 48764 5994614.33996039 2105771.86549765 37.7617387994959 -122.46176684024 (37.7617387994959, -122.46176684024) 15 5 11 56 12
32108 46588 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 49 Hill St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/05/2002 12:00:00 AM     Permit Number 44716 6006035.26319977 2103432.55413529 37.7559664326554 -122.422100192673 (37.7559664326554, -122.422100192673) 2 4 5 28859 19
32168 97432 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1696@ Newhall St McKinnon Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014941.5 2096322.6 37.7369422906262 -122.390802367297 (37.7369422906262, -122.390802367297) 10 3 8 58 1
32517 46827 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 503 Excelsior Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/25/2002 12:00:00 AM     Permit Number 44904 6003640.3820222 2091980.16396675 37.7243854297654 -122.429565753929 (37.7243854297654, -122.429565753929) 9 7 6 28861 5
32792 49723 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1300@ REVERE Griffith St 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446) 10 3 8 58 1
33070 97928 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 275 Grattan St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/31/1973 12:00:00 AM     Permit Number 12389 5997436 2106416 37.7636694565674 -122.452054375547 (37.7636694565674, -122.452054375547) 15 5 11 29492 9
33121 65464 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 118 Ashton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1989 12:00:00 AM     Permit Number 28342 5994182.95740399 2090714.30483177 37.7203696579549 -122.462166753245 (37.7203696579549, -122.462166753245) 9 8 6 28861 24
33609 98909 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 501X Shotwell St 1 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
34081 30398 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2800 Turk St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1956 12:00:00 AM     Permit Number 66 5997681.665837 2111673.48633421 37.7781192320704 -122.451583952943 (37.7781192320704, -122.451583952943) 15 6 2 54 16
34120 58949 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 91 Harper St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/31/1980 12:00:00 AM   3x3 Permit Number 50911 6003609.463337 2097799.84135396 37.7403631988963 -122.43008760169 (37.7403631988963, -122.43008760169) 2 7 5 63 7
34331 37333 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 700 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39840 6003021.44463533 2104165.68333023 37.7578089842605 -122.432575328482 (37.7578089842605, -122.432575328482) 2 4 5 28862 3
35675 105864 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 5 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
35781 256056 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 418 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010297 2120665 37.8035221265997 -122.408577200527 (37.8035221265997, -122.408577200527) 3 1 10 308 23
38036 66620 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2670 22nd St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/02/2008 12:00:00 AM   3x3 Permit Number 51134 6010115.86602004 2103418.5070285 37.7561571717357 -122.407987065665 (37.7561571717357, -122.407987065665) 2 4 7 28859 19
38649 30390 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2800 Turk St 22 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1956 12:00:00 AM     Permit Number 66 5997681.665837 2111673.48633421 37.7781192320704 -122.451583952943 (37.7781192320704, -122.451583952943) 15 6 2 54 16
38747 40873 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3456 Washington St 7 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1999 12:00:00 AM     Permit Number 41788 5998239.16759035 2115871.78992415 37.7896785829725 -122.449958017829 (37.7896785829725, -122.449958017829) 13 6 1 54 31
39024 256835 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1201x Franklin St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
39197 118321 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 557 03RD AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994963 2111751 37.7781759995674 -122.460994353515 (37.7781759995674, -122.460994353515) 11 6 2 54 11
39324 107135 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 38 08th St   Sidewalk: Curb side : Cutout Tree Private 2   07/31/2014 12:00:00 AM   3x3 Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
39366 98015 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1561@21st Ave Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988339.7 2098919.1 37.7425597372021 -122.482965774008 (37.7425597372021, -122.482965774008) 1 8 3 29491 35
39386 50841 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1871 Hayes St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/2004 12:00:00 AM     Permit Number 47358 5998915.90678898 2110046.56932775 37.7737227395784 -122.447197166031 (37.7737227395784, -122.447197166031) 15 5 11 29492 16
40392 49801 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1314 South Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/11/2003 12:00:00 AM   3x3 Permit Number 46595 6007674.4763735 2101992.27281083 37.7521040666078 -122.416329227522 (37.7521040666078, -122.416329227522) 2 4 7 28859 19
40417 253553 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2763 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2       4X4   6007078.6273 2102287.5862 37.7528814055888 -122.418410705424 (37.7528814055888, -122.418410705424) 2 4 7 28859 19
40444 40871 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3456 Washington St 9 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1999 12:00:00 AM     Permit Number 41788 5998239.16759035 2115871.78992415 37.7896785829725 -122.449958017829 (37.7896785829725, -122.449958017829) 13 6 1 54 31
40528 47330 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 242 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2002 12:00:00 AM     Permit Number 45261 5994763.5780735 2090205.44685868 37.719005869189 -122.460122904553 (37.719005869189, -122.460122904553) 9 8 6 28861 24
40765 32225 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 196 Riley Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/1995 12:00:00 AM     Permit Number 35544 5995435.34413163 2120227.18780964 37.8014764801815 -122.45997454226 (37.8014764801815, -122.45997454226) 11   1 61 30
40988 256790 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 199x Cedar St 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
41027 113738 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 15 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
41455 109491 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1315 PINE ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007628 2115744 37.789860448493 -122.417464454457 (37.789860448493, -122.417464454457) 13 1 10 28858 21
41487 98013 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1535 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/12/1987 12:00:00 AM     Permit Number 24638 5988477 2098970 37.7427074834674 -122.482494765439 (37.7427074834674, -122.482494765439) 1 8 3 29491 35
41899 106286 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1600X Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2           6007107 2116756 37.7926098218975 -122.419338891627 (37.7926098218975, -122.419338891627) 5 9 10 28858 32
41952 45558 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 631 07th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/24/2001 12:00:00 AM     Permit Number 44306 5993757.287623 2111198.20088201 37.7765887076598 -122.465125156838 (37.7765887076598, -122.465125156838) 11 6 2 54 11
42428 37409 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 301 Clipper St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39889 6003208.12169915 2100936.51274949 37.7489530306424 -122.431699173329 (37.7489530306424, -122.431699173329) 2 4 5 28862 22
42636 93199 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 748 CLAYTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2       7x9   5998625.2 2107963.2 37.7679857237315 -122.448052727493 (37.7679857237315, -122.448052727493) 15 5 11 29492 9
42668 101190 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 300 Irving St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5994863 2106716 37.764345459457 -122.460975263176 (37.764345459457, -122.460975263176) 15 5 11 56 12
42788 87800 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 225 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50552 6003750 2109140 37.7715085476448 -122.430410589394 (37.7715085476448, -122.430410589394) 15 9 11 29492 10
42851 113727 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 4 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
43085 31420 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 4052 21st St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/01/1995 12:00:00 AM     Permit Number 35006 6001951.47636685 2103555.31466959 37.7560723237915 -122.436232037881 (37.7560723237915, -122.436232037881) 2 4 5 28862 3
43176 94649 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 363 30th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/22/2010 12:00:00 AM   3x3 Permit Number 53787 6004189 2098364 37.7419450553656 -122.428123987508 (37.7419450553656, -122.428123987508) 2 7 5 63 7
43314 37567 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 4406 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40002 6001744.86990875 2104124.02927541 37.7576221359597 -122.436987264882 (37.7576221359597, -122.436987264882) 2 4 5 28862 3
43381 104682 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 4 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
43439 107915 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 40X Carmel St 3 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5998867.83001 2105402.91503 37.7609696909735 -122.447029231618 (37.7609696909735, -122.447029231618) 15 5 11 29492 12
43633 46452 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 988 Fulton St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/14/2002 12:00:00 AM     Permit Number 44663 6003039.93601639 2111368.51212752 37.77758724287 -122.433025981227 (37.77758724287, -122.433025981227) 15 9 11 29492 41
44560 42722 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1790 Yosemite Ave 13 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/2000 12:00:00 AM     Permit Number 42732 6013616.31802888 2093434.69648512 37.7289390851959 -122.395181915037 (37.7289390851959, -122.395181915037) 10 3 8 58 1
44740 30404 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2800 Turk St 10 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1956 12:00:00 AM     Permit Number 66 5997681.665837 2111673.48633421 37.7781192320704 -122.451583952943 (37.7781192320704, -122.451583952943) 15 6 2 54 16
45336 84022 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 4243 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/29/2008 12:00:00 AM   3x3 Permit Number 50505 6002293.79060162 2101178.89811159 37.7495666934434 -122.434878261178 (37.7495666934434, -122.434878261178) 2 4 5 28862 22
45384 33766 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 310 Magellan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   12/23/1996 12:00:00 AM     Permit Number 37816 5994334.89031031 2100058.38542597 37.7460349532135 -122.462318932902 (37.7460349532135, -122.462318932902) 1 8 4 29491 40
45410 36115 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1226 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/29/1998 12:00:00 AM     Permit Number 39212 5991452.81371882 2107068.83835934 37.7651174387305 -122.472795757205 (37.7651174387305, -122.472795757205) 11 8 11 56 12
45705 63970 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 427 Jersey St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/19/1987 12:00:00 AM       6002374.96532989 2101475.67318166 37.750386176039 -122.434618774806 (37.750386176039, -122.434618774806) 2 4 5 28862 22
45802 46737 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1 Sargent St 4 Sidewalk: Curb side : Cutout Tree Private 2   04/24/2002 12:00:00 AM     Permit Number 44847 5994017.67630199 2089152.6927279 37.7160723272597 -122.46262485198 (37.7160723272597, -122.46262485198) 9 8 6 64 24
45959 113293 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1626 PIERCE ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002154 2114089 37.7850067228559 -122.436285471088 (37.7850067228559, -122.436285471088) 13 6 11 29490 13
46010 41100 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 519 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/10/1999 12:00:00 AM     Permit Number 41847 5998900.19465733 2108958.89301628 37.770735360026 -122.447173222473 (37.770735360026, -122.447173222473) 15 5 11 29492 9
46029 43373 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 410 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43122 6001780.55436365 2103444.50870534 37.7557583646153 -122.436815210583 (37.7557583646153, -122.436815210583) 2 4 5 28862 22
46045 30393 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2800 Turk St 19 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1956 12:00:00 AM     Permit Number 66 5997681.665837 2111673.48633421 37.7781192320704 -122.451583952943 (37.7781192320704, -122.451583952943) 15 6 2 54 16
46074 39608 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 40X Carmel St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/29/1998 12:00:00 AM   4x4 Permit Number 41011 5998720.01537421 2105405.17907901 37.7609674612338 -122.447540618719 (37.7609674612338, -122.447540618719) 15 5 11 29492 12
46454 97864 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 895 Indiana St 11 Sidewalk: Property side : Cutout Tree Private 2           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978) 10 3 8 28856 29
46500 46448 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 988 Fulton St 5 Sidewalk: Curb side : Cutout Tree Private 2   02/14/2002 12:00:00 AM     Permit Number 44663 6003039.93601639 2111368.51212752 37.77758724287 -122.433025981227 (37.77758724287, -122.433025981227) 15 9 11 29492 41
46563 61038 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 233 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/02/2008 12:00:00 AM   3x3 Permit Number 50553 6003740.22262264 2109194.37057661 37.7716572821034 -122.430448289878 (37.7716572821034, -122.430448289878) 15 9 11 29492 10
47325 104683 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 5 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
47641 35015 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 47 Fair Oaks St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/24/1997 12:00:00 AM     Permit Number 38587 6005404.86941948 2103441.39072556 37.7559551202516 -122.424280933156 (37.7559551202516, -122.424280933156) 2 4 5 28859 19
47784 98579 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 301X Francisco St 17 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6009861.3 2121227.6 37.8050424754696 -122.410124709263 (37.8050424754696, -122.410124709263) 3 1 10 308 23
47808 254769 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 94X Natoma St 5 Sidewalk: Curb side : Cutout Tree Private 2       2x2   6013036.36382 2114723.48466 37.7873611724179 -122.398680241201 (37.7873611724179, -122.398680241201) 12 2 9 28855 6
47883 109990 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 501X Shotwell St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14 DPW     3x3   6007873.2 2105005.6 37.7603891478182 -122.415855367022 (37.7603891478182, -122.415855367022) 2 4 7 28859 19
48208 46710 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1302 Willard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/24/2002 12:00:00 AM     Permit Number 44840 5996796.89477309 2106986.36474823 37.7651989032411 -122.454306030419 (37.7651989032411, -122.454306030419) 15 5 11 29492 12
48264 110607 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1181 GREEN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   6007369 2118756 37.7981160762917 -122.418574247636 (37.7981160762917, -122.418574247636) 5 1 10 28858 32
48380 36884 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2610 Jackson St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/26/1998 12:00:00 AM     Permit Number 39541 6001692.79590827 2116681.16611668 37.7920979283339 -122.43806683477 (37.7920979283339, -122.43806683477) 13 6 1 29490 27
48394 256801 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1098x Geary St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
48418 48515 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1(REVISED) Church St 8 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45844 6004110.55275805 2108703.1215343 37.7703294028669 -122.429132262601 (37.7703294028669, -122.429132262601) 7 9 5 29492 10
48443 253457 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1710 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/06/2012 12:00:00 AM   0   6006684.5156 2108433.1634 37.7697335330848 -122.420209748815 (37.7697335330848, -122.420209748815) 8 4 7 28853 19
48743 253145 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 801X Santiago St 1 Side Yard : Yard Tree Private 2           5990274 2099728 37.7448931297685 -122.476336677657 (37.7448931297685, -122.476336677657) 1 8 3 29491 35
49166 47772 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1700 McKinnon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/2002 12:00:00 AM     Permit Number 45550 6014858.18965719 2096344.09030254 37.7369966758652 -122.391091912235 (37.7369966758652, -122.391091912235) 10 3 8 58 1
49225 53968 Planning Code 138.1 required 2 Pittosporum undulatum :: Victorian Box 36 1354 24th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/20/2015 12:00:00 AM   3x3 Permit Number 773113 5988678.33594659 2106104.92629407 37.7623097958053 -122.482321255458 (37.7623097958053, -122.482321255458) 1 8 3 56 35
49261 97810 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 901 Pine St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 33299 6009614 2116053 37.7908204311206 -122.410614878669 (37.7908204311206, -122.410614878669) 5 1 10 28857 21
49605 94362 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 507 11th Ave   Sidewalk: Curb side : Cutout Tree Private 2   07/21/2010 12:00:00 AM   3x3 Permit Number 53636 5992474.9 2111972.9 37.7786417900192 -122.469617677573 (37.7786417900192, -122.469617677573) 11 6 2 54 11
50054 97868 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 895 Indiana St 15 Sidewalk: Property side : Cutout Tree Private 2           6014975.4 2104402.3 37.7591293333254 -122.391249777978 (37.7591293333254, -122.391249777978) 10 3 8 28856 29
50350 48996 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 179 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/29/2003 12:00:00 AM     Permit Number 46859 5992717.47131078 2097513.94028533 37.7389552850694 -122.467726685378 (37.7389552850694, -122.467726685378) 1 8 4 59 40
50776 35405 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 206 Day St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/02/2008 12:00:00 AM   3x3 Permit Number 50565 6004580.90644064 2098724.42919099 37.7429568773749 -122.426794562995 (37.7429568773749, -122.426794562995) 2 7 5 63 22
50826 30385 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2800 Turk St 18 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1956 12:00:00 AM     Permit Number 66 5997681.665837 2111673.48633421 37.7781192320704 -122.451583952943 (37.7781192320704, -122.451583952943) 15 6 2 54 16

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