sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
49913 199985 2 35 1032 Revere Ave 1 1 1 1     4 Width 0ft   6018147.7753 2092169.4169 37.725715836336896 -122.379428312297 (37.7257158363369, -122.379428312297)
119612 96804 3 35 1200X Revere Ave 1 22 1 2           6017205.4 2092876.1 37.7276042330013 -122.38273521775801 (37.7276042330013, -122.382735217758)
171275 199981 3 35 1200x Shafter Ave 1 11 1 2     2 Width 0ft   6017028.9443 2092601.7798 37.7268412531355 -122.38332614590799 (37.7268412531355, -122.383326145908)
112336 24168 3 35 95X Whitney Young Cir 1 1 1 2   01/01/2008 12:00:00 AM 3 3x3   6016412.1769872 2096105.6107163997 37.736427970914 -122.38570241578998 (37.736427970914, -122.38570241579)
58886 196424 3 35 1427x Innes Ave 31 3 1 2     3     6016113.33147 2096777.48422 37.7382562587307 -122.386782500139 (37.7382562587307, -122.386782500139)
34311 67662 1 35 1544 Hudson Ave 1 1 1 1 1 11/05/1992 12:00:00 AM     Permit Number 31263 6016003.68231462 2097240.31166612 37.739521017402 -122.38719389035101 (37.739521017402, -122.387193890351)
149041 46629 1 35 1490 Newcomb Ave 1 1 1 1 1 04/12/2002 12:00:00 AM 7   Permit Number 44750 6015847.6531 2095265.1212 37.734088902667104 -122.38759560956001 (37.7340889026671, -122.38759560956)
59112 40021 1 35 1530 McKinnon Ave 1 1 1 1 1 02/03/1999 12:00:00 AM 5   Permit Number 41266 6015759.6141 2095683.1757 37.73523191912879 -122.387929152323 (37.7352319191288, -122.387929152323)
63659 38558 1 35 1534 McKinnon Ave 1 1 1 1 1 09/17/1998 12:00:00 AM     Permit Number 40523 6015743.77247492 2095689.90327715 37.735249514063895 -122.38798439240601 (37.7352495140639, -122.387984392406)
159636 40022 1 35 1535 McKinnon Ave 1 1 1 1 1 02/03/1999 12:00:00 AM 9   Permit Number 41267 6015717.1223 2095636.9971 37.7351027679039 -122.388072841786 (37.7351027679039, -122.388072841786)
184636 199678 3 35 1400x Underwood Ave 1 11 1 2     3 Width 0ft   6015628.2568 2092949.4044 37.72771825330071 -122.388192580507 (37.7277182533007, -122.388192580507)
127102 27759 3 35 1099X Cesar Chavez St 1 1 1 2   12/25/2005 12:00:00 AM 4 3x3   6015711.817910201 2101113.2850563 37.750139234821 -122.38847329943701 (37.750139234821, -122.388473299437)
14606 15049 3 35 1125 Mendell St 1 1 1 2   01/15/1999 12:00:00 AM 25 8X15   6015485.0268 2096001.9904 37.7360921037992 -122.388900760186 (37.7360921037992, -122.388900760186)
30204 74333 2 35 1118 Fitzgerald Ave 1 1 1 1 1 01/12/2002 12:00:00 AM 4     6015132.5367 2090213.511 37.720178552846 -122.389715298726 (37.720178552846, -122.389715298726)
114922 51808 1 35 1465 Van Dyke Ave 2 1 1 1   07/12/2005 12:00:00 AM     Permit Number 48055 6015124.97012751 2092940.21442791 37.727665120823495 -122.38993182362302 (37.7276651208235, -122.389931823623)
103592 121759 2 35 1019 Minnesota St 1 1 1 1       3x3   6015338.0 2103772.0 37.7574187808175 -122.389951694408 (37.7574187808175, -122.389951694408)
156664 51809 1 35 1465 Van Dyke Ave 1 1 1 1   07/12/2005 12:00:00 AM 2 3x3 Permit Number 48055 6015110.437000001 2092946.715 37.7276821641004 -122.389982519172 (37.7276821641004, -122.389982519172)
133911 60295 1 35 1469 Van Dyke Ave 1 1 1 1   09/27/1982 12:00:00 AM 7 3x3 Permit Number 19860 6015087.9595 2092963.5731 37.727727206447604 -122.390061402044 (37.7277272064476, -122.390061402044)
54244 196406 2 35 1021 Minnesota St 2 2 1 1     2 Width 4ft   6015301.01099 2103753.62638 37.7573662793475 -122.390078334671 (37.7573662793475, -122.390078334671)
80506 27758 3 35 1299 Cesar Chavez St 11 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874)
83929 27750 3 35 1299 Cesar Chavez St 3 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874)
118003 27753 3 35 1299 Cesar Chavez St 6 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874)
126737 27754 3 35 1299 Cesar Chavez St 7 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015153.848397 2101092.2403929 37.7500505146893 -122.390401336874 (37.7500505146893, -122.390401336874)
96146 29251 3 35 1300X Cesar Chavez St 5 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6015137.8598649 2101142.4987414 37.750187626613496 -122.39046013782401 (37.7501876266135, -122.390460137824)
124164 27720 3 35 1300X Cesar Chavez St 2 1 1 2   04/11/2015 06:49:00 AM 3 3X3   6015137.8598649 2101142.4987414 37.750187626613496 -122.39046013782401 (37.7501876266135, -122.390460137824)
46253 27745 3 35 1399 Cesar Chavez St 6 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6014867.852606599 2101105.5872465 37.7500712934283 -122.391391267014 (37.7500712934283, -122.391391267014)
104005 27743 3 35 1399 Cesar Chavez St 4 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6014867.852606599 2101105.5872465 37.7500712934283 -122.391391267014 (37.7500712934283, -122.391391267014)
99267 30767 1 35 1595 Underwood Ave 2 1 1 1 1 01/31/1995 12:00:00 AM     Permit Number 34647 6014606.20359025 2093675.42749231 37.729655084274995 -122.39177660646999 (37.729655084275, -122.39177660647)
172828 30770 1 35 1662 Wallace Ave 1 1 1 1   06/24/2008 12:00:00 AM 2   Permit Number 51077 6014463.7744 2093152.8983 37.7282124168861 -122.39223247286101 (37.7282124168861, -122.392232472861)
167759 196407 2 35 301 Pennsylvania Ave 2 9 1 1     2 Width 9ft   6014364.2295 2105674.4780599996 37.7625885210619 -122.393452545091 (37.7625885210619, -122.393452545091)
120573 40228 1 35 101 South Park 3 1 1 1   05/06/1999 12:00:00 AM     Permit Number 41410 6014331.14035058 2112607.2540326 37.7816225406641 -122.394052345281 (37.7816225406641, -122.394052345281)
128168 40229 1 35 101 South Park 4 1 1 1   05/06/1999 12:00:00 AM     Permit Number 41410 6014331.14035058 2112607.2540326 37.7816225406641 -122.394052345281 (37.7816225406641, -122.394052345281)
123154 4019 1 35 1760 Cesar Chavez St 2 1 1 1   03/23/2006 12:00:00 AM 3 2X3   6013957.30178 2101067.5315943 37.7499162221241 -122.39453736171801 (37.7499162221241, -122.394537361718)
160610 67707 1 35 31 Stillman St 1 1 1 1 1 11/19/1992 12:00:00 AM 11   Permit Number 31318 6014113.9587900005 2113076.60421 37.7828991959845 -122.39483657655 (37.7828991959845, -122.39483657655)
95103 64483 1 35 55X Stillman St 1 1 1 1 1 05/14/1994 12:00:00 AM     Permit Number 25357 6014099.57937836 2112818.90611884 37.782190816387796 -122.394868269842 (37.7821908163878, -122.394868269842)
159092 196393 2 35 93 Stillman St 1 4 1 1     9 Width 3ft   6013990.372330001 2112956.91555 37.7825636859099 -122.395255750564 (37.7825636859099, -122.395255750564)
57720 196392 2 35 93 Stillman St 4 4 1 1     1 Width 3ft   6013963.537140001 2112927.48749 37.7824813907387 -122.39534652723499 (37.7824813907387, -122.395346527235)
177156 196391 2 35 93 Stillman St 3 4 1 1     1 Width 3ft   6013949.37152 2112913.94153 37.7824434087757 -122.395394585209 (37.7824434087757, -122.395394585209)
54846 196390 2 35 93 Stillman St 2 4 1 1     1 Width 3ft   6013936.7797 2112901.90047 37.7824096464379 -122.39543730389799 (37.7824096464379, -122.395437303898)
32988 196389 2 35 93 Stillman St 1 4 1 1     1 Width 3ft   6013924.26567 2112893.70041 37.7823864349182 -122.395480022606 (37.7823864349182, -122.395480022606)
120359 32267 1 35 267 Texas St 1 1 1 1   08/15/1996 12:00:00 AM     Permit Number 36853 6013772.46926434 2105862.13808331 37.7630708975316 -122.395512392676 (37.7630708975316, -122.395512392676)
154435 196388 2 35 462 Stillman St 4 4 1 1     1 Width 3ft   6013913.95715 2112880.07634 37.782348452967206 -122.395514731015 (37.7823484529672, -122.395514731015)
156919 196387 2 35 462 Stillman St 3 4 1 1     1 Width 3ft   6013895.88765 2112864.3036700003 37.782304139751794 -122.39557613855301 (37.7823041397518, -122.395576138553)
133506 196386 2 35 462 Stillman St 2 4 1 1     1 Width 3ft   6013883.34247 2112854.56717 37.7822767077361 -122.395618857241 (37.7822767077361, -122.395618857241)
177545 196385 2 35 462 Stillman St 1 4 1 1     1 Width 3ft   6013873.09616 2112844.01572 37.7822471659153 -122.395653565657 (37.7822471659153, -122.395653565657)
100203 44089 1 35 500 Bryant St 5 1 1 1   10/31/2000 12:00:00 AM 6 3x3 Permit Number 43605 6013788.61209882 2112522.22157888 37.7813588929752 -122.395923288248 (37.7813588929752, -122.395923288248)
124052 44088 1 35 500 Bryant St 4 1 1 1   10/31/2000 12:00:00 AM 6 3x3 Permit Number 43605 6013788.61209882 2112522.22157888 37.7813588929752 -122.395923288248 (37.7813588929752, -122.395923288248)
46066 67709 1 35 87 Stillman St 1 1 1 1   11/19/1992 12:00:00 AM 10   Permit Number 31320 6013781.91426 2112762.09602 37.7820171606904 -122.395963274202 (37.7820171606904, -122.395963274202)
48475 196394 2 35 497 03rd St 1 4 1 1     8 Width 3ft   6013753.77821 2112514.40047 37.781335479998496 -122.39604324912202 (37.7813354799985, -122.396043249122)
15620 44090 1 35 500 Bryant St 1 1 1 1   10/31/2000 12:00:00 AM 6 3x3 Permit Number 43605 6013747.9947 2112490.5876700003 37.7812697737139 -122.39606158808701 (37.7812697737139, -122.396061588087)
25052 196384 2 35 99 Stillman St 3 4 1 1     7 Width 0ft   6013750.52811 2112736.60264 37.781945415491705 -122.396070069587 (37.7819454154917, -122.396070069587)
14002 44086 1 35 500 Bryant St 2 1 1 1   10/31/2000 12:00:00 AM 6 3x3 Permit Number 43605 6013734.19002 2112474.65205 37.7812252500735 -122.396108228707 (37.7812252500735, -122.396108228707)
179071 67710 1 35 99 Stillman St 1 1 1 1 1 11/19/1992 12:00:00 AM 7   Permit Number 31321 6013724.697430001 2112718.68187 37.7818947719595 -122.396158176154 (37.7818947719595, -122.396158176154)
119406 4026 3 35 1900 Cesar Chavez St 4 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6013444.007912099 2101040.051797 37.7498122193832 -122.39631044368099 (37.7498122193832, -122.396310443681)
121773 4025 3 35 1900 Cesar Chavez St 3 1 1 2   06/25/2015 03:01:00 PM 3 3X3   6013444.007912099 2101040.051797 37.7498122193832 -122.39631044368099 (37.7498122193832, -122.396310443681)
123464 4023 3 35 1900 Cesar Chavez St 1 1 1 2   06/26/2015 02:44:00 PM 3 3X3   6013444.007912099 2101040.051797 37.7498122193832 -122.39631044368099 (37.7498122193832, -122.396310443681)
77817 67647 1 35 1980 Quesada Ave 1 1 1 1 1 11/05/1992 12:00:00 AM     Permit Number 31246 6013237.51927358 2096157.49523352 37.736394256512206 -122.39668225739901 (37.7363942565122, -122.396682257399)
170429 178896 2 35 424 Blanken Ave 2 1 1 1     2 Width 2ft   6012763.5947 2086999.9849599998 37.711223202768295 -122.397678716599 (37.7112232027683, -122.397678716599)
35382 40325 1 35 655 Folsom St 1 1 1 1   05/14/1999 12:00:00 AM 4   Permit Number 41463 6013209.4791 2113639.3788 37.78439411283129 -122.39800521351201 (37.7843941128313, -122.398005213512)
37685 178897 2 35 250 Tocoloma Ave 1 1 1 1     3 Width 3ft   6012667.83856 2087309.2144 37.7120669530014 -122.39803135517599 (37.7120669530014, -122.398031355176)
164638 178898 2 35 250 Tocoloma Ave 2 1 1 1     3 Width 3ft   6012665.55046 2087301.61111 37.7120459484316 -122.398038730507 (37.7120459484316, -122.398038730507)
42943 178899 2 35 250 Tocoloma Ave 3 1 1 1     4 Width 3ft   6012660.08669 2087284.72268 37.7119992718279 -122.39805643095801 (37.7119992718279, -122.398056430958)
89222 89359 1 35 308 Tocoloma Ave 3 8 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50704 6012556.9 2087009.2 37.7112369933076 -122.39839375585301 (37.7112369933076, -122.398393755853)
107830 4033 3 35 2150 Cesar Chavez St 7 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
125081 4027 3 35 2150 Cesar Chavez St 1 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
143514 4029 3 35 2150 Cesar Chavez St 3 1 1 2   03/23/2006 12:00:00 AM 3 3X3   6012617.955900401 2100994.1740901 37.749640248492604 -122.39916376626199 (37.7496402484926, -122.399163766262)
66305 54661 1 35 345 Peninsula Ave 1 1 1 1   07/27/1972 12:00:00 AM 2   Permit Number 10485 6012308.35839 2086909.49761 37.71094938168571 -122.399245788885 (37.7109493816857, -122.399245788885)
80354 67682 1 35 56 Topeka Ave 1 1 1 1 1 11/05/1992 12:00:00 AM     Permit Number 31286 6012201.16288031 2095460.48706817 37.73442268368721 -122.400216460292 (37.7344226836872, -122.400216460292)
171467 196377 2 35 137 Clara St 1 1 1 1     3 Width 3ft   6012419.03852 2112368.2176 37.7808597440141 -122.40065055237899 (37.7808597440141, -122.400650552379)
78614 196378 2 35 135 Clara St 2 1 1 1     4 Width 3ft   6012410.6733800005 2112360.21924 37.78083731581879 -122.400678929615 (37.7808373158188, -122.400678929615)
184862 196379 2 35 135 Clara St 3 1 1 1     4 Width 3ft   6012397.66121 2112347.77768 37.7808024284316 -122.400723071038 (37.7808024284316, -122.400723071038)
163292 196380 2 35 135 Clara St 4 1 1 1     3 Width 3ft   6012381.80562 2112329.94836 37.780752588889705 -122.40077667062599 (37.7807525888897, -122.400776670626)
55206 196381 2 35 135 Clara St 5 1 1 1     3 Width 3ft   6012369.74132 2112319.30273 37.7807226855437 -122.400817659004 (37.7807226855437, -122.400817659004)
138811 43293 1 35 975 De Haro St 1 1 1 1 1 07/12/2000 12:00:00 AM     Permit Number 43062 6012196.286885 2103939.61174077 37.7577042695859 -122.40082883013599 (37.7577042695859, -122.400828830136)
126294 43292 1 35 969 De Haro St 1 1 1 1 1 07/12/2000 12:00:00 AM     Permit Number 43061 6012193.84203757 2103983.88594083 37.75782570042529 -122.400840395966 (37.7578257004253, -122.400840395966)
148188 196382 2 35 135 Clara St 6 1 1 1     2 Width 3ft   6012355.92865 2112312.32296 37.780702750265704 -122.400864953468 (37.7807027502657, -122.400864953468)
168201 38758 1 35 133 Shipley St 8 1 1 1   10/20/1998 12:00:00 AM 3   Permit Number 40630 6012273.2979999995 2112461.93462 37.7811089398776 -122.401161330453 (37.7811089398776, -122.401161330453)
178028 38750 1 35 133 Shipley St 7 1 1 1   10/20/1998 12:00:00 AM 3   Permit Number 40630 6012258.40846 2112446.8085 37.7810665763953 -122.40121177791 (37.7810665763953, -122.40121177791)
154431 178903 3 35 10x Mansell St 3 11 1 2     1 Width 0ft   6011814.45609 2090752.0893599999 37.7214728265024 -122.401222688486 (37.7214728265024, -122.401222688486)
54864 178902 3 35 10x Mansell St 2 11 1 2     3 Width 0ft   6011813.97335 2090761.03311 37.721497357285706 -122.401224985361 (37.7214973572857, -122.401224985361)
27753 178904 3 35 10x Mansell St 4 11 1 2     1 Width 0ft   6011792.88406 2090769.7339700002 37.7215200714836 -122.401298496839 (37.7215200714836, -122.401298496839)
130997 38752 1 35 133 Shipley St 6 1 1 1   10/20/1998 12:00:00 AM 3   Permit Number 40630 6012228.62933 2112416.55663 37.780981850378105 -122.40131267285 (37.7809818503781, -122.40131267285)
159980 196374 2 35 135 Shipley St 1 1 1 1     3 Width 3ft   6012209.830030001 2112433.27452 37.7810267049661 -122.40137888454201 (37.7810267049661, -122.401378884542)
74536 196375 2 35 135 Shipley St 2 1 1 1     2 Width 3ft   6012200.498790001 2112422.5734200003 37.7809968015951 -122.401410413864 (37.7809968015951, -122.401410413864)
29397 38753 1 35 133 Shipley St 5 1 1 1   10/20/1998 12:00:00 AM 1   Permit Number 40630 6012187.7155 2112376.5476 37.780869712107396 -122.40145140226002 (37.7808697121074, -122.40145140226)
187913 196376 2 35 135 Shipley St 3 1 1 1     3 Width 3ft   6012181.9653199995 2112407.5214 37.780954438148704 -122.40147347253999 (37.7809544381487, -122.40147347254)
37281 38754 1 35 133 Shipley St 4 1 1 1   10/20/1998 12:00:00 AM 3   Permit Number 40630 6012174.72166 2112365.01303 37.7808373158384 -122.40149554368901 (37.7808373158384, -122.401495543689)
155512 196383 2 35 172 Clara St 1 4 1 1     7 Width 2ft   6012113.23171 2112074.9324 37.780037390439794 -122.40168787361799 (37.7800373904398, -122.401687873618)
77426 91342 1 35 829 Folsom St 5 1 1 1   02/23/2009 12:00:00 AM   3x3 Permit Number 52060 6012100.0 2112601.0 37.7814811117781 -122.401770636493 (37.7814811117781, -122.401770636493)
79690 91341 1 35 829 Folsom St 4 1 1 1   02/23/2009 12:00:00 AM   3x3 Permit Number 52060 6012100.0 2112601.0 37.7814811117781 -122.401770636493 (37.7814811117781, -122.401770636493)
138531 91340 1 35 829 Folsom St 3 1 1 1   02/23/2009 12:00:00 AM   3x3 Permit Number 52060 6012100.0 2112601.0 37.7814811117781 -122.401770636493 (37.7814811117781, -122.401770636493)
145257 48941 1 35 1343 San Bruno Ave 1 1 1 1 1 11/25/2002 12:00:00 AM     Permit Number 46128 6011661.44049501 2091503.35733972 37.7235271168325 -122.401804405977 (37.7235271168325, -122.401804405977)
88065 34303 1 35 1219 San Bruno Ave 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38091 6011656.31212487 2091520.16541192 37.7235729821535 -122.40182331486 (37.7235729821535, -122.40182331486)
106934 48938 1 35 1213 San Bruno Ave 1 1 1 1 1 11/25/2002 12:00:00 AM     Permit Number 46126 6011656.06397948 2091520.97870067 37.7235752014293 -122.40182422980101 (37.7235752014293, -122.401824229801)
95411 48937 1 35 1211 San Bruno Ave 1 1 1 1 1 08/17/2004 12:00:00 AM     Permit Number 47623 6011655.9812658 2091521.24979215 37.7235759411749 -122.401824534776 (37.7235759411749, -122.401824534776)
144364 51585 1 35 2310@ KANSAS 26th St 1 1 1 1   02/28/2005 12:00:00 AM     Permit Number 47878 6011640.45005076 2101375.04283717 37.7506315072329 -122.40257081531401 (37.7506315072329, -122.402570815314)
80278 42211 1 35 937 Harrison St 1 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42479 6011834.2594701 2111457.32291808 37.7783260063796 -122.40260952625201 (37.7783260063796, -122.402609526252)
125151 42210 1 35 937 Harrison St 2 1 1 1 1 06/23/2000 12:00:00 AM     Permit Number 42479 6011834.2594701 2111457.32291808 37.7783260063796 -122.40260952625201 (37.7783260063796, -122.402609526252)
127195 38189 1 35 541 Girard St 1 1 1 1 1 04/16/2013 12:00:00 AM     Permit Number 770070 6011097.98403945 2092306.25144746 37.7257002373273 -122.403808654284 (37.7257002373273, -122.403808654284)
33576 196395 2 35 260 Clara St 3 4 1 1     9 Width 3ft   6011460.59942 2111454.8789 37.7782984271806 -122.40390199009501 (37.7782984271806, -122.403901990095)
10780 26783 1 35 6 Leland Ave 2 1 1 1     3 4X4   6010951.9721 2087077.0783 37.711333837408205 -122.40394559103301 (37.7113338374082, -122.403945591033)
Powered by Datasette · Query took 11.487ms · Data source: data.sfgov.org