Street_Tree_List

Data source: data.sfgov.org

818 rows where qSpecies = 30 sorted by qAddress

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize

Link rowid TreeID qLegalStatus qSpecies qAddress ▼ SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
184634 227630 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 10 Arbor St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 2ft   6002176.820309999 2096986.40745 37.7380484541639 -122.43498294671998 (37.7380484541639, -122.43498294672)
171489 176938 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 10 Lois Ln 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 2ft   6012264.960419999 2087928.82829 37.7137458424772 -122.39946729997101 (37.7137458424772, -122.399467299971)
92160 39928 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 100 Arleta Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1999 12:00:00 AM     Permit Number 41199 6010702.15739083 2087798.94554582 37.7133019788898 -122.404859809077 (37.7133019788898, -122.404859809077)
105518 39927 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 100 Arleta Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/25/1999 12:00:00 AM     Permit Number 41199 6010702.15739083 2087798.94554582 37.7133019788898 -122.404859809077 (37.7133019788898, -122.404859809077)
108210 122590 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 100 MacOndray Ln 1 Unaccepted Street : Yard 14 Tree 1 Private 1           6008161.0 2119143.0 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147)
37575 176976 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 100 Winding Way 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6002487.993290001 2086859.8664400002 37.710260908397395 -122.433183714473 (37.7102609083974, -122.433183714473)
64273 176978 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 100 Winding Way 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6002453.716630001 2086834.19677 37.7101884805901 -122.433300348445 (37.7101884805901, -122.433300348445)
152536 176979 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 100 Winding Way 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6002427.23589 2086817.03836 37.7101398650242 -122.433390645786 (37.7101398650242, -122.433390645786)
181896 176977 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 100 Winding Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 5ft   6002472.369080001 2086850.07188 37.710233128335396 -122.433237015483 (37.7102331283354, -122.433237015483)
5887 94203 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1000 Green St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/25/2010 12:00:00 AM 6 3x3 Permit Number 53605 6008148.35783 2118956.03523 37.7987091687558 -122.415891605907 (37.7987091687558, -122.415891605907)
94707 94202 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1000 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   06/25/2010 12:00:00 AM 6 3x3 Permit Number 53605 6008232.0 2118962.0 37.798730248485896 -122.415602598872 (37.7987302484859, -122.415602598872)
156039 31965 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1000 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3   Permit Number 35367 6008195.50256 2118963.54127 37.7987324288073 -122.41572900131099 (37.7987324288073, -122.415729001311)
35287 35365 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1000 Rhode Island St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/23/1998 12:00:00 AM 7   Permit Number 38825 6011873.18705 2103679.58539 37.7569722674636 -122.401927970125 (37.7569722674636, -122.401927970125)
55006 35364 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1000 Rhode Island St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/23/1998 12:00:00 AM 7   Permit Number 38825 6011875.91601 2103641.3243400003 37.7568673633546 -122.401915842767 (37.7568673633546, -122.401915842767)
57481 35363 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1000 Rhode Island St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/23/1998 12:00:00 AM 5   Permit Number 38825 6011873.19867 2103659.8662799997 37.7569181237816 -122.401926543791 (37.7569181237816, -122.401926543791)
29861 227623 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1001 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 4ft   6001957.40527 2101134.69618 37.7494262207603 -122.43603832812599 (37.7494262207603, -122.436038328126)
105384 55357 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1001 Diamond St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   11/01/1972 12:00:00 AM     Permit Number 11290 6001956.10378782 2101177.25372795 37.749542999745 -122.436045873593 (37.749542999745, -122.436045873593)
73740 200018 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1008 Revere Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 0ft   6018250.1161 2092086.6599 37.7254942451327 -122.37906877917801 (37.7254942451327, -122.379068779178)
155800 53889 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1009 Goettingen St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/10/1972 12:00:00 AM 6   Permit Number 9600 6011157.21659 2090045.52637 37.7194960599821 -122.403444914172 (37.7194960599821, -122.403444914172)
70158 98192 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1020 Green St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 3x3   6008091.62981 2118948.72517 37.7986859077751 -122.41608738562799 (37.7986859077751, -122.416087385628)
94438 41525 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1034 Innes Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/20/2000 12:00:00 AM     Permit Number 42065 6018447.62591186 2095068.89236301 37.733693765900604 -122.37859297315 (37.7336937659006, -122.37859297315)
175672 191260 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1058 De Haro St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 4ft   6012165.085 2103460.39568 37.7563867072014 -122.400903071241 (37.7563867072014, -122.400903071241)
16227 7404 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1060 Folsom St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2   05/28/1992 12:00:00 AM 24 3X3   6010543.2443 2111181.3457 37.777496075538004 -122.407056190657 (37.777496075538, -122.407056190657)
123726 35235 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1077 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/17/1998 12:00:00 AM 6   Permit Number 38732 6007771.26508 2119552.1201 37.8003246614186 -122.417238733675 (37.8003246614186, -122.417238733675)
162454 227640 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1098 22nd St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 3ft   6006270.9018 2103197.69782 37.7553348592182 -122.421268598461 (37.7553348592182, -122.421268598461)
169093 176928 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 110 Hester Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6012745.689669999 2087817.6299700001 37.713467297259996 -122.397797917233 (37.71346729726, -122.397797917233)
182528 176929 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 110 Hester Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 2ft   6012755.76956 2087791.93581 37.7133973075252 -122.397761276185 (37.7133973075252, -122.397761276185)
161451 227601 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1100 San Jose Ave 48 Sidewalk: Property side : Yard 9 Tree 1 Private 1     13     6004769.19859 2096667.0685 37.7373184762576 -122.425997076417 (37.7373184762576, -122.425997076417)
28729 191333 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1108 04th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6014865.84277 2110042.3598599997 37.7746096212801 -122.392023095184 (37.7746096212801, -122.392023095184)
60304 191330 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1108 04th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 5ft   6014815.79386 2110104.2477700002 37.7747767728644 -122.392200554832 (37.7747767728644, -122.392200554832)
73709 191332 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1108 04th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6014847.27565 2110066.45331 37.774674745668996 -122.392089008326 (37.774674745669, -122.392089008326)
154442 191335 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1108 04th St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6014898.40719 2110003.75259 37.774505422222 -122.391907747266 (37.774505422222, -122.391907747266)
155061 191334 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1108 04th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 Width 5ft   6014881.31548 2110022.28226 37.7745553516884 -122.391968167293 (37.7745553516884, -122.391968167293)
179838 191331 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1108 04th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 5ft   6014830.54088 2110082.99883 37.77471924682621 -122.392148055082 (37.7747192468262, -122.392148055082)
111793 93854 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1109 Moraga St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/09/2010 12:00:00 AM   3x3 Permit Number 53359 5990875.0 2103807.0 37.7561278331456 -122.47455618324601 (37.7561278331456, -122.474556183246)
26163 247176 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 111 Buena Vista Ave East 1 : 4 Tree 1 Private 1     5 Width 4ft   6001288.35672 2108578.65763 37.7698274924813 -122.438885293015 (37.7698274924813, -122.438885293015)
95736 31792 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 111 Buena Vista East Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1995 12:00:00 AM     Permit Number 35262 6001241.81019665 2108627.72464151 37.7699595699392 -122.439049813001 (37.7699595699392, -122.439049813001)
186507 227658 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 111 States St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6001589.01566 2106181.9491 37.763263822894295 -122.437673651738 (37.7632638228943, -122.437673651738)
62217 250619 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 114 28th Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5987113.722030001 2115192.60557 37.7871708695801 -122.48840049988002 (37.7871708695801, -122.48840049988)
102328 34270 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 114 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1997 12:00:00 AM     Permit Number 38072 5987122.50109111 2115231.37554308 37.7872778329962 -122.48837297696699 (37.7872778329962, -122.488372976967)
106270 34269 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 114 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1997 12:00:00 AM     Permit Number 38072 5987122.50109111 2115231.37554308 37.7872778329962 -122.48837297696699 (37.7872778329962, -122.488372976967)
154559 250620 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 114 28th Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     4 Width 4ft   5987116.07946 2115204.5954 37.7872039277514 -122.48839322528099 (37.7872039277514, -122.488393225281)
54446 129451 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1147 Filbert St 1 Sidewalk: Curb side : Pot 10 Tree 1 Private 1     9 Width 3ft   6007395.89235 2119499.90916 37.80016017810029 -122.418533970572 (37.8001601781003, -122.418533970572)
46688 207094 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 115 Kenwood Way 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   5994559.61163 2093655.1393099998 37.728466159762505 -122.46107783977101 (37.7284661597625, -122.461077839771)
69654 227617 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 115 Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 2ft   6009080.60999 2097991.13845 37.7411968070922 -122.411183978775 (37.7411968070922, -122.411183978775)
116693 37466 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 115 Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/19/1998 12:00:00 AM     Permit Number 39937 6009086.92753477 2097969.49395992 37.7411377303504 -122.411160606325 (37.7411377303504, -122.411160606325)
185179 61519 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1161 Filbert St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/20/1984 12:00:00 AM 7   Permit Number 21475 6007368.68612 2119491.86468 37.8001365583177 -122.418627544125 (37.8001365583177, -122.418627544125)
162971 227657 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 117 States St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 3ft   6001570.048769999 2106180.8326 37.7632596788053 -122.437739171852 (37.7632596788053, -122.437739171852)
73208 49756 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1171 Goettingen St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/04/2003 12:00:00 AM 1   Permit Number 46552 6011373.3818 2089351.75942 37.71760318852571 -122.40264894398899 (37.7176031885257, -122.402648943989)
102904 34272 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 118 28th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1997 12:00:00 AM     Permit Number 38073 5987121.09736721 2115203.94287654 37.7872024288867 -122.48837581666099 (37.7872024288867, -122.488375816661)
143244 34271 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 118 28th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 07/14/1997 12:00:00 AM     Permit Number 38073 5987121.09736721 2115203.94287654 37.7872024288867 -122.48837581666099 (37.7872024288867, -122.488375816661)
111098 50485 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 118 Lee Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/29/2003 12:00:00 AM     Permit Number 47121 5996542.39678919 2090678.14826944 37.720405949717104 -122.45400837564699 (37.7204059497171, -122.454008375647)
184290 227618 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 119 Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 2ft   6009077.3937800005 2097965.31988 37.7411257345706 -122.411193275964 (37.7411257345706, -122.411193275964)
42869 129448 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1190 Pine St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6008230.449580001 2115909.44994 37.79034861235171 -122.415391745646 (37.7903486123517, -122.415391745646)
54469 57397 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1190 Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/02/1976 12:00:00 AM 11   Permit Number 16237 6008290.06558 2115917.44184 37.7903739066804 -122.41518604372601 (37.7903739066804, -122.415186043726)
64750 129447 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1190 Pine St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008246.65377 2115911.69756 37.7903556945065 -122.41533583927799 (37.7903556945065, -122.415335839278)
189130 227619 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1193 Shotwell St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6008092.35309 2100991.6752 37.7493801403813 -122.414813334067 (37.7493801403813, -122.414813334067)
87075 52479 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 119POWHATTAN Nevada St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/28/2005 12:00:00 AM     Permit Number 48589 6009084.88956475 2097947.60140706 37.7410775038925 -122.411166106845 (37.7410775038925, -122.411166106845)
74356 186817 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1200 Sunset Blvd 110 Sidewalk: Property side : Yard 9 Tree 1 Private 1     2 Width 0ft   5984826.8059 2106810.865 37.7640233139964 -122.49569412937599 (37.7640233139964, -122.495694129376)
26504 227603 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1201 San Jose Ave 55 Front Yard : Yard 7 Tree 1 Private 1     2     6004504.07862 2096101.1879099999 37.735749708773795 -122.42687342978998 (37.7357497087738, -122.42687342979)
44798 227608 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1201 San Jose Ave 73 Front Yard : Yard 7 Tree 1 Private 1     3     6004572.06439 2096162.43718 37.7359217292935 -122.426642736581 (37.7359217292935, -122.426642736581)
54300 227606 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1201 San Jose Ave 60 Front Yard : Yard 7 Tree 1 Private 1     3     6004509.90475 2096122.13365 37.7358075504724 -122.426854777822 (37.7358075504724, -122.426854777822)
165842 227605 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1201 San Jose Ave 58 Front Yard : Yard 7 Tree 1 Private 1     2     6004504.61589 2096121.06345 37.735804312902204 -122.426872987299 (37.7358043129022, -122.426872987299)
166757 227604 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1201 San Jose Ave 57 Front Yard : Yard 7 Tree 1 Private 1     4     6004502.9106 2096117.99556 37.7357957927473 -122.426878664735 (37.7357957927473, -122.426878664735)
184269 227602 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1201 San Jose Ave 54 Front Yard : Yard 7 Tree 1 Private 1     1     6004494.61967 2096104.27773 37.735757657887994 -122.426906353066 (37.735757657888, -122.426906353066)
184382 227607 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1201 San Jose Ave 61 Front Yard : Yard 7 Tree 1 Private 1     2     6004513.177130001 2096122.0643 37.735807545078295 -122.426843458979 (37.7358075450783, -122.426843458979)
159965 176962 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 121 Saint Charles Ave 1 : 4 Tree 1 Private 1     12 Width 2ft   5992069.06615 2087619.0428799998 37.71174887986621 -122.46924855110301 (37.7117488798662, -122.469248551103)
93936 32892 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1235 07th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 09/01/2016 12:00:00 AM 3 3x3 Permit Number 778801 5993897.25914467 2107077.09548698 37.7652813146396 -122.464341682773 (37.7652813146396, -122.464341682773)
60958 48733 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1235 30th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   09/25/2002 12:00:00 AM 2   Permit Number 46013 5986739.234 2106838.4777 37.764210939174106 -122.489081723593 (37.7642109391741, -122.489081723593)
164170 62984 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1235 37th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 01/06/1994 12:00:00 AM 7   Permit Number 33034 5984571.8482 2106766.3839 37.7638862475145 -122.496572656852 (37.7638862475145, -122.496572656852)
55812 50231 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1255 29th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/27/2003 12:00:00 AM 8   Permit Number 46939 5987056.8298 2106727.188 37.7639239004312 -122.487975087347 (37.7639239004312, -122.487975087347)
134902 181607 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1255 29th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft   5987053.8771 2106742.5422 37.7639658865787 -122.487986427971 (37.7639658865787, -122.487986427971)
152638 129450 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1257 Lombard St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 6ft   6006338.43207 2120038.90392 37.8015805322681 -122.42223151426799 (37.8015805322681, -122.422231514268)
138266 109806 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1264 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/03/2015 12:00:00 AM 3 3x3 Permit Number 775061 5992117.2 2106823.9 37.764483341532 -122.47047998805401 (37.764483341532, -122.470479988054)
168739 207051 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1264 Funston Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5992092.816880001 2106815.43538 37.764458690039 -122.47056370526899 (37.764458690039, -122.470563705269)
29311 199962 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1265 Griffith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 Width 0ft   6018011.0370000005 2092725.2017 37.7272343718441 -122.379939611903 (37.7272343718441, -122.379939611903)
49816 207050 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1287 17th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5990781.88485 2106644.27108 37.7639128285243 -122.475085316637 (37.7639128285243, -122.475085316637)
170818 227612 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1299 York St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6010076.057159999 2101688.5205599996 37.7514047850101 -122.40800274303601 (37.7514047850101, -122.408002743036)
157041 199935 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1310 Griffith St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   6017874.9241 2092620.1152 37.726938315047896 -122.380402857754 (37.7269383150479, -122.380402857754)
74170 129446 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1329 Washington St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft   6008344.2402 2117236.00141 37.7939973921104 -122.415091973713 (37.7939973921104, -122.415091973713)
155958 227621 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1335 Douglass St 5 Sidewalk: Property side : Yard 9 Tree 1 Private 1     5 Width 4ft   6001398.3282 2099807.1524799997 37.7457493236871 -122.43787655407499 (37.7457493236871, -122.437876554075)
176691 75284 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1335 Griffith St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/13/1998 12:00:00 AM 3     6017835.3471 2092484.583 37.7265639860027 -122.380530259866 (37.7265639860027, -122.380530259866)
27806 129444 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1338 Clay St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6008418.059880001 2116953.62618 37.793226207275794 -122.414816555443 (37.7932262072758, -122.414816555443)
97690 48988 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/06/2002 12:00:00 AM     Permit Number 46175 6005014.67029629 2099626.41666977 37.7454580443014 -122.42535889959998 (37.7454580443014, -122.4253588996)
170771 227615 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 28th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 4ft   6005000.954919999 2099622.04361 37.7454452619845 -122.42540601408001 (37.7454452619845, -122.42540601408)
28952 176968 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 Craut St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004019.9865 2094083.3714700001 37.7301818557853 -122.428403350153 (37.7301818557853, -122.428403350153)
59805 176969 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 Craut St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft   6004020.786 2094067.71187 37.7301389032718 -122.428399470475 (37.7301389032718, -122.428399470475)
150746 176967 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 Craut St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   6004019.42662 2094104.5358400003 37.7302399367234 -122.428406793639 (37.7302399367234, -122.428406793639)
52098 207062 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 Taraval St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993034.65386 2099189.08337 37.7435731145127 -122.46675176060499 (37.7435731145127, -122.466751760605)
67199 207064 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 Taraval St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993028.0499599995 2099189.22218 37.743573114522206 -122.466774605159 (37.7435731145222, -122.466774605159)
178142 207065 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 Taraval St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993024.9505900005 2099189.6741400003 37.743574176615894 -122.46678535477301 (37.7435741766159, -122.466785354773)
183793 207061 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 Taraval St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     1 Width 3ft   5993037.74509 2099188.24411 37.7435709885186 -122.466741010989 (37.7435709885186, -122.466741010989)
186485 207063 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 134 Taraval St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 3ft   5993031.18209 2099190.3171200003 37.7435763017135 -122.46676385469401 (37.7435763017135, -122.466763854694)
164682 37224 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1340 34th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 06/12/1998 12:00:00 AM 5   Permit Number 39788 5985571.0917 2106094.9849 37.7621012650414 -122.49306716261101 (37.7621012650414, -122.493067162611)
49002 97113 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1345 Noriega St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4   Permit Number 18860 5989785.9448 2103084.5073 37.7540808992005 -122.478269637351 (37.7540808992005, -122.478269637351)
2850 27607 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1377 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6001133.4058 2111053.0447 37.7766127217509 -122.439598674592 (37.7766127217509, -122.439598674592)
6797 27608 DPW Maintained 3 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1377 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 DPW 2     3 3X3   6001149.4313 2111053.53 37.776614966343296 -122.439543272646 (37.7766149663433, -122.439543272646)
83118 38678 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1377 Fulton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/02/1998 12:00:00 AM     Permit Number 40596 6001182.75800309 2111056.33200795 37.776624556634495 -122.439428187036 (37.7766245566345, -122.439428187036)
122986 38679 Permitted Site 1 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1377 Fulton St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/02/1998 12:00:00 AM     Permit Number 40596 6001182.75800309 2111056.33200795 37.776624556634495 -122.439428187036 (37.7766245566345, -122.439428187036)
173778 71255 Undocumented 2 Laurus nobilis :: Sweet Bay: Grecian Laurel 30 1392 Pacific Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 08/19/1995 12:00:00 AM 1     6007494.44606 2117816.87319 37.795544530015604 -122.418073553678 (37.7955445300156, -122.418073553678)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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