sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
184634 227630 2 30 10 Arbor St 2 1 1 1     5 Width 2ft   6002176.820309999 2096986.40745 37.7380484541639 -122.43498294671998 (37.7380484541639, -122.43498294672)
171489 176938 2 30 10 Lois Ln 1 1 1 1     11 Width 2ft   6012264.960419999 2087928.82829 37.7137458424772 -122.39946729997101 (37.7137458424772, -122.399467299971)
92160 39928 1 30 100 Arleta Ave 2 1 1 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 1 30 100 Arleta Ave 1 1 1 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 2 30 100 MacOndray Ln 1 14 1 1           6008161.0 2119143.0 37.7992232381339 -122.415861106147 (37.7992232381339, -122.415861106147)
37575 176976 2 30 100 Winding Way 1 1 1 1     1 Width 5ft   6002487.993290001 2086859.8664400002 37.710260908397395 -122.433183714473 (37.7102609083974, -122.433183714473)
64273 176978 2 30 100 Winding Way 3 1 1 1     1 Width 5ft   6002453.716630001 2086834.19677 37.7101884805901 -122.433300348445 (37.7101884805901, -122.433300348445)
152536 176979 2 30 100 Winding Way 4 1 1 1     1 Width 5ft   6002427.23589 2086817.03836 37.7101398650242 -122.433390645786 (37.7101398650242, -122.433390645786)
181896 176977 2 30 100 Winding Way 2 1 1 1     1 Width 5ft   6002472.369080001 2086850.07188 37.710233128335396 -122.433237015483 (37.7102331283354, -122.433237015483)
5887 94203 1 30 1000 Green St 2 1 1 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 1 30 1000 Green St 1 1 1 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 1 30 1000 Green St 1 1 1 1     3   Permit Number 35367 6008195.50256 2118963.54127 37.7987324288073 -122.41572900131099 (37.7987324288073, -122.415729001311)
35287 35365 1 30 1000 Rhode Island St 1 1 1 1 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 1 30 1000 Rhode Island St 3 1 1 1 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 1 30 1000 Rhode Island St 2 1 1 1 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 2 30 1001 Diamond St 1 1 1 1     12 Width 4ft   6001957.40527 2101134.69618 37.7494262207603 -122.43603832812599 (37.7494262207603, -122.436038328126)
105384 55357 1 30 1001 Diamond St 1 1 1 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 2 30 1008 Revere Ave 1 1 1 1     1 Width 0ft   6018250.1161 2092086.6599 37.7254942451327 -122.37906877917801 (37.7254942451327, -122.379068779178)
155800 53889 1 30 1009 Goettingen St 1 1 1 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 2 30 1020 Green St 1 1 1 1     15 3x3   6008091.62981 2118948.72517 37.7986859077751 -122.41608738562799 (37.7986859077751, -122.416087385628)
94438 41525 1 30 1034 Innes Ave 1 1 1 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 2 30 1058 De Haro St 1 1 1 1     3 Width 4ft   6012165.085 2103460.39568 37.7563867072014 -122.400903071241 (37.7563867072014, -122.400903071241)
16227 7404 3 30 1060 Folsom St 1 1 1 2   05/28/1992 12:00:00 AM 24 3X3   6010543.2443 2111181.3457 37.777496075538004 -122.407056190657 (37.777496075538, -122.407056190657)
123726 35235 1 30 1077 Filbert St 1 1 1 1 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 2 30 1098 22nd St 2 1 1 1     5 Width 3ft   6006270.9018 2103197.69782 37.7553348592182 -122.421268598461 (37.7553348592182, -122.421268598461)
169093 176928 2 30 110 Hester Ave 1 1 1 1     4 Width 2ft   6012745.689669999 2087817.6299700001 37.713467297259996 -122.397797917233 (37.71346729726, -122.397797917233)
182528 176929 2 30 110 Hester Ave 2 1 1 1     4 Width 2ft   6012755.76956 2087791.93581 37.7133973075252 -122.397761276185 (37.7133973075252, -122.397761276185)
161451 227601 2 30 1100 San Jose Ave 48 9 1 1     13     6004769.19859 2096667.0685 37.7373184762576 -122.425997076417 (37.7373184762576, -122.425997076417)
28729 191333 2 30 1108 04th St 4 1 1 1     5 Width 5ft   6014865.84277 2110042.3598599997 37.7746096212801 -122.392023095184 (37.7746096212801, -122.392023095184)
60304 191330 2 30 1108 04th St 1 1 1 1     2 Width 5ft   6014815.79386 2110104.2477700002 37.7747767728644 -122.392200554832 (37.7747767728644, -122.392200554832)
73709 191332 2 30 1108 04th St 3 1 1 1     4 Width 5ft   6014847.27565 2110066.45331 37.774674745668996 -122.392089008326 (37.774674745669, -122.392089008326)
154442 191335 2 30 1108 04th St 6 1 1 1     5 Width 5ft   6014898.40719 2110003.75259 37.774505422222 -122.391907747266 (37.774505422222, -122.391907747266)
155061 191334 2 30 1108 04th St 5 1 1 1     5 Width 5ft   6014881.31548 2110022.28226 37.7745553516884 -122.391968167293 (37.7745553516884, -122.391968167293)
179838 191331 2 30 1108 04th St 2 1 1 1     4 Width 5ft   6014830.54088 2110082.99883 37.77471924682621 -122.392148055082 (37.7747192468262, -122.392148055082)
111793 93854 1 30 1109 Moraga St 1 1 1 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 2 30 111 Buena Vista Ave East 1 4 1 1     5 Width 4ft   6001288.35672 2108578.65763 37.7698274924813 -122.438885293015 (37.7698274924813, -122.438885293015)
95736 31792 1 30 111 Buena Vista East Ave 1 1 1 1 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 2 30 111 States St 1 1 1 1     10 Width 3ft   6001589.01566 2106181.9491 37.763263822894295 -122.437673651738 (37.7632638228943, -122.437673651738)
62217 250619 2 30 114 28th Ave 1 2 1 1     4 Width 4ft   5987113.722030001 2115192.60557 37.7871708695801 -122.48840049988002 (37.7871708695801, -122.48840049988)
102328 34270 1 30 114 28th Ave 1 1 1 1 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 1 30 114 28th Ave 2 1 1 1 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 2 30 114 28th Ave 2 2 1 1     4 Width 4ft   5987116.07946 2115204.5954 37.7872039277514 -122.48839322528099 (37.7872039277514, -122.488393225281)
54446 129451 2 30 1147 Filbert St 1 10 1 1     9 Width 3ft   6007395.89235 2119499.90916 37.80016017810029 -122.418533970572 (37.8001601781003, -122.418533970572)
46688 207094 2 30 115 Kenwood Way 2 1 1 1     3 Width 3ft   5994559.61163 2093655.1393099998 37.728466159762505 -122.46107783977101 (37.7284661597625, -122.461077839771)
69654 227617 2 30 115 Nevada St 1 1 1 1     10 Width 2ft   6009080.60999 2097991.13845 37.7411968070922 -122.411183978775 (37.7411968070922, -122.411183978775)
116693 37466 1 30 115 Nevada St 1 1 1 1 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 1 30 1161 Filbert St 1 1 1 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 2 30 117 States St 1 1 1 1     12 Width 3ft   6001570.048769999 2106180.8326 37.7632596788053 -122.437739171852 (37.7632596788053, -122.437739171852)
73208 49756 1 30 1171 Goettingen St 1 1 1 1 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 1 30 118 28th Ave 2 1 1 1 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 1 30 118 28th Ave 1 1 1 1 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 1 30 118 Lee Ave 1 1 1 1 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 2 30 119 Nevada St 1 1 1 1     7 Width 2ft   6009077.3937800005 2097965.31988 37.7411257345706 -122.411193275964 (37.7411257345706, -122.411193275964)
42869 129448 2 30 1190 Pine St 3 1 1 1     10 Width 3ft   6008230.449580001 2115909.44994 37.79034861235171 -122.415391745646 (37.7903486123517, -122.415391745646)
54469 57397 1 30 1190 Pine St 1 1 1 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 2 30 1190 Pine St 2 1 1 1     8 Width 3ft   6008246.65377 2115911.69756 37.7903556945065 -122.41533583927799 (37.7903556945065, -122.415335839278)
189130 227619 2 30 1193 Shotwell St 1 1 1 1     3 Width 3ft   6008092.35309 2100991.6752 37.7493801403813 -122.414813334067 (37.7493801403813, -122.414813334067)
87075 52479 1 30 119POWHATTAN Nevada St 1 1 1 1 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 2 30 1200 Sunset Blvd 110 9 1 1     2 Width 0ft   5984826.8059 2106810.865 37.7640233139964 -122.49569412937599 (37.7640233139964, -122.495694129376)
26504 227603 2 30 1201 San Jose Ave 55 7 1 1     2     6004504.07862 2096101.1879099999 37.735749708773795 -122.42687342978998 (37.7357497087738, -122.42687342979)
44798 227608 2 30 1201 San Jose Ave 73 7 1 1     3     6004572.06439 2096162.43718 37.7359217292935 -122.426642736581 (37.7359217292935, -122.426642736581)
54300 227606 2 30 1201 San Jose Ave 60 7 1 1     3     6004509.90475 2096122.13365 37.7358075504724 -122.426854777822 (37.7358075504724, -122.426854777822)
165842 227605 2 30 1201 San Jose Ave 58 7 1 1     2     6004504.61589 2096121.06345 37.735804312902204 -122.426872987299 (37.7358043129022, -122.426872987299)
166757 227604 2 30 1201 San Jose Ave 57 7 1 1     4     6004502.9106 2096117.99556 37.7357957927473 -122.426878664735 (37.7357957927473, -122.426878664735)
184269 227602 2 30 1201 San Jose Ave 54 7 1 1     1     6004494.61967 2096104.27773 37.735757657887994 -122.426906353066 (37.735757657888, -122.426906353066)
184382 227607 2 30 1201 San Jose Ave 61 7 1 1     2     6004513.177130001 2096122.0643 37.735807545078295 -122.426843458979 (37.7358075450783, -122.426843458979)
159965 176962 2 30 121 Saint Charles Ave 1 4 1 1     12 Width 2ft   5992069.06615 2087619.0428799998 37.71174887986621 -122.46924855110301 (37.7117488798662, -122.469248551103)
93936 32892 1 30 1235 07th Ave 1 1 1 1 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 1 30 1235 30th Ave 1 1 1 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 1 30 1235 37th Ave 1 1 1 1 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 1 30 1255 29th Ave 2 1 1 1 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 2 30 1255 29th Ave 1 1 1 1     7 Width 0ft   5987053.8771 2106742.5422 37.7639658865787 -122.487986427971 (37.7639658865787, -122.487986427971)
152638 129450 2 30 1257 Lombard St 1 1 1 1     15 Width 6ft   6006338.43207 2120038.90392 37.8015805322681 -122.42223151426799 (37.8015805322681, -122.422231514268)
138266 109806 1 30 1264 Funston Ave 1 1 1 1 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 2 30 1264 Funston Ave 1 1 1 1     1 Width 3ft   5992092.816880001 2106815.43538 37.764458690039 -122.47056370526899 (37.764458690039, -122.470563705269)
29311 199962 2 30 1265 Griffith St 1 1 1 1     4 Width 0ft   6018011.0370000005 2092725.2017 37.7272343718441 -122.379939611903 (37.7272343718441, -122.379939611903)
49816 207050 2 30 1287 17th Ave 1 1 1 1     2 Width 3ft   5990781.88485 2106644.27108 37.7639128285243 -122.475085316637 (37.7639128285243, -122.475085316637)
170818 227612 2 30 1299 York St 1 1 1 1     3 Width 3ft   6010076.057159999 2101688.5205599996 37.7514047850101 -122.40800274303601 (37.7514047850101, -122.408002743036)
157041 199935 2 30 1310 Griffith St 1 1 1 1     3 Width 0ft   6017874.9241 2092620.1152 37.726938315047896 -122.380402857754 (37.7269383150479, -122.380402857754)
74170 129446 2 30 1329 Washington St 1 1 1 1     14 Width 3ft   6008344.2402 2117236.00141 37.7939973921104 -122.415091973713 (37.7939973921104, -122.415091973713)
155958 227621 2 30 1335 Douglass St 5 9 1 1     5 Width 4ft   6001398.3282 2099807.1524799997 37.7457493236871 -122.43787655407499 (37.7457493236871, -122.437876554075)
176691 75284 2 30 1335 Griffith St 3 1 1 1 1 06/13/1998 12:00:00 AM 3     6017835.3471 2092484.583 37.7265639860027 -122.380530259866 (37.7265639860027, -122.380530259866)
27806 129444 2 30 1338 Clay St 3 1 1 1     9 Width 3ft   6008418.059880001 2116953.62618 37.793226207275794 -122.414816555443 (37.7932262072758, -122.414816555443)
97690 48988 1 30 134 28th St 1 1 1 1 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 2 30 134 28th St 1 1 1 1     8 Width 4ft   6005000.954919999 2099622.04361 37.7454452619845 -122.42540601408001 (37.7454452619845, -122.42540601408)
28952 176968 2 30 134 Craut St 2 1 1 1     2 Width 3ft   6004019.9865 2094083.3714700001 37.7301818557853 -122.428403350153 (37.7301818557853, -122.428403350153)
59805 176969 2 30 134 Craut St 3 1 1 1     3 Width 3ft   6004020.786 2094067.71187 37.7301389032718 -122.428399470475 (37.7301389032718, -122.428399470475)
150746 176967 2 30 134 Craut St 1 1 1 1     2 Width 3ft   6004019.42662 2094104.5358400003 37.7302399367234 -122.428406793639 (37.7302399367234, -122.428406793639)
52098 207062 2 30 134 Taraval St 2 1 1 1     1 Width 3ft   5993034.65386 2099189.08337 37.7435731145127 -122.46675176060499 (37.7435731145127, -122.466751760605)
67199 207064 2 30 134 Taraval St 4 1 1 1     1 Width 3ft   5993028.0499599995 2099189.22218 37.743573114522206 -122.466774605159 (37.7435731145222, -122.466774605159)
178142 207065 2 30 134 Taraval St 5 1 1 1     1 Width 3ft   5993024.9505900005 2099189.6741400003 37.743574176615894 -122.46678535477301 (37.7435741766159, -122.466785354773)
183793 207061 2 30 134 Taraval St 1 1 1 1     1 Width 3ft   5993037.74509 2099188.24411 37.7435709885186 -122.466741010989 (37.7435709885186, -122.466741010989)
186485 207063 2 30 134 Taraval St 3 1 1 1     2 Width 3ft   5993031.18209 2099190.3171200003 37.7435763017135 -122.46676385469401 (37.7435763017135, -122.466763854694)
164682 37224 1 30 1340 34th Ave 1 1 1 1 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 1 30 1345 Noriega St 4 1 1 1     4   Permit Number 18860 5989785.9448 2103084.5073 37.7540808992005 -122.478269637351 (37.7540808992005, -122.478269637351)
2850 27607 3 30 1377 Fulton St 1 1 1 2     3 3X3   6001133.4058 2111053.0447 37.7766127217509 -122.439598674592 (37.7766127217509, -122.439598674592)
6797 27608 3 30 1377 Fulton St 2 1 1 2     3 3X3   6001149.4313 2111053.53 37.776614966343296 -122.439543272646 (37.7766149663433, -122.439543272646)
83118 38678 1 30 1377 Fulton St 1 1 1 1 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 1 30 1377 Fulton St 2 1 1 1 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 2 30 1392 Pacific Ave 1 1 1 1 1 08/19/1995 12:00:00 AM 1     6007494.44606 2117816.87319 37.795544530015604 -122.418073553678 (37.7955445300156, -122.418073553678)
59171 207090 2 30 1400 Ulloa St 4 1 1 1     3 Width 3ft   5991605.432 2098443.60055 37.741443622419894 -122.47163929621 (37.7414436224199, -122.47163929621)
Powered by Datasette · Query took 11.361ms · Data source: data.sfgov.org