sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
144026 104949 2 60 535 Gonzalez Dr 2 2 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
109251 104950 2 60 600 Gonzalez Dr 2 2 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
88948 104951 2 60 600 Gonzalez Dr 1 2 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
112803 104952 2 60 600 Gonzalez Dr 3 2 1 1           5990401.0 2090562.0 37.719732984351396 -122.475228499286 (37.7197329843514, -122.475228499286)
92889 104953 2 11 601 Gonzalez Dr 3 2 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
113878 104954 2 11 601 Gonzalez Dr 2 2 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
138275 104955 2 11 601 Gonzalez Dr 1 2 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
122291 104956 2 60 759 Gonzalez Dr 1 2 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
71511 104957 2 60 759 Gonzalez Dr 2 2 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
90415 104958 2 60 759 Gonzalez Dr 3 2 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
94825 104959 2 60 759 Gonzalez Dr 3 2 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
22945 104992 2 7 2423 47TH AVE 1 2 1 1   01/14/2016 12:00:00 AM 10 2x6 Permit Number 775156 5981729.7 2098576.9 37.74123331264771 -122.505795454359 (37.7412333126477, -122.505795454359)
102201 105253 2 2 130 GONZALEZ DR 1 2 1 1     2     5990327.0 2090136.0 37.7185590045312 -122.47545320091999 (37.7185590045312, -122.47545320092)
79133 105258 2 3 132 GONZALEZ DR 1 2 1 1     50     5990327.0 2090136.0 37.7185590045312 -122.47545320091999 (37.7185590045312, -122.47545320092)
92022 105259 2 2 466 GONZALEZ DR 2 2 1 1     2     5989603.4 2089229.6 37.7160282834266 -122.477888136934 (37.7160282834266, -122.477888136934)
80132 105261 2 71 619 GONZALEZ DR   2 1 1     3     5988914.8 2089258.8 37.716068469533205 -122.48027037241002 (37.7160684695332, -122.48027037241)
142770 105263 1 153 759 GONZALEZ DR 3 2 1 1     3     5988771.3 2089745.5 37.7173964863294 -122.48080198209499 (37.7173964863294, -122.480801982095)
105942 105266 1 153 737 GONZALEZ DR 3 2 1 1     3     5988857.6 2089713.7 37.7173141872637 -122.48050136001899 (37.7173141872637, -122.480501360019)
104763 105268 1 71 842X GONZALEZ DR 1 2 1 1     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302)
79402 105345   5 466 Gonzalez Dr 3 2 1 1           5989603.4 2089229.6 37.7160282834266 -122.477888136934 (37.7160282834266, -122.477888136934)
143348 105370 2 2 518 GONZALEZ DR 1 2 1 1     2     5989481.9 2089475.9 37.7166975095441 -122.47832609269699 (37.7166975095441, -122.478326092697)
92687 105834 2 3 3031 QUINTARA ST 1 2 1 1     22     5984010.9 2100823.5 37.747535864547 -122.498073868906 (37.747535864547, -122.498073868906)
77389 105910 2 17 80 LINARES AVE 5 2 1 1           5994154.8 2102090.7 37.75160480205479 -122.46308908916401 (37.7516048020548, -122.463089089164)
116415 105994 2 41 131 GRIJALVA DR 2 2 1 1     18     5989195.7 2089107.3 37.7156688070552 -122.479288383095 (37.7156688070552, -122.479288383095)
115356 106044 2 21 415 DEWEY BLVD   2 1 1           5995172.1 2100351.0 37.7468865723154 -122.45944518004801 (37.7468865723154, -122.459445180048)
140580 106157 2 215 450 MAGELLAN AVE 1 2 1 1     20     5993514.2 2099497.2 37.7444467889139 -122.465115996043 (37.7444467889139, -122.465115996043)
120337 106158 2 215 450 MAGELLAN AVE   2 1 1     20 6x6   5993514.2 2099497.2 37.7444467889139 -122.465115996043 (37.7444467889139, -122.465115996043)
118708 106159 2 17 280 DORANTES AVE 1 2 1 1           5993249.6 2099727.1 37.745062774532 -122.46604762346 (37.745062774532, -122.46604762346)
72586 106187 2 5 1353 ULLOA ST 2 2 1 1     12 4x15   5991777.0 2098367.4 37.7412443198206 -122.471040528993 (37.7412443198206, -122.471040528993)
146314 106188 2 5 1353 ULLOA ST 1 2 1 1     12 4x15   5991777.0 2098367.4 37.7412443198206 -122.471040528993 (37.7412443198206, -122.471040528993)
104501 106211 2 105 1646 35TH AVE 1 2 1 1         Permit Number 773238 5985355.0 2103995.9 37.7563251201532 -122.49365984919201 (37.7563251201532, -122.493659849192)
64991 106213 2 28 1646 35th Ave 2 2 1 1     7     5985329.6566 2104002.0012 37.7563403897038 -122.493747943766 (37.7563403897038, -122.493747943766)
81509 106258 2 15 205 GRANADA AVE 2 2 1 1     16 4x4   5995602.7 2091290.9 37.722034494846895 -122.457300887551 (37.7220344948469, -122.457300887551)
127763 106347 2 241 415 DEWEY BLVD 2 2 1 1           5995172.1 2100351.0 37.7468865723154 -122.45944518004801 (37.7468865723154, -122.459445180048)
16807 106757 2 47 999 Key Ave 1 2 1 1   06/02/2014 12:00:00 AM 36     6013321.202330001 2089752.82506 37.718812992515105 -122.395944254446 (37.7188129925151, -122.395944254446)
99355 106961 2 47 325 DWIGHT ST   2 1 1           6010604.0 2091349.0 37.7230442144558 -122.405448941518 (37.7230442144558, -122.405448941518)
12169 107579 2 44 100 Panama St 1 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992416.91174 2086830.03613 37.7096025506984 -122.467988957943 (37.7096025506984, -122.467988957943)
10370 107580 2 44 100 Panama St 2 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992406.39157 2086830.73395 37.709603859212706 -122.468025367885 (37.7096038592127, -122.468025367885)
10524 107581 2 44 100 Panama St 3 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992393.946819999 2086830.9956900002 37.7096038591978 -122.46806839775299 (37.7096038591978, -122.468068397753)
11907 107582 2 44 100 Panama St 4 2 1 1   11/12/2014 12:00:00 AM 3   Permit Number 774090 5992337.55751 2086836.4734200002 37.7096156430274 -122.46826368552 (37.7096156430274, -122.46826368552)
111059 108382 2 17 30 CASTILLO ST 1 2 1 1       6x12   6006869.1 2086298.1 37.7089659714277 -122.418001881162 (37.7089659714277, -122.418001881162)
138563 108589 6 17 1139x HUDSON AVE 1 2 1 1           6017760.0 2094672.0 37.732566047797704 -122.38094273978099 (37.7325660477977, -122.380942739781)
110904 109242 7 64 2479 DIAMOND ST   2 2 1           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916)
114226 110115 2 344 185x SANSOME ST 1 2 1 1       9x90   6012318.0 2116367.0 37.7918338284962 -122.40128118389099 (37.7918338284962, -122.401281183891)
114274 110143 3 143 1130X PORTOLA DR 3 2 1 2       3x3   5994964.0 2098019.0 37.7404715144277 -122.459995857341 (37.7404715144277, -122.459995857341)
109312 110236 6 3 100 BUCHANAN ST 1 2 1 1   05/12/2015 12:00:00 AM 3 3x20   6004868.5 2109011.4 37.771218737852294 -122.426532477218 (37.7712187378523, -122.426532477218)
125197 110465 3 5 1485 FAIRFAX AVE 2 2 1 2     9 3x3   6016296.0 2097688.0 37.7407664622153 -122.38621437638201 (37.7407664622153, -122.386214376382)
100469 110542 1 60 996 SOUTH VAN NESS AVE 3 2 1 1           6007549.0 2103894.0 37.757318718735704 -122.41689786927 (37.7573187187357, -122.41689786927)
124442 111071 2 5 1908 15TH AVE 1 2 1 1       3x3   5991632.0 2102414.0 37.7523468518329 -122.471836728689 (37.7523468518329, -122.471836728689)
119453 111088 2 3 136 GONZALEZ DR 1 2 1 1   06/04/2015 12:00:00 AM 45 3x3 Permit Number 775596 5990091.0 2089770.0 37.71754037603979 -122.476242228391 (37.7175403760398, -122.476242228391)
139222 111092 2 15 801 GONZALEZ DR   2 1 1   06/04/2015 12:00:00 AM 2   Permit Number 775593 5988333.0 2089769.0 37.717435525652704 -122.48231868452 (37.7174355256527, -122.48231868452)
111271 111095 2 15 841x GONZALEZ DR 1 2 1 1   06/04/2015 12:00:00 AM 3   Permit Number 775593 5988358.0 2089771.0 37.7174424713469 -122.48223241855301 (37.7174424713469, -122.482232418553)
106585 111654 2 1 1740 CESAR CHAVEZ ST 1 2 1 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
112222 111655 2 1 1740 CESAR CHAVEZ ST 2 2 1 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
83540 111656 2 1 1740 CESAR CHAVEZ ST 3 2 1 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
126012 111657 2 1 1740 CESAR CHAVEZ ST 4 2 1 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
127871 111658 2 1 1740 CESAR CHAVEZ ST 5 2 1 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
122826 111659 2 1 1740 CESAR CHAVEZ ST 6 2 1 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
96677 111660 2 1 1740 CESAR CHAVEZ ST 7 2 1 1   07/07/2015 12:00:00 AM 3     6014066.0 2101066.0 37.749918058990104 -122.394161367931 (37.7499180589901, -122.394161367931)
64865 111721 3 276 950X Beach St 2 2 1 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
86010 111722 3 276 950X Beach St 3 2 1 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
100349 111723 3 276 950X Beach St 4 2 1 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
91241 111724 3 276 950X Beach St 5 2 1 2           6005896.0 2121751.0 37.8062565433008 -122.42388434548401 (37.8062565433008, -122.423884345484)
116050 111759 1 54 1235 47th Ave 2 2 2 1   06/23/2015 12:00:00 AM 3 6x4   5981472.7 2106671.7 37.7634442160317 -122.50728446314301 (37.7634442160317, -122.507284463143)
88249 111922 2 2 2 SEACLIFF AVE 1 2 1 1     15     5988181.0 2115833.0 37.7889914240961 -122.484754991166 (37.7889914240961, -122.484754991166)
99293 111923 2 2 2 SEACLIFF AVE 2 2 1 1     15     5988181.0 2115833.0 37.7889914240961 -122.484754991166 (37.7889914240961, -122.484754991166)
117998 111927 2 2 40 SEACLIFF AVE 1 2 1 1     24     5987998.0 2115828.0 37.78896703592721 -122.48538777195401 (37.7889670359272, -122.485387771954)
104367 111928 2 2 40 SEACLIFF AVE 2 2 1 1     28     5987998.0 2115828.0 37.78896703592721 -122.48538777195401 (37.7889670359272, -122.485387771954)
105418 111929 2 2 40 SEACLIFF AVE 3 2 1 1     34     5987998.0 2115828.0 37.78896703592721 -122.48538777195401 (37.7889670359272, -122.485387771954)
93352 112398 6 1 246 CRESCENT AVE 1 2 1 1           6006552.0 2095759.0 37.7349257177289 -122.419768681192 (37.7349257177289, -122.419768681192)
50152 113698 3 47 80 LINARES AVE 1 2 1 2           5994154.8 2102090.7 37.75160480205479 -122.46308908916401 (37.7516048020548, -122.463089089164)
113956 114069 2 103 2 HIGUERA AVE 2 2 1 1     40     5988091.0 2090188.0 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801)
121843 114070 2 2 2 HIGUERA AVE 1 2 1 1     3     5988091.0 2090188.0 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801)
104756 114071 2 2 2 HIGUERA AVE 3 2 1 1     4     5988091.0 2090188.0 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801)
84582 114072 6 21 454 ARBALLO DR 1 2 1 1     4     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
119334 114073 6 146 18x HIGUERA AVE 1 2 1 1     6     5988029.0 2090212.0 37.718634203797706 -122.483401916227 (37.7186342037977, -122.483401916227)
91565 114074 6 146 18x HIGUERA AVE 2 2 1 1     5     5988029.0 2090212.0 37.718634203797706 -122.483401916227 (37.7186342037977, -122.483401916227)
92772 114075 2 103 24 HIGUERA AVE 1 2 1 1     26     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
138466 114076 2 103 24 HIGUERA AVE 2 2 1 1     24     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
90371 114077 2 2 32 HIGUERA AVE 1 2 1 1     6     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
111154 114078 2 2 32 HIGUERA AVE 2 2 1 1     7     5987903.0 2090420.0 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784)
126430 114212 2 3 302 SERRANO DR 1 2 1 1     64     5988825.0 2090618.0 37.7197952736455 -122.480680205506 (37.7197952736455, -122.480680205506)
129039 114213 2 3 230 SERRANO DR 1 2 1 1     60     5988981.0 2090766.0 37.720210710128896 -122.48015180069099 (37.7202107101289, -122.480151800691)
119916 114214 2 25 230 SERRANO DR 2 2 1 1     13     5988981.0 2090766.0 37.720210710128896 -122.48015180069099 (37.7202107101289, -122.480151800691)
86161 114215 2 2 16 HIGUERA AVE 1 2 1 1     6     5988029.0 2090212.0 37.718634203797706 -122.483401916227 (37.7186342037977, -122.483401916227)
141371 114216 2 306 2X ACEVEDO AVE 1 2 1 1     14     5987907.0 2090895.0 37.720502447579996 -122.483873669144 (37.72050244758, -122.483873669144)
140259 114217 2 306 2X ACEVEDO AVE 2 2 1 1     18     5987907.0 2090895.0 37.720502447579996 -122.483873669144 (37.72050244758, -122.483873669144)
105245 114225 6 60 99x FONT BLVD 1 2 1 1     48     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
49231 114226 6 140 99x FONT BLVD 2 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105541 114227 6 140 99x FONT BLVD 3 2 1 1     16     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
80545 114228 6 140 99x FONT BLVD 4 2 1 1     7     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128290 114229 6 140 99x FONT BLVD 5 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105010 114230 6 140 99x FONT BLVD 6 2 1 1     30     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
112189 114231 6 140 99x FONT BLVD 7 2 1 1     10     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128194 114232 6 140 99x FONT BLVD 8 2 1 1     15     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
139193 114233 6 140 99x FONT BLVD 9 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
125709 114234 6 140 99x FONT BLVD 10 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
86013 114235 6 140 99x FONT BLVD 11 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
139478 114236 6 140 99x FONT BLVD 12 2 1 1     22     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
117729 114237 6 140 99x FONT BLVD 13 2 1 1     14     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
138891 114238 6 140 99x FONT BLVD 14 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
Powered by Datasette · Query took 42.368ms · Data source: data.sfgov.org